For a table in Lotus Approach, use exported CSV to import into postgres table

zipperer / migrate_database_with_michael

0 stars 0 forks source link

For a table in Lotus Approach, use exported CSV to import into postgres table #14

Closed zipperer closed 8 months ago

zipperer commented 10 months ago

Execute commands from postgres_script.txt

== for a table in Lotus Approach export CSV ==

== import rows from CSV into table in postgres ==
psql> \copy target_table(column1, ..., columnN) FROM '/file_exported_from_lotus_approach.csv' WITH (FORMAT CSV, DELIMITER ',');

perform check that number of rows equal
SELECT COUNT(*) FROM target_table;
 and compare to display in Lotus Approach

zipperer commented 10 months ago

During #2 , we:

used .dbf file exported from Lotus Approach
imported that into LibreOffice spreadsheet

exported from there a CSV

psql> \copy target_table(column1, ..., columnN) FROM '/file_exported_from_lotus_approach.csv' WITH (FORMAT CSV, DELIMITER ',', HEADER);

We did this with a .dbf file that contained two rows. It remains to perform this with an export file that contains all the rows in the table for mailing list.

zipperer commented 8 months ago

We have imported sample data into mailing_list and offerings. Michael will experiment further with larger samples or full export from Lotus Approach.