Hi @freyma,
I’ve been out of the country until today so I apologize that I was unable to get back to you sooner!
In @AndyBentley’s database, Vessel and Cruise are mapped to text1 and text2 respectively, so no further modification to the specify_workbench_datamodel.xml was necessary. I’m not sure why that is, but it could be due to the larger character limit, or the data placement decision may have predated the introduction of those fields.
I was able to add the vessel and cruise fields to the Specify 6 WorkBench by adding the following 2 lines to the specify_workbench_upload_def.xml file under the <!-- collectingtrip --> heading:
<field table="CollectingTrip" name="vessel" actualname="Vessel"/>
<field table="CollectingTrip" name="cruise" actualname="Cruise"/>
specify_workbench_upload_def.xml (144.0 KB)
specify_workbench_datamodel.xml (143.3 KB)
After adding those lines to your file, let me know if you are still not seeing those in the WorkBench mapper! As a reminder, Specify 7 supports uploading data to (nearly) any field and table, so we encourage you to explore using that for data imports going forward!