Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Welcome to the CollectiveAccess support forum! Here the developers and community answer questions related to use of the software. Please include the following information in every new issue posted here:

  1. Version of the software that is used, along with browser and version

  2. If the issue pertains to Providence, Pawtucket or both

  3. What steps you’ve taken to try to resolve the issue

  4. Screenshots demonstrating the issue

  5. The relevant sections of your installation profile or configuration including the codes and settings defined for your local elements.

If your question pertains to data import or export, please also include:

  1. Data sample

  2. Your mapping

Answers may be delayed for posts that do not include sufficient information.

Basic import of data

Hello all,

My apologies for another post on data importing.

I have attached my mapping and a data sample. I keep getting the following error: 
  • (2017-02-13 09:07:53) [Error] Could not insert new record for object: Type must be specified
I have also attached a screenshot from Liust and Vocabularies, Object Type.

Very confused,



  • You need to define the object types (under Manage-Lists & Vocabularies-Object Types). Then, in your mapping's Settings you must declare which type the imported records should be.

    Currently, your type setting has the phrase 'objects' - Objects is actually the table you are importing to. Within that, each object record should be of a type (e.g Artifact, Photograph, Document, etc.)
  • Jonathan,
    Thank you for your reply and my apologies for my delay.

    Your suggestion helped and I was able to import most of my data. I am still having trouble with mapping two elements:
    1. Description (text describing an object)

    Description/Descriptive note is a Container and I am cannot figure out how to set the mapping for it. Could you help with the syntax for the CA table.element and the Group?
    Rule typeSourceCA table.elementGroup
    Mapping 11              ca_objects.description                                        Description

    2. Subject terms (mostly keyword from a local authority that is not in CA)
    In my data spreadsheet I have a column with subject terms separated by semicolons for each object.
    What is the best CA field to import keywords into?

    Thank you so much for any help you can provide.


  • edited March 2017
    Hi Jeff,

    To import to containers, the syntax should be 'ca_table.container_element_code.import_target_element_code.

    In other words, it should look something like: ca_objects.description.description_text. (Substitute "description_text" for whatever the actual element code is for the sub-element you want to import to.)

    If you have separate mapping lines to import to several sub-elements within the same Container, be sure to assign them all to the same "Group."

    I would probably create a vocabulary list called "keywords" and import the terms to this list using a listItemSplitter. Be sure to include a delimiter setting in your refinery parameters so that they get broken up on semi-colons. It should look something like this:

    {"listItemType": "concept", "list": "keywords", "delimiter":";", "relationshipType": "described"}

    table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { font-weight: 700; text-align: left; }.xl64 { color: black; text-align: left; white-space: normal; }
Sign In or Register to comment.