1

Topic: Environment Agency Data Template

Hi
I've been looking at this and trying to work out what R6 fields best match to Marina's new EA template fields. There are few awkward bits, such as location and location name appearing to need to be concatenated into one field  to ensure the location description is adequately filled. I imagine there is some code somewhere within an existing XML report that would do this, but if it would obviously need altering to provide the rest of the information Marina requires.

Also is there a way to pull out start and end date without going through the back end or SQL Server Management Studio. I found a couple examples on her relating to SD/ED but they were very specific and I couldn't see how to use them for this.

We don't presently have the XML knowledge to create our own bespoke report for this so I can see I am probably going to have to muddle through using my limited Access skills, but if anyone else does create a suitable report and is willing to share it with other LERCs I'd for one be really grateful.

Thank
Purgle

Purgle Linham
Wiltshire & Swindon Biological Records Centre

2

Re: Environment Agency Data Template

Hi

Doesn't sound like it would be too difficult to add these to the report wizard.  Can you clarify the format of the Location/Location Name field  and is the start end date two output field or just one - also date format required.

Mike Weideli
Littlefield Consultancy - IT Consultants

3 (edited by Purgle Linham 30-01-2017 11:14:14)

Re: Environment Agency Data Template

Hi
I've attached Marina's template for your info.

I think I would match the following fields in case that helps:

COMMON_NAME    = Recommended Common Name or Group
SCIENTIFIC_NAME    = Recommended Taxon Name
SURVEY_OBSERVATION    = Obs Abundances (LC)
LOCATION_DESCRIPTION    = Sample Location & Sample Location Name
SURVEY_START    = Sample Start Date
SURVEY_END    = Sample Start Date
SURVEY_TYPE    = Record Type
FILE_CODE    = Obs Key
RECORDER    = Observer [or other term if not providing recorder names]
SOURCE    = Survey
GRIDREF _SUPPLIED  = Sample Spatial Reference

The rest I would add afterwards as they will be '0', 'no information' or LERC Name.

Thanks

Purgle

Post's attachments

TEMPLATE_SPECIES_for suppliers v1_20170119.xls 40.5 kb, 1 downloads since 2017-01-30 

You don't have the permssions to download the attachments of this post.
Purgle Linham
Wiltshire & Swindon Biological Records Centre

4

Re: Environment Agency Data Template

The attached script should add thee new entries into the report wizard under Sample- Sample Date Start, Sample Date End and Sample Location Info. The latter will merge the Sample Location and Location Name together separated by a full stop and space. If the Location and Location name are the same then only one will be included.

Post's attachments

000000B0.zip 1.33 kb, 17 downloads since 2017-01-30 

You don't have the permssions to download the attachments of this post.
Mike Weideli
Littlefield Consultancy - IT Consultants

5

Re: Environment Agency Data Template

Thanks very much Mike. Sorry to be an idiot but where do I put the SQL script? Do I run it using SQL Server Management Studio, and if so where do I put it to run it? I've had a look for instructions on this but can't find any that explain the how.

Thanks

Purgle Linham
Wiltshire & Swindon Biological Records Centre

6

Re: Environment Agency Data Template

Run in Mangement Studio, Unzip and paste into a new query (against NBNdata)

Mike Weideli
Littlefield Consultancy - IT Consultants

7

Re: Environment Agency Data Template

Mike

I just tested the Location extract  - it worked for a small test but then came up with the following error message when run against another larger selection.

MARK

date/time         : 2017-01-30, 16:21:04, 307ms
computer name     : SERVER2013
user name         : Manager
registered owner  : Manager
operating system  : Windows 7 x64 Service Pack 1 build 7601
system language   : English
system up time    : 7 hours 35 minutes
program up time   : 6 minutes 48 seconds
processors        : 4x Intel(R) Core(TM) i5-4570 CPU @ 3.20GHz
physical memory   : 3446/8131 MB (free/total)
free disk space   : (C:) 5.27 GB
display mode      : 1920x1080, 32 bit
process id        : $e58
allocated memory  : 66.52 MB
command line      : RecorderApp.exe /331794
executable        : RecorderApp.exe
exec. date/time   : 2017-01-01 21:46
version           : 6.26.1.285
compiled with     : Delphi 7
madExcept version : 3.0n
callstack crc     : $5b5c45c7, $f390d320, $f390d320
exception number  : 4
exception class   : EOleException
exception message : Invalid length parameter passed to the RIGHT function.

