Changes between Version 12 and Version 13 of SpreadsheetImporter


Ignore:
Timestamp:
01/24/10 00:15:50 (12 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • SpreadsheetImporter

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