Categories
View Replies (5)

Resolved Importing multiple values for a string/list custom field

  1. konstantinos29
    konstantinos29
  2. RO CSVI
  3. Thursday, 27 June 2019
  4.  Subscribe via email
Hello,

I want to import a custom field of multiple values for products, in the same CSV with the product.

The custom field is of type string, with "is a list" enabled.

Virtuemart documentation describes that the way to enter the multiple list values, is by separating them with semicolons.
e.g.: "1998;1999;2000;2001"

This is the way I attempted to do it in the CSV. The field, however, fails to be populated correctly in VM.

Any thoughts?

Thanks
0
Responses (5)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Also look,

The field values are separated during import in VM and in the frontend (they appear in normal order in the csv).

CSV:
Χρονολογίες~Χρονολογίες~Χρονολογίες~Χρονολογίες~Τεμάχια~Τεμάχια,"1999~2000~2001~2002~1 τμχ~2 τμχ"

Your field Χρονολογίες is a string custom field? When i create a String custom field with Is a list option set to Yes, i don't see any option to save it as you mentioned "1998;1999;2000;2001". Can you send me a screenshot of how you have this custom field? Also the VirtueMart document link which explains about its values.
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
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Yes for multiple values you need to use custom_title and custom_value fields. You can use your string custom field as an individual field if it has a single value. That is explained in "BASIC IMPORT WITH CUSTOM FIELDS" section of above linked document.
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. # 2
konstantinos29
konstantinos29
Accepted Answer Pending Moderation
Also look,

The field values are separated during import in VM and in the frontend (they appear in normal order in the csv).

CSV:
Χρονολογίες~Χρονολογίες~Χρονολογίες~Χρονολογίες~Τεμάχια~Τεμάχια,"1999~2000~2001~2002~1 τμχ~2 τμχ"

Actual results (see screenshots)
Attachments (2)
separated-fields-001.png separated-fields-001.png
separated-fields-002.png separated-fields-002.png
  1. more than a month ago
  2. RO CSVI
  3. # 3
konstantinos29
konstantinos29
Accepted Answer Pending Moderation
Thanks,

If I have multiple custom fields, each having multiple values, I need to import them all in one line?

e.g.
custom_title: "field 1~field 1~field 1~field 2~field 2"
custom_value: "value 1~value 2~value 3~value 4~value 5"

No way to do it separately for each field?
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Take a look at Product import with custom fields document and under "CUSTOM FIELDS WITH MULTIPLE VALUES" section to know to import String custom field with multiple values.
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. # 5
  • Page :
  • 1


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