Uploading Photos to the Database (with Windows Client)
Last updated: 27th September 2017
(NB These are instructions for uploading using the windows client. In future releases it may be possible to upload photos via the cloud and this website will be updated accordingly).
Before you start:
- Check that your UnitIDs are already present on the database. If they are not, then upload them.
- Check your UnitIDs are not already being used. If you have been allocated unit IDs they should not be in the database, but it is worth checking. Use a filter list or a simple search of the database to check their presence.
- This is only possible by people with both a user ID and access to the windows client.
- It is strongly recommended to first try the protocol with a small subset of the files you want to upload to check that it works correctly.
Step 1: Create a excel spreadsheet (xlsx)
The template for the spreadsheet can be found at on the dropbox folder at:
Or an example file can be found here
There are four required columns
|Unit||CAM999999||This is the UnitID the photo will be linked to|
|FilePath||C:\Documents\myPhotos||This is the location of the folder containing the photos locally|
|FileName||myphoto.jpg||This is the filename of the photo|
|Storage||EarthCape Heliconius Amazon S3||This is the where the photo will be stored on the database, always the same|
Step 2: On the windows client, go to File > Import Data
Step 3: Select “Add files”
Step 4: Select the type of data that is being imported (in this case “Attachment”)
Step 5: Select “Import”
On any error messages press “Continue” (this will be fixed in future).
Step 6: Check the files have been correctly uploaded either on the windows client…
Or the cloud…