What XML structure should my data have?
Posted: Mon May 15, 2017 12:34 pm
I have the following test XML file which I'm trying to use inside the Web JS designer. To do this I created an xml connection using the following parameters:
Name : Cities
Alias : Cities
XML Type : Xml
Path to XML Data : /home/purvez/DevSW/Stimulsoft/Cities.xml
The data inside the file looks like this:
However when I create the connection it is not showing me any tables. I was expecting to see table Cities.
I have tried removing the <Cities> node but that didn't make any difference. Please can someone tell me if I need to add any additional nodes or do something else to allow the Web Designer to recognise the data in the JS version.
Many thanks
Purvez
Name : Cities
Alias : Cities
XML Type : Xml
Path to XML Data : /home/purvez/DevSW/Stimulsoft/Cities.xml
The data inside the file looks like this:
Code: Select all
<Cities>
<City>
<id>1</id>
<CityName>London</CityName>
</City>
<City>
<id>2</id>
<CityName>Paris</CityName>
</City>
</Cities>
I have tried removing the <Cities> node but that didn't make any difference. Please can someone tell me if I need to add any additional nodes or do something else to allow the Web Designer to recognise the data in the JS version.
Many thanks
Purvez