1 Reply by F M Leslie

  • F M Leslie
  • Member
  • Offline
  • Registered: 26-10-2006
  • Posts: 41

Re: Import wizard error

I am trying to import an Excel spreadsheet containing 4,500 plant records into Recorder 6.13 but am receiving the below error message.  Please could someone tell me what is going wrong!  Thanks

Exception occurred in application Recorder 6 at 05/03/2009 12:56:47.
Version : 6.13.2.176

Exception path:
EOleException : Unclosed quotation mark before the character string 'J'

Last event\actions:
  actImport invoked
  TfrmImportWizard created
  TfrmImportWizard activated
  TfrmImportWizard destroyed
  actImport invoked
  TfrmImportWizard created
  TfrmImportWizard activated

Operating System : Windows XP  5.01.2600  Service Pack 3
Physical Memory available : 1,046,512 KB

DLLs loaded:
  advapi32.dll (5.1.2600.5512)
  comctl32.dll (5.82.2900.5512)
  comdlg32.dll (6.0.2900.5512)
  gdi32.dll (5.1.2600.5698)
  gdiplus.dll (5.1.3102.5581)
  HHCtrl.ocx (5.2.3790.4110)
  kernel32.dll (5.1.2600.5512)
  mpr.dll (5.1.2600.5512)
  MS5.Dll (5.0.0.12)
  MS5User.Dll (5.0.0.4)
  odbc32.dll (3.525.1132.0)
  ole32.dll (5.1.2600.5512)
  oleaut32.dll (5.1.2600.5512)
  shell32.dll (6.0.2900.5622)
  user32.dll (5.1.2600.5512)
  version.dll (5.1.2600.5512)
  winmm.dll (5.1.2600.5512)
  winspool.drv (5.1.2600.5512)

2 Reply by Lynn Heeley

  • Lynn Heeley
  • Administrator
  • Offline
  • Registered: 03-07-2008
  • Posts: 345

Re: Import wizard error

Hi Leslie,

Looks like you have a symbol (a single quotation mark probably - like this ' or this ` ) which is near a letter J which is causing you problems. You could search for this symbol using Edit/find in excel and remove it and your spreadsheet should import fine. Unfortunately Recorder at the moment cannot cope with some symbols - hopefully with more funds we will be able to sort this out. Until this time you will have to clean your data so that the import wizard can manage the data.

Sorry, I know its annoying but using the find in excel you should be able to get to the bottom of it relatively quickly.

Cheers,
Lynn

3 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: Import wizard error

Also try " (double quote) - see http://forums.nbn.org.uk/viewtopic.php?pid=3946#p3946. Have you any plans to upgrade to v6.13.3.182? - see http://forums.nbn.org.uk/viewtopic.php?pid=3643#p3643

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687

4 Reply by F M Leslie

  • F M Leslie
  • Member
  • Offline
  • Registered: 26-10-2006
  • Posts: 41

Re: Import wizard error

Thank you for your messages.

I assumed the problem was a ' or " near a J too, so I searched for all ' and " (there were none) and then checked that all Js and js had no odd symbols near them, but could find nothing.  I am quite sure there are no other punctuation marks within the file, but could you suggest anything else I should search for?

The name of the observer begins with a J, so I have deleted and retyped this.

The box that pops up after the error message is 'The import file is empty, there is no data to input', if this means anything.

5 Reply by Lynn Heeley

  • Lynn Heeley
  • Administrator
  • Offline
  • Registered: 03-07-2008
  • Posts: 345

Re: Import wizard error

Recorder only imports from the first sheet in a spreadsheet. I presume you have the data on the first sheet of the spreadsheet? After retyping the observer name I presume you got the same error message?

Lynn

6 Reply by F M Leslie

  • F M Leslie
  • Member
  • Offline
  • Registered: 26-10-2006
  • Posts: 41

Re: Import wizard error

Please ignore the last message - after staring blankly at the offending spreadsheet waiting for divine inspiration I noticed a Chart1 worksheet tab before the Sheet1 tab which must have been mistakenly created during data entry and explains everything!

7 Reply by Lynn Heeley

  • Lynn Heeley
  • Administrator
  • Offline
  • Registered: 03-07-2008
  • Posts: 345

Re: Import wizard error

Good - its nice when the answer to a problem is straightforward. Thanks for explaining. Does the import now work after retyping your observer name?
Lynn

8 Reply by F M Leslie

  • F M Leslie
  • Member
  • Offline
  • Registered: 26-10-2006
  • Posts: 41

Re: Import wizard error

Yes, everything has gone smoothly now - Recorder must have been trying to enter the data in the Chart sheet rather than the actual spreadsheet containing the records.  Thanks for your help.