1. maik85
  2. RO CSVI
  3. Thursday, 03 March 2016
  4.  Subscribe via email
Hi,
I tried to import products. In my template the option process images is set to "NO". In my CSV File I've the file_url with the path to my existing files. But on import CSVI is creating for all files new images with the default path.



CSVI PRO 6.5.3

Regards,
Maik

Edit: Add Attachements seems not working, I've added log and csv, but it is not visible
Accepted Answer Pending Moderation
Hello Maik,
Please try compressing the files and post them.
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
Accepted Answer Pending Moderation
The CSV File is now attached, but cant add the log...it is a zip with 694kb
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

Please do an import with a few products only, that is enough to show what is going on. The log file will be significantly smaller. Thanks.
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. # 3
Accepted Answer Pending Moderation
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Maik,

The log and file makes it clear what happened but not what you actually want happening. Do you not want to import the file_url and file_url_thumb field? If so, you can set the fields to Skip in your template.

The Process images No, will still import the images but not try to resize, download etc. You are correct the default path is used but this field is hidden if you set the Process images to No. If you do want to import the images with the correct path. Please specify the correct path in the template and set the Process images to No. CSVI will use what you have entered into the image location path.

Does that help you?
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. # 5
Accepted Answer Pending Moderation
Hello Roland,

the files are still exists in the media table. What I want is, that CSVI add the medias to the product ... in fact update the table virtuemart_product_medias with the correct existing media ID's.

The file_url in my csv file is the complete url. So the path must be empty in my template settings, but in this case CSVI used the default path.

Best Regards,
Maik
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello Maik,

So if I understand correctly your images are located at
http://example.com/images_virtuemart/.... 


CSVI takes the default path because in that case you don't have to enter anything. This is indeed an issue in your case because there is nothing in the field.

First way of going about this is to enter images_virtuemart/ into the images location field and remove that part from your import file. This should make the CSV file more readable as well. I don't know if HALFAR is always the same otherwise you could add that as well.

Second way that may work, haven't tried it, is to enter ./ (dot and slash) into the field, this means the current folder.

These are the 2 things I can think of now.
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. # 7
Accepted Answer Pending Moderation
Hello Roland,

It is still not working. I deleted images_virtuemart/ and added it to the template configuration. But CSVI is still creating new media files and don't use the existing ones.

Regards,
Maik
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello Maik,

I have analyzed your new log and file. CSVI is indeed adding images but that is not the only thing, CSVI is also updating images. It finds the very first image images_virtuemart/HALFAR/1101401-406.jpg but not the ones after that. This raises a few questions, first of all, what is the filename stored for the other images, it perhaps is not the same as what CSVI is looking for. If you could do a media export of the file_url field that would be helpful as well to see what is currently there.

Second question is, what is CSVI looking for. That I can't see yet but I have attached a patch file. If you can load the patch file, after that run the import once more, we will be able to see what CSVI is looking for.

With these 2 pieces of the puzzle I think we can see why it is doing an insert instead of an update.
Attachments (1)
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. # 9
Accepted Answer Pending Moderation
Hello Roland,

It seems there was also some files missing.

So now CSVI updates the images and dont't added new ones. But CSVI updates all image information like title, thumb_url, role, file_desc ...

But why? If I say don't process images on product import it can't be, that CSVI override my image details???

Best Regards,
Maik
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello Maik,

But why? If I say don't process images on product import it can't be, that CSVI override my image details???
The product import does all kinds of checks for importing media to make sure all data is complete. Also the media import does all the extra checks and data filling.

If you only want to change the file_url field, you can only use the custom table import, this does no checking whatsoever and only deals with the fields you are importing. Only downside is that it is more work. You will need to run an export of the virtuemart_media table with at least the virtuemart_media_id and file_url fields and then you can update the fields as needed.

Finally another option is to make an override of the product import and strip out all the checks/changes you don't want.
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. # 11
Accepted Answer Pending Moderation
Hello Roland,

On the product import I want to change nothing of the media details. The only thing I want to do is, apply the medias to the product. But nothing of the media details should be changed.
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello Maik,

That is not possible with the product import or the media import, but is possible with the custom table import. This will work for existing media but not new ones.

Each media item requires a minimum amount of information, that is what CSVI is adding in the product and media import. If all you want to do is change an existing file_url value with a new one, the custom table import is what needs to be used. If you need help with that, we will be happy to assist.
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. # 13
Accepted Answer Pending Moderation
Hi Roland,

It seems you don't understand. I don't want to change anything of the media. The only thing I want is, to assign the existing medias to the product, and this on the same time with the normal product import.

I think this must be a normal feature. Only assign the medias to the product, but don't touch the media details.

Regards,
Maik
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello Maik,

I think we have finally reached the point where we understand each other :)

So what you are asking for isn't there, all imports that do something with media manages the media table. What you are asking for is to only store the media product relation.

I can see this being useful so will add it to the list for the next release. When we have a patch available it can be send to you so you don't have to wait for the next release if you want.
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. # 15
Accepted Answer Pending Moderation
OK fine, if you add it to the next release. Atm I'll use a temporary hack. You can send me the patch if you have done it.

Regards,
Maik
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello Maik,

Will do, the request is already on the todo list.
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. # 17
Accepted Answer Pending Moderation
Hello Maik,
We have the patch ready for this feature. We have added a new option in template settings under Image tab as "Update media link only", when set to Yes, code will check for file_url in media table and create product media relation if does not exists. Please test and let us know.

patch_vm_medialink_2016-03-21.zip
Attachments (1)
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. # 18
  • Page :
  • 1


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