1 Reply by TonyP

  • TonyP
  • TonyP
  • Veteran
  • Offline
  • From: Somerset
  • Registered: 15-05-2006
  • Posts: 306

Re: Import - Validating Data

So 3 days to modify data from MapMate to fit the Wizard, 3 days matching names that should and some that shouldn't have been matched.

The final screen - Crashes on Validating Data - I rebooted the machine and started the import again and on the final screen it crashes on Validating Data. There is no where else to go! Continue application does not mean the import continues. I'm not sure what it is validating since I've had to confirm matches for each name, species and term list in the data set.

End of story no point in continuing with Recorder. My first, smallest and least complex dataset and it can't even cope with that. Any one got any suggestions?

date/time         : 2010-07-14, 15:07:54, 909ms
computer name     : SERC-TONY
user name         : tony.price
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 18 minutes 6 seconds
program up time   : 8 minutes 55 seconds
processors        : 2x AMD Athlon(tm) 7750 Dual-Core Processor
physical memory   : 1235/1919 MB (free/total)
free disk space   : (C:) 180.70 GB (U:) 36.14 GB
display mode      : 1280x1024, 32 bit
process id        : $b10
allocated memory  : 33.23 MB
command line      : RecorderApp.exe /131792
executable        : RecorderApp.exe
exec. date/time   : 2009-11-23 09:25
version           : 6.14.5.218
madExcept version : 2.7h
exception class   : EOleException
exception message : Invalid class string.

main thread ($bbc):
0097b659 RecorderApp.exe 
7e42a993 user32.dll       CallWindowProcA
7c90eb94 ntdll.dll        RtlAnsiStringToUnicodeString
7e4292de user32.dll       SendMessageW
7e42a993 user32.dll       CallWindowProcA
7e4196c2 user32.dll       DispatchMessageA

