Is there a way to upload catch records in bulk?

Hello,
Is there a way to upload multiple records of catches (from numerous traps) in a batch? E.g. via a file in CSV format? If not, are there any plans to allow this function in future?

Our trapping project has a master record of all catches held in a spreadsheet, but to get the records into Trap NZ, it seems that we need to input them one at a time.

Thanks.

Also very interested in this, hoping Trap.NZ staff will pick this thread up!

We’ve added a bulk import (from CSV file) function under the Traps menu.

Hi Dan, that sounds good and I would like to try it,but I can’t see what you’ve described.
I’ve tried to attach screenshot to this post for reference. Can you show a screenshot of where the bulk import function is please?

Hi - sorry - should have mentioned that bulk import facility is only available to project admins at the moment.

Hi Dan, thanks for the reply and fair enough. I’ll get in touch with my ‘boss’. By the way, do you know if there is a restriction on how many project admins a particular project can have? i.e. is it limited to 1 person or the one who set up the project originally? Thanks.

Hi Dan (again) - thanks for pointing me in the right direction. I got promoted this evening by our project administrator, so I can now see the Import Records page and corresponding documentation. I’m looking forward to trying it out. Cheers, Michael

You can have any number of admins on a project :slight_smile:

Hey, just had some records fail to import because it doesn’t like the value ‘Still set, bait bad’, also the help text suggests that’s a valid value. Am I missing something?

PS. Uploading catches has changed my life!

If your file is comma separated, have you got double quotes around the values in question? e.g. “Still set, bait bad”

Yes, I’m using comma separated. Have just checked out the CSV, Google Sheets has added double quotes…but there’s a space at the end of the text "Still set, bait bad " which I must have added when entering the data into Sheets. No doubt that’ll be the reason it failed. Thanks.

Thanks for that info! Someone else had a similar issue. Any trailing white space should be trimmed automatically on import but it looks likes it fails on a non-breaking space (these can get added if you cut and paste).

Hi, I’ve just tried doing a bulk import using the import records function of my project’s historical data (just over 22,000 records spread over around 1000 traps). Unfortunately the import stalled halfway through when it hit a line of bad data, which I have since cleaned up. I deleted the records that had been entered to avoid double ups and want to now have a second go at importing our historical records, but the import records screen is still frozen with a message saying “currently busy, please wait (51%)” which is where it got stuck on my first import attempt two hours ago. Does anybody know how to reset things so that I can have another go at a bulk import? Thanks very much for your help! Sanjay