main thread ($d40):
0059bcf2 RecorderApp.exe ADODB                    TADOCommand.Execute
0059bc4c RecorderApp.exe ADODB                    TADOCommand.Execute
0059bc2c RecorderApp.exe ADODB                    TADOCommand.Execute
0090fc31 RecorderApp.exe ReportGenerator 1107 +16 TReportGenerator.ExecuteSQL
0090fa27 RecorderApp.exe ReportGenerator 1064 +31 TReportGenerator.PopulateAttributes
0090b6ea RecorderApp.exe ReportGenerator  357  +7 TReportGenerator.PrepareData
0091123c RecorderApp.exe WizardData       422  +3 TdmWizard.PrepareOutput
00928626 RecorderApp.exe FilterResult     662 +19 TfrmFilterResult.UpdateResults
00928202 RecorderApp.exe FilterResult     572 +16 TfrmFilterResult.RunWizard
0092814f RecorderApp.exe FilterResult     550  +1 TfrmFilterResult.WMRunWizard
004dd148 RecorderApp.exe Controls                 TControl.WndProc
004e01a7 RecorderApp.exe Controls                 TWinControl.WndProc
004f7c75 RecorderApp.exe Forms                    TCustomForm.WndProc
004dfe24 RecorderApp.exe Controls                 TWinControl.MainWndProc
00430c3c RecorderApp.exe Classes                  StdWndProc
761c7bc5 user32.dll                               DispatchMessageA
004fe313 RecorderApp.exe Forms                    TApplication.ProcessMessage
004fe34a RecorderApp.exe Forms                    TApplication.HandleMessage
004fe57a RecorderApp.exe Forms                    TApplication.Run
00a9f0ee RecorderApp.exe RecorderApp      416 +79 initialization
76833368 kernel32.dll                             BaseThreadInitThunk

thread $18f8:
77180166 ntdll.dll                 NtWaitForMultipleObjects
76031714 KERNELBASE.dll            WaitForMultipleObjectsEx
768319f7 kernel32.dll              WaitForMultipleObjectsEx
761d087c user32.dll                MsgWaitForMultipleObjectsEx
761d0b7c user32.dll                MsgWaitForMultipleObjects
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
76833368 kernel32.dll              BaseThreadInitThunk
>> created by main thread ($d40) at:
76833490 kernel32.dll              CreateThread

thread $7b0:
77180166 ntdll.dll     NtWaitForMultipleObjects
76833368 kernel32.dll  BaseThreadInitThunk

thread $1e20:
77180166 ntdll.dll                 NtWaitForMultipleObjects
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
76833368 kernel32.dll              BaseThreadInitThunk
>> created by main thread ($d40) at:
76833490 kernel32.dll              CreateThread

thread $1e7c:
7717f8da ntdll.dll                 NtWaitForSingleObject
760315c8 KERNELBASE.dll            WaitForSingleObjectEx
7683118f kernel32.dll              WaitForSingleObjectEx
76831143 kernel32.dll              WaitForSingleObject
00476bed RecorderApp.exe madExcept CallThreadProcSafe
00476c57 RecorderApp.exe madExcept ThreadExceptFrame
76833368 kernel32.dll              BaseThreadInitThunk
>> created by main thread ($d40) at:
76833490 kernel32.dll              CreateThread

thread $1ea0:
77181f4f ntdll.dll     NtWaitForWorkViaWorkerFactory
76833368 kernel32.dll  BaseThreadInitThunk

thread $1d4:
77181f4f ntdll.dll     NtWaitForWorkViaWorkerFactory
76833368 kernel32.dll  BaseThreadInitThunk

