Topic-icon XML Online Feed to MYSQL

More
18 Jan 2019 06:44 #6677

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


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Werner Priewasser
  • Werner Priewasser's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
30 Nov 2018 14:10 #6547

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.
best regards
Werner

Please Log in or Create an account to join the conversation.

  • Werner Priewasser
  • Werner Priewasser's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
12 Nov 2018 16:00 #6504

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?
Please help.
Werner

Attachments:

Please Log in or Create an account to join the conversation.

  • Werner Priewasser
  • Werner Priewasser's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
11 Nov 2018 10:26 #6502

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.

Please Log in or Create an account to join the conversation.

More
31 Oct 2018 12:59 #6493

Hello,
Reverted to your email asking for the login details, Please check...

PS: Please do not post the same message in multiple places, it would delay the response process.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Werner Priewasser
  • Werner Priewasser's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
31 Oct 2018 10:31 #6492

Please Log in or Create an account to join the conversation.

  • Werner Priewasser
  • Werner Priewasser's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
31 Oct 2018 09:59 #6491

Hello @ All

I'm desperate to import an XML feed.
My task:
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.
Werner Priewasser

Attachments:

Please Log in or Create an account to join the conversation.

Cron Job Starts