modules:
00350000 C4DLL.DLL             1.0.0.1          U:
003c0000 MS5User.Dll           5.0.0.4          U:
00400000 RecorderApp.exe       6.14.5.218       U:
013c0000 ms5cnv.dll            5.0.0.10         U:
01b50000 odbcint.dll           3.525.1132.0     C:\WINDOWS\system32
029a0000 xpsp2res.dll          5.1.2600.5512    C:\WINDOWS\system32
038e0000 SQLOLEDB.RLL          2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
038f0000 msadcer.dll           2.81.1132.0      C:\Program Files\Common Files\System\msadc
03b70000 ShowUnchecked.ocx     6.0.0.13         U:\Addins
03dc0000 StdValLib.dll         6.14.3.208       U:\Addins
046d0000 Normaliz.dll          6.0.5441.0       C:\WINDOWS\system32
07160000 Audiodev.dll          5.2.5721.5145    C:\WINDOWS\system32
0f9a0000 VBAJET32.DLL          6.0.1.9432       C:\WINDOWS\system32
0f9c0000 expsrv.dll            6.0.72.9590      C:\WINDOWS\system32
10000000 MS5.Dll               5.0.0.12         U:
10930000 PortableDeviceApi.dll 5.2.5721.5145    C:\WINDOWS\system32
11c70000 WMASF.DLL             11.0.5721.5238   C:\WINDOWS\system32
15110000 WMVCore.DLL           11.0.5721.5275   C:\WINDOWS\system32
16080000 mdnsNSP.dll           1.0.3.1          C:\Program Files\Bonjour
16210000 wpdshext.dll          5.2.5721.5145    C:\WINDOWS\system32
1b000000 msjet40.dll           4.0.9511.0       C:\WINDOWS\system32
1b2c0000 msjter40.dll          4.0.9502.0       C:\WINDOWS\system32
1b2d0000 MSJINT40.DLL          4.0.9502.0       C:\WINDOWS\system32
1b570000 msjetoledb40.dll      4.0.9502.0       C:\WINDOWS\system32
1b5d0000 mswstr10.dll          4.0.9502.0       C:\WINDOWS\system32
1b800000 msjtes40.dll          4.0.9502.0       C:\WINDOWS\system32
20000000 xpsp3res.dll          5.1.2600.5512    C:\WINDOWS\system32
3d930000 WININET.dll           8.0.6001.18923   C:\WINDOWS\system32
3dfd0000 iertutil.dll          8.0.6001.18923   C:\WINDOWS\system32
4ca30000 msadrh15.dll          2.81.1132.0      C:\Program Files\Common Files\System\ado
4d650000 msadox.dll            2.81.1132.0      C:\Program Files\Common Files\System\ado
4dd00000 sqloledb.dll          2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
4de10000 msado15.dll           2.81.1132.0      C:\Program Files\Common Files\System\ado
4ec50000 gdiplus.dll           5.2.6001.22319   C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.6001.22319_x-ww_f0b4c2df
593f0000 wiashext.dll          5.1.2600.5512    C:\WINDOWS\system32
5ad70000 uxtheme.dll           6.0.2900.5512    C:\WINDOWS\system32
5b860000 NETAPI32.dll          5.1.2600.5694    C:\WINDOWS\system32
5d090000 comctl32.dll          5.82.2900.5512   C:\WINDOWS\system32
5edd0000 olepro32.dll          5.1.2600.5512    C:\WINDOWS\system32
605d0000 mslbui.dll            5.1.2600.5512    C:\WINDOWS\system32
60e30000 MSDATL3.dll           2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
662b0000 hnetcfg.dll           5.1.2600.5512    C:\WINDOWS\system32
68000000 rsaenh.dll            5.1.2600.5507    C:\WINDOWS\system32
68100000 dssenh.dll            5.1.2600.5507    C:\WINDOWS\system32
69b10000 msxml4.dll            4.20.9876.0      c:\WINDOWS\system32
6bd00000 SYNCOR11.DLL          0.1.2.3          C:\WINDOWS\system32
6d4f0000 DBNETLIB.DLL          2000.85.1132.0   C:\WINDOWS\system32
71a50000 mswsock.dll           5.1.2600.5625    C:\WINDOWS\system32
71a90000 wshtcpip.dll          5.1.2600.5512    C:\WINDOWS\System32
71aa0000 WS2HELP.dll           5.1.2600.5512    C:\WINDOWS\system32
71ab0000 WS2_32.dll            5.1.2600.5512    C:\WINDOWS\system32
71ad0000 wsock32.dll           5.1.2600.5512    C:\WINDOWS\system32
71b20000 mpr.dll               5.1.2600.5512    C:\WINDOWS\system32
71bf0000 SAMLIB.dll            5.1.2600.5512    C:\WINDOWS\System32
71c10000 ntlanman.dll          5.1.2600.5512    C:\WINDOWS\System32
71c80000 NETRAP.dll            5.1.2600.5512    C:\WINDOWS\System32
71c90000 NETUI1.dll            5.1.2600.5512    C:\WINDOWS\System32
71cd0000 NETUI0.dll            5.1.2600.5512    C:\WINDOWS\System32
71f80000 security.dll          5.1.2600.5512    C:\WINDOWS\system32
73000000 winspool.drv          5.1.2600.5512    C:\WINDOWS\system32
73160000 oledb32.dll           2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
732e0000 RICHED32.DLL          5.1.2600.0       C:\WINDOWS\system32
73ba0000 sti.dll               5.1.2600.5512    C:\WINDOWS\system32
74060000 msadce.dll            2.81.3002.0      C:\Program Files\Common Files\System\msadc
74320000 odbc32.dll            3.525.1132.0     C:\WINDOWS\system32
74720000 MSCTF.dll             5.1.2600.5512    C:\WINDOWS\system32
74ae0000 CFGMGR32.dll          5.1.2600.5512    C:\WINDOWS\system32
74e30000 RICHED20.dll          5.30.23.1230     C:\WINDOWS\system32
750b0000 RESUTILS.DLL          5.1.2600.5512    C:\WINDOWS\system32
750f0000 MTXCLU.DLL            2001.12.4414.706 C:\WINDOWS\system32
75130000 colbact.DLL           2001.12.4414.700 C:\WINDOWS\system32
75350000 OLEDB32R.DLL          2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
754d0000 CRYPTUI.dll           5.131.2600.5512  C:\WINDOWS\system32
755c0000 msctfime.ime          5.1.2600.5512    C:\WINDOWS\system32
75f60000 drprov.dll            5.1.2600.5512    C:\WINDOWS\System32
75f70000 davclnt.dll           5.1.2600.5512    C:\WINDOWS\System32
75f80000 browseui.dll          6.0.2900.5512    C:\WINDOWS\system32
76390000 IMM32.DLL             5.1.2600.5512    C:\WINDOWS\system32
763b0000 comdlg32.dll          6.0.2900.5512    C:\WINDOWS\system32
765b0000 MSDART.DLL            2.81.1132.0      C:\WINDOWS\system32
76600000 CSCDLL.dll            5.1.2600.5512    C:\WINDOWS\System32
76620000 comsvcs.dll           2001.12.4414.702 C:\WINDOWS\system32
76780000 SHFolder.dll          6.0.2900.5512    C:\WINDOWS\system32
76790000 cryptdll.dll          5.1.2600.5512    C:\WINDOWS\system32
767a0000 ntdsapi.dll           5.1.2600.5512    C:\WINDOWS\system32
767f0000 schannel.dll          5.1.2600.5834    C:\WINDOWS\system32
76990000 ntshrui.dll           5.1.2600.5512    C:\WINDOWS\system32
769c0000 USERENV.dll           5.1.2600.5512    C:\WINDOWS\system32
76b20000 ATL.DLL               3.5.2284.2       C:\WINDOWS\system32
76b40000 winmm.dll             5.1.2600.5512    C:\WINDOWS\system32
76c30000 WINTRUST.dll          5.131.2600.5922  C:\WINDOWS\system32
76c90000 IMAGEHLP.dll          5.1.2600.5512    C:\WINDOWS\system32
76d10000 CLUSAPI.DLL           5.1.2600.5512    C:\WINDOWS\system32
76d60000 iphlpapi.dll          5.1.2600.5512    C:\WINDOWS\system32
76f20000 DNSAPI.dll            5.1.2600.5625    C:\WINDOWS\system32
76f60000 WLDAP32.dll           5.1.2600.5512    C:\WINDOWS\system32
76fb0000 winrnr.dll            5.1.2600.5512    C:\WINDOWS\System32
76fc0000 rasadhlp.dll          5.1.2600.5512    C:\WINDOWS\system32
76fd0000 CLBCATQ.DLL           2001.12.4414.700 C:\WINDOWS\system32
77050000 COMRes.dll            2001.12.4414.700 C:\WINDOWS\system32
77120000 oleaut32.dll          5.1.2600.5512    C:\WINDOWS\system32
773d0000 comctl32.dll          6.0.2900.5512    C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.5512_x-ww_35d4ce83
774e0000 ole32.dll             5.1.2600.5512    C:\WINDOWS\system32
77920000 SETUPAPI.dll          5.1.2600.5512    C:\WINDOWS\system32
77a20000 cscui.dll             5.1.2600.5512    C:\WINDOWS\System32
77a80000 crypt32.dll           5.131.2600.5512  C:\WINDOWS\system32
77b20000 MSASN1.dll            5.1.2600.5875    C:\WINDOWS\system32
77b40000 apphelp.dll           5.1.2600.5512    C:\WINDOWS\system32
77c00000 version.dll           5.1.2600.5512    C:\WINDOWS\system32
77c10000 msvcrt.dll            7.0.2600.5512    C:\WINDOWS\system32
77c70000 msv1_0.dll            5.1.2600.5876    C:\WINDOWS\system32
77dd0000 advapi32.dll          5.1.2600.5755    C:\WINDOWS\system32
77e70000 RPCRT4.dll            5.1.2600.5795    C:\WINDOWS\system32
77f10000 GDI32.dll             5.1.2600.5698    C:\WINDOWS\system32
77f60000 SHLWAPI.dll           6.0.2900.5912    C:\WINDOWS\system32
77fe0000 Secur32.dll           5.1.2600.5834    C:\WINDOWS\system32
78130000 urlmon.dll            8.0.6001.18923   C:\WINDOWS\system32
7c800000 kernel32.dll          5.1.2600.5781    C:\WINDOWS\system32
7c900000 ntdll.dll             5.1.2600.5755    C:\WINDOWS\system32
7c9c0000 shell32.dll           6.0.2900.5622    C:\WINDOWS\system32
7e290000 shdocvw.dll           6.0.2900.5512    C:\WINDOWS\system32
7e410000 user32.dll            5.1.2600.5512    C:\WINDOWS\system32
7e4b0000 HHCtrl.ocx            5.2.3790.4110    C:\WINDOWS\system32
7e720000 SXS.DLL               5.1.2600.5512    C:\WINDOWS\system32

