Learn more about exportrpt, a command-line tool for exporting report definitions from an xTuple database to files on your file system.
Name
exportrpt - Report definition export tool
Synopsis
exportrpt
-databaseURL=<connection URL> -username=<user name> -passwd=<password>
Description
The exportrpt utility is a command-line tool for exporting report definitions from a database to files. For each report in a the report table on the database connected to exportrpt creates a file following the convention of reportname-grade.xml.
Options
-databaseURL=<connection URL>
Specify the connection information that exportrpt should use when loading a report definition. The connection URL is in the following format:
psql://servername/database:port
In the connection URL, the servername is the host or IP address of the server where the database is running.
somehost.openmfg.com
The database is the name of the actual database you want to connect to on the specified server.
mydb
The last option, port, is optional. If included, it must follow the color and be a valid port number. If the port is not specified, the default port of '5432' is used. For example, if you wanted to connect to the database 'mydb' on the server 'somehost.openmfg.com' using the default port, you would use the following URL:
psql://somehost.openmfg.com/mydb
Similarly, if you wanted to connect to the database 'dbtest' on the server '192.168.128.64' using the port 2345 you would use the following connection URL:
psql://192.168.128.64/dbtest:2345
The user name you are using to connect to the server and database.
-username=<password>
The password for the user name you specified.
-passwd=<password>