Changes between Version 12 and Version 13 of SpreadsheetImporter

Timestamp:

01/24/10 00:15:50 (15 years ago)

Author:

Fran Boon

Comment:

--

SpreadsheetImporter

@@ -14 +14 @@
  1. Get a spreadsheet of good Data together (e.g. using Google Docs)
  2. Save as CSV
- 3. Open in Open Office (MS Excel destroys data - do NOT use!)
- 4. Export copies of the tables you wish to import to in CSV format, e.g.:
+ 3. Export copies of the tables you wish to import to in CSV format, e.g.:
   * /gis/location.csv
   * /hms/hospital.csv
+ 4. Open in an Editor
+  * Text editor best if you can
+  * MS Excel destroys CSV files (MS-DOS mode export better)
+  * Google Docs destroys timestamps
+  * Open Office truncates Lats/Lons to 2 digits of precision
  5. Plan how you are going to deal with duplicates between these datasets.
   * e.g. copy exported data into Spreadsheet & then clear table: {{{db.module_resource.truncate()}}}