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.

  1. Execute the datadump.bat command.

  2. 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.

  3. Verify the output located in the provided CSV or zip file destination.