Categories
View Replies (9)

Resolved [SOLVED ]Import | Update jos_virtuemart_products

  1. webcouleur
    webcouleur
  2. RO CSVI
  3. Saturday, 15 August 2015
  4.  Subscribe via email
CSVI Pro 6.0.1
Joomla 3.4

Hi Roland,

I'm trying to set up my first import routine, upload a csv file and update the jos_virtuemart_products with the actual product stock values. My csv file contains the following 3 fields :

product_sku, product_gtin and product_in_stock

[table]
[tr]
[td]product_sku[/td]
[td]product_gtin[/td]
[td]product_in_stock[/td]
[/tr]
[tr]
[td]10203894[/td]
[td]7680329340211[/td]
[td]100[/td]
[/tr]
[tr]
[td]10203860[/td]
[td]7680329350289[/td]
[td]100[/td]
[/tr]
[/table]
(Please see CSV file attached)

I have created my import template (please see attached docx file)
I have created 3 template fields (please see attached docx file)

When I'm running the import process, uploading the csv files etc. the process works fine...

But instead of updating the 2 records which are already in the database, 2 records are added in the jos_virtuemart_products table.

I tried also to open the product_in_stock and product_gtin template field in order to take a screenshot, but the following error messages occured : Template with ID 4 has not been found for the first and Template with ID 5 has not been found for the second (Please see attached docx file).

I'm certainly missing something and I would appreciate if you could advise me how to update instead of insert data. I tried to set rules for each fields, without success, but since I was unable to understand how it's works and don't know if they are really needed in my case, I skip it.

Thanks in advance for your support.

Marc

ps: I tried several time to uplad the docx with the screenshots, but I'm unable to. I will send the file to contact@csvimproved.com (+name of the topic).
0
Responses (9)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Marc,

I have created my import template (please see attached docx file)
I see you are creating a custom table import while that is not needed. CSVI has full support for VirtueMart but you must install the VirtueMart addon. To answer your question posted on mail, no, you don't need to do all those tables yourself, if you choose the correct import type, for example product import, CSVI will take care of everything. Read more about it in the Import VirtueMart products tutorial.

I tried also to open the product_in_stock and product_gtin template field in order to take a screenshot, but the following error messages occured : Template with ID 4 has not been found for the first and Template with ID 5 has not been found for the second (Please see attached docx file).
This issue has been fixed in todays releasse 6.1.0. You would still be able to edit the fields by selecting it and click the toolbar button.

I tried to set rules for each fields, without success, but since I was unable to understand how it's works and don't know if they are really needed in my case, I skip it.
Rules are usually not needed unless you need special treatment for your fields.
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. # 1
webcouleur
webcouleur
Accepted Answer Pending Moderation
Hi Roland,
Thank you for your explanations. It is clear now. I have downloaded the virtuemart addon, I will install it and try again to create my Import template. I will carefully read your Import VirtueMart Product tutorial.
Concerning our script issue, I will send you a email to contact@csvimproved.com.
Cheers,
Marc Quentier
  1. more than a month ago
  2. RO CSVI
  3. # 2
webcouleur
webcouleur
Accepted Answer Pending Moderation
Hi Roland,

I tried also to open the product_in_stock and product_gtin template field in order to take a screenshot, but the following error messages occured : Template with ID 4 has not been found for the first and Template with ID 5 has not been found for the second (Please see attached docx file).

This issue has been fixed in todays releasse 6.1.0. You would still be able to edit the fields by selecting it and click the toolbar button.


I have installed the new realease, but my template fields are still locked.

When I'm trying to create a new template field for my template, I get the following message : Erreur
COM_CSVI_NO_AVAILABLE_FIELDS_FOUND.

Thanks in advance for your support.

Cheers,

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

I have installed the new realease, but my template fields are still locked.
You can edit them using the toolbar button or not? There shouldn't be any lock icon before the field as this has been removed completely.

When I'm trying to create a new template field for my template, I get the following message : Erreur
COM_CSVI_NO_AVAILABLE_FIELDS_FOUND.
Is this for the template of the custom table operation? Have you created a new template for the VirtueMart product import?

Do you see any available fields on the Available fields page?
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
webcouleur
webcouleur
Accepted Answer Pending Moderation
Hi Roland,

You can edit them using the toolbar button or not? There shouldn't be any lock icon before the field as this has been removed completely.


No I can't edit it using the toolbar button.

Is this for the template of the custom table operation? Have you created a new template for the VirtueMart product import?


I've got one template for which I have created 3 templates fields which are blocked (please see screencapture). When I'm trying to create a new template field by clicking on "New" button (view=templatefields), I get the error message.

If you want I can grant you access to the backend it is perhaps easier for you.
Attachments (1)
TEMPLATEFIELDS.jpg TEMPLATEFIELDS.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Do you see any available fields on the Available fields page?

What have you set for operation in the template?
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
webcouleur
webcouleur
Accepted Answer Pending Moderation
Hi Roland,

I just experienced something weird. I created a new Import Template and added a new template field to this template. And 2 records have been created (please see TEMPLATEFIELDS-2 DB.JPG) !? I had the same issue this morning when I created your Joomla Backend Support account.

Cheers,

Marc
Attachments (2)
TEMPLATEFIELDS-2.jpg TEMPLATEFIELDS-2.jpg
TEMPLATEFIELDS-2DB.jpg TEMPLATEFIELDS-2DB.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 7
webcouleur
webcouleur
Accepted Answer Pending Moderation
Hello,

Do you see any available fields on the Available fields page?

Yes about 300

What have you set for operation in the template

Operation field value is Custom Tables (which is the only possible choice)
  1. more than a month ago
  2. RO CSVI
  3. # 8
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Marc,

I have reset the Tasks for you and now you can also select VirtueMart operations in your template. As for the duplicate fields, I don't see that happen on your site.

On a sidenote, no need to fill the Your Field, this is not needed for normal operations.
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
  • Page :
  • 1


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