Import List of Controlled Vocabularies

makalisterand

Hello everyone, it's me again.
I would like a tip, I have a List of Controlled Vocabularies (more than 16k concepts) how do I import a list into Collective Access? I've already worked with importing data (objects, media) using mapping through the base spreadsheet provided by the CA documentation, but I didn't get anything to import vocabulary lists.

Which table to import to? I named the list "Descriptors" but I can't insert the "concepts" into it, has anyone done something similar?

monica

To import just the terms, your import mapping needs to be for the table ca_list_items

Create the list first inside CA and in your mapping have a constant value with target of ca_list_items.list_id , with source the list_id number (can see this in the URL of the list, eg /list_id/67)
Then create the importer just the same as your objects.

When you import your objects, either have a listItemSplitter that related to the term (if using relationships) or just the value if using a metadata element attribute of type 'list'.

makalisterand

monica
Thanks for your help, I feel like I've made progress, but now I have another problem that I don't quite understand

ERROR
I am facing the above error, I understand that the plural name is missing (when inserting the concept manually, it is there), however, accessing the ca_list_items table in the database, there is no name_plural to insert a representative, do you have any idea how can I do?

Planilha base
Mapping

monica

makalisterand
The images you have uploaded are showing broken (this platform might not allow image upload).
If you would copy and paste the text from the image instead?

If this ERROR is coming from you loading the ca_list_items in a mapping, then you will need to map to ca_list_items.preferred_labels.name_singular and ca_list_items.preferred_labels.name_plural
The table in the DB these are held would be the ca_list_item_labels, not the ca_list_items.

makalisterand

monica Thank you very much, the problem was the same, the lack of name_plural and name_singular after preferred_labels