XML Online Feed to MYSQL
6 years 7 months ago #6677
by Daniel
Thanks
Daniel
Replied by Daniel on topic Import a column (XML File) into one line each
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
1) url
2) ftp,
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
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
1) url
2) ftp,
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
Thanks
Daniel
Please Log in to join the conversation.