1

Re: Import Wizard - Survey Event Comment & Sample Comment

I was pleased ot see in the new version that the imprt wizard allows comments to be allocated to a particular level in the hierarchy. However, I've been trying it out and come stuck. Trying to allocate the comments column to either the Survey Event comment or sample comment results in the following error that appears during the "Processing Import file" stage:
Version : 6.13.2.176

Exception path:
EOleException : The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator

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

Operating System : Windows XP  5.01.2600  Service Pack 2
Physical Memory available : 1,047,552 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)
  gdiplus.dll (5.1.3102.2180)
  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)


Using the Taxon Occurence comment works as fine.
Can anybody else testify on this?

Many thanks,

Alex
Lothian Wildlife Information Centre

2

Re: Import Wizard - Survey Event Comment & Sample Comment

Hi Alex,

We have looked into this issue and have found a solution - this will be fixed for the next release (later this year).
The specimen comment also seems to have issues too which will be looked at.

Cheers,
Lynn Heeley
JNCC

3

Re: Import Wizard - Survey Event Comment & Sample Comment

Hi
I received a similar error message to Alex whilst importing an excel spreadsheet with a “sample comment” field. Without the “sample comment” field the import works fine.
I’m not sure which parts of the error message are of use, so here it is complete and unedited (apologies for its length):

date/time         : 2008-12-22, 12:46:13, 765ms
computer name     : PC1
user name         : David Angel
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 2 hours 6 minutes
program up time   : 30 minutes 58 seconds
processor         : Intel(R) Pentium(R) 4 CPU 2.60GHz
physical memory   : 2048/2048 MB (free/total)
free disk space   : (C:) 15.93 GB
display mode      : 1280x1024, 32 bit
process id        : $a4c
allocated memory  : 22.78 MB
command line      : RecorderApp.exe /721428
executable        : RecorderApp.exe
exec. date/time   : 2008-11-04 08: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 ($ac0):
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
7c90eb74 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
004528d8 RecorderApp.exe Classes                     StdWndProc
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

Interestingly, we have a separate instance of Recorder running on a stand alone machine. When I imported the spreadsheet on that machine it worked fine. Both instances of Recorder are  the same version number (6.13.3.182) which makes me think that SQL may be to blame. However this could merely be a wild accusation, as I know very little about the workings of SQL.
I hope this info helps someone in some way.
Cheers
David

[color=blue]David Angel[/color]
[color=blue]Data Officer[/color]
[color=blue]The Wildlife Information Centre[/color]

4

Re: Import Wizard - Survey Event Comment & Sample Comment

The smilely was not in the error message. It should read c colon close bracket.

[color=blue]David Angel[/color]
[color=blue]Data Officer[/color]
[color=blue]The Wildlife Information Centre[/color]

5

Re: Import Wizard - Survey Event Comment & Sample Comment

Hi David,

This issue was fixed with a script which was meant to have been included in 6.13.3 - I have spoken to Dorset about this and it was included in the upgrade (but not on the CD which was not available to Recorder users anyway). It does seem strange that you have one pc that does not trigger the error and one that does. Other users who have this error should ensure that they are on the latest version of Recorder.

Lynn