|
The technical forum of the NBN Trust for use by the Network. It includes discussions and announcements on the NBN Atlas, Recorder 6 and Indicia |
You are not logged in. Please login or register.
Forum → How Do I... & Other Questions → Exports and custodianship
I'm trying to work out why my exports are missing some records. Am I right in thinking that only records for which I have custody are included?
I can see the sense of this in stopping records being sent back to their source system, but it is also stopping them being sent on to other people who need them.
Janet
Custody doesn't effect exporting. Records can't be confidential, they have to be checked and the verified indicator on Taxon Occurrencer must not be 1. In some systems the verified indicator has got out of step with the Determination type. If this is the problem then the following query will bring them back into line.
UPDATE taxon_occurrence set verified = DT.verified
from Taxon_Occurrence TOCC
INNER JOIN Taxon_Determination TDET
ON TDET.Taxon_Occurrence_key = TOCC.Taxon_Occurrence_Key and TDET.Preferred = 1
INNER JOIN Determination_Type DT
ON DT.Determination_Type_key = TDET.Determination_Type_Key
Confidential observations can be exported if you tick the box on the General tab for Tools - Options but observations for user added taxa aren't exported.
Thanks to Mike and Sally for your help with this.
It turns out that (like my other posting on survey tags) this problem is also to do with transfer of custody. The survey I was trying to export includes records input on two systems, and so with two custodians. I wanted to export them all together, transferring my input to the same custody as the rest of the records, but with transfer selected the export only picked up the records in my custody. The workaround is to run the export twice, first to transfer custody on those records that need it and then again to do the export for real.
The export with transfer of custody is still very slow.
Janet
Forum → How Do I... & Other Questions → Exports and custodianship
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.