Due to weather conditions, the Museum will close at 5 p.m. on Tuesday, Sept. 27 and reopen at 10 a.m. on Saturday, Oct. 1. More Info

The following is a checklist and troubleshotting guide for validating and processing skeletal files for upload into the SERNEC portal.

The csv files created by the Imaging Workflow App have the following header:

catalogNumber,sciname,identificationQualifier,recordEnteredBy,
verbatimEventDate,recordedBy,recordNumber,
country,stateProvince,county

WARNING: These files only use commas to separate fields and the fields ARE NOT delimited by quotes. Staff have filled in data with commas in some places and this will cause data errors. The file needs to be checked in MS-Excel repeatedly and later in MS-Foxpro to make sure these errors are corrected.

The original CSV files come with two entries for each specimen image. This is because there is a JPG and NEF file image.

All records will need to have a GUID assigned. Add a column (K) with GUID as the header. Use the macro to populate the column with GUIDs (more details on this later). The header should now be:

catalogNumber,sciname,identificationQualifier,recordEnteredBy,
verbatimEventDate,recordedBy,recordNumber,
country,stateProvince,county,GUID

Preparing the preliminary CSV for loading into the SERNEC portal.