Categories
View Replies (16)

Resolved rename product images

  1. pascal_pasvorm
    pascal_pasvorm
  2. RO CSVI
  3. Friday, 05 October 2018
  4.  Subscribe via email
Hi,
I need to rename current product image filenames.
Did export
product_sku file_url file_title file_meta file_description picture_url
In this I can find/replace names in file_url

But if I import I want to remove current first, else the new ones are added

So did import: product_sku file_url media_delete
but this gives an error: The media images/stories/virtuemart/product/images/stories/virtuemart/product/bod'or-b17a02-k8.jpg|images/stories/virtuemart/product/bod'or-facet944.jpg has not been found to delete

Looks like first url is double?
What am I missing here?

Another option i'm thinking about is;
copy media folder, rename all files.
Delete all media files in virtuemart
Import product images with csv
Is this a easier way, It will also clean up double/unused images.

Regards,
Pascal
0
Responses (16)
pascal_pasvorm
pascal_pasvorm
Accepted Answer Pending Moderation
Hi Roland,

Changing to lowercase did the job, all fixed now.

Thanks.
Pascal
  1. more than a month ago
  2. RO CSVI
  3. # 1
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Pascal,

Not sure what has happened in your installation because I just setup a multi-lingual VirtueMart setup and the table names are completely lowercase. So I think the best course of action is to also lowercase your table names. The import should be all fine then.
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. # 2
pascal_pasvorm
pascal_pasvorm
Accepted Answer Pending Moderation
Hi Roland,

I noticed this difference also, not sure where this is coming from.
Maybe this happend because i'm exporting from older version,
and import this to a clean, new install.

Using VirtueMart 3.4.2 and Joomla! 3.8.13

Isn't it possible to change/correct the database table?

Regards,
Pascal
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hallo Pascal,

That this is confusing is clear. I think I see why as well. You still get the error
Table lltb_virtuemart_categories_nl_nl has not been found.
correct? If yes, then I can see what the issue is. Looking at your screenshot the table is called lltb_virtuemart_categories_nl_NL and not lltb_virtuemart_categories_nl_nl. Notice the difference in capitals.

Let me know if you still get the error about the missing table, if so, I most likely need to provide a patch to deal with this change in VirtueMart for no longer lowercasing the tablenames.

Which VirtueMart version are you using?
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. # 4
pascal_pasvorm
pascal_pasvorm
Accepted Answer Pending Moderation
Hi Roland,

I still don't understand.
Did add all missing categorie images in vm in Dutch language.
Just took a look at the datebase it shows mainly dutch data on product and categories. (see screens)

Still it's confusing, I just want to export categorie- and product images filenames.
Change the image filenames and upload/replace these.
I'll also rename the actual images in the folder.

What should the export and import file look like for this.

Regards,
Pascal
Attachments (2)
Screen Shot 2018-10-13 at 09.45.25.png Screen Shot 2018-10-13 at 09.45.25.png
Screen Shot 2018-10-13 at 09.45.13.png Screen Shot 2018-10-13 at 09.45.13.png
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Pascal,

Sorry I don't understand....
No problem, I will try to explain again. As your screenshots show that everything is set to Dutch, there is no screenshot of how the data is actually stored in the database. If you were to take a screenshot of that, you will notice that VirtueMart stores the data in tables like virtuemart_products_en_gb and not in tables like virtuemart_product_nl_nl. That is why in your CSVI template you need to select English instead of Dutch.

Does that make it clear?
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. # 6
pascal_pasvorm
pascal_pasvorm
Accepted Answer Pending Moderation
Hi Roland,
Sorry I don't understand....
Attached my settings for joomla, virtuemart and csvi, I'd say all is set to dutch.

How should the import file be set-up?

Regards,
Pascal
Attachments (5)
virtuemart config.png virtuemart config.png
virtuemart-porduct.png virtuemart-porduct.png
joomla language.png joomla language.png
joomla language site.png joomla language site.png
csv language.png csv language.png
  1. more than a month ago
  2. RO CSVI
  3. # 7
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Pascal,

