Exporting a Database from the Command Line
You can export a database from the command line using the DBExporter.exe command. This command is used independently of the Database Manager.
The DBExporter.exe command allows you to export all tags currently loaded on local or remote node to a comma separated value (CSV) or GDB text file. When no command parameters are specified, DBExporter.exe exports tags on local node to PDB name.csv to local PDB path. Typically, this path is: C:\Program Files (x86)\Proficy\iFIX\PDB.
Syntax
DBExporter.exe [/NNodeName] [/OOutputFileName>] [/F] [/R]
Parameters
The following table lists the command line parameters available for the DBExporter.exe exporter tool.
|
Parameter |
Description |
|
/NNodeName |
Optionally, specify the remote SCADA node name that you want to to export the database from. Replace NodeName with the actual node name. |
|
/OOutputFileName |
Optionally, specify the output file name with full path or no path. If no path is specified, output file is created in local PDB path. Typically, this path is: C:\Program Files (x86)\Proficy\iFIX\PDB. The file name portion requires the file extension: .csv or .gdb. Replace OutputFileName with the actual output file name. For example: MyFile.csv. |
|
/F |
Optionally, allows you to run a fast export. The export runs as fast as possible, maximizing CPU usage up to 100%. |
|
/R |
Optionally, allows you to skip header information (that includes the node name, database name, file name, and date and time of the export), in the output file. |
Error Codes
The following table describes the error codes and descriptions DBExporter.exe exporter tool.
|
Code |
Result |
|
0 |
Successfully exported. |
|
1 |
General Failure. iFIX is not running; unable to load DatabaseManagerRes.dll, an so on. |
|
2 |
Invalid commands. |
|
3 |
Invalid node. |
|
4 |
Invalid file name. |
|
5 |
Invalid file extension. |
|
6 |
Unable to open Export.err file used for recording error details. |
|
7 |
Empty database. |
|
8 |
Invalid output file. |
|
9 |
Exporting failure. The export file had an open or write error, EDA call failure, or other similar type error during the export process. |