modules:
00230000 C4DLL.DLL            1.0.0.1            \\SERVER2013\Recorder 6 Server
002a0000 MS5User.Dll          5.0.0.4            \\SERVER2013\Recorder 6 Server
00390000 ms5cnv.dll           5.0.0.10           \\SERVER2013\Recorder 6 Server
00400000 RecorderApp.exe      6.26.1.285         \\SERVER2013\Recorder 6 Server
05770000 BulkLoad.ocx         6.0.0.10           \\SERVER2013\Recorder 6 Server\Addins
06690000 GOTOGR~1.OCX         2.0.0.16           \\SERVER2013\Recorder 6 Server\Addins
06990000 GotoKey2.dll                            \\SERVER2013\Recorder 6 Server\Addins
07900000 LASTKE~1.OCX         6.0.0.6            \\SERVER2013\Recorder 6 Server\Addins
086a0000 MANAGE~1.OCX                            \\SERVER2013\Recorder 6 Server\Addins
08870000 NBNEXC~1.DLL                            \\SERVER2013\Recorder 6 Server\Addins
09d30000 OBSADD~1.OCX                            \\SERVER2013\Recorder 6 Server\Addins
09ef0000 PHENOL~2.OCX         6.17.2.252         \\SERVER2013\Recorder 6 Server\Addins
0a0f0000 PROJEC~2.OCX                            \\SERVER2013\Recorder 6 Server\Addins
0a2c0000 PROJEC~3.OCX                            \\SERVER2013\Recorder 6 Server\Addins
0a490000 PROJEC~1.OCX                            \\SERVER2013\Recorder 6 Server\Addins
0a650000 SHOWUN~1.OCX         6.0.0.13           \\SERVER2013\Recorder 6 Server\Addins
0a860000 STDVAL~1.DLL         6.15.1.230         \\SERVER2013\Recorder 6 Server\Addins
0aa40000 SURVEY~1.OCX         6.0.0.25           \\SERVER2013\Recorder 6 Server\Addins
10000000 MS5.Dll              5.0.0.12           \\SERVER2013\Recorder 6 Server
5b070000 msadce.dll           6.1.7601.17514     C:\Program Files (x86)\Common Files\System\msadc
5b100000 comsvcs.dll          2001.12.8531.19062 C:\Windows\system32
5b670000 sqloledb.dll         6.1.7601.17514     C:\Program Files (x86)\Common Files\System\Ole DB
5b760000 oledb32.dll          6.1.7601.17514     C:\Program Files (x86)\Common Files\System\Ole DB
5b8e0000 schannel.dll         6.1.7601.23642     C:\Windows\SysWOW64
5bf20000 msado15.dll          6.1.7601.17857     C:\Program Files (x86)\Common Files\System\ado
5c090000 ATL.DLL              3.5.2284.0         C:\Windows\system32
5fd00000 msv1_0.DLL           6.1.7601.23642     C:\Windows\SysWOW64
615f0000 DBNETLIB.DLL         6.1.7600.16385     C:\Windows\system32
61620000 HHCtrl.ocx           6.1.7600.16385     C:\Windows\system32
616b0000 msadcer.dll          6.1.7600.16385     C:\Program Files (x86)\Common Files\System\msadc
616c0000 SQLOLEDB.RLL         6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
616d0000 netbios.dll          6.1.7600.16385     C:\Windows\system32
616e0000 MSDATL3.dll          6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
61700000 OLEDB32R.DLL         6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
61720000 MSDART.DLL           6.1.7600.16385     C:\Windows\system32
64500000 gdiplus.dll          6.1.7601.23545     C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.7601.23545_none_5c06d189a00e2c29
69290000 ntdsapi.dll          6.1.7600.16385     C:\Windows\system32
69b10000 msxml4.dll           4.20.9876.0        C:\Windows\SysWOW64
6cb20000 security.dll         6.1.7600.16385     C:\Windows\system32
6cb80000 comctl32.dll         5.82.7601.18837    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.18837_none_ec86b8d6858ec0bc
6d010000 srvcli.dll           6.1.7601.17514     C:\Windows\system32
6d030000 NETAPI32.dll         6.1.7601.17887     C:\Windows\system32
6d060000 cryptdll.dll         6.1.7600.16385     C:\Windows\system32
6d0f0000 uxtheme.dll          6.1.7600.16385     C:\Windows\system32
6d190000 bcryptprimitives.dll 6.1.7601.23451     C:\Windows\SysWOW64
6d1d0000 SXS.DLL              6.1.7601.17514     C:\Windows\system32
6d6d0000 SHFolder.dll         6.1.7600.16385     C:\Windows\system32
6e510000 winspool.drv         6.1.7601.17514     C:\Windows\system32
6e650000 fwpuclnt.dll         6.1.7601.18283     C:\Windows\System32
6e690000 rasadhlp.dll         6.1.7600.16385     C:\Windows\system32
6e7c0000 WLIDNSP.DLL          7.250.4311.0       C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live
6e810000 DNSAPI.dll           6.1.7601.17570     C:\Windows\system32
6e890000 wship6.dll           6.1.7600.16385     C:\Windows\System32
6e8a0000 wshtcpip.dll         6.1.7600.16385     C:\Windows\System32
6e8b0000 mswsock.dll          6.1.7601.23451     C:\Windows\system32
70010000 credssp.dll          6.1.7601.23642     C:\Windows\system32
713d0000 netutils.dll         6.1.7601.17514     C:\Windows\system32
713e0000 wkscli.dll           6.1.7601.17514     C:\Windows\system32
728c0000 bcrypt.dll           6.1.7601.23642     C:\Windows\system32
728e0000 ncrypt.dll           6.1.7601.23642     C:\Windows\system32
72920000 dwmapi.dll           6.1.7601.18917     C:\Windows\system32
72bc0000 SECUR32.DLL          6.1.7601.23642     C:\Windows\system32
72bd0000 WINNSI.DLL           6.1.7600.16385     C:\Windows\system32
72be0000 IPHLPAPI.DLL         6.1.7601.17514     C:\Windows\system32
72c10000 winmm.dll            6.1.7601.17514     C:\Windows\system32
72d40000 RpcRtRemote.dll      6.1.7601.17514     C:\Windows\system32
72d50000 rsaenh.dll           6.1.7600.16385     C:\Windows\system32
72d90000 CRYPTSP.dll          6.1.7601.23471     C:\Windows\system32
72db0000 odbcint.dll          6.1.7600.16385     C:\Windows\system32
72df0000 odbc32.dll           6.1.7601.17514     C:\Windows\system32
72fa0000 olepro32.dll         6.1.7601.23452     C:\Windows\system32
72fd0000 Comctl32.dll         6.10.7601.18837    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7601.18837_none_41e855142bd5705d
73170000 version.dll          6.1.7600.16385     C:\Windows\system32
73860000 wsock32.dll          6.1.7600.16385     C:\Windows\system32
747b0000 mpr.dll              6.1.7600.16385     C:\Windows\system32
74a40000 CRYPTBASE.dll        6.1.7601.23642     C:\Windows\syswow64
74a50000 SspiCli.dll          6.1.7601.23642     C:\Windows\syswow64
74b40000 MSCTF.dll            6.1.7601.23572     C:\Windows\syswow64
74c20000 GDI32.dll            6.1.7601.23591     C:\Windows\syswow64
74cb0000 MSASN1.dll           6.1.7601.17514     C:\Windows\syswow64
74cc0000 IMM32.DLL            6.1.7601.17514     C:\Windows\system32
74f90000 sechost.dll          6.1.7601.18869     C:\Windows\SysWOW64
74fb0000 CRYPT32.dll          6.1.7601.23566     C:\Windows\syswow64
750e0000 shell32.dll          6.1.7601.23537     C:\Windows\syswow64
75d30000 ADVAPI32.dll         6.1.7601.23572     C:\Windows\syswow64
76020000 KERNELBASE.dll       6.1.7601.23572     C:\Windows\syswow64
76080000 SHLWAPI.dll          6.1.7601.17514     C:\Windows\syswow64
760e0000 WINTRUST.dll         6.1.7601.23566     C:\Windows\syswow64
761b0000 user32.dll           6.1.7601.23594     C:\Windows\syswow64
762b0000 LPK.dll              6.1.7601.23587     C:\Windows\syswow64
762c0000 ole32.dll            6.1.7601.23392     C:\Windows\syswow64
76570000 oleaut32.dll         6.1.7601.23569     C:\Windows\syswow64
76610000 CLBCatQ.DLL          2001.12.8530.16385 C:\Windows\syswow64
766a0000 comdlg32.dll         6.1.7601.17514     C:\Windows\syswow64
76720000 msvcrt.dll           7.0.7601.17744     C:\Windows\syswow64
767d0000 NSI.dll              6.1.7600.16385     C:\Windows\syswow64
76820000 kernel32.dll         6.1.7601.23572     C:\Windows\syswow64
76b50000 WS2_32.dll           6.1.7601.23451     C:\Windows\syswow64
76b90000 PSAPI.DLL            6.1.7600.16385     C:\Windows\syswow64
76bb0000 RPCRT4.dll           6.1.7601.23642     C:\Windows\syswow64
76ca0000 USP10.dll            1.626.7601.23585   C:\Windows\syswow64
77160000 ntdll.dll            6.1.7601.23572     C:\Windows\SysWOW64

