Imports

To access the Imports screen, select Setup|Imports. Three types of imports can be done namely, SQL Statement, Linx Process and DTS Package.

To add an import:

Select the import type from the dropdown then select the Add button. There are two parts to the import, one being the sample data query to test the import and the second bit being the details of the import itself.

For SQL statements, the import section will reference a store procedure. The Linx process will reference the Linx Solution name and for DTS Packages, the server where the location of the package is stored.

The import will require a name and both the sample and details section require a Data Source. The details section parameters must have the '@' in front of them.

To edit an existing import:

Select the Edit link. To save the ammended import select the Save button.

To preview an import:

Select the Sample ( ) icon. A window will appear with the data from the sample query.

To run an import:

Select the Run () icon. You will the be required to insert parameters if the details sections has parameters assigned. To confirm the run after inserting the parameters you will need to hit the run icon again.

A window will appear if the import is succesful. No record is placed in the process log.

To delete an import:

Select the delete () icon. A prompt will appear to confirm the action. Selecting OK will delete the validation.