1 Reply by davec

  • davec
  • Veteran
  • Offline
  • From: Brecon, Powys, Wales
  • Registered: 11-05-2006
  • Posts: 108

Re: Import from Zipped mdb file fails...

Exception occurred in application Recorder 6 at 15/05/2008 12-06-28.
Version : 6.10.4.120

Exception path:
EOleException : Incorrect syntax near '='
EDBMergerError : Error occurred transferring records for SQLSERVER_TAXON_OCCURRENCE into the main database

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

Operating System : Windows XP  5.01.2600  Service Pack 2
Physical Memory available : 2,063,312 KB

DLLs loaded:
  advapi32.dll (5.1.2600.2180)
  comctl32.dll (5.82.2900.2982)
  comdlg32.dll (6.0.2900.2180)
  gdi32.dll (5.1.2600.3316)
  HHCtrl.ocx (5.2.3790.2847)
  kernel32.dll (5.1.2600.3119)
  mpr.dll (5.1.2600.2180)
  MS5.Dll (5.0.0.12)
  MS5User.Dll (5.0.0.4)
  odbc32.dll (3.525.1117.0)
  ole32.dll (5.1.2600.2726)
  oleaut32.dll (5.1.2600.3266)
  shell32.dll (6.0.2900.3241)
  user32.dll (5.1.2600.3099)
  version.dll (5.1.2600.2180)
  winmm.dll (5.1.2600.2180)
  winspool.drv (5.1.2600.2180)

Information has been saved to the file R:\LastError.txt

Has anyone had this before and found the source/fix for it. Thanks in anticipation.

Dave Cope,
Biodiversity Technology Officer,
Biodiversity Information Service for Powys and Brecon Beacons National Park.

davec's Website

2 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Import from Zipped mdb file fails...

Are there any Lalandii records in the import by any chance? They have an = in the name which causes various problems. If not Lalandii, then are there any other species in there with = in the name?

I think this problem is being fixed in the new version.

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

3 Reply by davec

  • davec
  • Veteran
  • Offline
  • From: Brecon, Powys, Wales
  • Registered: 11-05-2006
  • Posts: 108

Re: Import from Zipped mdb file fails...

Hi Charles,

Thanks for the tip. I've not had chance to scan the data yet as I've been on other tasks, but will do that now.  This is a serious bug, hope it does get fixed in the next version.

Kind Regards.

Dave Cope,
Biodiversity Technology Officer,
Biodiversity Information Service for Powys and Brecon Beacons National Park.

davec's Website

4 Reply by davec

  • davec
  • Veteran
  • Offline
  • From: Brecon, Powys, Wales
  • Registered: 11-05-2006
  • Posts: 108

Re: Import from Zipped mdb file fails...

Hi Charles,

Yep...

Quercus petraea x robur = Q. x rosacea
Carex hostiana x viridula = C. x fulva

Not much I can do about this then. Another set of data which I'll have to spend large amount of time trying to clean up. :rolleyes:

Thanks.

Dave Cope,
Biodiversity Technology Officer,
Biodiversity Information Service for Powys and Brecon Beacons National Park.

davec's Website

5 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Import from Zipped mdb file fails...

Actually, you can do something about it. Just search for names in the dictionary that contain the = sign and replace it with a different unique character. I used the tilde I think: ~. Then once we get the update you can change the character back. It might be simpler to wait, though, seeing as the new version is just days away now.

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

6 Reply by davec

  • davec
  • Veteran
  • Offline
  • From: Brecon, Powys, Wales
  • Registered: 11-05-2006
  • Posts: 108

Re: Import from Zipped mdb file fails...

charlesr wrote:

Actually, you can do something about it. Just search for names in the dictionary that contain the = sign and replace it with a different unique character. I used the tilde I think: ~. Then once we get the update you can change the character back. It might be simpler to wait, though, seeing as the new version is just days away now.

Hi Charles,

Well yes, if the update is nearly ready I think I'd rather wait. Sound's like a lack of escaping in the underlying SQL or a bug in a parser somewhere. Is the use of the "=" char common practice in taxonomy? Genuinely interested to find out.

Thanks for the pointers Charles.

Dave Cope,
Biodiversity Technology Officer,
Biodiversity Information Service for Powys and Brecon Beacons National Park.

davec's Website