processes:
0000 Idle                     0 0    0
0004 System                   0 0    0
013c smss.exe                 0 0    0
01e4 csrss.exe                0 0    0
0238 csrss.exe                1 0    0
0240 wininit.exe              0 0    0
0270 winlogon.exe             1 0    0
02a4 services.exe             0 0    0
02ac lsass.exe                0 0    0
02b4 lsm.exe                  0 0    0
0318 svchost.exe              0 0    0
0368 svchost.exe              0 0    0
03c4 MsMpEng.exe              0 0    0
009c atiesrxx.exe             0 0    0
00dc svchost.exe              0 0    0
021c svchost.exe              0 0    0
023c svchost.exe              0 0    0
0294 svchost.exe              0 0    0
044c svchost.exe              0 0    0
04e4 svchost.exe              0 0    0
0558 atieclxx.exe             1 0    0
05cc spoolsv.exe              0 0    0
061c svchost.exe              0 0    0
06a4 armsvc.exe               0 0    0
06dc atkexComSvc.exe          0 0    0
0704 cbVSCService11.exe       0 0    0
0770 remoting_host.exe        0 0    0
0798 DbxSvc.exe               0 0    0
07c8 svchost.exe              0 0    0
0594 remoting_host.exe        0 0    0
0664 HPBDSService.exe         0 0    0
0654 HPLaserJetService.exe    0 0    0
0808 HeciServer.exe           0 0    0
0890 sqlservr.exe             0 0    0
08f4 svchost.exe              0 0    0
0914 svchost.exe              0 0    0
0954 sqlbrowser.exe           0 0    0
098c sqlwriter.exe            0 0    0
09e0 WLIDSVC.EXE              0 0    0
0b3c WLIDSVCM.EXE             0 0    0
0c30 svchost.exe              0 0    0
0c80 WUDFHost.exe             0 0    0
0dc0 NisSrv.exe               0 0    0
0f6c svchost.exe              0 0    0
0438 IAStorDataMgrSvc.exe     0 0    0
00e0 GoogleCrashHandler.exe   0 0    0
0dd0 GoogleCrashHandler64.exe 0 0    0
01d8 Jhi_service.exe          0 0    0
0e60 SearchIndexer.exe        0 0    0
0364 WmiPrvSE.exe             0 0    0
0ef0 taskhost.exe             1 16   17   normal
0e6c taskeng.exe              1 10   3    normal
0498 itype.exe                1 19   40   normal
0444 ipoint.exe               1 19   46   normal
0c20 dwm.exe                  1 22   2    high
02f8 explorer.exe             1 700  474  normal
1054 RtkNGUI64.exe            1 20   30   normal
107c msseces.exe              1 143  60   normal
10cc WrtMon.exe               1 16   12   normal C:\Windows\System32\spool\drivers\x64\3
10e4 Cobian.exe               1 24   11   normal C:\Program Files (x86)\Cobian Backup 11
10ec googledrivesync.exe      1 4    1    normal C:\Program Files (x86)\Google\Drive
1104 WrtProc.exe              1 16   13   normal C:\Windows\System32\spool\drivers\x64\3
118c iusb3mon.exe             1 18   7    normal C:\Program Files (x86)\Intel\Intel(R) USB 3.0 eXtensible Host Controller Driver\Application
11a8 HPStatusAlerts.exe       1 45   27   normal C:\Program Files (x86)\HP\StatusAlerts\bin
11c0 hpwuschd2.exe            1 9    4    normal C:\Program Files (x86)\HP\HP Software Update
11d0 MOM.exe                  1 9    11   normal
11e4 Dropbox.exe              1 55   68   normal C:\Program Files (x86)\Dropbox\Client
1204 jusched.exe              1 9    2    normal C:\Program Files (x86)\Common Files\Java\Java Update
120c cbInterface.exe          1 145  59   normal C:\Program Files (x86)\Cobian Backup 11
09f4 svchost.exe              0 0    0
13b4 googledrivesync.exe      1 80   60   normal C:\Program Files (x86)\Google\Drive
14a4 dllhost.exe              0 0    0
16a0 IAStorIcon.exe           1 33   15   normal C:\Program Files\Intel\Intel(R) Rapid Storage Technology
14ec CCC.exe                  1 47   40   normal
15f0 OUTLOOK.EXE              1 770  597  normal
0340 jucheck.exe              1 12   6    normal C:\Program Files (x86)\Common Files\Java\Java Update
18c4 chrome.exe               1 128  65   normal C:\Program Files (x86)\Google\Chrome\Application
1e40 chrome.exe               1 4    1    normal C:\Program Files (x86)\Google\Chrome\Application
1e98 chrome.exe               1 9    4    normal C:\Program Files (x86)\Google\Chrome\Application
1d48 chrome.exe               1 16   5    normal C:\Program Files (x86)\Google\Chrome\Application
1ce8 chrome.exe               1 4    1    idle   C:\Program Files (x86)\Google\Chrome\Application
1ad0 chrome.exe               1 4    1    normal C:\Program Files (x86)\Google\Chrome\Application
142c chrome.exe               1 4    1    normal C:\Program Files (x86)\Google\Chrome\Application
043c chrome.exe               1 4    1    normal C:\Program Files (x86)\Google\Chrome\Application
1b40 chrome.exe               1 4    1    normal C:\Program Files (x86)\Google\Chrome\Application
1dac chrome.exe               1 4    1    normal C:\Program Files (x86)\Google\Chrome\Application
126c chrome.exe               1 4    1    normal C:\Program Files (x86)\Google\Chrome\Application
1c04 chrome.exe               1 4    1    idle   C:\Program Files (x86)\Google\Chrome\Application
0cfc chrome.exe               1 4    1    normal C:\Program Files (x86)\Google\Chrome\Application
0334 chrome.exe               1 4    1    normal C:\Program Files (x86)\Google\Chrome\Application
1840 chrome.exe               1 4    1    normal C:\Program Files (x86)\Google\Chrome\Application
1530 chrome.exe               1 4    1    normal C:\Program Files (x86)\Google\Chrome\Application
1a30 chrome.exe               1 4    1    idle   C:\Program Files (x86)\Google\Chrome\Application
1f7c chrome.exe               1 4    1    normal C:\Program Files (x86)\Google\Chrome\Application
0f2c EXCEL.EXE                1 2030 1070 normal
1d50 chrome.exe               1 4    1    normal C:\Program Files (x86)\Google\Chrome\Application
0de0 chrome.exe               1 4    1    idle   C:\Program Files (x86)\Google\Chrome\Application
0e58 RecorderApp.exe          1 390  294  normal \\SERVER2013\Recorder 6 Server
0e70 audiodg.exe              0 0    0
1408 SearchProtocolHost.exe   0 0    0
1910 SearchFilterHost.exe     0 0    0

