What program are you using to deal with your eBird data? Can you open it in Excel or something like that?
The first thing I would try is replacing all the X's (in the numbers column, not in the bird names!) with nothing. So do Edit > Find and Replace and just leave the "Replace With" box completely blank (no spaces or anything). Then, when you do a replace, it will clear out the number cells that have X's.
Birdstack treats a blank value the same way that eBird treats an X. We probably need to look at just accepting X's on import so you don't have to replace them like that.
drewweber said:
Trying to import some eBird data and the 'x' I input for some of the species I didn't count causes the import tool some problems. Any suggestions?
Posted Wednesday, 23 January 2008, 02:59
djringer said:
Hi Drew,
What program are you using to deal with your eBird data? Can you open it in Excel or something like that?
The first thing I would try is replacing all the X's (in the numbers column, not in the bird names!) with nothing. So do Edit > Find and Replace and just leave the "Replace With" box completely blank (no spaces or anything). Then, when you do a replace, it will clear out the number cells that have X's.
Birdstack treats a blank value the same way that eBird treats an X. We probably need to look at just accepting X's on import so you don't have to replace them like that.
Hope this helps.
David
David J. Ringer
http://djringer.com/birding
http://birdstack.com
Posted Wednesday, 23 January 2008, 14:40
djringer said:
Drew and all,
Our import tool now allows a single "X" in the "Number observed" column. Hope this helps!
David
David J. Ringer
http://djringer.com/birding
http://birdstack.com
Posted Saturday, 26 January 2008, 05:43