XML Import-Export Forum :: Import XML to mySQL database
This thread was displayed: 0 times
Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.
For more information about the affected products visit: www.interaktonline.com/Support/
John Picton
03-09-2007 17:23:53 GMT +2
|
I need some functionality where I can daily import data from an XML newsfeed into a table in a mySQL database. I would like this to happen automatically if possible.
I've tried using the XML Import-Export extension but have been unsuccessful - the table I've created in the database has fields that match the XML but nothing is imported.
Also, If I try to create a recordset from the XML file I don't get the little plus sign next to the bindings, so I can't get any data from it.
Any ideas what may be wrong?
|
|
|
Razvan Racasanu[InterAKT]  03-09-2007 17:38:29 GMT +2
|
Hello,
XML Import-Export does not work with every XML document. The document must have the following structure (the element names are not important)
<root>
<row>
<fieldname1>Fieldname1 value</fieldname1>
<fieldname2>Fieldname2 value</fieldname2>
....
<fieldnameN>FieldnameN value</fieldnameN>
</row>
....
<row>
<fieldname1>Fieldname1 value</fieldname1>
<fieldname2>Fieldname2 value</fieldname2>
....
<fieldnameN>FieldnameN value</fieldnameN>
</row>
</root>
Also, XML Import-Export cannot automatically import a feed daily.
Regards,
Razvan RACASANU
|
|
|
John Picton
03-09-2007 17:42:04 GMT +2
|
The XML file I need to use is like this:
<Article Created="13:41:37" ID="18084416">
<Heading> Heading in here </Heading>
<Date>09/03/2007</Date>
<Contents> News content is in here </Contents>
<Categories>
<Category ID="430009727">Health</Category>
<Category ID="430009737">Science</Category>
</Categories>
</Article>
Is it the categories that is the problem?
|
|
|
Razvan Racasanu[InterAKT] 03-09-2007 17:44:37 GMT +2
|
Hello,
This XML does not respect the required structure. The root element could be Article, but in this case you do not have the row element that contains the fields. If the Article is the row, then Categories is the problem.
Regards,
Razvan RACASANU
|
|
|
John Picton
03-09-2007 17:47:36 GMT +2
|
OK, thanks for your very quick response.
|
|
|
benjamin wende
09-22-2007 15:42:09 GMT +2
|
Hello
Shortly, the XML file must have a valid structure?
Only the structur above is supported?
Should this be better, after integrating in the ADDT?
thx
benjamin
My Sites:
jobbörse - strom - webhosting - schmuck
|
|
|
