It’s simple to build your own classification set using the online editor, but if you already have an extensive list of items, importing it into Fulcrum is easy as a CSV file.

Preparing a CSV for Import

You can structure your list inside of a spreadsheet to load in and automatically create a classification set. You will need to format the values in a CSV file. The classification set can nest items beneath one another, building a subsection picklist (a powerful feature for large standardized sets of options). You will need to have a separate column for each level of the classification set, indenting for each “sub-level”. In this example, it shows a list of species, with each sub-level indented by one cell:

Once you have your file formatted correctly, save it as a CSV file format. Go to the Fulcrum homepage, then click the Setup button in the sub-menu and select Classification Sets. Once on the classification set page,  select Import Classification Set to upload your file.

Using Custom Data Names

You can also set custom data names in your file as you’re prepping for import. To set the data name value for a classification set pick list item, add the custom data name in the cell to the right of each item. Using the same previous example, we’d use this format so the user sees the animal’s common name, but have Fulcrum store the scientific name:

Download a sample file to view the required formatting:

Did this answer your question?