Welcome to the Birder's Diary Forum for Support And General Questions
Use the Support forum for all questions or issues.
Use the Wish List forum to leave your ideas for improving Birder’s Diary.
Setup your Forum photo and profile here.
I am trying to import multiple Ebird lists by simultaneously
selecting multiple .csv files downloaded from Ebird from my hard drive. The Import procedure seems to work for two or three of the files, but then gives me the set of error messages in the attached file.
Sometimes this error prevents further importing, and I have to close and reopen Birder's Diary or open and close the offending file in Excel get back to importing.
This never seems to happen when I import one file at a time, but when I have multiple lists each day this is a very tedious alternative.
Hi David,
Thanks for posting and for the screenshots and details.
This should always fail if you have any of the downloaded eBird export files open. You cannot import any files that are currently open in Excel.
Are you saying you do or do not have the eBird CSV file open in Excel?
BD first reads in each file and writes out a BD Import File. The message is curious. And I will have to dig deeper into the code to figure out what must be going on and see if I can reproduce this.
But, for clarification, my guess is that if you have none of the eBird downloaded CSV files open in any program, then the import works fine. Please clarify.
Thanks.
p.s. I have guests in town for 3 more days, so more digging on this one and my response to your streamlining topic update will need to wait until Sunday please. Happy Holidays.
Hi David,
Digging into this one today.
So, after re-reading your original post, it does not appear that you have any of the import files open when attempting to import them - correct? When I do, I get a message intended to check for this that looks like this.
Not what you are getting.
Instead, you say that if you open/close one of the problem import files then BD import will work again - correct?
Sorry I misread that to begin with... house full of guests for a couple weeks.
You are getting this...
The extra msgs that you provided are simply due to this error.
BD takes the eBird import file and converts it to a BD import file by the name of "EBirdSightingsImport.csv". And then attempts to import that into the database.
After I create the CSV mentioned above, I do close it. And then attempt to import into the database using the command in the error message.
My guess, and it is a strong guess, is that you have a fast multiprocessor computer and these statements are running on different threads on different CPUs and get out of sync (a Windows OS problem that can happen). Such that the import attempts to happen before the close on the newly created import file completes.
So, I am going to put some code in such that if this happens, it will pause for 2s and try again to see if the file eventually closes. It will try this twice before reporting the error, and let's see how that goes. This will be in Build 13 of v5.3.
Please let me know if you ever see this again after upgrading to Build 13.
Build 13 is now available. fyi
Latest Post: Run-time error 3346 Our newest member: lloydjonesv Recent Posts Unread Posts
