Hi I'm trying to import products via csv in virtuemart 3 and everything works ok only that for a product I have to set more values for a string field, how can I pass this information? using | or / it does not seem to go ..
I attach screen
Thanks
Christopher
- webmarketingtrento
- RO CSVI
- Friday, 05 January 2018
- Subscribe via email
0
Accepted Answer
Pending Moderation
Sorry if I was late with the answer but you were right, it works, thanks.
Accepted Answer
Pending Moderation
Hello,
I did not say File tab but Fields tab(as per your screenshot Campi). click on the Select button next to Group by fields and you can see the fields added. Remove them and run the export.
No, I am attaching screens
I did not say File tab but Fields tab(as per your screenshot Campi). click on the Select button next to Group by fields and you can see the fields added. Remove them and run the export.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
--Since you are importing multiple values for a single string custom field you need to use custom_title and custom_value in your import file instead of having your custom --field as an individual column
OK I did not understand, I thought I had to do a different import, now I try. Thank you
--In your export template settings on Fields tab, you have set few number of Group by fields. Remove them and run the export.
No, I am attaching screens
OK I did not understand, I thought I had to do a different import, now I try. Thank you
--In your export template settings on Fields tab, you have set few number of Group by fields. Remove them and run the export.
No, I am attaching screens
Attachments (1)
Accepted Answer
Pending Moderation
Hello,
Since you are importing multiple values for a single string custom field you need to use custom_title and custom_value in your import file instead of having your custom field as an individual column. This is explained in the document i linked in my previous post.
So example of your custom field import for string field Un regalo per sempre will be like
In your export template settings on Fields tab, you have set few number of Group by fields. Remove them and run the export.
Attach file test.csv and file log (com_csvi.log.92.zip) The problem is in the field "Un regalo per sempre"
I have to create 2 strings for the same field see attachment screen-string.jpg
Since you are importing multiple values for a single string custom field you need to use custom_title and custom_value in your import file instead of having your custom field as an individual column. This is explained in the document i linked in my previous post.
So example of your custom field import for string field Un regalo per sempre will be like
product_sku;custom_title;custom_value
12345r;Un regalo per sempre~Un regalo per sempre;Cresima~Battesimo
I set up Italian and exports only 132 products. I enclose log n.94
In your export template settings on Fields tab, you have set few number of Group by fields. Remove them and run the export.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Attach file test.csv and file log (com_csvi.log.92.zip) The problem is in the field "Un regalo per sempre"
I have to create 2 strings for the same field see attachment screen-string.jpg
--CSVI will export product details from the VirtueMart language table as set in your export template settings and on Options tab. Check if you have correct language set in --your export template.
I set up Italian and exports only 132 products. I enclose log n.94
I have to create 2 strings for the same field see attachment screen-string.jpg
--CSVI will export product details from the VirtueMart language table as set in your export template settings and on Options tab. Check if you have correct language set in --your export template.
I set up Italian and exports only 132 products. I enclose log n.94
Attachments (4)
Accepted Answer
Pending Moderation
Hello,
Yes, you can use one csv file to import product and custom fields. Can you post a sample import file to check? Also post the debug log of your import. To know on how to get the debug log check the blue box on top of this page.
Can you explain more on this?
What you have in your import file is what imported. You can add specific custom fields you need to import to your import file.
CSVI will export product details from the VirtueMart language table as set in your export template settings and on Options tab. Check if you have correct language set in your export template.
Thanks for the reply but I do not think so I can solve, I'm importing products from a csv and I can in the same csv also import custom fields only that it does not create more string fields when set more values for a string field.
Yes, you can use one csv file to import product and custom fields. Can you post a sample import file to check? Also post the debug log of your import. To know on how to get the debug log check the blue box on top of this page.
I can not use one for the categories o / when there are multiple values or duplicate the custom field column?
Can you explain more on this?
Is it possible to import only specific custom fields?
What you have in your import file is what imported. You can add specific custom fields you need to import to your import file.
I'm also noticing that if I export the products in csv it exports only 132, why? I have not set limits and there are more than 1000 products
CSVI will export product details from the VirtueMart language table as set in your export template settings and on Options tab. Check if you have correct language set in your export template.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Thanks for the reply but I do not think so I can solve, I'm importing products from a csv and I can in the same csv also import custom fields only that it does not create more string fields when set more values for a string field.
I can not use one for the categories o / when there are multiple values or duplicate the custom field column?
Is it possible to import only specific custom fields?
I'm also noticing that if I export the products in csv it exports only 132, why? I have not set limits and there are more than 1000 products
Thanks
I can not use one for the categories o / when there are multiple values or duplicate the custom field column?
Is it possible to import only specific custom fields?
I'm also noticing that if I export the products in csv it exports only 132, why? I have not set limits and there are more than 1000 products
Thanks
Accepted Answer
Pending Moderation
Hello Christoper,
Have a look at Product import with custom fields document and under section CUSTOM FIELDS WITH MULTIPLE VALUES to know on how to use multiple values for custom fields.
Have a look at Product import with custom fields document and under section CUSTOM FIELDS WITH MULTIPLE VALUES to know on how to use multiple values for custom fields.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »