XML Parsing problems

Xarshi · Post by **Xarshi** » Fri Jun 19, 2009 9:06 pm

Ok, so I'm trying to parse some data exported from a program.

Here's a little snippet of some data I'm parsing:

<Cell ss:StyleID="s21" >
<Data ss:Type="DateTime" >2009-06-19T12:50:00</Data>
</Cell>
<Cell ss:StyleID="s23" >
<Data ss:Type="Number" >1.64846</Data>
</Cell>

I want to be able to read in the date from the first one, and the number from the second one.

Basically, I can read in the ss:Type, but of course, that is set to "DateTime" and "Number". Then I see how many attributes there are, and there is only 1. So my question would have to be how can I get the value, for instance, 1.64846 out of the second cell?

Acki · Post by **Acki** » Fri Jun 19, 2009 10:20 pm

I'm not that familiar with Irrlicht's xml parser though, but did you try to use getAttributeAsFloat and getAttributeAsString ???

Xarshi · Post by **Xarshi** » Sat Jun 20, 2009 6:00 am

Yup.

It's not that. The values aren't actually stored as an attribute it would seem. It's quite odd. The only attribute associated to each cell is what type of data it is (i.e. number or date).

But yeah, I wouldn't have come here if it was something so easy xD Either way, this is really frustrating to say the least.

This xml file is intended to be imported into excel, but I figured since its xml and reads the same way there wouldn't be much of a problem. I'll take a look around at other xml parsers to see if there is a way.

Valmond · Post by **Valmond** » Sat Jun 20, 2009 8:58 am

For what I know, "1.64846" isn't an attribute, it's an element.

HTH

Acki · Post by **Acki** » Sat Jun 20, 2009 3:21 pm

Xarshi wrote:I'll take a look around at other xml parsers to see if there is a way.

I love tinyXML...

Arcoroc · Post by **Arcoroc** » Sat Jun 20, 2009 3:58 pm

What about this:

Code: Select all

bool XmlTestParser( const core::stringc& loadFilePath )
{
	// assuming loadFilePath points to xml file with the following content:
	//
	// <?xml version="1.0" encoding="utf-8"?>
	// <Cell ss:StyleID="s21" > 
	//	<Data ss:Type="DateTime" >2009-06-19T12:50:00</Data> 
	// </Cell> 
	// <Cell ss:StyleID="s23" > 
	//	<Data ss:Type="Number" >1.64846</Data> 
	// </Cell>

	// init reader 
	irr::io::IXMLReader* reader =  irrlichtDevice->getFileSystem()->CreateXmlReader( loadFilePath.c_str() )  ; 
	if ( !reader ) { return false; } 

	// parse the file until end reached
	core::stringw somestring ;
	core::stringw number ;
	bool timeToReadNumber = false ;

	while( reader && reader->read() )
	{
		switch( reader->getNodeType() )
		{
		case EXN_ELEMENT:
			somestring = reader->getNodeName() ;
			if ( somestring == L"Data" ) 
			{
				somestring = reader->getAttributeValue( L"ss:Type" ) ;
				if ( somestring == L"Number" ) timeToReadNumber = true ;
			}
			break;
		case EXN_TEXT:
			if ( timeToReadNumber ) number = reader->getNodeData() ;
			// do something with your data...
			break;
		}
	}

	delete reader ; reader=0 ;
	return true ;

}

[/code]

Arcoroc · Post by **Arcoroc** » Sat Jun 20, 2009 4:00 pm

Valmond wrote:For what I know, "1.64846" isn't an attribute, it's an element.

HTH

Actually it would be the text of the element 'Data'.

Xarshi · Post by **Xarshi** » Sat Jun 20, 2009 9:25 pm

Thank you a ton, arcoroc. That was the problem. Seems I don't know all that much about xml, hah.