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/


View All View Non Threaded Newest first
  • 10-17-2005 17:15:39 GMT +2 Gary Fuhrmann

    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>

    • 10-20-2005 15:29:51 GMT +2 Marius STOIAN [InterAKT]Adobe Systems Romania staff

      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.

       
Forums
XML Table Export 1.8.6
© Adobe Systems Romania. All rights reserved.