Cinnamon Hummingbird

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.

Problem importing m...
 
Notifications
Clear all

[Solved] Problem importing multiple Ebird lists


Posts: 11
Topic starter
(@jdhoule01)
Active Member
Joined: 2 years ago

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. 

Reply
3 Replies
Jeff
Posts: 478
 Jeff
Admin
(@jeff)
Creator & Technical Support
Joined: 2 years ago

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. 

Reply
Jeff
Posts: 478
 Jeff
Admin
(@jeff)
Creator & Technical Support
Joined: 2 years ago

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.

image

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.

image

You are getting this...

image

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.

Reply
Jeff
Posts: 478
 Jeff
Admin
(@jeff)
Creator & Technical Support
Joined: 2 years ago

Build 13 is now available. fyi

Reply
Share: