Re: Data exchange with another Recorder user
We are working towards exchanging data with another user of Recorder 6. The data exchange will mostly be one-way (we will be receiving their data, but they don't need ours.)
We are expecting there to be a large amount of overlap in the lists of recorders and I am rather concerned that this will lead to a lot of work, merging individuals when the data reaches our system (in many cases it will be clear that the individual on our system is the same as on theirs, but not always). Obviously it is not enough to do it just on our system as subsequent data exchanges will simply reintroduce the duplication. So I am looking for a way that we can harmonise our INDIVIDUAL (and ORGANISATION and NAME tables with theirs.
I was just wondering if anyone else had tackled this problem before and come up with a protocol?
Would it be possible, after import of the original dataset to resolve duplicated recorders (in so far as this is possible) and then re-export all the records to their system, so that the names on their system are replaced by ours?
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre