Topic: Error importing records
I was attempting to import 3 records from an Excel Spreadsheet (downloaded from iRecord as a csv file, with some minor edits and saved as xsls file). A job I have done numerous times before. No problems experienced reading the file. At the final step in the process Recorder6 reported the error
Error occurred transferring records for SQLSERVER_TAXON_OCCURRENCE_DATA into the main database: Error occurred transferring records for SQLSERVER_TAXON_OCCURRENCE_DATA into the main database: Not a valid bookmark.
Exiting Recorder6 and restarting, I checked the observations
For two records (1st and 3rd) the Event and Sample had been created, but there were no Taxon Occurrence underneath. Attempting to delete the Sample, Recorder6 reported that it was unable to delete because it was referenced by other records in the database. However, Related Data showed no linked records.
The 2nd record does not appear in the observations
Running version 6.30.0,291 under Windows 10, using SQL Server 2017, with database version C3 and dictionary 4S
Rejected records
Items rejected by Recorder 6 in data imported at 11-15-52 on 05/12/2020:
Created SQLSERVER_SURVEY_EVENT
Created SQLSERVER_SAMPLE
Created SQLSERVER_TAXON_OCCURRENCE
Created SQLSERVER_SURVEY_EVENT_RECORDER
Exception on create for SQLSERVER_TAXON_OCCURRENCE_DATA: Not a valid bookmark
Surrey County Butterfly Recorder