Data Export Parameters

How to Define Data Export Parameters?

· Data Export Parameters are defined for Data Export Task which is inbuilt.

· Right click on the Data Export Task and select Details.

· Select Data Export Parameters tab to add parameters. Click on Add flag.

· User need to specify the type of file. The file types are provided with file extension.

Export parameters for text file

· Give appropriate name for Export.

· If there are more than one Export Parameters, they will be arranged according to sequence number given.

· Give file extension type as txt from the dropdown.

· Delimiter must be selected with respect to the File Extension selected.for Text(*.txt), Comma is used as common. And also other delimiters like Tab, Semicolon and Pipe used as delimiter for txt file.

· If user wants to export only some specific Tables, then user can specify them.

· Export Location shows the path to store the file that has been exported from the application.

· For Text(*.txt), File names are shown as Table Name.

· Click on Select button and user will be displayed with the table names.

· Add the required tables.

· Selected Tables will be displayed below the select button.

· User can set Date Format.

· Select the Affected Module. Affected Module has 3 dropdowns.

    1. Forecast.

    2. Planning and Scheduling.

    3. Replenishment.

· User can select appropriate module.

· Add the parameters once the fields are filled.

Export parameters for csv file

· User has to give the same as like as text file type

· Give file extension type as csv from the dropdown.

· Comma is used as delimiter fot csv file

· Give Export Location, specific tables and affected module as mentioned in file type text

Export parameters for Excel file

· User has to give the same details as mentioned above.

· Give file extension type as Excel from the dropdown.

· No delimiter needs to give for Excel file, because it takes Tab as delimiter by default.

· Give Export prefix to the file.

· Give Export Location, specific tables and affected module as mentioned in text file type

Export parameters for sql file

· The conditions for adding sql file is given below

· choose file extension type as sql from the dropdown.

· Delimiter is not required for this file type.

· Directory Location is required where the file is taken from.

· Give specific tables which are mentioned in the sql query and Export Location to store the exported file. The file will be exported as txt.

· User must enter DSN Name, User Name, Password or use connection string in DSN field for sql file type.

· User has to specify the DB Type from the dropdown. There are three options; SQL, ORACLE, ODBC.

Export parameters for ODBC file

· There are several conditions for adding ODBC file as Export parameters

· choose file extension type as odbc from the dropdown.

· Delimiter and Dir Location are not required for this file type.

· Give Insert Type and specific tables.

· User must enter DSN Name, User Name, Password or use connection string in DSN field for ODBC file type.

· User has to specify the DB Type from the dropdown. There are three options; SQL, ORACLE, ODBC.

· Add the parameters once the fields are filled.