Forum Thread
Slickdeals Discounts, Deals and Coupon Codes

XML File Not Displaying Properly in IE ~ Solved...Open Excel and then use Excel to open the XML File. Thanks jkee

DC 33,249 6,001 May 20, 2011 at 10:17 AM More Slickdeals Deals
I found this threadthat said to use IE for XML Files

However...I'm not getting the data to be displayed properly. XP pro SP3, Office 2K3

I'm using IP Scanner2 and this version saves to an XML file instead of txt like the old version did.

The file is being displayed with what looks like all the tag info and the actual data...

Like looking at an HTML page with view source code on...you see the data, but you also see all the tags.

I tried to open the file on a box running XP Pro SP3 Office 2k7...same result...it opened in IE.

Is there a better viewer program then IE?

Thanks!

13 Comments

1

Sign up for a Slickdeals account to remove this ad.

#2
Notepad?

What functionality are you looking for?
Reply Helpful Comment? 0 0
Quote from cigarbaron View Post :
If evolution improves the species. Why haven't we had a alligator join Mensa?
Checkmate, Atheists.
Joined Mar 2007
Password: ••••••••
21,218 Posts
1,587 Reputation
#3
Quote from .DC. View Post :
I found this threadthat said to use IE for XML Files

However...I'm not getting the data to be displayed properly. XP pro SP3, Office 2K3

I'm using IP Scanner2 and this version saves to an XML file instead of txt like the old version did.

The file is being displayed with what looks like all the tag info and the actual data...

Like looking at an HTML page with view source code on...you see the data, but you also see all the tags.

I tried to open the file on a box running XP Pro SP3 Office 2k7...same result...it opened in IE.

Is there a better viewer program then IE?

Thanks!
What exactly are you trying to do? All XML is is structured data. It (when composed by normal, sane developers) contains no formatting or layout data. It is up to the program that is designed to read the file to present it in the best possible format.

For example if you have:

<Dog breed="Lab">
<Weight>70</Weight>
<Color>Black</Color>
<Age>5</Age>
</Dog>

Is IE supposed to know to present a picture of a 5 year old black labrador retriever that weighs 70 lbs? laugh out loud shake head
Reply Helpful Comment? 0 0
Last edited by redmaxx May 20, 2011 at 12:04 PM
Steve Gibson on password policies [grc.com]: I mean, I don't get this change it every eight weeks. ... It's not as if passwords are traveling by camel after they've been stolen, going to the bad guys, and so there's, like, some weird eight-week window, like, oh, we're going to change your password so that the stale password no longer works. ... And all this does is make IT people despised because users, who are not dumb, they think, why am I - why do I have to do this? What problem is this solving?
#4
You might even be able to import it into excel
Reply Helpful Comment? 0 0
Joined Jul 2003
L10: Grand Master
33,249 Posts
6,001 Reputation
Original Poster
#5
Quote from highfloydelity View Post :
Notepad?

What functionality are you looking for?
Quote from redmaxx View Post :
What exactly are you trying to do? All XML is is structured data. It (when composed by normal, sane developers) contains no formatting or layout data. It is up to the program that is designed to read the file to present it in the best possible format.

For example if you have:

<Dog breed="Lab">
<Weight>70</Weight>
<Color>Black</Color>
<Age>5</Age>
</Dog>

Is IE supposed to know to present a picture of a 5 year old black labrador retriever that weighs 70 lbs? laugh out loud shake head
Quote from jkee View Post :
You might even be able to import it into excel
The old version of IP Scan would list the ip addy, the mac address, machine name and any other info it could gleam from the scan of the given IP range...

This could be saved as a CSV / Txt file and I would open it in Excel...

The current version only saves to XML file type.
and I get as as the output when IE displays it...

<?xml version="1.0" encoding="UTF-8" ?>
- <Advanced_IP_scanner>
<row ip="192.168.2.1" status="1" mac="00:00:C5:84:34:9C" has_http="0" has_https="0" has_ftp="0" has_radmin_1="0" has_radmin_2="0" has_radmin_3="0" has_radmin_4="0" />
<row ip="192.168.2.3" status="1" mac="00:0F:CC:E9:6F:B4" has_http="0" has_https="0" has_ftp="0" has_radmin_1="0" has_radmin_2="0" has_radmin_3="0" has_radmin_4="0" />
- <row ip="192.168.2.5" status="1" name="SERVERBOX" mac="00:24:E8:3E:65:C8" has_http="0" has_https="0" has_ftp="0" has_radmin_1="0" has_radmin_2="0" has_radmin_3="0" has_radmin_4="0">
<share name="sharename$" />
<share name="C$" />
<share name="sharename" />
<share name="sharename" />
<share name="sharenameC$" />
<share name="sharename" />
<share name="sharename" />
<share name="sharename" />
<share name="SYSVOL" />
<share name="sharename" />
</row>
<row ip="192.168.2.6" status="1" name="HP8000" mac="00:30:6E:C8:02:5D" has_http="0" has_https="0" has_ftp="0" has_radmin_1="0" has_radmin_2="0" has_radmin_3="0" has_radmin_4="0" />

If it has all the damn tags...why can it use them to format the data???
Reply Helpful Comment? 0 0
worshipTHANK YOU to those whom have fought and are fighting for our FREEDOMworship

Please Support Autism Awareness [autismspeaks.org]
Yahoo!Yahoo! 7/11/2009
#6
Quote from .DC. View Post :
The file is being displayed with what looks like all the tag info and the actual data...

