Hi!
Since I haven't had an answer to my topic since last friday --maybe because I added too many sub-topics to it in the late questions. I decided to post in separate topics.
I managed to read again the documentation (at
http://docs.abantecart.com/pages/tools/import.html#Example4:insert) about importing and found out that I was missing a lot columns when trying to import the references for the images of each product.
Turns out that for each image there are about 8 columns needed to include in the CSV file.
resource_map[0].resource_id = leave empty
resource_map[0].object_name = products
resource_library[0][0].type_id = 1
resource_descriptions[0][0][0].language_id = 1 (the id of installed language)
resource_descriptions[0][0][0].name = anyname (usually imagefile name)
resource_descriptions[0][0][0].title = leave empty or fill if you need title
resource_descriptions[0][0][0].description = leave empty or fill if you need description for the resource
resource_descriptions[0][0][0].resource_path = somefolder/product_image_1.jpg
So I added the correct 40 columns --differing in their ([0][0][0]) numbering ([1][0][0], [2][0][0]... and so on) for up to 5 images max.
I split into 100-rows CSV files in order to avoid a Gateway error due to a big files with too much data, but even with this small file, when uploading the CSV file I got this error:
"
Total loaded: 6. Updated: 0. Created: 0. Errors: 6
There are some errors. Show details
Insert data error for products SQL Error: Duplicate entry '127' for key 'PRIMARY'
Error No: 1062
SQL: INSERT INTO `abc_products` SET `product_id` = '127'
Missing special relation ID product_id for insert action in table resource_map. Skipping.
Missing special relation ID product_id for insert action in table resource_map. Skipping.
Missing special relation ID product_id for insert action in table resource_map. Skipping.
Missing special relation ID product_id for insert action in table resource_map. Skipping.
Missing special relation ID product_id for insert action in table resource_map. Skipping.
"
I did these CSV files following the instructions on the documentation page which all required columns which are included so I don't know what's going on? Is this a bug at the import?
Please somebody help as I'mpretty stuck at the moment for this problem.
I attach sample of the CSV files.
Thanks!