The issue you are seeing is that you are using the Dutch language in the English language tables. So you need to choose English in your template so that the English tables of VirtueMart are used. Let me know if that helps.
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. # 8
pascal_pasvorm
pascal_pasvorm
Accepted Answer Pending Moderation
Im using NL-nl only for site/shop but english is also installed.

If I use NL for primairy and 2nd I get a new error:

Er is een fout opgetreden tijdens de 1import. Hieronder staat het antwoord van de server.
Table lltb_virtuemart_categories_nl_nl has not been found. Check if you have set the correct language in your template settings on the Options tab to continue with import. In case the language is correct, check if the language is enabled in the VirtueMart configuration.

language is set in template and is installed and set in virtuemart...

How can this be fixed, tried all kind of options to just add category images...

Regards,
Pascal
  1. more than a month ago
  2. RO CSVI
  3. # 9
pascal_pasvorm
pascal_pasvorm
Accepted Answer Pending Moderation
Hi Roland,
Just tried a different methode;
import category_path and file_url
now I get this error ?

1 Incorrect Failure The category language has either not been set or not found. The source language is set to nl_nl and the target language is set to en_gb

What should be done to fix this issue.

Thanks,
Pascal
  1. more than a month ago
  2. RO CSVI
  3. # 10
pascal_pasvorm
pascal_pasvorm
Accepted Answer Pending Moderation
Hi Roland,
Last question, I tried to do the same for categorie images.
Using just: virtuemart_category_id and file_url

But this didn't work, should I use this different?

Thanks,
Pascal
  1. more than a month ago
  2. RO CSVI
  3. # 11
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Pascal,

Nothing noteworthy changed. I have not received any bounce emails either.
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. # 12
pascal_pasvorm
pascal_pasvorm
Accepted Answer Pending Moderation
Hi Roland,

Ok I will try this to rename image file names.

ps did anything change because I don't recieve mails anymore if there's a reply on forum topics?

Regards,
Pascal
  1. more than a month ago
  2. RO CSVI
  3. # 13
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Pascal,

To only replace product file name.
If you only want to replace a product file name, you only need to import the field file_url and the product_sku of course.

The option to delete the image relation is only available on the VirtueMart Product import, so you would need to use that template for this import.

As said, if you enable that option, the relation between the product and image is removed and the new one is inserted.

Does that help?
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. # 14
pascal_pasvorm
pascal_pasvorm
Accepted Answer Pending Moderation
Hi tharuna,

For second option are these the only field necessary; product_sku file_url media_delete?
To only replace product file name.

Attached the debug file, maybe error is because I need 'Image tab set Delete image relations to Yes'

I created a template: import - virtuemart - media
But at tab -image- I have no option to delete?
Or should this be done first in a seperate template.
Regards,
Pascal
Attachments (1)
com_csvi.log.151.zip
  1. more than a month ago
  2. RO CSVI
  3. # 15
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Pascal,
Two ways to remove the current product images and import the new ones in VirtueMart.

1. In CSVI Maintenance menu, select VirtueMart in first option, Remove Product media link in the second option and click continue. This will remove all the links between media and products. You can then import the new images.
2. Another way is in your import template settings on Image tab set Delete image relations to Yes and save the template. This option will delete the product and media relation of a product and then imports the new one.

Do note that the first option is to remove media for all products in VirtueMart and second is to remove image based on the product imported.

So did import: product_sku file_url media_delete
but this gives an error: The media images/stories/virtuemart/product/images/stories/virtuemart/product/bod'or-b17a02-k8.jpg|images/stories/virtuemart/product/bod'or-facet944.jpg has not been found to delete

Looks like first url is double?
What am I missing here?

Can you send us your debug log to check? Check how to get debug information? document to get the debug log.
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
  • Page :
  • 1


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