Has anyone imported data using the wizard in R6 cos I'm beginning to wonder if it can be done?

Data Manger
Somerset Environmental Records Centre

TonyP's Website

2 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: Import - Validating Data

I've got into the habit of copying the temporary database Recorder creates (if I get that far) in case it fails validation or I need to go home and get some sleep and kill Recorder.

Recorder, for me at least, puts its temporary databases in:

C:\Documents and Settings\ {username} \Local Settings\Temp\NBN Import

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

3 Reply by TonyP

  • TonyP
  • TonyP
  • Veteran
  • Offline
  • From: Somerset
  • Registered: 15-05-2006
  • Posts: 306

Re: Import - Validating Data

Thanks, but I'm not sure how that helps as it still fails the validation, is there some way to import from the temp database?

Data Manger
Somerset Environmental Records Centre

TonyP's Website

4 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: Import - Validating Data

It only helps if you know why it's failing validation - I find it much quicker to trawl through the Access database and correct it rather than importing it through Recorder all over again.

I think Recorder saves the Access database as .idb file - if you rename it to a mdb, you can open it up with Access. Zipping the mdb will create a "NBN access database", which you can then import into Recorder.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

5 Reply by TonyP

  • TonyP
  • TonyP
  • Veteran
  • Offline
  • From: Somerset
  • Registered: 15-05-2006
  • Posts: 306

Re: Import - Validating Data

Thanks again that means If I can work out what Invalid class string error has occurred I might be able to import some data. Tomorrow looks to be a long day.

Data Manger
Somerset Environmental Records Centre

TonyP's Website

6 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Import - Validating Data

Hi Tony
Can you try this:
Select Tools->Install->Add-in module on the menu.
Click on Recorder 6 Standard Validation
Click Remove and accept any prompts from Windows.
Click Install
Browse to your Addins folder in the Recorder 6 installation
Select StdValLib.dll and click Open.
Does that install successfully?
If so, does it help your import problem?

John van Breda
Biodiverse IT

johnvanbreda's Website

7 Reply by TonyP

  • TonyP
  • TonyP
  • Veteran
  • Offline
  • From: Somerset
  • Registered: 15-05-2006
  • Posts: 306

Re: Import - Validating Data

Thanks John but no, I can't remove the standard validation as it causes an exception;

version           : 6.14.5.218
madExcept version : 2.7h
exception class   : EOleSysError
exception message : Class not registered.

I did find something possibly useful when having another go this morning. The temp database may not be created properly. I only get an .ldb and a .tmp file created by the time it falls over. I'm not sure that it is a wrong name having never got this far before. It does appear to be a valid access database as I can rename it and open it.

