Scythebill 17.1 - more spreadsheet options for reports and checklists

Scythebill 17.1.0 is now available.  This release includes some new features for report and checklist spreadsheets, and some . As always, download here, and let me know if you have any problems, either on Facebook or by email.

More options for spreadsheets

When saving a report as a spreadsheet, you previously had only one "sort by" option.  It wasn't obvious, but this sorted the species, not the sightings.  If you wanted a list of species in taxonomic order, you couldn't have any sighting other than the earliest.  So if you wanted to generate a report with last-seen dates, there wasn't a great way to do it:

Old spreadsheet options

Now, you can sort both species and sightings, and the dialog has been reorganized:

New spreadsheet options

Checklist spreadsheets have added a similar option. There, the only support was showing your first sighting from the checklist area. So, if you were traveling to Peru for the first time, there wasn't a way to create a checklist that shows where you had seen those species outside of Peru. Now, you can:

New checklist spreadsheet options

There's four options for the sighting - the first sighting (if any) from Peru, the most recent (if any) from Peru, your first sighting anywhere, and the most recent sighting anywhere.

Other changes

• Wildlife Recorder imports now automatically preserve the "Very common", "Common", and "Scarce" approximate numeric counts (-3, -2, and -1 respectively) by copying that text into the sighting notes.
• Tabs in location names are no longer converted to spaces after saving and loading.
• Users who hit the previous bug and were very unlucky could get into a state where their .bsxm files were un-loadable. Scythebill now recovers from this state automatically.

Scythebill 17.0.2 and 17.0.3 - bug fixes

Scythebill 17.0.2 is now available.  This release includes no new features, only bug fixes and small improvements. As always, download here, and let me know if you have any problems, either on Facebook or by email.

Update: Scythebill 17.0.3 included a number of additional bug fixes and small features.

Import/export fixes

• Observation.org/Waarneming imports will work once again - they changed their format to use localized strings for group names ("Vogels" instead of "Birds") and place names.
• An error message some users saw in imports while looking up locations is resolved.
• Very large eBird exports (large enough to require multiple files) would split almost all checklists across those files.  They'll now be much better at keeping checklists together in each file.
• 17.0.3: eBird files can now be imported directly from .zip files - especially useful for eBird's "MyData" mass exports, which come as .zip files.
• 17.0.3: Some CSV editing software would add "byte-order marks" to CSV files which usually don't have them, breaking imports. Scythebill now always supports these files (by ignoring the byte-order marks).
• 17.0.3: Scythebill now gives a much better error message if a provided Wildlife Recorder "locations export" file appears to be invalid.
• 17.0.3: "Observado" imports are now properly named "Observation.org".

Spreadsheet fixes

