1 Topic by beckymay

  • beckymay
  • Member
  • Offline
  • Registered: 22-08-2012
  • Posts: 5

Topic: Importing from an excel spreadsheet - error message

Hi - I am trying to import a lot of bat records into recorder using an excel spreadsheet. I've tried to create a Recorder-friendly template and, when I validate columns, there are no recorded errors. However, at that point I get an 'unhandled error' message so I can't proceed to the next stage of import. On viewing the bug report, it says it's a range check error. Any ideas on what I am doing wrong?

Many thanks,

Becky (ps - I am relatively new to recorder...!)

2 Reply by Gordon Barker

  • Gordon Barker
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 344

Re: Importing from an excel spreadsheet - error message

Is the import file still open in XL? This will prevent the import at either the first or second step, can't remember which off the top of my head.

Gordon Barker
Biological Survey Data Manager
National Trust

3 Reply by beckymay

  • beckymay
  • Member
  • Offline
  • Registered: 22-08-2012
  • Posts: 5

Re: Importing from an excel spreadsheet - error message

Hi Gordon - no it's not open in excel...

4 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Importing from an excel spreadsheet - error message

The date column is most likely causing the problem, but rather than   keep trying things if you can zip up the data and attach it to this topic I will take a look for you.

Mike Weideli

MikeWeideli's Website

5 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Importing from an excel spreadsheet - error message

To move forward you need to remove all  the question marks (all of them)  from the abundance column.   This should allow you to proceed to the next stage.

Mike Weideli

MikeWeideli's Website

6 Reply by beckymay

  • beckymay
  • Member
  • Offline
  • Registered: 22-08-2012
  • Posts: 5

Re: Importing from an excel spreadsheet - error message

Thanks v much, Mike - I'll try that.