I am working on data import using the CA's Excel template, and have a question about linking the ca_objects table to ca_occurrences (in my case, a bibliographic Source table).In my object table, only the ID numbers for the Source are attached to each record. In the Source table, there are a column for ID numbers and a column for full citation. In the UI in CollectiveAccess, on the object entry screen, I have set up a metadata field to look up the full citation data, not the ID number because a cataloger wouldn't know what the ID number is for a book. In this case, how would I fill out the template in order to link the object records to the source records? I have filled in "sourceSplitter" and the refinery parameters to indicate the relationship, but I don't have matching information for linking the two tables.I've attached sample ca_objects data and sample ca_occurrences data (couldn't upload CSV, so used XLS). In the attached data template sheet, the row 49 and 61 (Excel row no.) are the ones in question.I am not a coder, and I don't have access to the backend server, so please instruct me to move forward using the Excel template. Thanks!
