Categories
View Replies (3)

Resolved custom fields with multiple values

  1. joely666
    joely666
  2. RO CSVI
  3. Tuesday, 18 October 2016
  4.  Subscribe via email
Joomla version, 3.6.2
VirtueMart 3.0.10
CSVI Pro 6.6.4

Hi,

When I have multiple values for custom fields I have been importing like so:
custom_title;custom_param;custom_value;custom_ordering
Branch~Branch~Branch~Branch;;2~3~4~5;1~2~3~4

This works fine for me, but not for clients who need to upload files to run as cron jobs.
My other custom fields are populated as individual columns in the csv file. I have tried simply repeating the field in the template/csv file like below:
Branch;Branch;Branch;Branch
2;;4;5
;3;;5
2;3;4;5

But only the first field is added.
Is there any configuration that would allow me to do this?
Also I should add that I don't want to combine the data in these fields as they are individual entities used by the Custom filter component.
Thanks,
Joely
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Joely,
This works fine for me, but not for clients who need to upload files to run as cron jobs.
My other custom fields are populated as individual columns in the csv file. I have tried simply repeating the field in the template/csv file like below:
Branch;Branch;Branch;Branch
2;;4;5
;3;;5
2;3;4;5
But only the first field is added.
Is there any configuration that would allow me to do this?

You can have individual columns only if the custom field is available as a available field in CSVI. Not sure if Branch is an example field, if you want to have multiple values for a custom field you either need to use it with multiple separator ~ and with custom_multiple field or you can set custom field value as each row instead of column. You can have a look at product import with custom fields documentation. If you need any more help send us your sample import file to check along with your debug log.

Also I should add that I don't want to combine the data in these fields as they are individual entities used by the Custom filter component.

This import wont combine the data in the fields, it is just an order we follow in CSVI so the import file and process looks compact and friendly. Once the import is done without any issue, the values will be same as what VirtueMart saves when you do so on backend.
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
joely666
joely666
Accepted Answer Pending Moderation
Thanks for your reply. In my example 'Branch' is a custom field available to add to my import template. The problem is I want 4 instances of this. I can add 4 instances to the import template, which maps correctly to my csv file, but only the first column is added to the product. So my question is if there is a configuration for the import template which will allow for four instances of the same custom field to be added in this way, rather than by using custom_title and custom_value with tilde separated data.

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
In my example 'Branch' is a custom field available to add to my import template. The problem is I want 4 instances of this. I can add 4 instances to the import template, which maps correctly to my csv file, but only the first column is added to the product.

Thats correct. CSVI can read only the first instance of custom field. For multiple values you need to have them combined with ~ character and with custom_title and custom_value fields.

So my question is if there is a configuration for the import template which will allow for four instances of the same custom field to be added in this way, rather than by using custom_title and custom_value with tilde separated data.

There is no configuration to import multiple instance of a custom field without using custom_title and custom_value fields.
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. # 3
  • Page :
  • 1


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