| Note |
|---|
This has been migrated to https://docs.openedx.org/en/latest/educators/how-tos/content-tagging-how-tos/build_taxonomy_using_template.html - this wiki page is now locked. Please backlink this article into the Redwood Release Notes (under Taxonomy Import & Updates) when put into RST on the docs site |
...
Now, to add the “California” tag, we put it in the next row. Let’s give it the ID “2” and put the value as “California”. Now, because we want this tag to be a “child” of the “United States” tag in our taxonomy, we also need to set the parent_id field. In this case the parent is “United States”, which we gave the ID 1, so we’d put 1 as the parent_id, like this:
Likewise, to create “Los Angeles” as a child tag of “California”, we need to give it an ID (say, 3), and set its parent ID to the ID we gave to “California” (in this case, 2).
So far, this would result in the following taxonomy:
United States
California
Los Angeles
Now, continue to add the rest of the tags. You can put notes in the “comments” column if you want; that column and any other columns besides “id”, “value”, and “parent_id” are ignored by the system during import.
Save the spreadsheet using the default format (e.g. .xlsx), in case you want to edit it later.
Export the spreadsheet to a CSV file.
In Excel, use File > Save As…, and set the “File format” to “CSV UTF-8 (comma-delimited) (.csv)” (preferred) or “Comma Separated Values (.csv)” then enter a filename and save it.
In Google Sheets, use File > Download > Comma Separated Values (.csv).
In Numbers, use File > Export To > CSV… and use the default options.
Import your taxonomy following the How-to: Import and export a taxonomy guide.