Today I thought I'd share a "how to" for bulk uploads. After only a day of doing these I feel like I need the extra practice. Plus some other folk have mentioned they'd like to join me in attempting this but don't know how. So here it goes!
First you have to find a person with specimens that need uploading. I'm going to pick the fabulous Alexander Wetmore. I've previously transcribed his photo albums with @TranscribeSI He was a prolific collector and needs some @BloodhoundTrack love. 
So I go to the "Upload" tab on his profile page. And then press the blue "Download" csv file button.
This downloads a csv file of specimen data. I open up the file. Now I'm going to be using Excel but you may use something else. When opened the file looks like this in Excel.
I'll go through the important columns. The first is the "action" column. This is where you'll put "recorded" if the specimen was collected by Alexander, or "identified" if it was identified by him. If he did both you add "recorded, identified". Note the comma separating the two!
You can see whether Alexander recorded or identified specimens by checked the "recordedby" or "identifiedby" columns in the spreadsheet.
The other column that may be of use is the "Not Me" column. If it isn't your collector that either collected or identified the specimen you can add "True" to this column.
Once you've got your spreadsheet ready with some claims added you can then upload it into Bloodhound. I'm just going to do a few so I can show you what to do. I'm going to assume you have basic excel skills. All I'm going to do is use the sort & filter and search recordedby.
I'll add "recorded" in the "action" column to all those lines. I'll then check the "identifiedby" column to make sure he didn't identify any of the specimens. If he did I'll add a comma and "identified" to those specimens he also identified.
Now obviously you can keep on working on the spreadsheet. But I'll just leave it there so I can show you the next steps. What I do next may not be the best way but it works. I save the spreadsheet and a warning pops up. I press "No" on the warning and save as an Excel workbook.
I then press "save as" and choose the file format CSV UTF-8 format.
I then rename the file making sure to add .csv to the file name and press save
Now I always get a warning. But I press "yes" and save the file in the csv format. Then I close the file.
Then I go back to Bloodhound Tracker - Alexanders profile, the Upload tab and press "choose file". I choose the file I've just renamed and saved as a csv file. Then I press submit.
And the 56 files that I've done will be added. The biggest batch you can do is 10,000. So there you go and happy bulk uploading of data!
