I am desperate trying to import this xml to the sqlite without any success using navicat application as well as some other application and scripts all are give me some error and below the xml;
<?xml version="1.0" encoding="UTF-8"?>
<S:Envelope xmlns:S="http://ift.tt/sVJIaE">
<S:Body>
<ns2:getBooksPerCategoryByLanguageResponse xmlns:ns2="http://ws/">
<return>
<author>memo rangos </author>
<averageRating>3.0000</averageRating>
<categoryId>0</categoryId>
<categoryName>computer test</categoryName>
<contentType>application</contentType>
<description>bla bla bla bla</description>
<fileName>12154867shbakat..zip</fileName>
<filePath>http://ift.tt/1AsA8Sg;
<id>1820</id>
<image>http://ift.tt/1Ac2Bsg;
<manufacturerId>67</manufacturerId>
<manufacturerName>mr romano barhan</manufacturerName>
<metadata>
<author>romano burhano </author>
<bookFormat>.zip</bookFormat>
<edition/>
<language/>
<numberOfPages>460</numberOfPages>
<originalAuthor/>
<originalLanguage/>
<originalPublisher/>
<originalTitle/>
<publishingDate>2009-01-01</publishingDate>
</metadata>
<name>networks benfit</name>
<onlin.ziplishDate>27/12/2014</onlin.ziplishDate>
<priceExTax>15.9900</priceExTax>
<priceIncTax>15.99</priceIncTax>
<priceSAR>59.9900</priceSAR>
<rating>5.0000</rating>
<type>1</type>
<url/>
<version>0</version>
</return>
<return>
<author>bool makfev</author>
<averageRating>3.0000</averageRating>
<categoryId>0</categoryId>
<categoryName>computer test</categoryName>
<contentType>application/octet-stream</contentType>
<description>windows 8</description>
<fileName>282205329_Teach Yourself Visually Windows 8.zip</fileName>
<filePath>http://ift.tt/1Ac2z3K;
<id>984</id>
<image>http://ift.tt/1AsA9Ww;
<manufacturerId>46</manufacturerId>
<manufacturerName>jarrer</manufacturerName>
<metadata>
<author>bool makfed</author>
<bookFormat>.zip</bookFormat>
<edition/>
<language>arabi</language>
<numberOfPages>340</numberOfPages>
<originalAuthor>Paul Mcfedries</originalAuthor>
<originalLanguage>arabic</originalLanguage>
<originalPublisher>John Wiley & Sons Ltd.</originalPublisher>
<originalTitle>Teach Yourself Visually Windows 8</originalTitle>
<publishingDate>2012-01-01</publishingDate>
</metadata>
<name>Windows 8</name>
<onlin.ziplishDate>19/06/2013</onlin.ziplishDate>
<priceExTax>9.9900</priceExTax>
<priceIncTax>9.99</priceIncTax>
<priceSAR>36.9900</priceSAR>
<rating>0.0000</rating>
<sampleUrl>http://ift.tt/1Ac2z3M;
<type>1</type>
<url/>
<version>0</version>
</return>
</ns2:getBooksPerCategoryByLanguageResponse>
</S:Body>
</S:Envelope>
thanks our any best way to import xml to sqlite
No comments:
Post a Comment