Categories
View Replies (17)

Resolved VirtueMart Product Import- Problem with Image CF

  1. fotisman01
    fotisman01
  2. RO CSVI
  3. Thursday, 15 September 2016
  4.  Subscribe via email
I Have created a VirtueMart product import template with the following fields:

Published - Works Perfectly
Product SKU - Works Perfectly
Product Name - Works Perfectly
Product Weight - Works Perfectly
Product Price - Works Perfectly
Category id - Works Perfectly
Product Description - Works Perfectly
Image Custom Field - DOESNT WORK :unsure:
String Custom Field - Works Perfectly


I use one csv for importing everything!
I the Image Custom Field Row, I'm adding the image id as found in the SHOP->Media Files menu in virtuemart.

BUT the field doesn't seem to import that custom field at all! The String Custom Fields on the other hand work perfectly.

How can i import the media file id in the Image Custom Field???

Please HELP!
0
Responses (17)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you post your import debug log and also your sample import file? Also post the screenshot of your image custom field as you have set in VirtueMart custom fields page.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
fotisman01
fotisman01
Accepted Answer Pending Moderation
I Get - No debug log available

The import does import all the string custom fields but No image custom fields.

I can give you super user access to my website if you want!
Attachments (2)
image-custom-fields.jpg image-custom-fields.jpg
custom-fields-view-in-product.jpg custom-fields-view-in-product.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Please check the section "Where to get the debug information?" on top of this page to know how to get the debug log. I would also need your sample import file. If you can provide these required information, i should be able to find the cause of the issue.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
fotisman01
fotisman01
Accepted Answer Pending Moderation
I'm providing you the Sample Bellow. I home you dont mind the greek letters in the csv! Use UTF-8 to see them.

I changed Set the Enable logging to Yes and now i cannot import at all ( 504 Gateway Time-out )
Attachments (1)
Sample-import-file.csv
  1. more than a month ago
  2. RO CSVI
  3. # 4
fotisman01
fotisman01
Accepted Answer Pending Moderation
Just tryed importing less products ( only 100 ) and i got the Log.

Im attaching it here

https://www.dropbox.com/s/xm1is9g7nsl8wa1/com_csvi.log.67.txt?dl=0
  1. more than a month ago
  2. RO CSVI
  3. # 5
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I am looking into this and will get back to you with a update.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
fotisman01
fotisman01
Accepted Answer Pending Moderation
Thank you very much for the help. I really need it right now!

Have a great day!
  1. more than a month ago
  2. RO CSVI
  3. # 7
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I see the issue, you have used the media ids for your custom fields whereas CSVI is looking for image URL like we have for file_url field and so no processing is happening. It is a rule we have in CSVI that we donot process any records based on ids as they are primary key values of database and using them may mess up the database records. Can you try to give the media url to your custom fields and try the import? I would suggest you to try with few records first and see how it goes.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
fotisman01
fotisman01
Accepted Answer Pending Moderation
Tryed that now, but still no luck. I used the image file ( for example 1.jpg ) or the full path ( images/stories/virtuemart/product/Karlie-img/1.jpg ) but it doesn't seem to get the picture in the Image Custom Field.

I'm attaching the Log again.

I'm also attaching the import file so you can see what I used.

I used the id's before because I tryed to do the reverse action of the export. When I export all the Products, I get the ids on the Picture Custom Field rows!!!!!!
Attachments (2)
com_csvi.log.71.zip
ProdImpCSV-no-link-test.csv
  1. more than a month ago
  2. RO CSVI
  3. # 9
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The reason you get IDs in the Picture Custom Field rows is because CSVI doesn't "translate" the ID to it's actual value. That is something we will add, no problem.

On import, CSVI expects the value of the file_url field as found in the virtuemart_medias table. Can you verify that the value images/stories/virtuemart/product/Karlie-img/117.png exists in the virtuemart_medias table?

I did do a test import with the image and it was fine in my case, we just need to see why it can't find the image in your case.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 10
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The attached patch file will solve the issue of exporting media ids instead of picture urls for media custom field. Load the file from maintenance menu and see if your issue is solved.


patch_mediacustomfield_2016-09-16.zip
Attachments (1)
patch_mediacustomfield_2016-09-16.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 11
fotisman01
fotisman01
Accepted Answer Pending Moderation
Worked just like you described above! Thanks for the good work man!
  1. more than a month ago
  2. RO CSVI
  3. # 12
fotisman01
fotisman01
Accepted Answer Pending Moderation
One more quick question!

If I perform an other import with the same products, and I want to remove the the previous image custom field from the previous import.

Is there a way to do that?

For example, I have product TESTPRODUCT with Image custom field /images/1.jpg
I want to import again TESTPRODUCT with NO Image custom field. What do I put in this row so I can remove the field?
  1. more than a month ago
  2. RO CSVI
  3. # 13
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
If I perform an other import with the same products, and I want to remove the the previous image custom field from the previous import.

Is there a way to do that?

To remove the previous image, you just need to put in your new image value in there. CSVI will update the custom field with new value and remove the previous one.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 14
fotisman01
fotisman01
Accepted Answer Pending Moderation
Thanks for the answer!

The question is a bit different thought. I want to REMOVE the image and remove the image custom field in the new import.

So if there was an image, now there is no image insead.

Is there a way to do that?

Something like a Null on this Custom Field, so it removes the custom field that excisted before in the product!
  1. more than a month ago
  2. RO CSVI
  3. # 15
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
No, there is no way right now to remove only a particular or one custom field for a product but if you want to remove all the custom fields related to a product, you can set 'Delete custom fields relations' to yes on options tab in your import template settings. But again this will remove all the custom fields for a product. If you don't see this option, click on Advanced button on top.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 16
fotisman01
fotisman01
Accepted Answer Pending Moderation
This option worked for me. So that did the job. Thanks!!! Have a nice day!
  1. more than a month ago
  2. RO CSVI
  3. # 17
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!