hardware:
+ Computer
  - ACPI x64-based PC
+ Disk drives
  - Intel Raid 1 Volume SCSI Disk Device
  - WD Elements 107C USB Device
+ Display adapters
  - AMD Radeon HD 6450 (driver 13.200.16.0)
  - LogMeIn Mirror Driver (driver 7.1.542.0)
+ DVD/CD-ROM drives
  - ATAPI iHAS124   E SCSI CdRom Device
+ Human Interface Devices
  - HID-compliant consumer control device
  - HID-compliant device
  - HID-compliant device
  - HID-compliant device
  - HID-compliant device
  - HID-compliant device
  - USB Input Device
  - USB Input Device
  - USB Input Device (Logitech Download Assistant) (driver 1.10.77.0)
+ Imaging devices
  - HP LJ400 M425 Scan (driver 11.1.1.1)
+ Keyboards
  - HID Keyboard Device
  - Standard PS/2 Keyboard
+ Mice and other pointing devices
  - HID-compliant mouse
+ Monitors
  - Generic Non-PnP Monitor
  - Generic PnP Monitor
+ Network adapters
  - Realtek PCIe GBE Family Controller (driver 7.67.1226.2012)
+ Ports (COM & LPT)
  - Communications Port (COM1)
+ Processors
  - Intel(R) Core(TM) i5-4570 CPU @ 3.20GHz
  - Intel(R) Core(TM) i5-4570 CPU @ 3.20GHz
  - Intel(R) Core(TM) i5-4570 CPU @ 3.20GHz
  - Intel(R) Core(TM) i5-4570 CPU @ 3.20GHz
