Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Friday 4:35 am
Add a reply View Replies (4)

Resolved I can't Import a field if it is a pick-list

  1. joenglesson
    joenglesson
  2. Features Request
  3. Sunday, January 25 2015, 03:30 AM
Hello,
I am trying to import this but the filed that is a picklist is not being imported. Any ideas?
Here is the CSV file:

username;email;firstname;lastname;ml-number-test
jojoenglesson;[email protected];JoJoJo;Englesson;ML18

Also, is there a way to set a flag to update the user groups on existing contacts when importing?

Thank you!

Jo Englesson
References
  1. http://gtgradweb.com
Responses (4)
admin
admin Accepted Answer
Admin
Try to use these rows

username;email;firstname;lastname;ml-number-test
jojoenglesson;[email protected];JoJoJo;Englesson;ml18

Import plugin write data directly to database, but in database is stored the value of field, in your field you have this option:
...
ml18|ML18
...
value|text

the value is ml18 not ML18.
  1. more than a month ago
  2. Features Request
  3. # 1
joenglesson
joenglesson Accepted Answer
Pro
Thank you, that worked!
  1. more than a month ago
  2. Features Request
  3. # 2
joenglesson
joenglesson Accepted Answer
Pro
This is an awesome feature! However, in the US the excel sheet saves as CSV with a comma and not a semicolon. Could you make the import file accept a comma separated file? The only way for me to change this is to change the decimal setting in System Preferences to use european standards (a comma instead of a period) - this forces excel to export a CSV with a semi colon.
  1. more than a month ago
  2. Features Request
  3. # 3
admin
admin Accepted Answer
Admin
Thanks for your suggestion, we plan to add some option like:
- option to specify if text is quoted
- column Separator char
- file encoding (UTF8,UTF16,ISO-8859 latin,ISO-8859 Windows,...)
  1. more than a month ago
  2. Features Request
  3. # 4
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.