After you have created or identified a suitable Import Source for your import file (see Creating Import Sources), you can run the Generic Import wizard.
Follow these steps:
- Select the Import Runs service.
- Click the the Generic Import Wizard icon icon in the toolbar to launch the wizard.
- This icon is also available in the view toolbar of Import Runs list views.
...
-
- Enter the applicable source record in the the Import Source field field.
- Place a check mark in the Select the Customize Field Mapping for This Import Run box option to review or modify the Import Source Columns for this run. Import Wizard: Step 1
Click Next to 
- Click Next to continue.
- Modify the field mappings as necessary, and then click click Next to to continue.
- This step is not applicable if you did not check
...
- the Customize Field Mapping for This Import Run
...
- box.
- You cannot modify the Source Column fields in this dialog.
...
-
- To specify a different entity field for the Mapping Field, place your cursor in the appropriate row to enable a drop-down list that contains all of the fields in the entity. Select a different field as necessary.
-
...
-
- If the data in a source column corresponds to a linked field in the Mapping Entity, you can
-
...
- select the Lookup check box. When
...
- selected, Aptify
...
- performs a lookup in the specified entity to find the record ID that matches the text in the source column.
For example, if the data in the Culture source column is text (such as
- performs a lookup in the specified entity to find the record ID that matches the text in the source column.
...
Spanish) and this column maps to a CultureID linked field, then Aptify can lookup the ID for the Cultures record whose name is Spanish and return the appropriate ID. This ID can then populate the CultureID field in the new record created from the import data.
...
Info The Lookup feature applies only to entities
...
whose Name
...
field is Unique (in other words,
...
the Unique
...
option is
...
selected on that Entity Fields record that also has the
...
Is Name
...
option selected). This feature does not support entities whose records can share the same name.
- You can also modify each row's details by opening the Import Mappings sub-type record. Click within a Description field to display an ellipsis (...) button and then click that button to open the form.
...
-
- Specify the import file details in the fields provided, and click click Next.
- The fields vary depending on the import source's import source type. These fields correspond to the items on the Import Source Type's Input Properties tab.
- For tab-delimited text files, identify the name and location of
...
- the Import File.
- For Excel files, identify the name and location of
...
- the Import File
...
- and the name of the Excel file'
...
- s Worksheet
...
- that contains the import data.
- For Access files, identify the name and location of
...
- the Import File
...
- and the name of
...
- the Table
...
- that contains the import data.
...
- Select the Has Header
...
- option if the first row of the import file contains column headings. When
...
- selected, the Generic Import wizard ignores the first row in the import file.
...
- Click Finish to
- Click Finish to begin the import process.
- Click Click OK when when prompted that the file was imported successful.
- This opens the Import Runs record that the wizard created. Proceed to
...
...
- .