+ Sound, video and game controllers
  - AMD High Definition Audio Device (driver 7.12.0.7716)
  - Realtek High Definition Audio (driver 6.0.1.6782)
+ Storage controllers
  - Intel(R) Desktop/Workstation/Server Express Chipset SATA RAID Controller (driver 12.8.0.1016)
+ System devices
  - 4th Gen Core processor DRAM Controller - 0C00 (driver 9.4.0.1008)
  - ACPI Fan
  - ACPI Fan
  - ACPI Fan
  - ACPI Fan
  - ACPI Fan
  - ACPI Fixed Feature Button
  - ACPI Power Button
  - ACPI Thermal Zone
  - ACPI Thermal Zone
  - AMDA00 Interface (driver 14.47.2.348)
  - Composite Bus Enumerator
  - Direct memory access controller
  - File as Volume Driver
  - High Definition Audio Controller
  - High Definition Audio Controller
  - High precision event timer
  - Intel(R) 8 Series/C220 Series PCI Express Root Port #1 - 8C10 (driver 9.4.0.1011)
  - Intel(R) 8 Series/C220 Series PCI Express Root Port #3 - 8C14 (driver 9.4.0.1011)
  - Intel(R) 8 Series/C220 Series SMBus Controller - 8C22 (driver 9.4.0.1011)
  - Intel(R) 82802 Firmware Hub Device
  - Intel(R) H87 LPC Controller - 8C4A (driver 9.4.0.1011)
  - Intel(R) Management Engine Interface
  - Microsoft ACPI-Compliant System
  - Microsoft System Management BIOS Driver
  - Microsoft Virtual Drive Enumerator Driver
  - Microsoft Windows Management Interface for ACPI
  - Motherboard resources
  - Motherboard resources
  - Motherboard resources
  - Motherboard resources
  - Motherboard resources
  - Numeric data processor
  - PCI bus (driver 2.5.0.19)
  - Plug and Play Software Device Enumerator
  - Programmable interrupt controller
  - Remote Desktop Device Redirector Bus
  - System board
  - System CMOS/real time clock
  - System timer
  - Terminal Server Keyboard Driver
  - Terminal Server Mouse Driver
  - UMBus Enumerator
  - UMBus Root Bus Enumerator
  - Volume Manager
  - Xeon(R) processor E3-1200 v3/4th Gen Core processor PCI Express x16 Controller - 0C01 (driver 9.4.0.1008)
