Sorry for this newbie question, this is not my realm of expertese.
I have searched google, tried several applications that claim they can do this, such as Mapforce, which I found confusing, to Oxygen, to HTML kit, et cetera.
I am more confused than ever.
here's my quandry.
I was sent a file and told that we need to get the data into a more readable form.
I've tried using apps to pull it in, but it's not displaying properly.
I just need to get this to appear as a table. web, SQL table, it doesn't matter.
Here is the basic structure of the table
<Snapshot device="Device name" model="Model" version="1">
−
<node name="FOO">
−
<table name="Table1">
−
<row>
<column name="COL1">'+SYS'</column>
<column name="COL2">'1234'</column>
<column name="COL3">'+'</column>
<column name="COL4">0</column>
<column name="COL5">5</column>
<column name="COL6">50</column>
<column name="COL7">1</column>
<column name="COL8">1</column>
<column name="COL9">0</column>
<column name="COL10">0</column>
<column name="COL11">1</column>
<column name="COL12">0</column>
<column name="COL13">0</column>
<column name="COL14">1</column>
<column name="COL15">1</column>
<column name="COL16">0</column>
<column name="COL17">0</column>
<column name="COL18">0</column>
<column name="COL19">0</column>
<column name="COL20">1</column>
<column name="COL21">15</column>
<column name="COL22">1</column>
<column name="COL23">388</column>
<column name="COL24">2</column>
</row>
.
.
.
.
.
.
</table>
</node>
</Snapshot>
Again, I apologize for the newbie question.
I have about 130K rows that I need to convert into a table.
I've tried Access, Excel and a few other applications to try to do a quick parse. XML is not my strong suit
I don't know how to turn this into a table that would be viewable. Any suggestions?
|
|
July 14th, 2008 10:04 PM
# 2
|
Re: newbie question: Convert XML to a table.
The least technical solution would be to use Excel 2003 or later to convert it into a spreadsheet, then save it to html format.
The 2nd least technical solution would be to use xsl to convert it into a table like html form, but that'd require a little work.
Check your version of Excel first.
|
|
|
July 15th, 2008 05:35 PM
# 4
|
Re: newbie question: Convert XML to a table.
With bigger files, I would stay away from any xml processing that involves DOM, eg XSLT. Are you much of a programmer? If so pick a language, and we can probably start from there.
Suggested languages, PHP, C#, Java
