× Looking for a useful answer?

Read this first and make sure you checked all steps: csvimproved.com/support/getting-started

Don't just say it doesn't work but describe in detail what is happening and add the following information:
* Version of the extension you are using
* CSVI version (Latest is not a version number)
* Sample of the file being imported
* A copy of the template you are using. Use the maintenance menu to create a backup of your template
* Collected debug information

Without this information you won't get a useful answer. If no debug log is attached, you will get a request to post it.

Where to get the debug information?

A tutorial ( csvimproved.com/support/questions-and-answers/390-how-to-collect-debug-information ) has been written to help you collect your debug information.

Import muliple value for the same customfield

  • keep
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
More
1 month 3 weeks ago #60343 by keep
keep created the topic: Import muliple value for the same customfield
There is a site where are several virtuemart custom fields. These are mostly meta params of the product, like: color, material etc.
I run the 'available fields' script of CSVI and added them to the export template as template field.
The export/import is fine except one thing.
There is a custom field which is called 'gifts' and sometimes multiple instances of this field is binded to the product, because some products contains 1 gift, some other containts 3 gifts etc. So in the #__virtuemart_product_customfield table there are multiple rows with the same virtuemart_product_id and virtuemart_custom_id
How can I export/import these fields?
The main goal would be building a product filter with breadesigns' custom filters extension and use a checkbox to filter the products where a specified gift is available.

Please Log in or Create an account to join the conversation.

More
1 month 3 weeks ago #60345 by tharuna
tharuna replied the topic: Import muliple value for the same customfield
Hello,
For exporting and importing multiple values you need to use custom_title, custom_value and custom_param as available fields. Check Product import with custom fields document for import examples and Product export with custom fields for export examples.

Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory

Please Log in or Create an account to join the conversation.

  • keep
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
More
1 month 3 weeks ago #60351 by keep
keep replied the topic: Import muliple value for the same customfield
Hello

Yes, I found it, it's ok for me, but it makes more hard to handle that for the data admin, who is not a programmer.
Could you please consider adding a spearator-based version, like file_url or category_path where I can set multiple values via a single field with a | separator character?
It would be much more easy to read/handle that

Please Log in or Create an account to join the conversation.

More
1 month 3 weeks ago #60356 by tharuna
tharuna replied the topic: Import muliple value for the same customfield
Hello,
Thank you for your feedback. We do have the plan of making custom fields handling in a more user friendly way and you can expect these changes with CSVI 8 version which we are planning to release later this year.

Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory

Please Log in or Create an account to join the conversation.

More
1 month 3 weeks ago #60366 by rolandd
rolandd replied the topic: Import muliple value for the same customfield
Hello,

You are asking for a more friendly format, but what do you suggest? If we take the example CSV

product_sku;custom_title;custom_value;custom_price;custom_param;custom_disabler;custom_override
H01;Size~Size~Size;34~36~38;24~26~28;Y~N~Y;Y~N~Y


You have a Size field with different sizes and values. How would you propose to handle that? I am just looking for some feedback here :)

Kind regards,

RolandD

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory

Please Log in or Create an account to join the conversation.

  • keep
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
More
1 month 3 weeks ago - 1 month 3 weeks ago #60373 by keep
keep replied the topic: Import muliple value for the same customfield
maybe something like this:
product_sku;color;material;gifts
sku1;black;metal;case
sku2;white;metal;case|cable|spare buttons
sku3;white;plastic;

It's quite similar to multiple category_path or file_url values
Last edit: 1 month 3 weeks ago by keep.
The following user(s) said Thank You: rolandd

Please Log in or Create an account to join the conversation.