XML Table Export Forum :: Trying XML layout to database
This thread was displayed: 1,076 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/
Gary Fuhrmann
10-17-2005 17:15:39 GMT +2
|
I have created a static Flash catalog for a CDROM whose in formation is generated by a XML file. I would like to create a MYSQL database to match my XML file so I can more easily update the catalog. I am not sure how to match the XML structure to my database. I was wondering if you could help, here is my XML format.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE data[
<!ELEMENT product (comments, image)>
<!ATTLIST product productToBuy CDATA #REQUIRED>
<!ELEMENT description (#PCDATA)>
<!ELEMENT image (#PCDATA)>
]>
<categories>
<category categoryName="">
<product productName="">
<productsDetails jpegURL="" productName="" productPrice="" productToBuy="">
<![CDATA[ ]]>
</productsDetails>
</product>
</category>
</categories>
|
|
|
Marius STOIAN[InterAKT]  10-20-2005 15:29:51 GMT +2
|
Hi,
Unfortunately you can't import this xml file using the XML Import-Export package.
The XML file must have one of the following two formats:
Data as nodes (corresponding to Import field as nodes):
<?xml version="1.0" encoding="[encoding]"?>
<[root node]> // this is the root node and can have any name you want
<[row]> // this is the node that will contain all data that need to be imported for one row, again can have any name that you want
<[field1]>[field1 value]</[field1]>
<[field2]>[field2 value]</[field2]>
............. (more fields)
<[field_n]>[field_n value]</[field_n]>
</[row]>
.......... (more rows)
</[root node]>
- field1 to field_n are the names of the fields that need to be inserted, this fields must correspond (have the same names) with the fields from the table in which the data need to be inserted (the order its not important)
Data as attributes format its pretty much the same thing like the data as nodes, the differences its that the fields are specified as attributes instead as nodes, see below an example:
<?xml version="1.0" encoding="[encoding]"?>
<[root node]> // this is the root node and can have any name you want
<[row] [field1]="[field1 value]" ... [field_n]="[field_n value]" />
... more rows
</[root node]>
I think you can adapt your xml format to match one of supported formats. If so you can easily import and export your data.
Regards,
Marius.
|
|
|
