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">'+S YS'</column>
<column name="COL2">'12 34'</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">38 8</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?
3 2337 jkmyoung 2,057
Recognized Expert Top Contributor
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.
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.
jkmyoung 2,057
Recognized Expert Top Contributor
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
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: mirth |
last post by:
Hi all,
Is there any obvious way to sum only certain rows. I suppose it's
similar to cube or rollup but I can't get either of them to work. what
I basically have is this...
CREATE TABLE #TempTable (
INT,
INT,
varchar(50),
|
by: akej via SQLMonster.com |
last post by:
Hi, i have table with 15 columns
CREATE TABLE . (
PRIMARY KEY ,
NULL ,
NULL ,
NULL ,
NULL ,
(50) NULL ,
NULL
|
by: Steve Jorgensen |
last post by:
In a recent thread, RKC (correctly, I believe), took issue with my use of
multiple parameters in a Property Let procedure to pass dimensional
arguments on the basis that, although it works, it's not obvious how the
code works if you don't know the intricacies of the Property Let/Get
syntax. Likewise, I dislike (and code to minimize the use of) the VB/VBA
syntax of returning a value by referring to the function name as if it were
a...
|
by: Elger |
last post by:
Dear Members,
A newbie question
How do I convert this XML example into HTML (using XSLT)?
<DOCUMENT>
<PARA>
This <BOLD>is</BOLD> a <BOLD>test</BOLD>
</PARA>
</DOCUMENT>
|
by: SteveM |
last post by:
I am sure this is an easy question, but being relatively new to ASP.NET
programming, I can not quite grasp what I need to accomplish what I
need to do.
What I have is a word document that is rendered as a page (or actualy a
part of a page) that is editiable. To do this I let the user download
the document, edit it and then upload it back to the site. Then at
Page_Open, I convert the .doc file to an html and render it back to the
page......
| |
by: vincibleman |
last post by:
Howdy all,
Working my way into SQL from Access. Think I might have the hang of the basics, but would really appreciate a sanity check. The stored procedure listed below works, but I can't help but think there is a better way to do this.
Gist of what I'm doing:
I need aggregate error data for each satellite in tblSatellite.
-Satellite code, name, etc.
-Count of number of errors over a given frame of time
-The Problem Type with the...
|
by: Harlett O'Dowd |
last post by:
Please forgive this newbie question but java is new to me and I'm
still trying to find a course in my area.
I'm tweaking an online survey and have gotten it to display what I
want but can't figure out how to *require* the surveyee to pick a
choice.
For each of ten questions, the surveyee is asked:
|
by: John |
last post by:
Hi
I have a WinForm app with a bound form. When user enters a value in field
rateid I lookup the respective rate amount from a table and assign it to
field rate.I am using the DLookup function to achieve this (full code given
below). This function returns a value of type object so I need to convert it
to string. If I use the function as below (using ToString) it works fine;
Me.txtRate.Text = DLookup(<parameters here>).ToString
|
by: Adam Chapman |
last post by:
Hi,
Im trying to migrate from programming in Matlab over to C. Im trying
to make a simple function to multiply one matrix by the other. I've
realised that C can't determine the size of a 2d array, so im
inputting the dimensions of those myself.
The problem is that the output array (C=A*B) has as many rows as A and
as many columns as B. I would think of initialising C with:
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |