Post

3 followers Follow
0
Avatar

Loading values from file into new custom picklist field

While creating a new custom picklist field, I am presented with the option to load the values from a file (the Choose File link):

What should the format of this file be?

Lance Luvaul Answered

Please sign in to leave a comment.

10 comments

0
Avatar

I've tried both .txt files and .csv files with one value per line, but I get a Validation Error: "File type is not supported"

Lance Luvaul 0 votes
Comment actions Permalink
0
Avatar

The 'choose file' is just to add an icon to the value you're adding. To add values to a custom field, use the data loader add on.

Guy 0 votes
Comment actions Permalink
0
Avatar

Hi Lance,

 

As Guy has already mentioned the easiest way to load values into your custom picklist is using the Data Loader.

https://www.clarizen.com/apps/data-loader/

The Data Loader’s user interface is intuitive and easy to use. Feedback messages are also embedded to help track data issues in the process. In five steps you can load your data into Clarizen:

  1. Identify the Clarizen entity you want to load the data into
  2. Map the Clarizen fields to the ones available in your data file
  3. Create an Excel or CSV file with the field names in the headers and the data in the rows
  4. Open the Clarizen Data Loader from within Clarizen
  5. Upload the file and hit the update button
Bea Genthner 0 votes
Comment actions Permalink
0
Avatar

Bea and Guy, I want to create a new custom picklist field called GLC against the Project entity type.  So, if I understand you correctly, I should:

1 - create the new picklist field without any field values

2 - load the excel data using the dataloader (the values become the possible picklist values)

Then when I create a new Project, I'll see the values from the excel sheet in the GLC selection/dropdown menu, correct?

 

Lance Luvaul 0 votes
Comment actions Permalink
0
Avatar

No, if I understand correctly you should first create the field and its values, and then use the Data Loader to set all the records to the value you need. But wait for Bea's input on this as well.

Guy 0 votes
Comment actions Permalink
0
Avatar

Ok, that's exactly what I *don't* want to do: enter all 200 of the picklist values by hand during the custom field creation.  While I'm *creating* the new field, I want to be able to point to a file containing the picklist values

Lance Luvaul 0 votes
Comment actions Permalink
0
Avatar

Ok, I wasn't aware there are 200 values. In this case I believe you can also use the Data Loader to create the field itself. 

Guy 0 votes
Comment actions Permalink
0
Avatar

In other words, it's during the setup of the new *field* itself that I want to "dataload" a bunch of values from a file

Lance Luvaul 0 votes
Comment actions Permalink
0
Avatar

Bea, could you give me a quick explanation of how to use the Data Loader to create the field itself (and load in my 200 picklist values)?

Lance Luvaul 0 votes
Comment actions Permalink