+ Universal Serial Bus controllers
  - Generic USB Hub
  - Generic USB Hub
  - Intel(R) 8 Series/C220 Series USB Enhanced Host Controller #1 - 8C26 (driver 9.4.0.1011)
  - Intel(R) 8 Series/C220 Series USB Enhanced Host Controller #2 - 8C2D (driver 9.4.0.1011)
  - Intel(R) USB 3.0 eXtensible Host Controller (driver 2.5.0.19)
  - Intel(R) USB 3.0 Root Hub (driver 2.5.0.19)
  - USB Composite Device
  - USB Mass Storage Device
  - USB Root Hub
  - USB Root Hub
Mark Pollitt
SWSEIC (formerly DGERC)

8 (edited by Purgle Linham 30-01-2017 18:00:17)

Re: Environment Agency Data Template

That worked, thanks very much.

Edit:
It did on a small query but I get the same error message on a bigger one. The exception number is '1' though.

Purgle Linham
Wiltshire & Swindon Biological Records Centre

9

Re: Environment Agency Data Template

Hi
I didn't allow for situations  where both fields are  blank.  I have fixed this and changed the original download. Should work if you download and run this again.

Mike Weideli
Littlefield Consultancy - IT Consultants

10

Re: Environment Agency Data Template

That now works for a bigger batch. Thanks Mike.

Purgle Linham
Wiltshire & Swindon Biological Records Centre