I am working with a museum in San Diego to move object data for about 2,000 records from a custom Access database to CollectionSpace. I am new to imports with CollectionSpace.
I have a couple tables with people in the categories of artists (about 80), authors (about 200), and museum staff (less than a dozen). Some of the names have English and Chinese versions. To work with the data and build XML payloads for each person, I have stored the artists in a MySQL table with UTF8 and the proper collation. This works. I can extract data and display the Chinese characters when present.
I received from Richard a zip file with examples of how to add a person authority and three example persons. After a couple missteps, I was successful in adding them to core.collectionspace.org. Via the returned URLs from each cURL command, I am able to see the sent elements.
I created a person authority called "artists" on core.collectionspace.org and added a person "Chiang Kai-shek" to that person authority.
http://core.collectionspace.org:8180/cspace-services/personauthorities/01bd36db-0b0f-409b-8c45/items/4d7855a3-c399-4c4a-a4ee
When I visited core.collectionspace.org, logged in, and created a new object record with the Inventory template, I tried to type in the new name to the "Production Person" field. The name was not found in the AJAX-style look-up. It offered me a chance to save the name to "Local Persons," a pre-defined container (person authority?).
I am thinking that my attempt to create an "artists" person authority might not be a best practice for CSpace.
I attempted to guess at the person authority short name for "Local Persons" (localpersons) but this person authority was not found.
If I should be adding these artists to local persons to work with the UI and its helpers, how do I do so?
If I want to import several artists at once, what should the XML look like above the personTermGroupList level to allow me to have multiple values in the same document. Keep in mind that some of my names have English and Chinese versions.
I can provide more examples of the XML payloads and response codes though I think you should be able to see at least the person XML stored with the above link (until the site is wiped again).
James D. Keeline
I am working with a museum in San Diego to move object data for about 2,000 records from a custom Access database to CollectionSpace. I am new to imports with CollectionSpace.
I have a couple tables with people in the categories of artists (about 80), authors (about 200), and museum staff (less than a dozen). Some of the names have English and Chinese versions. To work with the data and build XML payloads for each person, I have stored the artists in a MySQL table with UTF8 and the proper collation. This works. I can extract data and display the Chinese characters when present.
I received from Richard a zip file with examples of how to add a person authority and three example persons. After a couple missteps, I was successful in adding them to core.collectionspace.org. Via the returned URLs from each cURL command, I am able to see the sent elements.
I created a person authority called "artists" on core.collectionspace.org and added a person "Chiang Kai-shek" to that person authority.
http://core.collectionspace.org:8180/cspace-services/personauthorities/01bd36db-0b0f-409b-8c45/items/4d7855a3-c399-4c4a-a4ee
When I visited core.collectionspace.org, logged in, and created a new object record with the Inventory template, I tried to type in the new name to the "Production Person" field. The name was not found in the AJAX-style look-up. It offered me a chance to save the name to "Local Persons," a pre-defined container (person authority?).
I am thinking that my attempt to create an "artists" person authority might not be a best practice for CSpace.
I attempted to guess at the person authority short name for "Local Persons" (localpersons) but this person authority was not found.
If I should be adding these artists to local persons to work with the UI and its helpers, how do I do so?
If I want to import several artists at once, what should the XML look like above the personTermGroupList level to allow me to have multiple values in the same document. Keep in mind that some of my names have English and Chinese versions.
I can provide more examples of the XML payloads and response codes though I think you should be able to see at least the person XML stored with the above link (until the site is wiped again).
James D. Keeline
