467,074 Members | 884 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,074 developers. It's quick & easy.

newbie question: Convert XML to a table.

Lokean
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?
Jul 14 '08 #1
  • viewed: 1998
Share:
3 Replies
jkmyoung
Expert 2GB
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.
Jul 14 '08 #2
Lokean
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.
I've tried Excel(2003), the file is just too big for excel.
Jul 15 '08 #3
jkmyoung
Expert 2GB
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
Jul 15 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by mirth | last post: by
20 posts views Thread by akej via SQLMonster.com | last post: by
reply views Thread by Elger | last post: by
33 posts views Thread by Adam Chapman | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.