Changes between Initial Version and Version 1 of ImportContent

Timestamp:

Feb 3, 2010, 12:53:52 PM (15 years ago)

Author:

fknauft

Comment:

--

ImportContent

@@ +1 @@
+back to  - [[https://it-dev.mpiwg-berlin.mpg.de/tracs/GIS/wiki/SystInst System Installation]]
+== Import of Content-Data into PostGis ==
+=== FrameMaker-Tables ===
+  * Export the table with FrameMaker to *.csv with "UTF-16"
+  * Open the *.csv in TextWrangler, save with "UTF-8"
+  * copy the following sql-Script to pgAdmin3 and run it there [[BR]]
+ or [[BR]]
+ save the script as <*.sql>, open the directory in a terminal and run it with:
+{{{
+  Developer/usr/local/pgsql/bin/psql -f <*.sql> -d <databasename>
+}}}
+
+ !! All the attributes will be of type "text" (for now), as in some datasets the dates 
+ are empty and PostgreSQL does not like this !! [[BR]]
+
+{{{
+-- Table: craftsmanlabels
+
+DROP TABLE craftsmanlabels;
+
+CREATE TABLE craftsmanlabels
+(
+  id SERIAL, 
+  "callno" text,
+  "object" text,
+  "kind" text,
+  "title" text,
+  "dynasty" text,
+  "reign period" text,
+  "production begin year" text,
+  "production end year" text,
+  "found place" text,
+  "found province" text,
+  "found date" text,
+  "production place" text,
+  "production place GIS id" text,
+  "accuracy of gis id" text,
+  "production institution" text,
+  "inscription chinese" text,
+  "inscription pinyin" text,
+  "inscription translation" text,
+  "position" text,
+  "remark" text,
+  "inscription type" text,
+  CONSTRAINT id PRIMARY KEY (id)
+)
+WITH (OIDS=FALSE);
+ALTER TABLE craftsmanlabels OWNER TO postgres;
+
+COPY craftsmanlabels(
+            "callno", "object", "kind", "title", "dynasty", "reign period", "production begin year", 
+            "production end year", "found place", "found province", "found date", 
+            "production place", "production place GIS id", "accuracy of gis id", 
+            "production institution", "inscription chinese", "inscription pinyin", 
+            "inscription translation", "position", "remark", "inscription type")
+    FROM '/Users/fknauft/Projekt/RawData/craftsmanlabels1.csv' WITH CSV 
+    FORCE NOT NULL "production begin year", "production end year", "found date";
+}}}
+
+==== Single Datasets via WebBrowser-based Entry-Mask ====
+[[http://culhis.mpiwg-berlin.mpg.de/doku.php/gis/craftman_labels_project:craftsman_label_project Craftsman labels]]