1

Topic: Data Sources

Hi all,

I've been asked by my superiors to start adding the original recorders' date source to every taxon occurrence I import into Recorder 6. So far, I've hit a dead end on how I can best achieve this. The Documents table would be ideal and is the correct format; however, I understand I would have to manually add all of the sources manually before I can match them during the Import Wizard, so this is a non-starter as I would be spending more time adding individual sources/documents than I would actually importing the data. Are there any other options in Recorder 6 I can look at please? How do others go about this?

Best wishes,

Les

Les Evans-Hill
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme

2

Re: Data Sources

The documents table is a no go for us because any more than a couple of hundred and the user interface grinds to halt when trying to browse through it.

I use a combination of "a survey for each data source" and use the external references on the sources tab to link to the actual data source on the file system (and I use the "display as" attribute to note down who it came from and when we got it). This has the advantage that I can just double click on something in the external sources and up pops the original data. It has the disadvantage that the "display as" attribute is just free text, so I can't easily bring up eg all data received from John Smith. Having 10,000 surveys can also cause some minor delays eg in the report wizard while it lists them all, but as long as you organise everything with tags, the observation hierachy is perfectly useable.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

3

Re: Data Sources

Hi Charlie,

Many thanks for this. I'll have a look to see if this approach will work to their expectations.

Les

Les Evans-Hill
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme

4

Re: Data Sources

Hi

The private tab on the Taxon Ocurrence can hold  a lot of  information about a record.

Mantis 658/690 – Adds a new table ‘Taxon_Private_Data’ and fully supports this as a new tab ‘Private’ tab on the Occurrences. This table replaces the Taxon_Occurrence_Ext_Ref table and existing external refs will be transferred to this table. Field lengths have been increased and additional fields added. 

Users can set up other types through the terms list. This facility is designed to meet a variety of user requirements to add additional information to Occurrences which will not be exported.  System Supplied support is provided for importing and reporting on external references. Other types of private data can be set up via the terms list and this alone will allow data entry. For importing and use in the import wizard additional table entries are required in the Import Wizard and Reporting tables. This can be done by users with the appropriate technical skills, by directly accessing the tables.   

Fields in the new table are for general use and have non-specific names.  It is suggested that users explain the meaning of terms for a specific type in the description.  The description field in the terms list will be displayed when a term list is chosen and will assist in consistency in making or adjusting entries.  The possible uses of the Private data table include the management of work in progress, for example looking into duplicates or investigating anomalies.

Mike Weideli

5

Re: Data Sources

Hi Mike,

Many thanks for your reply, I've finally managed to find some time to look into this.

You wrote, "For importing and use in the import wizard additional table entries are required in the Import Wizard and Reporting tables. This can be done by users with the appropriate technical skills, by directly accessing the tables."

I'd like to be able to import these data into the new ‘Taxon_Private_Data’ table, but I can't figure out what tables need additional entries or indeed what to enter. Do you, or anyone else for that matter, have any procedures to enable importing via the Import Wizard?

Les Evans-Hill
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme