I am unable to import test products using cronjobs, tried different settings.

[ivanessans]

Hi all!

To import products, I used the instructions at this link: https://aimeos.org/docs/2023.x/cronjobs ... est-import

I also want to display my settings file:

Code: Select all

	....

	'jobs' => [
		'product' => [
			'import' => [
				'csv' => [
					'location' => public_path( '/aimeos/products-import-example.csv' ),
					'container' => [
						'type' => 'Directory',
						'content' => 'CSV',
					],
					'skip-lines' => 1,
				]
			],
			'export' => [
				'location' => public_path('aimeos')
			]
		]
	],

	....

In the file "product-import-example.csv" I replaced "path/to/image2.jpg" with "".

Run command from terminal:

Code: Select all

> php artisan aimeos:jobs "product/import/csv" "default"

Unfortunately, I did not see an error, and the products were not displayed in the admin panel at my-shop.ru/admin/default/jqadm/search/product?locale=en
Throws an error only if there is no connection to the database (server not enabled).

However, the command run from the terminal was completed successfully:

Code: Select all

> php artisan aimeos:jobs "product/export/sitemap" "default"

Versions:
aimeos-laravel - 2023.04
Laravel - 10.12.0
PHP - 8.1
MySQL - 8.0
Windows 10

Please tell me how to import products?

[ivanessans]

Please HELP solve the problem! Tried different options. I have no one else to turn to.

The site is loading. There is access to the database. Can't import products.

[aimeos]

Your location path is wrong. If you've upgraded from 2022.x to 2023.x, it changes from an absolute path to a relative path within the virtual file system defined here:
https://github.com/aimeos/aimeos/blob/m ... #L115-L118

By default (without your configuration), it would be:

Code: Select all

./storage/import/product/

Remove these lines in your config and place your file in the directory mentioned above to import your file:

Code: Select all

'location' => public_path( '/aimeos/products-import-example.csv' ),
'container' => [
	'type' => 'Directory',
	'content' => 'CSV',
],

[ivanessans]

Thanks, it worked!