Hello Everyone,
Have a question for the group...
At work, we use a software/hardware inventory product called "Alchemy
Network Inventory". It scans each computer that logs into our network
and creates a result file on a server. The result files are tagged-text,
with an extension of ".XML". These files are not truly valid XML, as
they are missing the XML statement at the top and do not have a link to a
DTD/schema. I have asked the manufacturer for such a DTD/schema, but
they have not honored my request at this time.
They have a console program that reads the result files and can display
each computer and it's components/software, and this program can also
export any/all of the result files to more traditional file formats such
as Excel, CSV and Access (via ODBC).
What I'm looking for are ideas on what parsers/programming languages I
could use that would be able to "read" these result files and generate
reports in either HTML, pure text, etc.
Need something that I can do immediate, ad hoc reports and have been
looking at Perl, Python, VBScript, XSLT, etc., but am a novice programmer
and am looking to learn in the process of doing it.
Thanks in advance...
----------
Mark L. Woods
Saint Louis, MO USA 5 1522
Mark Woods wrote: At work, we use a software/hardware inventory product called "Alchemy Network Inventory". It scans each computer that logs into our network and creates a result file on a server. The result files are tagged-text, with an extension of ".XML". These files are not truly valid XML, as they are missing the XML statement at the top and do not have a link to a DTD/schema. I have asked the manufacturer for such a DTD/schema, but they have not honored my request at this time.
If by "XML statement" you mean the XML declaration e.g.
<?xml version="1.0"?>
then it is allowed to leave that out if the encoding of the file is
UTF-8 or UTF-16.
And "a link to a DTD", e.g. the DOCTYPE node
<!DOCTYPE root SYSTEM "whatever.dtd">
is also optional thus what you have could indeed be XML if it is
well-formed markup.
What I'm looking for are ideas on what parsers/programming languages I could use that would be able to "read" these result files and generate reports in either HTML, pure text, etc.
If it is XML then any XML parser would do and then you can use DOM or
XSLT to create other formats.
The programming language to choose obviously needs to support XML
parsing but most languages do that so your choice should be driven by
what you are comfortable with.
--
Martin Honnen http://JavaScript.FAQTs.com/
Mark Woods wrote: and creates a result file on a server. The result files are tagged-text, with an extension of ".XML". These files are not truly valid XML, as they are missing the XML statement at the top and do not have a link to a
xmllint accepts such files.
What I'm looking for are ideas on what parsers/programming languages I could use that would be able to "read" these result files and generate reports in either HTML, pure text, etc.
The canonical solution seems to be to use XSL.
Need something that I can do immediate, ad hoc reports and have been looking at Perl, Python, VBScript, XSLT, etc., but am a novice programmer and am looking to learn in the process of doing it.
I would use a script language rather than XSL.
Script languages allow you to implement stand-alone
scripts with a minimum of requirements.
Mark,
if I undestood it right, you want to convert the invalid xml into a
valid xml.
In case you have it in Excel, you could write out the Excel file as
XML. It has all the Excell items and declarations with it. Then you
might apply some xslt to the transform it to your target format. But
all this this might be a total overkill.
If I would have to do the job, I would use perl (some regex and
XML::Simple , which is quite easy)and write out xml. Then translate it
to HTML , text, etc. by xlst.
Rolf
Mark Woods <mb*****@earthlink.net> wrote in message news:<Xn*********************************@216.168. 3.30>... Hello Everyone,
Have a question for the group...
At work, we use a software/hardware inventory product called "Alchemy Network Inventory". It scans each computer that logs into our network and creates a result file on a server. The result files are tagged-text, with an extension of ".XML". These files are not truly valid XML, as they are missing the XML statement at the top and do not have a link to a DTD/schema. I have asked the manufacturer for such a DTD/schema, but they have not honored my request at this time.
They have a console program that reads the result files and can display each computer and it's components/software, and this program can also export any/all of the result files to more traditional file formats such as Excel, CSV and Access (via ODBC).
What I'm looking for are ideas on what parsers/programming languages I could use that would be able to "read" these result files and generate reports in either HTML, pure text, etc.
Need something that I can do immediate, ad hoc reports and have been looking at Perl, Python, VBScript, XSLT, etc., but am a novice programmer and am looking to learn in the process of doing it.
Thanks in advance...
----------
Mark L. Woods Saint Louis, MO USA
On Mon, 13 Sep 2004 01:44:29 -0000, Mark Woods <mb*****@earthlink.net>
wrote: These files are not truly valid XML, as they are missing the XML statement at the top and do not have a link to a DTD/schema.
These may not even be valid XML, but they're probably well-formed XML
and that's all you need.
XML alone can just be "well-formed", which means that the syntax is
correct. XML prologs, DTDs and schemas are all optional.
XML for a named application can go one better than this, and could be
"valid". This means that it's written according to a DTD/schema and
it matches that DTD/schema. Containing an explicit link to that
DTD/schema is still optional.
I have asked the manufacturer for such a DTD/schema, but they have not honored my request at this time.
They very rarely do. If they would tell you, they'd have told you
already and been proud of it.
What I'm looking for are ideas on what parsers/programming languages I could use
Some scripting language that you know / like, and that can connect to
an XML DOM / XSLT transformer. Perl or Python could easily do this.
By the sound of things you're on Windows (what about the servers ?)
so a handy XML tool is Microsft's MSXML that is a free download and
does both XML and XSLT.
Depending on the structure and usage of the schema, you may be able to
process the document entirely with XSLT. This is unlikely though -
it's usual that you need a slightly smart "wrapper" around it, so as
to feed it the right files and maybe some metadata from other sources.
You may also need to perform some internal computation or string
mangling that's hard in pure XSLT 1, but trivial in JavaScript or
regexes. This is a job for an extension to XSLT, a simple little
snippet of JavaScript embedded in the stylesheet. They're not very
portable for web-wide distribution, but they work fine for in house
tools.
Michael Kay's XSLT book is the one to have.
--
Smert' spamionam
Mark Woods <mb*****@earthlink.net> wrote: Hello Everyone,
Have a question for the group...
At work, we use a software/hardware inventory product called "Alchemy Network Inventory". It scans each computer that logs into our network and creates a result file on a server. The result files are tagged-text, with an extension of ".XML". These files are not truly valid XML, as they are missing the XML statement at the top and do not have a link to a DTD/schema. I have asked the manufacturer for such a DTD/schema, but they have not honored my request at this time.
They have a console program that reads the result files and can display each computer and it's components/software, and this program can also export any/all of the result files to more traditional file formats such as Excel, CSV and Access (via ODBC).
What I'm looking for are ideas on what parsers/programming languages I could use that would be able to "read" these result files and generate reports in either HTML, pure text, etc.
Need something that I can do immediate, ad hoc reports and have been looking at Perl, Python, VBScript, XSLT, etc., but am a novice programmer and am looking to learn in the process of doing it.
Thanks in advance...
Sounds like the result files just use the format of XML syntax. And,
that's all you need to parse it. I can think of Gawk and Bash, both
with Expat XML parser interface. Their URLs have been posted in this
newsgroup, I think.
If you can post a sample input you have and sample output you want, we
wouldn't have to guess. :-)
--
William Park <op**********@yahoo.ca>
Open Geometry Consulting, Toronto, Canada This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Gerhard Pretorius |
last post by:
ON Win 2003 IIS6,
Since yesterday, (12 Aug 2003) for some strange reason, (after installing
WindowsServer2003-KB823980-x86-ENU.exe)
I cannot pass the
Request object to to VB COM DLL.
I have...
|
by: mt404 |
last post by:
Hi,
I was wondering if someone might be able to provide some guidance on
how I could make an http request from a C# library.
Basically I have a library which accepts a couple of arguments that...
|
by: PJ |
last post by:
I would like to capture a request stream before the request has been
completely sent to the server for the sake of saving the bytes of a posted
file to disk. I have written httpmodules before, but...
|
by: Jason Minton |
last post by:
Please email your resume to me if at: JMinton@Emdeon.com if you feel you
could excel in the below position as a Siebel Production Engineer.
Compensation for this position is such that only the...
|
by: Steve Last |
last post by:
Hi all,
I’m using IIS6 for our college Intranet and I’m having trouble using
Request.Form. Here is my code:
<%
If Request.QueryString("action") = "show" Then
Response.Write "title: " &...
|
by: Wildemar Wildenburger |
last post by:
Hi there :)
I don't know how else to call what I'm currently implementing: An object
that behaves like a list but doesn't store it's own items but rather
pulls them from a larger list (if they...
|
by: Dan2kx |
last post by:
Hello (again)
i have a rather strange problem to tackle
i am still doing the holiday database (for those who have helped me before)
and now need (which means i have to rethink everything)
to...
|
by: ak121234 |
last post by:
Hello,
We have written a page which views correctly in Internet Explorer. As well, the page views ok for some of the other programmers on their machines in FireFox. The other programmers are...
|
by: chromis |
last post by:
Hi there,
I've recently been updating a site to use locking on application level variables, and I am trying to use a commonly used method which copies the application struct into the request...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
| |