ImportExport tool
From Geoikia-english
Contents |
Introduction
With the ImportExport tool you can export and import the Geoide Author data base using XML. A typical use case is to set up the initial Geoide Author data base. By the usage of XML instead of SQL you have more overview and you may use generic XML tools for mutations.
The ImportExport tool is a command line tool and part of the geoide-utilities.zip, which also comes with the installation.
Steps
Usage: java -jar geoide-author-import.jar [import | export] [options] database user password file
Options:
-t PostgreSQL | Oracle (default: PostgreSQL)
-h host (default: localhost)
-p port (default: 5432(PostgreSQL) or 1521(Oracle))
-f id string (filter example "{layer: layer1,layer2; queryaspect:
queryaspect3}")
-rd true | false (resolve dependencies, default: false)
-u true | false (report usage, default: true)
-a author (specify author name)
-rp true | false (remove public elements of other authors, default: false)
Explanation
- -t Choice of the data base to export to or import from (Oracle or PostgreSQL). You may import from or export to one database type to the other.
- -h localhost or IP address of database server
- -p portnumber of database server
- -f filter to indicate what of the data base has to be exported/imported. Default all items will be exported/imported (no filter).
- -rd resolve dependencies. For export only, and in combination with the filter option (-f); if set 'true' then all dependencies of the items listed for filtering, will be exported as well.
- -u report usage. For export only; if set 'false' then the usage of items is not reported, which avoids unnecessary XML-code.
- -a author name. If not specified and no filter (-f) is used, then the whole database will be exported/imported.
- for export: if specified, then only items of the specified author name and all public items will be exported.
- for import: if specified, then all items will get the specified author name. If no author database with the specified name exists, automatically a new data base with that name will be created.
- rp remove public elements of other authors. For export only ; if set 'true' public items will not be exported and the id of references to public items will be replaced by 'name'. (During import the name will be linked with the specified id in the existing database).
Examples
Example: java -jar geoide-author-import.jar import author_test postgres postgres geoide-author-export.xml
> Main Page > System and Application Management > ImportExport tool
