import mapping, cant set nonpreferred_labels.type_id

theCA

I writing a really simple import mapping but i cant make the ca_entities.nonpreferred_labels.type_id to work.
The idea is to import entities of type individuals (ind) and set the preferred and nonpreferred labels.
This is how the import mapping looks like:

Rule type	Source	CA table.element				Group		Options
Constant	ind	ca_entities.type_id				
Mapping		1	ca_entities.idno				
Mapping		2	ca_entities.source_id				
Mapping		3	ca_entities.preferred_labels.forename		preferred			
Mapping		4	ca_entities.preferred_labels.middlename		preferred	{"skipIfEmpty": 1}		
Mapping		5	ca_entities.preferred_labels.surname		preferred	{"skipIfEmpty": 1}		
Mapping		6	ca_entities.preferred_labels.displayname	preferred	{"skipIfEmpty": 1}		
Mapping		7	ca_entities.nonpreferred_labels.displayname	nonpreferred	{"skipIfEmpty": 1}		
Mapping		8	ca_entities.nonpreferred_labels.type_id		nonpreferred	{"skipIfEmpty": 1}

The nonpreferred_label.displayname works fine but the ca_entities.nonpreferred_labels.type_id is not working. I tried using the idno and the item name from the list entity_label_types with no luck.
Am i missing something?

darrigan

Supposed you have 3 types of nonpreferred_labels defined in Lists & vocabularies:

text "acronym"; code "acr"
text "used for"; code "uf"
text "alternate"; code "alt"

ca_entities.nonpreferred_labels.type_id refers to the text, not the code of this type...
(But I don't know how to refer to the code...)

darrigan

Look that: https://support.collectiveaccess.org/d/299934-299934

theCA

Yes, actually we have a few more.
I tried using the "text" and the "code" without success... (In this case neither alternate nor alt works)
Also added the option {"convertCodesToDisplayText": 1} in the options column in the import mapping but still no luck.

CSIPiemonte

Hi,
I'm not sure, but a label's type_id is probably also part of the list world. Perhaps to import the label's type_id you need to go through the list refinery and enter the correct code.
Something similar to this.

bye antonio

theCA

Thanks @CSIPiemonte , you point me to the right direction!!
For my future my and any other with this issue, this is how the line ended

Rule type	Source	CA table.element				Group		Options			Refinery		Refinery parameters
Constant	ind	ca_entities.type_id					
Mapping		1	ca_entities.idno					
Mapping		2	ca_entities.source_id					
Mapping		3	ca_entities.preferred_labels.forename		preferred				
Mapping		4	ca_entities.preferred_labels.middlename		preferred	{"skipIfEmpty": 1}			
Mapping		5	ca_entities.preferred_labels.surname		preferred	{"skipIfEmpty": 1}			
Mapping		6	ca_entities.preferred_labels.displayname	preferred	{"skipIfEmpty": 1}			
Mapping		7	ca_entities.nonpreferred_labels.displayname	nonpreferred	{"skipGroupIfEmpty": 1}			
Mapping		8	ca_entities.nonpreferred_labels.type_id		nonpreferred	{"skipIfEmpty": 1}	listItemSplitter	{“list”:”entity_label_types”, “matchOn”:[“idno”,”labels”], “dontCreate”:”1”}	
Mapping		9	ca_entities.otherinfo

CSIPiemonte

I'm glad my advice was helpful.
Have a nice weekend,
ciao Antonio.