CSV Import file location setup issue?
Posted: 12 Oct 2016, 03:36
I am working for the first time on a setup for importing product records with CVS. When I run
I get an error message: [Aimeos\Controller\Jobs\Exception]
Number of apostrophes don't match
I suspect the message is misleading and I am just not reading the the right file.
My store array has this for location:
I know the CSV file is at this location. I export it with phpexcel for laravel.
One record looks like this:
I am using the default mapping. (I will fine tune it after I know I can import.
I looked at the log but I cannot make sense out of it. If you want I can send it to you.
Seperate question: where can I find the commands for the cron jobs. I found this one on this forum.
Any help is welcome!
Alfred
Code: Select all
php artisan aimeos:jobs product/import/csv
Number of apostrophes don't match
I suspect the message is misleading and I am just not reading the the right file.
My store array has this for location:
Code: Select all
'controller' => array(
'jobs' => array(
'product' => array(
'import' => array(
'csv' => array(
'location ' => 'C:\Users\alfre\OneDrive\Websites\digital_ocean_procects\ga_delivery\storage\public\uploads\products.csv',
'skip-lines' => 1,
),
),
),
),
),
One record looks like this:
Code: Select all
"859162005091","","2","","long","Auntie Delores-Chili Lime Peanuts 50mg","strain","","","","","","","","","","","",""
I looked at the log but I cannot make sense out of it. If you want I can send it to you.
Seperate question: where can I find the commands for the cron jobs. I found this one on this forum.
Any help is welcome!
Alfred