Like looking at an HTML page with view source code on...you see the data, but you also see all the tags.
That is the correct way to display an arbitrary XML file.
Reply Helpful Comment? 0 0
Joined Jul 2003
L10: Grand Master
33,249 Posts
6,001 Reputation
Original Poster
#7
Quote from jkee View Post :
You might even be able to import it into excel
Ok...that worked...nice neat rows and columns woot

Quote from Aluvus View Post :
That is the correct way to display an arbitrary XML file.
how it looks now in excel is how I wanted to see it...and can now do something with it.
Reply Helpful Comment? 0 0
Last edited by DC May 20, 2011 at 01:47 PM
#8
Quote from .DC. View Post :
If it has all the damn tags...why can it use them to format the data???
I still don't quite know what format you're looking for. What is IP Scan exactly? A packet sniffer? If so, you could try out what I use, WireShark. It might display what you need better than IP Scan.

Here's an XML viewer, never used it but it's free: http://www.mindfusion.eu/product1.html

You could also use any recent version of Visual Studio to open it too.

Dontknow I just read XML as XML.
Reply Helpful Comment? 0 0

Sign up for a Slickdeals account to remove this ad.

Joined Mar 2007
Password: ••••••••
21,218 Posts
1,587 Reputation
#9
Quote from .DC. View Post :
If it has all the damn tags...why can it use them to format the data???
XML is purely structured data, it has no formatting. That way you can use one language to describe the computers on your network and still use the same language to send weather data from your favorite site to your phone. You're confusing it with HTML, which contains both formatting and data.

For IE to do anything but display the raw document to you, it would need an XSL file that describes the style for the data contained and then something to actually perform the transformation into HTML.
Reply Helpful Comment? 0 0
Joined Jul 2003
L10: Grand Master
33,249 Posts
6,001 Reputation
Original Poster
#10
Quote from redmaxx View Post :
XML is purely structured data, it has no formatting. That way you can use one language to describe the computers on your network and still use the same language to send weather data from your favorite site to your phone. You're confusing it with HTML, which contains both formatting and data.

For IE to do anything but display the raw document to you, it would need an XSL file that describes the style for the data contained and then something to actually perform the transformation into HTML.
The bottom line here is the one and only output file was XLM and I needed something to read that file and put it in some sort of arrangement that I could actually do something with the data that was meaningful...the previous version was csv/txt and it was obious to me that I should use Excel to open the data file and then do what I needed to do with it...See what IP were in use, sort by IP or Computer Name, etc.. The crap that showed up in IE was not usable in that state...I could sort through the formatting tags visually and make some sense of it...but it was not "usable" to me in that state.

I do know that hypertext mark up language denotes formatting, spacing, font size and at first glance that XML file seemed to be of similar nature...there was the data and there was "formatting" info around the data (that I really didn't even want") but that was the one and only file format that was exported from the IP Scan program. [cnet.com]
Reply Helpful Comment? 0 0
Joined Mar 2007
Password: ••••••••
21,218 Posts
1,587 Reputation
#11
Quote from .DC. View Post :
The bottom line here is the one and only output file was XLM and I needed something to read that file and put it in some sort of arrangement that I could actually do something with the data that was meaningful...the previous version was csv/txt and it was obious to me that I should use Excel to open the data file and then do what I needed to do with it...See what IP were in use, sort by IP or Computer Name, etc.. The crap that showed up in IE was not usable in that state...I could sort through the formatting tags visually and make some sense of it...but it was not "usable" to me in that state.

I do know that hypertext mark up language denotes formatting, spacing, font size and at first glance that XML file seemed to be of similar nature...there was the data and there was "formatting" info around the data (that I really didn't even want") but that was the one and only file format that was exported from the IP Scan program. [cnet.com]
I'm glad you got it sucked into Excel. Just letting you know why IE didn't do anything helpful with it.
Reply Helpful Comment? 0 0
Joined Jul 2003
L10: Grand Master
33,249 Posts
6,001 Reputation
Original Poster
#12
Quote from redmaxx View Post :
I'm glad you got it sucked into Excel. Just letting you know why IE didn't do anything helpful with it.
Thanks.

I do want to thank you for taking the time to post an explanation for me.
Reply Helpful Comment? 0 0
Joined Jul 2003
L10: Grand Master
33,249 Posts
6,001 Reputation
Original Poster
#13
Quote from highfloydelity View Post :
I still don't quite know what format you're looking for. What is IP Scan exactly? A packet sniffer? If so, you could try out what I use, WireShark. It might display what you need better than IP Scan.

Here's an XML viewer, never used it but it's free: http://www.mindfusion.eu/product1.html

You could also use any recent version of Visual Studio to open it too.

Dontknow I just read XML as XML.
I wanted the data that was contained within the XML tags...and omit the damn tags.

If it would have spit out a CSV file like the old version that would have been exactly what I wanted...as it was basically a Table of data scattered amongst the tags.
Reply Helpful Comment? 0 0
Page 1 of 1
1
Join the Conversation
Add a Comment
 
Copyright 1999 - 2016. Slickdeals, LLC. All Rights Reserved. Copyright / Infringement Policy  •  Privacy Policy  •  Terms of Service  •  Acceptable Use Policy (Rules)  •  Interest-Based Ads
Link Copied to Clipboard