Database Connected Data in CSA: Difference between revisions
Jump to navigation
Jump to search
(Created page with "Category:Client Server Architecture ==Import of Database Connected Data==") |
No edit summary |
||
| Line 1: | Line 1: | ||
[[Category:Client Server Architecture]] | [[Category:Client Server Architecture]][[File:Ent40px.PNG|This function is only available in the OCAD 11 Enterprise Edition.|link=https://www.ocad.com/en/products/ocad-for-cartography]] | ||
==Import of Database Connected Data== | ==Import of Database Connected Data== | ||
When a CSA-Project is opened, it is possible to import the database connection data to the PostgreSQL database on the server: | |||
# Choose the '''Manage Database Connections''' command in the '''[[Database]]''' menu | |||
# The '''[[Database#Manage Database Connections|Manage Database Connections]]''' dialog appears. On the right side of the dialog the '''Import to PostgreSQL''' button is shown. | |||
# Click this button. | |||
# The '''Server Import PostgreSQL Data''' dialog appears. | |||
# Enter the connection data and click the '''Test''' button to verify the connection. | |||
# If the connection was successful, choose a '''Dataset''' in the '''Dataset to Import part''' of the dialog. | |||
# Enter a name for the table. | |||
# Check the '''Drop existing table''' option to automatically overwrite an existing table with the same name chosen without any warning message. Otherwise a warning message will appear. | |||
# Click the '''Import''' button. | |||
# The '''Import progress for Dataset''' part of the dialog shows the progress of the import. | |||
# Click the '''Close''' button when finished. | |||
If any error occurs during the import, two files are written in the temporary folder: TABLENAME_ddl.sql and TABLENAME_data.sql. Keep them for support reasons. | |||
---- | |||
Last page: '''[[Rights Management]]'''<br /> | |||
Back to the '''[[Client Server Architecture]]''' page.<br /> | |||
An overview about all pages dealing with the '''[[Client Server Architecture]]''' can be found in the corresponding category (see below for the link). | |||
Revision as of 10:45, 3 September 2012
Import of Database Connected Data
When a CSA-Project is opened, it is possible to import the database connection data to the PostgreSQL database on the server:
- Choose the Manage Database Connections command in the Database menu
- The Manage Database Connections dialog appears. On the right side of the dialog the Import to PostgreSQL button is shown.
- Click this button.
- The Server Import PostgreSQL Data dialog appears.
- Enter the connection data and click the Test button to verify the connection.
- If the connection was successful, choose a Dataset in the Dataset to Import part of the dialog.
- Enter a name for the table.
- Check the Drop existing table option to automatically overwrite an existing table with the same name chosen without any warning message. Otherwise a warning message will appear.
- Click the Import button.
- The Import progress for Dataset part of the dialog shows the progress of the import.
- Click the Close button when finished.
If any error occurs during the import, two files are written in the temporary folder: TABLENAME_ddl.sql and TABLENAME_data.sql. Keep them for support reasons.
Last page: Rights Management
Back to the Client Server Architecture page.
An overview about all pages dealing with the Client Server Architecture can be found in the corresponding category (see below for the link).