datadump - Data Dump
The datadump utility exports Infor Lawson Core Technology table values. This utility can either export values from a specific table or all tables from a data area. A specific table will have an output of CSV file. If all tables are exported, all CSV files are compressed in a .zip file.
The utility can immediately parse date formats like "0000-00-00". By default, it uses the UTF-8 character set unless a different character encoding has been set by the administrator.
-
Execute the
datadump.sh
command. -
Respond to the following prompts:
Program Option Description Mode
(required)Specify
d
to export all tables from the data area.Specify
t
to export a specific table.If none of these options are specified, the program will exit.
Data Area
(required)The product line where the table is from. Table
(required)The source of data that will be dumped. If not specified, the program will exit.
This option is only available in
t
mode.Table Index
Supply the index table (the default is primary index).
This option is only available in
t
mode.CSV file destination
The path where the CSV output will be saved. The format should be <directory>/<filename>.csv
If not specified, the output file will be
<directory>\<name of TABLE>.csv
This option is only available in
t
mode.user
The user of the tool (defaults to "lawson"). character encoding
Defaults to UTF-8. Zip file destination
In d
mode, this option indicates the directory where the .zip file will be saved. If not specified, the current directory will be used. -
Verify the output located in the provided CSV or zip file destination.