How to read XML file?

[Peter de Rooij]

Hi All,

I have a XML file looking like below and I need to read it into a JS object.

Does anyone have a suggestion how to do this? I just need a starting point on how to read the nodes from the XML file in a loop, I think i can figure out how to fill the (array of) objects then.

thanks in advance.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<data-set xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<record>

               <Name>Name1</Name>

             <Address>Addresstreet 1</Address>

              <City>City</City>

              <Telephone>123123</Telephone>

  </record>

        <record>

               <Name>Name 2</Name>

            <Address>Address</Address>

             <City>City 2</City>

            <Telephone>345345-345345</Telephone>

   </record>

</data-set>

[Chris]

Here:
http://bfy.tw/4AQb

[Chris]

To note: if your app is a pure javascript app DOM methods won't work. Either use an html app, OR as I have, create a webview, set its visibility to 'Gone' - and load in a script that handles your needs.

I normally load jQuery and a few helper scripts into this hidden webview for DOM access and to make use of a lot of the jQuery code available on the net :)

[Peter de Rooij]

Very funny Chris, obviously I did google. Unfortunately most results are using DOM which is part of the browser

This is not working in a DroidScript JS application:

var xmlDoc=new ActiveXObject("Microsoft.XMLDOM");

[Peter de Rooij]

I believe our answers crossed :)

[Chris]

:)

You may need to look into:

window.DOMParser

instead of the microsoft way - pretty sure that won't work in a droid webview.

[Peter de Rooij]

I'm now doing some tests using marknote Javascript XML Library which appears to work pretty well (and simple enough for a beginner JS programmer to understand). See code below:

app.LoadScript("marknote.js");

function OnStart()

{

str = app.ReadFile( "Lijst_technieken.xml" );

var parser = new marknote.Parser(); 

var doc = parser.parse(str);

root=new marknote.Element();

root=doc.getRootElement()

len=children = root.getChildElements().length;

for (var i = 0; i < len; i++) 

{

var child = root.getChildElementAt(i);

var Name = child.getChildElement("Name").getContents();

var Address= child.getChildElement("Address").getContents();

alert(Name + Address);

}

}

[Peter de Rooij]

PS, this works without DOM.. marknote is "pure JS" library

[Chris]

Nice, so my link worked... lol :) just kidding....

I am adding that library into my snippets.

[kurios]

Hello, I know this is the wrong place 2 ask, but you sound like the right user 2 ask.
https://groups.google.com/forum/m/#!topic/androidscript/TUxVcFSqqW0

Im sorry, I know, but can you solve this problem?

[Medien Forscher]

Im trying to get marknote.js running but only get a black screen even with a very simple xml file. Is there anything to consider?
Thx, Olivier

[Dave Smart]

I suggest you use our free Xml2Js plugin instead. It reads and writes XML.

(Just look at the bottom of the DroidScript plugins list)

[Medien Forscher]

Thx, Dave. Is there a sample code to start with? I can't find anything. Thanks very much, Olivier

[Steve Garman]

Medien,

Once you have installed the plugin, there is a simple example that parses XML to a useful JavaScript object at
Docs > Plugins > Xml2Js

[Steve Garman]

Here's a cut-down version of an implementation of Xml2Js

var xml = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+
'<root>'+
" <a>'orses</a>"+
' <b>mutton</b>'+
' <c>looking</c>'+
' <d>ential</d>'+
'</root>'

app.LoadPlugin( "Xml2Js" );

function OnStart()
{
lay = app.CreateLayout( "Linear", "VCenter,FillXY" );
btn = app.CreateButton( "Press Me" );
btn.SetOnTouch( Parse );
lay.AddChild( btn );
plg = app.CreateXml2Js();
app.AddLayout( lay );
}

function Parse()
{
plg.ParseString( xml, OnResult );
}

function OnResult( err, result )
{
//alert( JSON.stringify(result,null,1) );
alert("C for " + result.root.c);
}

[Medien Forscher]

Thx Dave and Steve for your kind help.
@Steve: what if I have serveral nodes "c"? Can I count them and say I want the 3th element of the c nodes?

[Steve Garman]

//The 3 C's are basically an array

var xml = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+
'<root>'+
" <a>'orses</a>"+
' <b>mutton</b>'+

' <c>looking0</c>'+
' <c>looking1</c>'+
' <c>looking2</c>'+

' <d>ential</d>'+
'</root>'

app.LoadPlugin( "Xml2Js" );

function OnStart()
{
lay = app.CreateLayout( "Linear", "VCenter,FillXY" );

btn = app.CreateButton( "Press Me" );
btn.SetOnTouch( Parse );
lay.AddChild( btn );

plg = app.CreateXml2Js();

app.AddLayout( lay );
}

function Parse()
{
plg.ParseString( xml, OnResult );
}

function OnResult( err, result )
{
// alert( JSON.stringify(result,null,1) );

alert(result.root.c[1]);
}

[Steve Garman]

In the object, it's a JavaScript array so you can do :

function OnResult( err, result )
{

var max = result.root.c.length - 1;
alert("max = " + max +
"\n"+result.root.c[max] );
}

[Medien Forscher]

Thx very much, thats perfect. Do I have to mention every node until the one I want to access or could I jump directly to a node? I'm having difficulties with the node names until HeartRateBpm. I'm getting errors unidentified object Activity with following command (below the beginning of the xml) :

alert(result.TrainingCenterDatabase.Activities.Activity.Lap.Track.Trackpoint.Time) ;

<?xml version='1.0' encoding='UTF-8' standalone='yes' ?>

<TrainingCenterDatabase xmlns="http://www.garmin.com/xmlschemas/TrainingCenterDatabase/v2">
<Activities>
<Activity Sport="Other">
<Id>2017-01-19T13:27:19.866Z</Id>
<Lap StartTime="2017-01-19T13:27:19.866Z">
<TotalTimeSeconds>1800</TotalTimeSeconds>
<DistanceMeters>6604</DistanceMeters>
<Calories>344</Calories>
<Intensity>Active</Intensity>
<TriggerMethod>Manual</TriggerMethod>
<Track>
<Trackpoint>
<Time>2017-01-19T13:27:19.866Z</Time>
<Position>
<LatitudeDegrees>0.0</LatitudeDegrees>
<LongitudeDegrees>0.0</LongitudeDegrees>
</Position>
<DistanceMeters>1</DistanceMeters>
<HeartRateBpm>
<Value>96</Value>
</HeartRateBpm>

[a apo]

If you want to get the reading of "2017-01-19T13:27:19.866Z", try

alert(result.TrainingCenterDatabase.Activities[0].Activity[0].Lap[0].Track[0].Trackpoint[0].Time[0]._)