473,320 Members | 1,950 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Request for ideas/direction


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
Jul 20 '05 #1
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/
Jul 20 '05 #2
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.
Jul 20 '05 #3
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

Jul 20 '05 #4
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
Jul 20 '05 #5
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
Jul 20 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
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...
1
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...
4
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...
0
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...
10
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: " &...
10
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...
1
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...
4
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...
5
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...
0
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...
0
isladogs
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...
0
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...
1
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)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
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....
0
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
0
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...
0
isladogs
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.