Reading non-standard XML file?

**Jon Skeet [C# MVP]** · Jun 27 '08, 07:58 PM

Re: Reading non-standard XML file?

On Jun 20, 4:50 pm, "dm3281" <dm3...@nospam. netwrote:

Hello, I have this non-standard XML file that I have to manually sort thru
each day and verify whether various jobs finish successfully or not.
>
This file isn't a real XML file, so I cannot appear to read it using XML
classes.
>
I was wondernig if this is something I can/should read into memory using
StreamReader class and then somehow create an XML file in memory with the
outter tags???
>
Does anyone have any sampel code for this?
>
It would be be nice if I could create a service to run this each day from
previous day and e-mail the results (StatusDesc messages) to me.
>
Any help or comments would be appreciated.

<snip>

How big are these in practice? If you're happy to have them in memory,
then the easiest thing to do is read the whole lot into memory as a
string (TextReader.Rea dToEnd), prepend/append the start/end tags, and
then use the normal XML APIs by providing them with a StringReader.

If the files are too big to realistically load them into memory, you
could write a TextReader (or Stream) which effectively concatenated
other TextReaders/Streams - then just build up the data from the
start, middle and end.

Jon

**Martin Honnen** · Jun 27 '08, 07:58 PM

Re: Reading non-standard XML file?

dm3281 wrote:

Hello, I have this non-standard XML file that I have to manually sort
thru each day and verify whether various jobs finish successfully or not.
>
This file isn't a real XML file, so I cannot appear to read it using XML
classes.
>
I was wondernig if this is something I can/should read into memory using
StreamReader class and then somehow create an XML file in memory with
the outter tags???
>
Does anyone have any sampel code for this?

You can try to read it with XmlReader in fragment mode e.g.
XmlReaderSettin gs settings = new XmlReaderSettin gs();
settings.Confor manceLevel = ConformanceLeve l.Fragment;
using (XmlReader reader = XmlReader.Creat e("file.xml", settings))
{
while (reader.Read())
{
//extract contents here
}
}
You can even use XPath on that fragment if you pass an XmlReader like
the one created above to new XPathDocument() .

--

Martin Honnen --- MVP XML

Attention Required! | Cloudflare

http://JavaScript.FAQTs.com/

**dm3281** · Jun 27 '08, 07:58 PM

Re: Reading non-standard XML file?

Thanks fot the feedback. The file basically gets appended to each day. So
there could be a few hundred rows a day until I delete the file.

Do you know of a way I can read the file and save the EOF location. So next
time I read it I can continue where it left off?

"Jon Skeet [C# MVP]" <skeet@pobox.co mwrote in message
news:603ef54d-59ce-4e70-bd89-54d8b18577aa@79 g2000hsk.google groups.com...
On Jun 20, 4:50 pm, "dm3281" <dm3...@nospam. netwrote:

Hello, I have this non-standard XML file that I have to manually sort thru
each day and verify whether various jobs finish successfully or not.
>
This file isn't a real XML file, so I cannot appear to read it using XML
classes.
>
I was wondernig if this is something I can/should read into memory using
StreamReader class and then somehow create an XML file in memory with the
outter tags???
>
Does anyone have any sampel code for this?
>
It would be be nice if I could create a service to run this each day from
previous day and e-mail the results (StatusDesc messages) to me.
>
Any help or comments would be appreciated.

<snip>

How big are these in practice? If you're happy to have them in memory,
then the easiest thing to do is read the whole lot into memory as a
string (TextReader.Rea dToEnd), prepend/append the start/end tags, and
then use the normal XML APIs by providing them with a StringReader.

If the files are too big to realistically load them into memory, you
could write a TextReader (or Stream) which effectively concatenated
other TextReaders/Streams - then just build up the data from the
start, middle and end.

Jon

**Jon Skeet [C# MVP]** · Jun 27 '08, 07:58 PM

Re: Reading non-standard XML file?

dm3281 <dm3281@nospam. netwrote:

Thanks fot the feedback. The file basically gets appended to each day. So
there could be a few hundred rows a day until I delete the file.
>
Do you know of a way I can read the file and save the EOF location. So next
time I read it I can continue where it left off?

If you read it all into a byte array to start with (e.g. with
File.ReadAllByt es) you could just remember the length that you've read
- quite where you'll remember it is up to the rest of the system, of
course. You might put it in the database, or in a different file.

--
Jon Skeet - <skeet@pobox.co m>
Web site: http://www.pobox.com/~skeet
Blog: http://www.msmvps.com/jon.skeet
C# in Depth: http://csharpindepth.com

**dm3281** · Jun 27 '08, 07:58 PM

Re: Reading non-standard XML file?

Thanks.

I seem to remember back in my TRS-80 days that in LDOS I could do a #1.EOF
or something and it would give me the position. Later when I OPENed the
file, I could #1.SEEK or something to the saved position. Oh well --

"Jon Skeet [C# MVP]" <skeet@pobox.co mwrote in message
news:MPG.22c60d 07a4bf81fed9f@m snews.microsoft .com...

dm3281 <dm3281@nospam. netwrote:

>Thanks fot the feedback. The file basically gets appended to each day.
>So
>there could be a few hundred rows a day until I delete the file.
>>
>Do you know of a way I can read the file and save the EOF location. So
>next
>time I read it I can continue where it left off?

>
If you read it all into a byte array to start with (e.g. with
File.ReadAllByt es) you could just remember the length that you've read
- quite where you'll remember it is up to the rest of the system, of
course. You might put it in the database, or in a different file.
>
--
Jon Skeet - <skeet@pobox.co m>
Web site: http://www.pobox.com/~skeet
Blog: http://www.msmvps.com/jon.skeet
C# in Depth: http://csharpindepth.com

**dm3281** · Jun 27 '08, 07:58 PM

Re: Reading non-standard XML file?

All --

I wrote the following code, however there appears to be a problem with
SelectNodes("Lo g/LogEntry") as I'm not getting any nodes? Is there another
problem with the file format that I'm not seeing?

class Program
{
static void Main(string[] args)
{
ReadFile(@"C:\T EMP\PRM1360.trc ");

}

static void ReadFile(string filename)
{
StreamReader sr = new StreamReader(@" C:\TEMP\PRM1360 .trc");

string myfile = sr.ReadToEnd();

StringReader sreader = new StringReader("< ?xml version='1.0' ?>"
+ System.Environm ent.NewLine +
"" + System.Environm ent.NewLine +
"<Log>" + System.Environm ent.NewLine +
myfile +
"</Log>" + System.Environm ent.NewLine);

XmlDocument xd = new XmlDocument();
xd.Load(sreader );

XmlNodeList nodelist = xd.SelectNodes( "/Log/LogEntry");

foreach (XmlNode node in nodelist)
{
Console.WriteLi ne(node.Name);
}
}
}
}

**Martin Honnen** · Jun 27 '08, 07:58 PM

Re: Reading non-standard XML file?

dm3281 wrote:

I wrote the following code, however there appears to be a problem with
SelectNodes("Lo g/LogEntry") as I'm not getting any nodes? Is there
another problem with the file format that I'm not seeing?

The LogEntry elements are in the namespace
http://integration.company1.com/ so you need to use an
XmlNamespaceMan ager and bind a prefix to the namespace URI and use that
prefix in your XPath expressions to qualify names:
XmlNamespaceMan ager mgr = new XmlNamespaceMan ager(xd.NameTab le);
mgr.AddNamespac e("ic", "http://integration.com pany1.com/");
xd.SelectNodes( "/Log/ic:LogEntry", mgr)

--

Martin Honnen --- MVP XML

Attention Required! | Cloudflare

http://JavaScript.FAQTs.com/

Reading non-standard XML file?

Reading non-standard XML file?

Comment

Comment

Comment

Comment

Comment

Comment

Comment