Define a category hierarchy with a CSV file

A category is a type of field you can assign to a custom property in an AODocs document.
A category is composed of a set of defined values. Learn more: Create categories.

If you have a large list of values or a complex hierarchy of values to define, you can:

Define your list of values through a CSV file
Import the CSV file containing your category values in AODocs


Define your list of values through a CSV file

1. Create a Googel spreadsheet.

2. Format your spreadsheet as follows:

  • Column A contains the full hierachy of category values from the top level to the lowest sublevel.
    Sublevels are separated by slashes "/". 
  • Column B contains the short name for each hierarchy of category values.

image_01.png

3. Select File > Dowload as > Comma-separated values (.csv, current sheet).
The CSV file for your category values is downloaded.


Import the CSV file containing your category values in AODocs

1. Open the library administration interface.

2. Under Categories, choose a category and select Define values.

3. If you haven't defined any short name values in your CSV file, you can select the checkbox Add short name values if not defined in the .csv file to create short name values automatically.

Notes: 
- By default, the checkbox Add short name values if not defined in the .csv file is selected.
- The automatically generated short names are the three first letters of the category value.

4. Press + Add Files. Then browse your computer and select the CSV file containing your category values. You can also drag and drop the CSV file to the Drop files here area.

The category values are imported in AODocs in the background.

image_02.png

5. Refresh the page. The category values with its hierarchy defined in the CSV file appear.

Note: If you upload a CSV file with hierarchical sublevels and if you haven't created the sublevels, AODocs will automatically create the sublevels name them “Name-of-the-category Level X” (for example, “Country Level 3”).
You can then rename your category sublevels manually.

image_03.png

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.