• When Scythebill picks an earliest or most recent sighting, it no longer ignore times; it is now used as a tie-breaker when dates are the same.
• Saving a multi-taxonomy checklist as a spreadsheet in Browse by location should be much faster.
• Report spreadsheets sometimes had overly wide common name, scientific name, and location columns. These should now be much more reasonably sized.
• 17.0.3: There is now a "#" column in sorted report spreadsheets, which skips uncountable taxa (like sp's, hybrids, and escapees).

Other changes

• Windows users who tried to open up Scythebill files from directly in .zip files would be unable to save;  now, they'll get a warning message as soon as the file is open, asking them to save a copy outside of the .zip.
• Scythebill will more consistently give you a good error message when you try to save into a folder that your operating system doesn't allow.
• 17.0.3: Scythebill had stopped showing "new for year" if these were the first species of any sort to be recorded that year, a common problem on Jan. 1!
• 17.0.3: Using the "even more specific?" feature for entering very specific locations would incorrectly reset the parent location to World.

Scythebill 17.0.0 - the eBird/Clements 2024 taxonomy is here!

Scythebill 17.0.0 is now available.  It's a simple release, with just one new feature - the eBird/Clements 2024 taxonomy!  As always, download here, and let me know if you have any problems, either on Facebook or by email.

Nov. 21 update: Scythebill 17.0.1 was released; it fixes a problem with importing from observation.org as well as from BirdJournal's eBird exports, along with some checklist improvements.

eBird/Clements 2024 taxonomy

The taxonomy was released less than a week ago, and it is a big one.  There's more than 80 splits, and some of them are extremely intricate.  House Wren is split 7 ways, Common Cicadabird 13 ways, and Island Thrush is split into 17 species!  As always, Scythebill will do much of the heavy lifting for you, making the update as painless as possible.

eBird has a long page with a wealth of details about the update, but if you want to know how it affected your list, just visit Splits and Lumps in "Special reports":

Splits and Lumps for my own list

Scythebill 16.6 - IOC 14.2, checklist printing, and native Apple silicon

Scythebill 16.6 is now available!  It's got the IOC 14.2 taxonomy, checklist printing, Birda imports, and a native Apple Silicon version. As always, download here, and let me know if you have any problems, either on Facebook or by email.

October 6 update: Scythebill 16.6.1 includes a couple of new features and several bug fixes.

IOC 14.2 taxonomy

The headline feature is the latest IOC taxonomy - 14.2, released earlier this month.  It's a huge revision, with splits ranging the familiar (Red Grouse from Willow Ptarmigan) to the obscure (Vella Lavella Monarch from Kolombangara Monarch), to the big (a 7-way split of House Wren) and the absurdly big (a 17-way split of Island Thrush).  And there's some lumps as well - for those of us who've spent time in the Palearctic, all the Redpolls are lumped.  You can see the full list of taxonomic changes on the IOC site.

As always, Scythebill will handle much of the work for you automatically.  Once you're done, visit the Splits and Lumps report under Special Reports, and see what changed for your list:

Changes to my list in 14.2

(Scythebill 16.6.1 fixes a slightly incorrect mapping for the three-way Rock Martin split.)

Checklist printing

There's a new option when viewing a location checklist in Browse by location:  Print...

This gives you a way to print out a checklist without carefully formatting a spreadsheet, including a compact form which takes up very little space.

A compact checklist for Grenada

(Scythebill 16.6.1 fixes an error that affected some printed checklists for locations you'd already visited.)

Native support for Apple Silicon (16.6.1)

For the last several years, Apple has released Macs using their own CPUs, starting with the M1 (then M2, M3, and M4 today), collectively called "Apple silicon".  Scythebill runs fine on these, but only by built-in emulation software called Rosetta.  Rosetta's free and installed on-demand, but relying on it means software runs more slowly and uses more memory than if it ran natively.

With 16.6.1, Scythebill now offers a native Apple silicon download.  In my informal tests, this version starts up twice us fast as the previous version. If you're using an old Mac, no worries - I'll continue releasing Scythebill to support older CPUs.

Birda imports (16.6.1)

Birda is a relatively recent site supporting in-the-field bird sighting entry.  Scythebill now supports importing Birda exports. Even if you don't use Scythebill, this could be used to move data from Birda to eBird -Birda exports require a lot of work to transform into a form acceptable by eBird, and Scythebill will handle that for you.

Small features and fixes

There's a new preference "Show extinct taxa?".  It's enabled by default, but you can turn it off if you'd rather not see extinct species and subspecies in Scythebill.  (If you've been fortunate enough to see a species that is now extinct, it will still be shown.)

Observado imports should more consistently include latitude and longitude. (At least some countries used "lon" as an abbreviation for longitude instead of "lng".)

As a very minor tweak: if you sort report spreadsheets by date, and there are multiple observations with that same date, those observations will be sorted in taxonomic order.

Scythebill 16.5 - multi-taxonomy spreadsheets

Scythebill 16.5 is now available!  There's new features for creating spreadsheets across all taxonomies in one go, and an important fix to importing.  As always, download here, and let me know if you have any problems, either on Facebook or by email.

Update: Scythebill 16.5.1 was released on July 8th - it fixes one bug with multi-taxonomy checklist spreadsheets.

One spreadsheet, all taxonomies

Before this version, if you wanted to create checklists or save a report as a spreadsheet, it would only export one taxonomy at a time.

Now, there's a new option, both in Show reports and Browse by location, "Include all taxonomies?".   If you choose Export sightings... ... to a spreadsheet, or you save a location checklist with Save as spreadsheet..., you'll get this new option.

When you use this option, the spreadsheet will have separate sheets for each taxonomy:

Example report spreadsheet

Totals in saved checklists

At the top of a checklist spreadsheet, you'll see a summary line outlining how many species are on the checklist, as well as how many are endemic, possible lifers, and how many you've recorded in that location.

A Taiwan checklist - my birding there was limited to the airport. (11 species isn't so bad, considering!)

This is the same summary line that shows up atop Browse by locations, though in this release I've tried to improve that (and this) text to be more self-explanatory.

Other changes

One important bug fix: an error message could appear during location resolution while importing sightings.  (This was introduced in Scythebill 16.4.)

Scythebill 16.4 - "New for" column in checklist spreadsheets and more

Scythebill 16.4 is now available!  There's a "New for" column in checklist spreadsheets, a number of small import improvements, and other small fixes.   As always, download here, and let me know if you have any problems, either on Facebook or by email.

Update: Scythebill 16.4.1 was released on June 2nd, with bug fixes to import handling of timestamps and new locations (especially affecting BirdLasser).

"New for" column for location checklist spreadsheets

The last release of Scythebill added an option for a "Lifer?" column when you save a location checklist as a spreadsheet.  This release replaces it with a much more useful "New for" column, telling you not just if that checklist species would be new for you but how - whether it's new for your world list, the country (or state), or even if it'd be new for your world Photographed list (the latter only appears if you ever attach photos to sightings).

Import improvements

The summary of "New for" species when importing sightings should be both less confusing and not require resizing to be visible.  (Before, for example, if you had world lifers and new species for a site in one import, the lifers wouldn't show up as new for the site;  they will now.)

BirdLasser, BirdTrack, and Wildlife Recorder imports sometimes require you to choose a location for imported sightings off of a latitude and longitude.  Scythebill should now be much better at making that process less painful - countries will be filled in far more often, the "existing location" drop-down menu is sorted by closest location in KM, and it's generally smarter at guessing whether the new sightings should require a new location or can use an existing location.

Scythebill-format imports now optionally support a Genus/Species column, as well as an "End time" column.  Both of these are useful for importing from custom software - if some software exports genus and species names separately, rather than joined to a scientific name, you don't have to combine those columns before importing.  Similarly, you can supply an "End time" instead of a Duration, and Scythebill will calculate the Duration for you.

Scythebill now automatically supports imports for "Lawrence's", "Brewster's", and "Sutton's" Warblers - a few North American hybrids which might appear in eBird exports with those names.

Finally, BirdBase imports now properly handle imports from Newfoundland and the Northwest Territories.

Other fixes

• If you "remember" a report from Show reports which used the "Times sighted" option, it'll now show the correct number on the home screen.
• Gibraltar is no longer considered part of the UK for the Total Ticks "Country" report.  (I don't think any British birders consider Gibraltar sightings as part of their personal British list, but let me know if I've gotten that wrong!)
• You can now export "list-building imports" for eBird.  These are described on the eBird site, but briefly, they let you include sightings which don't have an exact day.  They'll be imported into eBird with the date January 1, 1900 and a visit comment of "life-list building checklist".  These sightings will be included on your life list in eBird, but won't be publicly visible or used as data on eBird.
• Exporting data for eBird might create files which couldn't be imported, with an error message like "Observation time is required for protocol...";  these shouldn't appear anymore.

Scythebill 16.3 - easier editing of existing visits

Scythebill 16.3 is now available!  It adds several small improvements and refinements; in particular, it's much easier to edit existing sightings. As always, download here, and let me know if you have any problems, either on Facebook or by email.

Editing existing sightings

Entering new sightings is easy, but getting back to the "Edit sightings" screen - to edit all the sightings from that visit - has always been a lot more difficult than it should be.  There was one way, buried deep in "Browse by location", but it was hard to find.

Now, it's easy: any time you select a sighting, whether in "Browse by species", "Browse by location", or even "Show reports", you'll see a new Visit sightings... button.  Click that, and you'll be taken to the "Edit sightings" screen with a list of all the sightings from that same visit.

Location checklist spreadsheet improvements

When you save a location checklist as a spreadsheet, there's two new options:

• First, you can turn off including family names, which can make your spreadsheet much shorter.
• Second, you can add a column for whether a species is a lifer.  Previously, the only option was marking the species name in bold, which was hard on those of you who like to write spreadsheet formulas.

BirdLasser import improvements

Scythebill now supports BirdLasser users who use scientific names as something other than the "Tertiary" name.

Scythebill also had a bug that could lead to some species being dropped from BirdLasser imports.  This would only happen in cases where the "ISO Date" column - which has date/time down to the millisecond! - had multiple species with the exact same value.

Small fixes

• In some very odd cases, US states whose two-letter abbreviation matches a country's two-letter abbreviation might display as that country.  (For example, Pennsylvania would appear as Panama!)
• State/province lists are updated for a few countries, to match updated eBird treatment.  The only really significant changes were for France, which changed from 22 regions to 13.  (Scythebill will automatically rearrange your records to match.)