Database Connected Data in CSA: Unterschied zwischen den Versionen

Aus OCAD 11 Wiki - Deutsch
Zur Navigation springen Zur Suche springen
 
(2 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
 
[[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]]
 
[[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]]
 +
 +
Diese Funktion ist in OCAD 11 nur in Englisch verfügbar.
 +
 
==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:
 
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
 
# 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.
+
# The '''[[Database#Datenbankverbindungen verwalten|Manage Database Connections]]''' dialog appears. On the right side of the dialog the '''Import to PostgreSQL''' button is shown.
 
# Click this button.
 
# Click this button.
 
# The '''Server Import PostgreSQL Data''' dialog appears.
 
# The '''Server Import PostgreSQL Data''' dialog appears.

Aktuelle Version vom 27. Juni 2013, 11:11 Uhr

This function is only available in the OCAD 11 Enterprise Edition.

Diese Funktion ist in OCAD 11 nur in Englisch verfügbar.

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:

  1. Choose the Manage Database Connections command in the Database menu
  2. The Manage Database Connections dialog appears. On the right side of the dialog the Import to PostgreSQL button is shown.
  3. Click this button.
  4. The Server Import PostgreSQL Data dialog appears.
  5. Enter the connection data and click the Test button to verify the connection.
  6. If the connection was successful, choose a Dataset in the Dataset to Import part of the dialog.
  7. Enter a name for the table.
  8. 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.
  9. Click the Import button.
  10. The Import progress for Dataset part of the dialog shows the progress of the import.
  11. 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).