Got me all excited for a moment :)

Full Error Report:
ree disk space   : (C:) 180.48 GB (U:) 36.09 GB
display mode      : 1280x1024, 32 bit
process id        : $cc8
allocated memory  : 13.83 MB
command line      : RecorderApp.exe /66514
executable        : RecorderApp.exe
exec. date/time   : 2009-11-23 09:25
version           : 6.14.5.218
madExcept version : 2.7h
exception class   : EOleSysError
exception message : Class not registered.

main thread ($ccc):
00506089 RecorderApp.exe 
7c90eb94 ntdll.dll        RtlAnsiStringToUnicodeString
7e4292de user32.dll       SendMessageW
7e42a993 user32.dll       CallWindowProcA
7e4196c2 user32.dll       DispatchMessageA

modules:
00350000 C4DLL.DLL         1.0.0.1          U:
003c0000 MS5User.Dll       5.0.0.4          U:
00400000 RecorderApp.exe   6.14.5.218       U:
013c0000 ms5cnv.dll        5.0.0.10         U:
01b50000 odbcint.dll       3.525.1132.0     C:\WINDOWS\system32
029a0000 xpsp2res.dll      5.1.2600.5512    C:\WINDOWS\system32
038e0000 SQLOLEDB.RLL      2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
038f0000 msadcer.dll       2.81.1132.0      C:\Program Files\Common Files\System\msadc
03b70000 ShowUnchecked.ocx 6.0.0.13         U:\Addins
03dc0000 StdValLib.dll     6.14.3.208       U:\Addins
10000000 MS5.Dll           5.0.0.12         U:
16080000 mdnsNSP.dll       1.0.3.1          C:\Program Files\Bonjour
20000000 xpsp3res.dll      5.1.2600.5512    C:\WINDOWS\system32
4dd00000 sqloledb.dll      2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
4de10000 msado15.dll       2.81.1132.0      C:\Program Files\Common Files\System\ado
4ec50000 gdiplus.dll       5.2.6001.22319   C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.6001.22319_x-ww_f0b4c2df
5ad70000 uxtheme.dll       6.0.2900.5512    C:\WINDOWS\system32
5b860000 NETAPI32.dll      5.1.2600.5694    C:\WINDOWS\system32
5d090000 comctl32.dll      5.82.2900.5512   C:\WINDOWS\system32
5edd0000 olepro32.dll      5.1.2600.5512    C:\WINDOWS\system32
605d0000 mslbui.dll        5.1.2600.5512    C:\WINDOWS\system32
60e30000 MSDATL3.dll       2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
662b0000 hnetcfg.dll       5.1.2600.5512    C:\WINDOWS\system32
68000000 rsaenh.dll        5.1.2600.5507    C:\WINDOWS\system32
68100000 dssenh.dll        5.1.2600.5507    C:\WINDOWS\system32
69b10000 msxml4.dll        4.20.9876.0      c:\WINDOWS\system32
6bd00000 SYNCOR11.DLL      0.1.2.3          C:\WINDOWS\system32
6d4f0000 DBNETLIB.DLL      2000.85.1132.0   C:\WINDOWS\system32
71a50000 mswsock.dll       5.1.2600.5625    C:\WINDOWS\system32
71a90000 wshtcpip.dll      5.1.2600.5512    C:\WINDOWS\System32
71aa0000 WS2HELP.dll       5.1.2600.5512    C:\WINDOWS\system32
71ab0000 WS2_32.dll        5.1.2600.5512    C:\WINDOWS\system32
71ad0000 wsock32.dll       5.1.2600.5512    C:\WINDOWS\system32
71b20000 mpr.dll           5.1.2600.5512    C:\WINDOWS\system32
71f80000 security.dll      5.1.2600.5512    C:\WINDOWS\system32
73000000 winspool.drv      5.1.2600.5512    C:\WINDOWS\system32
73160000 oledb32.dll       2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
74060000 msadce.dll        2.81.3002.0      C:\Program Files\Common Files\System\msadc
74320000 odbc32.dll        3.525.1132.0     C:\WINDOWS\system32
74720000 MSCTF.dll         5.1.2600.5512    C:\WINDOWS\system32
750b0000 RESUTILS.DLL      5.1.2600.5512    C:\WINDOWS\system32
750f0000 MTXCLU.DLL        2001.12.4414.706 C:\WINDOWS\system32
75130000 colbact.DLL       2001.12.4414.700 C:\WINDOWS\system32
75350000 OLEDB32R.DLL      2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
755c0000 msctfime.ime      5.1.2600.5512    C:\WINDOWS\system32
76390000 IMM32.DLL         5.1.2600.5512    C:\WINDOWS\system32
763b0000 comdlg32.dll      6.0.2900.5512    C:\WINDOWS\system32
765b0000 MSDART.DLL        2.81.1132.0      C:\WINDOWS\system32
76620000 comsvcs.dll       2001.12.4414.702 C:\WINDOWS\system32
76780000 SHFolder.dll      6.0.2900.5512    C:\WINDOWS\system32
76790000 cryptdll.dll      5.1.2600.5512    C:\WINDOWS\system32
767a0000 ntdsapi.dll       5.1.2600.5512    C:\WINDOWS\system32
767f0000 schannel.dll      5.1.2600.5834    C:\WINDOWS\system32
769c0000 USERENV.dll       5.1.2600.5512    C:\WINDOWS\system32
76b40000 winmm.dll         5.1.2600.5512    C:\WINDOWS\system32
76d10000 CLUSAPI.DLL       5.1.2600.5512    C:\WINDOWS\system32
76d60000 iphlpapi.dll      5.1.2600.5512    C:\WINDOWS\system32
76f20000 DNSAPI.dll        5.1.2600.5625    C:\WINDOWS\system32
76f60000 WLDAP32.dll       5.1.2600.5512    C:\WINDOWS\system32
76fb0000 winrnr.dll        5.1.2600.5512    C:\WINDOWS\System32
76fc0000 rasadhlp.dll      5.1.2600.5512    C:\WINDOWS\system32
76fd0000 CLBCATQ.DLL       2001.12.4414.700 C:\WINDOWS\system32
77050000 COMRes.dll        2001.12.4414.700 C:\WINDOWS\system32
77120000 oleaut32.dll      5.1.2600.5512    C:\WINDOWS\system32
773d0000 comctl32.dll      6.0.2900.5512    C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.5512_x-ww_35d4ce83
774e0000 ole32.dll         5.1.2600.5512    C:\WINDOWS\system32
77a80000 crypt32.dll       5.131.2600.5512  C:\WINDOWS\system32
77b20000 MSASN1.dll        5.1.2600.5875    C:\WINDOWS\system32
77b40000 apphelp.dll       5.1.2600.5512    C:\WINDOWS\system32
77c00000 version.dll       5.1.2600.5512    C:\WINDOWS\system32
77c10000 msvcrt.dll        7.0.2600.5512    C:\WINDOWS\system32
77c70000 msv1_0.dll        5.1.2600.5876    C:\WINDOWS\system32
77dd0000 advapi32.dll      5.1.2600.5755    C:\WINDOWS\system32
77e70000 RPCRT4.dll        5.1.2600.5795    C:\WINDOWS\system32
77f10000 GDI32.dll         5.1.2600.5698    C:\WINDOWS\system32
77f60000 SHLWAPI.dll       6.0.2900.5912    C:\WINDOWS\system32
77fe0000 Secur32.dll       5.1.2600.5834    C:\WINDOWS\system32
7c800000 kernel32.dll      5.1.2600.5781    C:\WINDOWS\system32
7c900000 ntdll.dll         5.1.2600.5755    C:\WINDOWS\system32
7c9c0000 shell32.dll       6.0.2900.5622    C:\WINDOWS\system32
7e410000 user32.dll        5.1.2600.5512    C:\WINDOWS\system32
7e4b0000 HHCtrl.ocx        5.2.3790.4110    C:\WINDOWS\system32
7e720000 SXS.DLL           5.1.2600.5512    C:\WINDOWS\system32

