I encounter problems when trying to upload records with different tables:
Table 1: Catalogue Number + CO + CE
Table 2: Catalogue Number + Det
Table 3: Catalogue Number + Preparation
I can upload the determinations, but when I try to upload the preparations, I get this error:
the mensage: (‘Collectionobject must have unique catalognumber in collection’, {‘table’: ‘Collectionobject’, ‘localizationKey’: ‘childFieldNotUnique’, ‘fieldName’: ‘catalognumber’, ‘fieldData’: {‘catalognumber’: ‘000100031’}, ‘parentField’: ‘collection’, ‘parentData’: {‘collection’: ‘Collection object (4)’}, ‘conflicting’: [200]})
If I want to upload records with the BW, do I have to upload everything in one table, or can I upload it with separate tables?
@Anna Yes, you can upload individual tables through the workbench independently but in order to do so you need to relate each of these tables back to the collection object and use the table you are uploading as the base table. You would thus need to upload the collection objects first so that you have something to reference. For instance, if you wanted to upload determinations to existing collection objects, you would use the determination table as the base table in the workbench when mapping and navigate through the tables structure back to the CO table to identify the catalog number for the determinations to be linked to. Same would apply for preparations.