1

Topic: Importing data into Recorder

I have just imported a dataset of 19,000 records - the final screen of the import reported no errors, however, when it completed it reported 1993 items not imported and the "ImportRejects.txt" is less than helpful (se below).

Craig

-contents of ImportRejects.txt---------------------
Items rejected by Recorder 6 in data imported at 09-01-39 on 20/02/2015:
Exception on create for SQLSERVER_SURVEY_EVENT: ODBC--call failed
Exception on create for SQLSERVER_SURVEY_EVENT: ODBC--call failed
Exception on create for SQLSERVER_SAMPLE: ODBC--call failed
Exception on create for SQLSERVER_SAMPLE: ODBC--call failed
Created SQLSERVER_BIOTOPE_OCCURRENCE
Exception on create for SQLSERVER_TAXON_OCCURRENCE: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE: ODBC--call failed
Exception on create for SQLSERVER_SURVEY_EVENT_RECORDER: ODBC--call failed
Exception on create for SQLSERVER_SURVEY_EVENT_RECORDER: ODBC--call failed
Exception on create for SQLSERVER_TAXON_DETERMINATION: ODBC--call failed
Exception on create for SQLSERVER_TAXON_DETERMINATION: ODBC--call failed
Exception on create for SQLSERVER_TAXON_DETERMINATION: ODBC--call failed
Exception on create for SQLSERVER_TAXON_DETERMINATION: ODBC--call failed
Exception on create for SQLSERVER_TAXON_DETERMINATION: ODBC--call failed
Exception on create for SQLSERVER_TAXON_DETERMINATION: ODBC--call failed
Exception on create for SQLSERVER_TAXON_DETERMINATION: ODBC--call failed
Exception on create for SQLSERVER_TAXON_DETERMINATION: ODBC--call failed
Exception on create for SQLSERVER_TAXON_DETERMINATION: ODBC--call failed
Exception on create for SQLSERVER_TAXON_DETERMINATION: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE_DATA: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE_DATA: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE_DATA: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE_DATA: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE_DATA: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE_DATA: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE_DATA: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE_DATA: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE_DATA: ODBC--call failed
Exception on create for SQLSERVER_TAXON_OCCURRENCE_DATA: ODBC--call failed
Created SQLSERVER_BIOTOPE_DETERMINATION
Created SQLSERVER_SPECIMEN
Created SQLSERVER_TAXON_OCCURRENCE_SOURCES
Created SQLSERVER_TAXON_OCCURRENCE_SOURCES
Created SQLSERVER_TAXON_OCCURRENCE_SOURCES
Created SQLSERVER_TAXON_OCCURRENCE_SOURCES
Created SQLSERVER_TAXON_OCCURRENCE_SOURCES
Created SQLSERVER_TAXON_OCCURRENCE_SOURCES
Created SQLSERVER_TAXON_OCCURRENCE_SOURCES
Created SQLSERVER_TAXON_OCCURRENCE_SOURCES
Created SQLSERVER_TAXON_OCCURRENCE_SOURCES
Created SQLSERVER_TAXON_OCCURRENCE_SOURCES

Craig Slawson
Staffordshire Ecological Record