i have had made in the past a php file to download a supplier list in xml format, import it to a temp database with a datestamp
then the file will check to see if product exists or not, has been removed from the file since last time or not and if the price has changed.
that supplier went bust, i am trying to tweak the file to produce the same results from a different supplier feed.
i have it logging in and downloading a xml file to local xml file.
when it starts processing the file i get an error message:-
.Error database when insert targetproduct : INSERT INTO `tl_target_importproducts` (`table_id`, `target_id`, `zen_product_id`, `creation_date` , `target_product_name` , `product_description`, `product_image`, `product_price`, `product_status`, `product_lastmodification_number`, 'target_description', `target_extendeddescription`)VALUES (NULL, NPNET-WNAP210200, -1, NULL, '0', '
i have ran mysql and executed 'LOAD XML LOCAL INFILE' to take local file in to a test database which i have already added.
and it works.
here is a snippet of my xml datafile excluding data, the only spaces are at the top after <items>
<?xml version="1.0" encoding="UTF-8"?> <items> <item> <stockcode></stockcode> <description></description> <extendeddescription></extendeddescription> <imageurl></imageurl> <thumbnailurl></thumbnailurl> <largeimageurl></largeimageurl> <manufacturer></manufacturer> <manupartcode></manupartcode> <weight></weight> <stock></stock> <price></price> <price5off></price5off> <price20off></price20off> <category></category> </item>