Data Manger
Somerset Environmental Records Centre

TonyP's Website

8 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Import - Validating Data

Tony

Loads of us have suffered these same problems and fixed them, if you google "NBN Forum Invalid Class String", you will find a thread in which we resolve that error (don't have time to find it for you I'm afraid), likewise, googling "NBN Forum Class not registered", should find the solution for that one. Or you could try just browsing my posts on here, for likely looking titles. Also check posts by Ellie Knott as she had some of the same problems.

It's a pain in the arse, but at least we know how to fix it, til the next time eh?

So many people have had these problems, I sincerley hope that the next update will prevent others from suffering what is by now a well known bug.

Good luck

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

9 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Import - Validating Data

While I am at it, wouldn't it be good to have a sticky post which collates all these error messages and points the way to the threads in which the solutions are to be found? That might save us the effort of having to answer the same questions over and over again.

In the interim, maybe a sticky which advises googling the exception message to find the relevant thread on here? That's what i do first whenever I get a problem and it usually works.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

10 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Import - Validating Data

Hi Tony
Have you tried using the bit of code I sent you yesterday before doing this? My hope is that this will fix the problem with adding or removing addins.

Note to others - instead of giving Tony instructions on how to fix it manually, I wrote a small app that will check the configuration of addins. It's only a "fledgling" but if the principle works I can make it available to all, and perhaps slowly expand it into something that can check various parts of the Recorder setup and auto-correct them if possible.

John van Breda
Biodiverse IT

johnvanbreda's Website

11 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Import - Validating Data

That sounds like a great idea John. Of course it would be even better if it could be incorporated into the Recorder workstation setup so we didn't get the problems in the first place. Hopefully one day.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

12 Reply by TonyP (edited by TonyP 16-07-2010 09:09:58)

  • TonyP
  • TonyP
  • Veteran
  • Offline
  • From: Somerset
  • Registered: 15-05-2006
  • Posts: 306

Re: Import - Validating Data

johnvanbreda wrote:

Hi Tony
Have you tried using the bit of code I sent you yesterday before doing this? My hope is that this will fix the problem with adding or removing addins..

Hi John yes I did I guess my email slipped up somewhere, I thought from your other post it had got to you.

