eBird to AviSys checklist import

Note: To be current with eBird, install the 2017 Taxonomy Update for AviSys.

File upload

Click to upload the selected checklist(s).
Enhancement: eBird to AviSys checklist import now remembers AviSys places from one session to the next. Read more.
Bug alert

Until 8 March 2017 this application had a minor bug that affected sightings from outside of the Lower 48 states of the US. Please read the bug report for full details, and an explanation of how your data can be easily and automatically corrected.

What it is

eBird to AviSys checklist import will convert one or more (up to 20) eBird checklist files (in csv format) into an AviSys stream file with which you can import the data into AviSys (Version 6).

What you do

  1. Download an eBird checklist (by going to My eBird->Manage My Observations->View or edit->Download). Save the csv file on your computer.
  2. In the “File upload” form above, select the downloaded checklist file and click “Upload”. You can upload multiple eBird checklists in one batch. Each time you select a file, a new button for selecting another file is added. When you've selected your last file, click “Upload”.
  3. On the next screen that you see, each eBird location that is in your input will be displayed. If the corresponding AviSys place has a different name, you can enter the correct AviSys place name. Then click the “Do it!” button that you will see. More details on this screen will be shown when you get there.
  4. Your AviSys stream file will be downloaded. Save it on your computer, then run Avisys to import it.
  5. That's it!

About species names

If AviSys does not recognize a species name while importing a stream file, it will skip that sighting record. (It will tell you!) You might want to edit the csv file before uploading it, to make sure that all species names that will go into the stream file are ones that will be recognized by AviSys. Important: if you edit the file in Excel, be sure to save it back in csv format, not as an xls or xlsx file!

One prominent difference between eBird names and AviSys names is that eBird accepts certain names with parenthetic qualifiers, e.g., “Northern Flicker (Yellow-shafted)”. You don't need to worry about these cases! eBird to AviSys checklist import will remove the parenthetic part of the name and insert it at the beginning of the AviSys comment.

Another difference is that eBird allows “sp” entries. You can either delete these before importing, or just let AviSys ignore them.

Finally, there might be some real differences between the nomenclature of eBird and AviSys, depending on timing of updates, etc. If you know about any such differences in advance, you can alter names in your csv file before uploading. Otherwise, AviSys will skip the unrecognized name during the import, and you will need to enter the record manually, using the name that AviSys recognizes.

Can I import from other sources?

You should be able to import any validly formatted csv file that contains at least four columns headed "species", "count", "location", and "date" or "observation date", and optionally a "comments" column and/or a "country" column. The order of columns and presence of other columns does not matter. The date can be in most any recognizable format.

What about eBird's “Download My Data”?

eBird provides a feature to download all of your eBird data in one file. eBird to AviSys checklist import will process that file too! However, if you are going to import a large amount of data all at once, you really should set up a test data set in AviSys and do a dry run of importing the data there before you commit to importing it to your real AviSys database.

What's a stream file?

Read the tutorial on using AviSys stream files to import data if you are not familiar with the process.

More eBird tools

Questions or comments?