Importing CSV file with images

20.09.2021 13:04
#1
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 263
Quote
Importing CSV file with images

Currently I import file then add image manually in Admin

Is there a tutorial to import images in one step
I have the Universal import module

thank you

 
20.09.2021 13:45
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 26146
Quote
Aw: Importing CSV file with images

https://www.joomshopping.com/forum/posts/7/2610.html

Field: images - list images
Type: string(Name, Url)
Example Name: test.jpg|test2.jpg|test3.jpg
Need upload 3 file in ftp folder /components/com_jshopping/files/img_products

 
21.09.2021 08:03
#3
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 263
Quote
Aw: Importing CSV file with images

thank you so much

 
27.09.2021 13:41
#4
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 263
Quote
Aw: Importing CSV file with images

I did all that

Field: images - list images
Type: string(Name, Url)
Example Name: test.jpg|test2.jpg|test3.jpg
Need upload 3 file in ftp folder /components/com_jshopping/files/img_products


this is my simple CSV file with URL option for images
id images
3970 3970.jpg
3975 3975.jpg
4029 4029.jpg

attached is error log

please assist
Aw: Importing CSV file with images

 
27.09.2021 21:38
#5
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 26146
Quote
Aw: Importing CSV file with images

1. file uploaded in folder /components/com_jshopping/files/img_products?
2. Configuration
For image Type: Name?


Last change: 27.09.2021 21:39
 
27.09.2021 23:04
#6
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 263
Quote
Aw: Importing CSV file with images

ok, tried name and it worked

see attached except for 1

any ideas, I will investigate on my end too
Aw: Importing CSV file with images

 
27.09.2021 23:52
#7
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 263
Quote
Aw: Importing CSV file with images

it worked this time so all good thank you

 
28.09.2021 04:46
#8
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 263
Quote
Aw: Importing CSV file with images

thank you
I have had success when using the import option for images however the file name has a prefix of "img_"

How can I avoid this prefix please

In particular the field name PRODUCT_IMAGE_NAME has no prefix and the IMAGE field has "img_" prefix in this table
_jshopping_products table

When using Universal Export it appears to be showing the IMAGE field ?

The purpose of this execsise is to have all the image files equal to the product ID
product_id product_thumb_image product_name_image product_full_image image

no I realise that they dont align and the import seems to only update the IMAGE field
please assist

Any thought on this please

cheers Nick


Last change: 28.09.2021 09:09
 
28.09.2021 07:41
#9
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 26146
Quote
Aw: Importing CSV file with images

\administrator\components\com_jshopping\importexport\unicsvimport\unicsvimportdata.php

row 456

Try delete
$imgName = "img_" . $imgName;

 
28.09.2021 14:07
#10
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 263
Quote
Aw: Importing CSV file with images

do I delete the whole row ?

 
28.09.2021 15:47
#11
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 26146
Quote
Aw: Importing CSV file with images

Yes.

 
28.09.2021 22:45
#12
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 263
Quote
Aw: Importing CSV file with images

thank you

that worked perfectly so the IMAGE field now has no IMG_ in the file name

what is the relationship of the IMAGE field and these fields
product_thumb_image product_name_image product_full_image

how can I align them to be all the same as the IMAGE field please

 
29.09.2021 07:53
#13
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 26146
Quote
Aw: Importing CSV file with images

what is the relationship of the IMAGE field and these fields
product_thumb_image product_name_image product_full_image

how can I align them to be all the same as the IMAGE field please


?
Error ?

 
29.09.2021 09:10
#14
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 263
Quote
Aw: Importing CSV file with images

what do you mean ?

dont understand your question

when I import existing ID the IMAGE field is updated but the other fields do not change name ?

 
29.09.2021 11:10
#15
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 26146
Quote
Aw: Importing CSV file with images

I do not understand you.
Screenshot?

 
29.09.2021 11:48
#16
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 263
Quote
Aw: Importing CSV file with images

in _jshopping_products table there are several image fields

product_thumb_image product_name_image product_full_image image

where are my image files not the same name in all tables ?

 
29.09.2021 14:35
#17
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 263
Quote
Aw: Importing CSV file with images

just sent a private message as I now need urgent help
image import not worked and deleted images
many images deleted !

please help

 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.