XML Online Feed to MYSQL
In profile, select include option from the drop down list, and then image and set the folder path(download folder) where you want to copy the image files and save it.
In import, map the image field (whether it is from database or any other format like csv ) and in the drop down select the type of transfer.
In this case we are importing from xml file..
Transfer type are 3
3) directory(absolute path)
So there are two cases : 1) photo field may have only the filename 2) or it will have the complete path
if transfer type is url
case 1) only filename : specify the prefix in the followed field
E.g. filename image.png and it is on the site example.com/images/
So, fill the field with the prefix example.com/images/ and map the xml image field with the corresponding coloumn
case 2) field contains the whole url for image, then skip the prefix field and map the xml field
if transfer type is ftp
cases are the same either it will contain the filename or the whole path
prefix field => ftp_host:FTP HOST|ftp_port:21|ftp_user:username|ftp_pass:password|ftp_directory:filepath/
ftp_directory here is prefix path for the image file
if transfere type is directory
same here, prefix field will be filled if image contains only the filename
How can I import columns in rows?
An XML file contains 10 image data in columns.
These should be imported into 10 lines of a table.
Is there a solution with vData?
I am pleased about the reference or info.
Today I managed to import more than 8 columns with the quick import of vData. Unfortunately, the XML attributes were ignored.
How can I do the rest? Since I can not change the XML file.
What are the correct settings for the import?
What is the difference with Quick Import?
Are only the column names adjusted?
The communication via email does not work. I do not get any answers.
Is my request in progress?
Can I get an offer for a paid solution to my problem?
I am patient, but also under pressure. Yes / No, please wait would be fine.
I am looking forward to reading from you.
Hello @ All
I'm desperate to import an XML feed.
Import an online XML feed into a MySQL table.
The import is aborted after only one column. Unfortunately, I can not correct or edit the XML feed.
If I convert this FEED to a CSV file and start the import it works.
(I convert with this service. www.convertcsv.com/xml-to-csv.htm )
Thus, it lies in the "interpretation of the XML feed".
Does anyone have a reference to a solution?
I am also happy to pay for a solution.
I hope for answers.