Set up Axiom ETL import for flat files

Use these instructions to set up folder and file options for importing flat files using the Axiom ETL importer. These instructions are for system implementers setting up new systems and for support technicians setting up import folders for additional flat file types.

IMPORTANT: When copying an existing flat import file, you must add an underscore (_) and a number or other character to the end of the copied file name: a copy of a file named CM_TempXXX would be named CM_TempXXX_y; so a copy of the file CM_TempClaimAddDRG could be named CM_TempClaimAddDRG_2.

To set up import file and folder options:

  1. In the Axiom Windows Client, from the Axiom ribbon tab, click Imports > Contract Management> [desired flat file import type] > Edit.
  2. In the Flat File Import dialog, click the Source tab.
  3. For Import Type, select File.
  4. In File Import Options, select the following:
    1. For File type, select Delimited file.
    2. For Source path, select Use specified path.

    3. In the Source folder field, enter the path to the folder in which the client will place files. This is also the folder from which the importer picks up the files.

      NOTE: This path is provided by the client. For requirements, see Client file specifications.

    4. For Import from, select Multiple files.

  5. In the File Options section, select the following:
    1. If the first row of data in your file has column headers, select the option First row has column names.
    2. For Delimiter character, select the pipe delimiter (|).

    3. For Text qualifier character, the default is quote marks. If your file uses a different qualifier character, enter it in this field.

  6. In the Multiple File Options section, select the following:
    1. For Import order, select Creation date.

    2. For Archive folder, this is the same path as the Source folder except that instead of a folder named “Import” the folder is named “Imported,” as shown in the following example.

    3. Ensure that the option Add timestamp prefix to file names when archiving successful import files is selected.

  7. If the client is using column header names in the file, click the Mapping tab and then verify that the information displayed in the Temp Table Column and Destination Column is correct.

  8. If the information is not correct, select the line in the column and then type the correct heading.
  9. Click Apply and then click OK.
See also