Copy Excelimport templates to production database

1
How can I copy the created templates to my production database?
asked
1 answers
1

Assuming you use a (local) PostgreSQL database, you could do it the following way:

Make a dump of the excelimporter tables, e.g.:

pgdump -a -t excelimporter$* -U [username] [databasename] > exceltempldat.sql

Then transfer this script to the production environment (/tmp)

Loggon to production using Putty.

Run the PostgreSQL commandline using 'psql' and go to /tmp directory (first type '\cd' then '\cd tmp')

Execute the script:

\i exceltempl_dat.sql

This will insert all the data.

answered