The App fails to install, you suggested removing the R6 Std Validation addin but that fails too. It looks like I have to resolve the class string & class not registered errors before I can continue.

Thanks Rob by the way. I'm just trying to find the solution you mention but can't seem to find it. I found the thread where you mention having the same problem but not a solution. I'll keep looking.

I had a look at thread http://forums.nbn.org.uk/viewtopic.php?id=1348

Unfortunately on the machines I've check so far the registry items are missing. I wonder if anyone is able to post the .reg files with the exported keys?

I would like to retry your app John but as I say it I cannot fix the class not registered error I can't try it. The addin does not remove it's self from the other machine I've tried either.
John do you think if I can resolve the class not registered error it will be good to retry your app? It would be nice to think that something good comes out of this.

Sadly I had a blue screen this morning with a video driver problem [MS updates] so I can't even run my machine while the driver is being replace remotely.

Data Manger
Somerset Environmental Records Centre

TonyP's Website

13 Reply by TonyP

  • TonyP
  • TonyP
  • Veteran
  • Offline
  • From: Somerset
  • Registered: 15-05-2006
  • Posts: 306

Re: Import - Validating Data

Thanks to both John & Rob now and from the past threads. I have made some progress.

I deleted the addins sub folders in the registry and rebooted. I then dropped [Recorder\]RecorderAddInInstaller.dll onto c:\windows\system32\regsvr32.exe

It reported successfully registering the dll. I ran R6 and Tools\Addins\Install [Recorder\Addins] StdValLib.dll

