Skip to content

Quick Import Parameters

How to Define Quick Import Parameters?

· Quick Import Parameters are defined for Quick Import Task which is predefined.

· Right click on the Quick Import Task and select Details.

img

· Select Quick Import Parameters tab to add parameters. Click on Add flag.

img

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

· Give appropriate name for Import.

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

· Give file extension type as txt from the dropdown.

img

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

· Dir Location shows the path to find the file that has to be imported into the application.

· Insert Type has three dropdowns.

  1. Append: Adds to the database incrementally. If the particular data already exists, it will not replace that data. It will throw an error stating that data is already present.

  2. Replace: Adds to the database incrementally. If the particular data already exists, then it will replace that data.

  3. Clear All: Clears all the contents in that particular table and loads the data contained in flat file or excel.

img

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

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

· Click on Select button and Add the required table.

· Add the parameters once the fields are filled.

Quick Import also supports Data file, CSV file and Excel file

· After added the data, it will show as follows

img

· Go back to WorkFlow, and Run Quick Import task. You will get a Success message.

img

· Check Details button; if there were any error while running task, it's detail will show in the Error window.

· If the task is run Successfully, no error will show when click on Details button.