Bulk Uploading Sightings

You are here:
< Back

NatureMapr provides an enterprise grade bulk upload utility to make it easy to upload hundreds or thousands of historical records into your project. All sightings that are bulk imported into your project will bypass the Moderator Workflow and become automatically Confirmed as the species you specify for each record.

Access the “Bulk upload sightings” tool from within the Admin area and you will be presented with the Bulk upload sightings wizard. Click the “Download Import Template” button to download a CSV template file to your computer, ready for you to populate your data in.

Download the Import Template

Bulk Upload Sightings - Step 1

Bulk Upload Sightings – Step 1

Populate the Import Template with data

Once you’ve downloaded the import template to your computer, use a spreadsheet program such as Microsoft Excel to populate the template file with all of your sighting information that you wish to import.

Populating the import template

Populating the import template

Mandatory Fields

Many of the fields for each row may be left blank, but the following fields are mandatory:

  • Scientific Name
  • Abundance Exact OR
    Abundance Approx
  • Reported Date/Time
  • Lat Decimal + Long Decimal OR
    Lat Degrees + Lat Minutes + Lat Seconds + Long Degrees + Long Minutes + Long Seconds OR
    Easting + Northing + UTM Zone
  • Author Username

Media Files

Importantly, when populating the import template, the filenames of any media files (images or audio clips) that you wish to import must exactly match the names you enter into the following fields:

  • Image1 Filename
  • Image2 Filename
  • Image3 Filename
  • Image4 Filename
  • Image5 Filename
  • Audio1 Filename

This is so that the sighting bulk upload tool can successfully find and associate each uploaded media file with each sighting row in your populate CSV import file. Your populated template should look something like this:

Import Template with filenames

Import Template with filenames

Saving your CSV file

When you’ve completely populated the CSV template file with data, save it somewhere easy to find on your computer and ensure you save it in CSV format.

Now you’re ready to click “Proceed to Step 2” where you can bulk upload any images and audio files.

Bulk Upload Media files

The sighting bulk upload tool accepts both JPG (image) files and M4A (audio) files.

Note: The filenames of any files you upload need to correspond to the filename columns you populated in the import template CSV file.

Simply drag and drop as many media files as you like into the upload control and wait for all of the files to finish uploading.

Note: This could take quite some time if you are accessing NatureMapr over a slow internet connection.

Bulk uploading media files

Bulk uploading media files

Once all of your media files have successfully uploaded, you’re ready to click “Proceed to Step 3” and upload your sighting CSV data.

Uploading Sighting data (CSV format)

Simply browse to the populated CSV import file that you created earlier.

You’ll also need to select an appropriate “Data Source” to associate your newly imported sighting records with.

Note: A Data Source is simply a way of grouping or categorising related sightings together so they’re easy to find in the future.

By default, the sighting bulk upload tool will skip importing any sighting records that it can’t find a matching species for in the project’s taxonomy. If however you would like the system to automatically create any species that don’t already exist, you can select the “Auto-create species that don’t exist in the project taxonomy?” option and the system will then create any missing species for you automatically.

If you select this option, you’ll also need to specify values for both Sensitivity Level and Conservation Level. These values will be assigned to any Species that the import operation creates for you.

Uploading sighting CSV data

Uploading sighting CSV data

You’re now ready to kick off your import operation and let the system do the heavy lifting for you.

Click the “Upload” button to commence the import process.

Performing an import operation

Performing an import operation

The page will automatically refresh itself as it progresses through the import operation, so you don’t need to do anything. Simply wait for the process to complete.

Operation Complete!

Congratulations, if your upload operation completed successfully, you’ll see a screen like this.

Once you’re completely happy with the results, you should press the “Clear Results” button which resets the tool so that’s ready for use again.

A successful import operation

A successful import operation

Error Messages

It is common for the import operation to find issues with the data you attempted to import. Common examples are things like:

  • You tried to import a sighting that already exists
  • The system was unable to find a media file that you specified
  • The location of a sighting was outside the project’s boundaries
  • One or more values in the CSV file was too big

The system will display any errors that it raised during processing of your CSV file and make recommendations for what you need to do. In the vast majority of cases, any invalid records will be skipped, allowing the rest of your import operation to be successfully processed.

So you may need to make changes to the contents of your CSV import file and retry the bulk upload one or more times, until you have resolved all of the errors with your data.

Your data is live

Following completion of the bulk upload process, your data will be completely live and accessible within the NatureMapr platform.

Here you can see the 3 sightings that we bulk uploaded showing against the assigned user’s profile:

Sightings successfully loaded in

Sightings successfully loaded in

July 15, 2018