Changes between Version 50 and Version 51 of BluePrint/Importer

Timestamp:

01/23/11 08:08:40 (15 years ago)

Author:

Pat Tressel

Comment:

--

BluePrint/Importer

@@ -202 +202 @@
   a multiple (1-N, N-N) relationship, that should be added to a collection of
   component records.
+
+==== Observed file formats and sample data: ====
+
+
+- Outer join has been observed "in the wild", e.g. the
+  [http://haiti.resource-finder.appspot.com/export?subject_type=hospital Google hospital data for Brazil]
+  has one level of join with a 1-1 valence, but adds a second level by using...
+
+- Lists in cells.
+
+- !OpenOffice spreadsheet export saves sheets in one spreadsheet to separate files.
+  OO spreadsheets were used to load Southern California hospital data into the
+  Humanity Road database, and these had separate files associated via UUID.
+  (The load was done by a script that did dal calls and constructed its own
+  org_site records. The secondary files were not linked OO sheets -- they just
+  had a column for the associated hospital's UUID.)
+
+- Need example of Excel exported CSV files.
+
+We should stop here and decide:
+
+==== Which of these formats do we expect to encounter and want to support? ====
+
+Besides the observed forms, please propose others that we want to support:
+
+- (Comments please!)
+
+==== Which should we implement in the initial version? ====
+
+Yes, we should keep an eye on the general case and make this easy to extend.
+Consider this to be prototyping (that may happen to have a specific use in mind).
+
+- (Pat:) Single file, outer join, allow lists in cells.
+
+- (Comments please!)
 
 === Specifying the file layout and schema mapping ===