airsalliance / airs-xml

Automatically exported from code.google.com/p/airs-xml
Creative Commons Zero v1.0 Universal
3 stars 2 forks source link

Require tAgency.RecordOwner #40

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
When importing multiple XML files from the same source, newly received agencies 
can be matched to previously imported agencies (and used to update the existing 
records) by matching on tAgency.Key values from the same data source. 

But there seems to be some variance in how the data source is specified.

Some AIRS XML instance documents use SourceEntity as a unique data source 
designation, while others use it to specify the software/vendor that produced 
the file. The latter tend to employ tAgency.RecordOwner to specify the data 
source (ie, one of that vendor's customers). Some files don't use 
tAgency.RecordOwner at all. 

Since the documentation for SourceEntity calls for a "description of data 
sources used in the dump" (which seems like more of a summary), it seems like 
tAgency.RecordOwner should be the definitive data source designation and should 
be required.

Original issue reported on code.google.com by sackri...@visionlink.org on 19 Dec 2011 at 3:52

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
Agree with the point of this, but perhaps we should discuss all possible fields 
or add a new one to clearly demarcate the source of each file.  Perhaps using 
ODBID would be more explicit?

Original comment by gglbwmn2...@gmail.com on 18 Jan 2012 at 5:48

GoogleCodeExporter commented 9 years ago
Voted for implementation, and in 3.1 release.  ODBID (originating database id) 
will keep sources unique.  RecordOwner:"This is a unique string indicating the 
organization that created and maintains this Agency record".  A record owner is 
an organization that may/may not be the same as the tAgency itself, so it 
doesn't buy us much uniqueness. 

Original comment by e...@ejahn.net on 18 Feb 2012 at 3:38

GoogleCodeExporter commented 9 years ago
added SourceID

Original comment by e...@ejahn.net on 23 Feb 2012 at 4:23