How to Bulkload Catalog Records
Enter Data > Bulkloader > Bulkload Builder
If you do not have a Bulkload Catalog Record Data sheet, begin with the Bulkload Builder.
The first small table includes groups of fields available to use. Select which ones you want to save time on selecting individual fields in the larger table below.
The following are the groups most often used:
- Coordinate Meta
- DMS Coordinates
- D.d Coordinates
- The Rest
From the larger table, you will see the fields that were selected as part of the groups selected above.
If there are fields that will never be used by your colelction and therefore do not need to be in your file. Unselect them. You will want to keep the format in CSV. That is the type of file Arctos works with.
Now click on “Download Template” located below the small table and above the large table. Your file will automatically be put into your computer’s downloads.
- Any header can be deleted, added, or rearranged in the excel sheet manually.
Be sure edited cells do not have an invisible lead or end, otherwise Arctos will reject it.
- You may notice the bulkload template has a large number of fields for parts, attributes, collector, etc. These are there only if you need them. You may or may not use them all and that is ok. They can be left blank.
The bulkloader only allows for one part attribute per part. If you need to add more attributes, consider bulkloading the records without parts and then bulkloading parts with the Part Bulkload Tool.
IT IS VERY HELPFUL TO HAVE THE SINGLE DATA ENTRY PAGE OPEN WHILE ENTERING DATA INTO THE BULKLOAD DATA SHEET. Much of the bulkloader works off of the single data sheet and many things are “text sensitive”, meaning Arctos will not accept your file if something does not already exist within Arctos (ie; agents, parts, attributes, etc) OR if something is spelled incorrectly.
Agents can be entered as “unknown”.
If no Catalog Number has been previously assigned you can leave the CAT_NUM blank if you want Arctos to automatically assign the next available catalog number.
When trying to fill a gap in the available catalog numbers, it is wise to view what is available and enter them manually. Only allow Arctos to assign numbers if you have no gaps in your assigned catalog numbers and are using an integer catalog number format.
Excel Helpful Hints:
- Excel likes dates to be in the (mm-dd-yyyy) format, whereas Arctos likes them to be in (yyyy-mm-dd) format. Excel will also re-format the date back to how it likes if you close and re-open the file. To change the date format at any point, do the following:
- In the Home tab of excel in the “Number” section there will be a drop menu. With the cell(s) you need selected, click the drop menu and scroll to the bottom and select Text. This tells excel to stop assuming it knows what to do with the date and keep it the way you want it.
- Another way to do this, which is especially helpful with a re-opened file, is to again, select the cell(s) you want and click the drop down menu in the “Number” section of the Home tab.
- Select “more number formats” at the very bottom.
- If “date” is not already selected, do so and it will bring up all the different formats for dates.
- In the “Locale (location)” drop down menu, select “English (South Africa)”
- South Africa is your new best friend because they have the date format that you need. Select “yyyy-mm-dd” format and click ok.
- Your highlighted cell(s) should automatically change to Arctos date format. Woot!
The following is a complete breakdown of all fields and what data they should include:
- A temporary number for the excel list only. It will not be included in the specimen data.
- Your Arctos user name
- Arctos will automatically assign the next available catalog number if this field is left blank.
- If the specimen already has an existing catalog number, put it here.
- Don’t ask why 5 is first, but this is used if there are any other useful ID’s connected with the specimen, e.g., wolf – WDL # AND KG #
- Again, if there is another useful ID connected with the specimen, put the type here.
- e.g., wolf- WDL # “original identifier” / KG # “collector number”
- Make sure to use a type that Arctos offers, do not make up your own!
- This is typically used more often in conjunction with one ID that is connected with the specimen.
- e.g., just the KG, or any other number previously assigned to the specimen.
- NOT THE NMZ #!. NMZ numbers are catalog numbers and have their own column.
- Describes what the other ID number is. KG for instance is a “collector number”.
- Format example: [NMU:Mamm]2015.02
- The specimen’s taxonomic name.
- Make sure it is spelled correctly!
- You can use any of the taxon formulas allowed in Arctos. Just enter the name(s) in the format shown in the code table.
- If it was caught then use “field”. If it is a specimen that has already existed in the museum, use “legacy”.
- Choose an existing agent such as Kurt E. Galbreath, or make a new agent in Arctos.
- The date the specimen was identified
- Any remarks made about the identification
- The date on the id tag or data sheet
- If a date is not exact or there is some uncertainty about it, use a sufficient range.
- e.g, Date on tag = 1978, Range = 1, Jan. 1978 – 1, Jan. 1979
- Continent, country, state, county
- Verbatim locality + state & country
- The locality on the specimen tag or data page
- decimal degrees
- Decimal latitude
- Decimal longitude
- N or S
- E or W
- World Geodetic System 1984
- Global positioning system (transcription)
- The max error for distance
- The units for max error; meters (m)
- Not recorded
- Event determiner which is usually the same as the collector and identifier unless indicated otherwise.
- Determination date
- Anything else will lock this section and cannot be changed.
- Any remarks about the locality. If none, it can be left blank.
- Not required by Arctos but it is there if someone decides to include the habitat.
- Can be left blank.
- Any remarks about the collection event.
- The collector agent
- Choose for your collection (NMU:Mamm, MLZ:Bird)
- Any remarks about the collection object
- One of the parts being put into the collection, ie; tissue, skeleton, skull, skin, etc o This is TEXT SPECIFIC, must spell exactly how arctos spells it.
- The condition of the part, ie; good, fair, bad, excellent.
- You can assign barcodes to new or old specimens here if so desired. Otherwise it can also be done through the “Bulkload Barcodes to Specimen Parts”.
- This also has to do with barcoding. If using a barcode use the barcode verbatim for the label.
- How many of that specimen you have. Usually just one (1) for skeletons, skins and skulls. May be two (2) if there was more than one tissue sample taken.
- In collection
- Any remarks regarding the part. Can be left blank.
- Sex, total length, tail, hind foot, ear, or weight.
- Male or female, measurement #
- No units for male or female, measurement = cm and g unless specified otherwise.
- Same as collection or id date
- Method of finding the attribute, usually left blank.
- Collector or identifier agent
- Usually left blank unless told otherwise.
- Wild caught
- Not really needed
- Not yet utilized;
- Use if returning to the same location a number of times.
- Not yet utilized;
- Use if returning to the same location a number of times.
- (similar to accession and agent)
- Any remarks about the trapping event.
- Accepted place of collection
- Any other id references
At the bulkloading page, just above where you will click to choose your file to upload, Arctos will tell you if the bulkloader is currently being used.
- “There is nothing in the staging table. You are free to proceed”
- As we know, Arctos is publicly shared. This is also true for the bulkloader. If another institution is bulkloading, this page will tell you who is using it and show their contact information (if they have any).
- If you are using the bulkloader, your name and contact information will be shown and will stay up there if you do not clear the staging table after you are done. If you forget to delete your stuff from the staging table, you may end up getting some emails from other institutions asking when you will be done.
Ready to Bulkload
- Choose your file and click “Upload this file”. !MAKE SURE TO EDIT THE FILE IN “NOTE” FIRST!
- Open the file in “note” and delete the empty space at the bottom of your data, save and your good to go.
- You will be brought to a page that says “There are (#) records in the staging table. They have not been checked or processed yet”. (#- the number of records you are trying to upload).
- From here you will choose from the following choices; Check and load these records, just load these records, or cleanup.
- “Check and load these records” - By-passes the need for the records to go into the bulkloader where they would normally be looked over by an administrator.
- “Just load these records” - Moves the records to the “personal” bulkloader where your administrator can approve them like any other single data entry.
- “Cleanup” – If you have last minute data that needs to be added or changed. Once you do that, go back and choose one of the two other choices. For practical purposes, choose “Just load these records”.
- You will be brought to a new page that says, “Your records have been checked and are now in the table bulkloader and flagged as loaded=’BULKOADED RECORD’. A data administrator can un-flag and load them.” After that it will say in blue “please delete from the staging table”, click that then click “yep, delete away” and you are all set.
- Your data should now be in your institution’s (?) bulkloader awaiting approval.
IMPORTANT: DELETE YOUR DATA FROM THE STAGING TABLE
How to Bulkload Data Tutorial Video