reading an external xml file's node using formapi

Hi,

I am working in ts 6.5 win env.
I have a requirement for reading the nodes of an xml file(not dcr).
I tried Microsoft.XMLDOM. But it didn't work.
Any ideas?

Sathish E

Find more posts tagged with

Comments

kaalraa

We are using XML: Smiley Very Happy

OM and its working all fine with our code. If you still want any of us to look upon... please attach your xml file along with the XML parsing code.

Hi,

I am working in ts 6.5 win env.
I have a requirement for reading the nodes of an xml file(not dcr).
I tried Microsoft.XMLDOM. But it didn't work.
Any ideas?

Sathish E

Sathishbsl

hi,

Thanks for ur feedback.. I am here attaching my xml file and nothing much in formapi.. just the four lines..
the alert is not firing..
var xml = new ActiveXObject("Microsoft.XMLDOM");
xml.async = false;
xml.load("Parent_Organization.xml");
alert("test");

Just I want to retrieve the 'code' attribute in the organization element according to the conditions.

Any more informations required.

Sathish E

GriffTheDog

If you put an alert in front of the xml.load call it get'****?

The xml file is in the same folder as the datacapture.cfg file?

Sathishbsl

Hi,

This is what i am trying to get in the alert..
The alert("test") is working.. But the next alert is not..

am i using the wrong methods?

var xml = new ActiveXObject("Microsoft.XMLDOM");
xml.async = false;
xml.load("Parent_Organization.xml");
alert("test");

var a= xml.getElementsByTagName("Organization").item(2);
alert(a.getAttribute("Code"));

Sathish E

Excel_Cross_Table_Likes.rptdesign

GriffTheDog

Using the xml file you passed there is no item[2] cause it's a zero based array. There is only item[0] and item[1].

Try:

var xml = new ActiveXObject("Microsoft.XMLDOM");
xml.async = false;
xml.load("Parent_Organization.xml");
alert("test");

var a= xml.getElementsByTagName("Organization")[1];
alert(a.getAttribute("Code"));

Or this:

var allItems= xml.getElementsByTagName("Organization");

for (i=0;i<allItems.length;i++)
{
alert(allItems.getAttribute('code'));
}

Sathishbsl

Thanks for ur feedback..
But it didn't work either. can we use getElementsByTagName in formapi?

Sathish E

Adam Stoller

hi,

Thanks for ur feedback.. I am here attaching my xml file and nothing much in formapi.. just the four lines..
the alert is not firing..
var xml = new ActiveXObject("Microsoft.XMLDOM");
xml.async = false;
xml.load("Parent_Organization.xml");
alert("test");

Just I want to retrieve the 'code' attribute in the organization element according to the conditions.

Any more informations required.

Sathish E

If the XML is server-side and FormAPI is running client-side - the only way to do this would be to do a CallServer() to a script on the server that could parse the XML and then output the appropriate javascript / FormAPI code to set the value (or make the alerts) on the client side. Alternatively, if the XML file can be parsed without regard to the contents of the DCR values - you could do it via an inline script instead of using the CallServer() mechanism.

Alternatively - you might be able to use your existing code if you provide a fully qualified URI to the XML file you're intending to parse (assuming it's someplace that can be accessed by a URI)

Sathishbsl

Hi fish,

Great.. It worked with URL.. But with a browser security warning..

Sathish E