Hi everyone! I've been using vData for awhile now and have a new client that needs a csv import procedure to update their Joomla component for real estate rentals.
I have a CSV with all the columns matched / named for all the database columns (rem_houses), and would like to JOIN another table (rem_photos) from a column in the CSV called 'images' - but the column has multiple image names, separated by semicolons. I would like to import this data into individual rows of the rem_photos table, each one inserting the column 'propid' with the associated propid for that record.
source data (CSV):
houseid images
2162 images/Abenaki/Abenaki.01.jpg;images/Abenaki/Abenaki.02.jpg;images/Abenaki/Abenaki.03.jpg;
Destination data (Database):
houseid img
2162 images/Abenaki/Abenaki.01.jpg
2162 images/Abenaki/Abenaki.02
2162 Abenaki/Abenaki.03.jpg
Can this be done? I read the import documentation carefully, but could not figure out how to JOIN and segregate the data without errors.
Thanks in advance!
Importing Realty Data with Images in another table
