1 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Importing Records

The following error message has just started to appear when importing records. It occurs in the very last stage when Recorder is 'Processing import file'

I have tried several different files, both TXT and Excel and importing into different surveys - all to no avail. Import was working perfectly yesterday morning and the only change I can think of is an automatic Windows update which required a restart.

Craig
- Error Message -------
date/time         : 2009-07-29, 13:56:28, 46ms
computer name     : WS10
user name         : slawsoc
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 5 hours 31 minutes
program up time   : 1 minute 21 seconds
processors        : 2x Intel(R) Pentium(R) 4 CPU 3.00GHz
physical memory   : 310/1023 MB (free/total)
free disk space   : (C:) 9.04 GB (R:) 7.61 GB
display mode      : 1600x1200, 32 bit
process id        : $fd8
allocated memory  : 30.84 MB
command line      : RecorderApp.exe /16122464
executable        : RecorderApp.exe
exec. date/time   : 2008-11-04 09:45
version           : 6.13.3.182
madExcept version : 2.7h
exception class   : EOleException
exception message : The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

main thread ($b94):
0055fd9e RecorderApp.exe ADODB                       TADOCommand.Execute
0055fcf8 RecorderApp.exe ADODB                       TADOCommand.Execute
0055fcd8 RecorderApp.exe ADODB                       TADOCommand.Execute
0062ba94 RecorderApp.exe DatabaseAccessADO       909 TdmDatabase.ExecuteSQL
008dc2ce RecorderApp.exe IWTableRule             581 TTableRule.Apply
008e6c80 RecorderApp.exe IWColumnMappingClasses 1673 TImportFile.ApplyTableRules
00901480 RecorderApp.exe Import                  183 TfraImport.GenerateImportDatabase
00901330 RecorderApp.exe Import                  152 TfraImport.Execute
008fd805 RecorderApp.exe ImportWizard            339 TfrmImportWizard.ChangePage
008fd279 RecorderApp.exe ImportWizard            189 TfrmImportWizard.btnNextClick
004b4048 RecorderApp.exe Controls                    TControl.Click
004a9160 RecorderApp.exe StdCtrls                    TButton.Click
0046ff09 RecorderApp.exe Buttons                     TBitBtn.Click
004a9254 RecorderApp.exe StdCtrls                    TButton.CNCommand
004b3eb0 RecorderApp.exe Controls                    TControl.WndProc
004b6f0f RecorderApp.exe Controls                    TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls                    TButtonControl.WndProc
006f42d4 RecorderApp.exe XPMenu                 2928 TControlSubClass.ControlSubClass
7c90eb94 ntdll.dll                                   RtlAnsiStringToUnicodeString
004b3c80 RecorderApp.exe Controls                    TControl.Perform
004b7047 RecorderApp.exe Controls                    DoControlMsg
004b769f RecorderApp.exe Controls                    TWinControl.WMCommand
004b3eb0 RecorderApp.exe Controls                    TControl.WndProc
004b6f0f RecorderApp.exe Controls                    TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls                    TButtonControl.WndProc
00445985 RecorderApp.exe Classes                     TList.Delete
004b6b8c RecorderApp.exe Controls                    TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes                     StdWndProc
7e4292de user32.dll                                  SendMessageW
7e42a993 user32.dll                                  CallWindowProcA
004b6ff3 RecorderApp.exe Controls                    TWinControl.DefaultHandler
004b4450 RecorderApp.exe Controls                    TControl.WMLButtonUp
004b3eb0 RecorderApp.exe Controls                    TControl.WndProc
004b6e41 RecorderApp.exe Controls                    TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls                    TButtonControl.WndProc
006f42d4 RecorderApp.exe XPMenu                 2928 TControlSubClass.ControlSubClass
004b3c80 RecorderApp.exe Controls                    TControl.Perform
004b6b8c RecorderApp.exe Controls                    TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes                     StdWndProc
7e4196c2 user32.dll                                  DispatchMessageA
004d4de3 RecorderApp.exe Forms                       TApplication.ProcessMessage
004d4e1a RecorderApp.exe Forms                       TApplication.HandleMessage
004d503a RecorderApp.exe Forms                       TApplication.Run
0099f832 RecorderApp.exe RecorderApp             317 initialization

Craig Slawson
Staffordshire Ecological Record

ser's Website

2 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Importing Records

To update this, I'm even more confused now - I have successfully imported some data from a spreadsheet, but the original files which caused the problem still refuse to import - this suggested it is a problem with the data.

After a number of experiments, I found the problem - one of the columns I was importing was assigned to 'Sample Start' - when I excluded this column the import worked fine. The original data had been formated in Excel as 'Time' so I am unclear why this caused the crash!

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website

3 Reply by Lynn Heeley

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

Re: Importing Records

Hi Craig,

I would suggest checking your data in the column causing the problem with that expected in the import wizard in the Help - it is possible that you have some data of an unexpected format that is causing an issue.

Cheers,
Lynn

4 Reply by Gordon Barker (edited by Gordon Barker 04-08-2009 09:07:15)

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

Re: Importing Records

Craig,

I think I have had a similar problem where a column on the import table has been assigned to Sample comment. The error message is the same, and the remedy is to start again and assign the value to Taxon Occurence Comment, or ignore the column. I assume that the import wizard is finding multiple values to assign to a single Sample field which causes it to throw a wobbly and give an error message that doesn't seem to make sense.

Gordon

Gordon Barker
Biological Survey Data Manager
National Trust

5 Reply by Lynn Heeley

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

Re: Importing Records

We have added a couple of scripts to 6.14 which will assist with the column matching in the import wizard - ie the following column headings did not match automatically: Survey event comment, survey event weather, taxon determination comment and taxon occurrence comment. In addition the survey event comment and sample comment now split the events and samples corectly on import so that comments are no longer lost. Hopefully this will help.
Cheers,
Lynn