All appers ok. I then ran Johns new tool [sorry I don't know if this is still a real test John] and get this report;

Recorder 6 System Check Report

OK - Recorder installation detected

OK - Checking addin StdValLib.Recorder 6 Standard Validation
OK - This addin is correctly installed.

OK - The Standard Validation Library is installed
OK - The Recorder addin installer is correctly installed.

OK - The Recorder 6 system check passed

As soon as I can get back on my machine [where the import data is] I can try this out there too and see if I can import.

I'll let you know.

Data Manger
Somerset Environmental Records Centre

TonyP's Website

14 Reply by TonyP

  • TonyP
  • TonyP
  • Veteran
  • Offline
  • From: Somerset
  • Registered: 15-05-2006
  • Posts: 306

Re: Import - Validating Data

Hurrah, well actually no.

Back on my own machine I edited the registry reinstated the dll and added the validation add-in. I ran Johns check too with same results as before. Hurrah

Then I tried importing data - Invalid Class String.

date/time         : 2010-07-16, 13:24:15, 435ms
computer name     : SERC-TONY
user name         : tony.price
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 13 minutes 19 seconds
program up time   : 7 minutes 53 seconds
processors        : 2x AMD Athlon(tm) 7750 Dual-Core Processor
physical memory   : 1191/1919 MB (free/total)
free disk space   : (C:) 175.18 GB (U:) 36.14 GB
display mode      : 1280x1024, 32 bit
process id        : $fa4
allocated memory  : 32.19 MB
command line      : RecorderApp.exe /132158
executable        : RecorderApp.exe
exec. date/time   : 2009-11-23 09:25
version           : 6.14.5.218
madExcept version : 2.7h
exception class   : EOleException
exception message : Invalid class string.

main thread ($fac):
0097b659 RecorderApp.exe 
7e42a993 user32.dll       CallWindowProcA
7c90eb94 ntdll.dll        RtlAnsiStringToUnicodeString
7e4292de user32.dll       SendMessageW
7e42a993 user32.dll       CallWindowProcA
7e4196c2 user32.dll       DispatchMessageA

modules:
00350000 C4DLL.DLL                  1.0.0.1          U:
003c0000 MS5User.Dll                5.0.0.4          U:
00400000 RecorderApp.exe            6.14.5.218       U:
013c0000 ms5cnv.dll                 5.0.0.10         U:
01b50000 odbcint.dll                3.525.1132.0     C:\WINDOWS\system32
029a0000 xpsp2res.dll               5.1.2600.5512    C:\WINDOWS\system32
038e0000 SQLOLEDB.RLL               2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
038f0000 msadcer.dll                2.81.1132.0      C:\Program Files\Common Files\System\msadc
03b70000 RecorderAddInInstaller.dll                  U:
04130000 Normaliz.dll               6.0.5441.0       C:\WINDOWS\system32
046e0000 StdValLib.dll              6.14.3.208       U:\Addins
07160000 Audiodev.dll               5.2.5721.5145    C:\WINDOWS\system32
0f9a0000 VBAJET32.DLL               6.0.1.9432       C:\WINDOWS\system32
0f9c0000 expsrv.dll                 6.0.72.9590      C:\WINDOWS\system32
10000000 MS5.Dll                    5.0.0.12         U:
10930000 PortableDeviceApi.dll      5.2.5721.5145    C:\WINDOWS\system32
11c70000 WMASF.DLL                  11.0.5721.5238   C:\WINDOWS\system32
15110000 WMVCore.DLL                11.0.5721.5275   C:\WINDOWS\system32
16080000 mdnsNSP.dll                1.0.3.1          C:\Program Files\Bonjour
16210000 wpdshext.dll               5.2.5721.5145    C:\WINDOWS\system32
1b000000 msjet40.dll                4.0.9511.0       C:\WINDOWS\system32
1b2c0000 msjter40.dll               4.0.9502.0       C:\WINDOWS\system32
1b2d0000 MSJINT40.DLL               4.0.9502.0       C:\WINDOWS\system32
1b570000 msjetoledb40.dll           4.0.9502.0       C:\WINDOWS\system32
1b5d0000 mswstr10.dll               4.0.9502.0       C:\WINDOWS\system32
1b800000 msjtes40.dll               4.0.9502.0       C:\WINDOWS\system32
20000000 xpsp3res.dll               5.1.2600.5512    C:\WINDOWS\system32
3d930000 WININET.dll                8.0.6001.18923   C:\WINDOWS\system32
3dfd0000 iertutil.dll               8.0.6001.18923   C:\WINDOWS\system32
4ca30000 msadrh15.dll               2.81.1132.0      C:\Program Files\Common Files\System\ado
4d650000 msadox.dll                 2.81.1132.0      C:\Program Files\Common Files\System\ado
4dd00000 sqloledb.dll               2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
4de10000 msado15.dll                2.81.1132.0      C:\Program Files\Common Files\System\ado
4ec50000 gdiplus.dll                5.2.6001.22319   C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.6001.22319_x-ww_f0b4c2df
593f0000 wiashext.dll               5.1.2600.5512    C:\WINDOWS\system32
5ad70000 uxtheme.dll                6.0.2900.5512    C:\WINDOWS\system32
5b860000 NETAPI32.dll               5.1.2600.5694    C:\WINDOWS\system32
5d090000 comctl32.dll               5.82.2900.5512   C:\WINDOWS\system32
5edd0000 olepro32.dll               5.1.2600.5512    C:\WINDOWS\system32
605d0000 mslbui.dll                 5.1.2600.5512    C:\WINDOWS\system32
60e30000 MSDATL3.dll                2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
662b0000 hnetcfg.dll                5.1.2600.5512    C:\WINDOWS\system32
68000000 rsaenh.dll                 5.1.2600.5507    C:\WINDOWS\system32
68100000 dssenh.dll                 5.1.2600.5507    C:\WINDOWS\system32
69b10000 msxml4.dll                 4.20.9876.0      c:\WINDOWS\system32
6bd00000 SYNCOR11.DLL               0.1.2.3          C:\WINDOWS\system32
6d4f0000 DBNETLIB.DLL               2000.85.1132.0   C:\WINDOWS\system32
71a50000 mswsock.dll                5.1.2600.5625    C:\WINDOWS\system32
71a90000 wshtcpip.dll               5.1.2600.5512    C:\WINDOWS\System32
71aa0000 WS2HELP.dll                5.1.2600.5512    C:\WINDOWS\system32
71ab0000 WS2_32.dll                 5.1.2600.5512    C:\WINDOWS\system32
71ad0000 wsock32.dll                5.1.2600.5512    C:\WINDOWS\system32
71b20000 mpr.dll                    5.1.2600.5512    C:\WINDOWS\system32
71bf0000 SAMLIB.dll                 5.1.2600.5512    C:\WINDOWS\System32
71c10000 ntlanman.dll               5.1.2600.5512    C:\WINDOWS\System32
71c80000 NETRAP.dll                 5.1.2600.5512    C:\WINDOWS\System32
71c90000 NETUI1.dll                 5.1.2600.5512    C:\WINDOWS\System32
71cd0000 NETUI0.dll                 5.1.2600.5512    C:\WINDOWS\System32
71f80000 security.dll               5.1.2600.5512    C:\WINDOWS\system32
73000000 winspool.drv               5.1.2600.5512    C:\WINDOWS\system32
73160000 oledb32.dll                2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
73ba0000 sti.dll                    5.1.2600.5512    C:\WINDOWS\system32
74060000 msadce.dll                 2.81.3002.0      C:\Program Files\Common Files\System\msadc
74320000 odbc32.dll                 3.525.1132.0     C:\WINDOWS\system32
74720000 MSCTF.dll                  5.1.2600.5512    C:\WINDOWS\system32
74ae0000 CFGMGR32.dll               5.1.2600.5512    C:\WINDOWS\system32
750b0000 RESUTILS.DLL               5.1.2600.5512    C:\WINDOWS\system32
750f0000 MTXCLU.DLL                 2001.12.4414.706 C:\WINDOWS\system32
75130000 colbact.DLL                2001.12.4414.700 C:\WINDOWS\system32
75350000 OLEDB32R.DLL               2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
754d0000 CRYPTUI.dll                5.131.2600.5512  C:\WINDOWS\system32
755c0000 msctfime.ime               5.1.2600.5512    C:\WINDOWS\system32
75f60000 drprov.dll                 5.1.2600.5512    C:\WINDOWS\System32
75f70000 davclnt.dll                5.1.2600.5512    C:\WINDOWS\System32
75f80000 browseui.dll               6.0.2900.5512    C:\WINDOWS\system32
76390000 IMM32.DLL                  5.1.2600.5512    C:\WINDOWS\system32
763b0000 comdlg32.dll               6.0.2900.5512    C:\WINDOWS\system32
765b0000 MSDART.DLL                 2.81.1132.0      C:\WINDOWS\system32
76600000 CSCDLL.dll                 5.1.2600.5512    C:\WINDOWS\System32
76620000 comsvcs.dll                2001.12.4414.702 C:\WINDOWS\system32
76780000 SHFolder.dll               6.0.2900.5512    C:\WINDOWS\system32
76790000 cryptdll.dll               5.1.2600.5512    C:\WINDOWS\system32
767a0000 ntdsapi.dll                5.1.2600.5512    C:\WINDOWS\system32
767f0000 schannel.dll               5.1.2600.5834    C:\WINDOWS\system32
76990000 ntshrui.dll                5.1.2600.5512    C:\WINDOWS\system32
769c0000 USERENV.dll                5.1.2600.5512    C:\WINDOWS\system32
76b20000 ATL.DLL                    3.5.2284.2       C:\WINDOWS\system32
76b40000 winmm.dll                  5.1.2600.5512    C:\WINDOWS\system32
76c30000 WINTRUST.dll               5.131.2600.5922  C:\WINDOWS\system32
76c90000 IMAGEHLP.dll               5.1.2600.5512    C:\WINDOWS\system32
76d10000 CLUSAPI.DLL                5.1.2600.5512    C:\WINDOWS\system32
76d60000 iphlpapi.dll               5.1.2600.5512    C:\WINDOWS\system32
76f20000 DNSAPI.dll                 5.1.2600.5625    C:\WINDOWS\system32
76f60000 WLDAP32.dll                5.1.2600.5512    C:\WINDOWS\system32
76fb0000 winrnr.dll                 5.1.2600.5512    C:\WINDOWS\System32
76fc0000 rasadhlp.dll               5.1.2600.5512    C:\WINDOWS\system32
76fd0000 CLBCATQ.DLL                2001.12.4414.700 C:\WINDOWS\system32
77050000 COMRes.dll                 2001.12.4414.700 C:\WINDOWS\system32
77120000 oleaut32.dll               5.1.2600.5512    C:\WINDOWS\system32
773d0000 comctl32.dll               6.0.2900.5512    C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.5512_x-ww_35d4ce83
774e0000 ole32.dll                  5.1.2600.5512    C:\WINDOWS\system32
77920000 SETUPAPI.dll               5.1.2600.5512    C:\WINDOWS\system32
77a20000 cscui.dll                  5.1.2600.5512    C:\WINDOWS\System32
77a80000 crypt32.dll                5.131.2600.5512  C:\WINDOWS\system32
77b20000 MSASN1.dll                 5.1.2600.5875    C:\WINDOWS\system32
77b40000 apphelp.dll                5.1.2600.5512    C:\WINDOWS\system32
77c00000 version.dll                5.1.2600.5512    C:\WINDOWS\system32
77c10000 msvcrt.dll                 7.0.2600.5512    C:\WINDOWS\system32
77c70000 msv1_0.dll                 5.1.2600.5876    C:\WINDOWS\system32
77dd0000 advapi32.dll               5.1.2600.5755    C:\WINDOWS\system32
77e70000 RPCRT4.dll                 5.1.2600.5795    C:\WINDOWS\system32
77f10000 GDI32.dll                  5.1.2600.5698    C:\WINDOWS\system32
77f60000 SHLWAPI.dll                6.0.2900.5912    C:\WINDOWS\system32
77fe0000 Secur32.dll                5.1.2600.5834    C:\WINDOWS\system32
78130000 urlmon.dll                 8.0.6001.18923   C:\WINDOWS\system32
7c800000 kernel32.dll               5.1.2600.5781    C:\WINDOWS\system32
7c900000 ntdll.dll                  5.1.2600.5755    C:\WINDOWS\system32
7c9c0000 shell32.dll                6.0.2900.5622    C:\WINDOWS\system32
7e290000 shdocvw.dll                6.0.2900.5512    C:\WINDOWS\system32
7e410000 user32.dll                 5.1.2600.5512    C:\WINDOWS\system32
7e4b0000 HHCtrl.ocx                 5.2.3790.4110    C:\WINDOWS\system32
7e720000 SXS.DLL                    5.1.2600.5512    C:\WINDOWS\system32

Data Manger
Somerset Environmental Records Centre

TonyP's Website

15 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Import - Validating Data

Hi Tony
That's disappointing, I'd hoped the tool would detect this sort of problem but it obviously needs more work. I wouldn't normally recommend it, but have you tried importing the data without the Standard  Validation Library addin installed? You can always skip the actual import step to avoid importing invalid records, but it would be interesting to prove that the problem relates to starting the validation addin.
Best Wishes

John van Breda
Biodiverse IT

johnvanbreda's Website

16 Reply by TonyP

  • TonyP
  • TonyP
  • Veteran
  • Offline
  • From: Somerset
  • Registered: 15-05-2006
  • Posts: 306

Re: Import - Validating Data

Hi John, having removed the STD validation library and tried again. I can confirm that it all appears to work up to that point without the validation process.

I hope that is helpful.

Data Manger
Somerset Environmental Records Centre

TonyP's Website