Aptify includes a wizard that imports any data into the system. This wizard is ideal for recurring imports of small sets of data. Note that this tool is not intended to be used for data conversions.
By default, the standard Aptify installation supports importing from tab-delimited text files, Microsoft Excel files, and Microsoft Access databases.
The following steps provide an overview of how to use the wizard to import data into Aptify:
- Identify the data that you want to import into Aptify. Also, identify the following:
- The current format of the data.
- The location where the data should be added into Aptify. For example, for the customer contact information to import, you will want to import that data into the Persons entity.
- If the data's format is not one of the existing source type, create a new Import Source Types record. See "Creating New Import Source Types" in the Admin Guide.
- Note that creating new source types requires that a developer write code.
- Note that creating new source types requires that a developer write code.
- Create a new Import Sources record for your data. This record ties a import source type to the entity to which you are importing the data. Also, you can specify an object that overwrites the default record matching and posting behavior with your own business logic. See "Creating Import Sources" in the Admin Guide.
- This assumes that a suitable Import Source does not already exist. -However, you can use an existing source if your system already has a record that specifies the data's source type, its fields, and the target entity.
- Note that creating your business logic for the matching and posting processes requires that a developer write code. Alternatively, you can define and modify matching criteria while running the Generic Import wizard, reducing the amount of code a developer needs to write to specify different matching logic. See "Running the Generic Import Wizard" on page 651 for more details.
- Run the Generic Import wizard from the Import Runs service. See "Running the Generic Import Wizard" on page 651.
- Match import run details with existing records in the entity within the Import Runs record that was automatically generated by the wizard. Then, post the import run details to create new records for unmatched items. See "Matching and Posting Import Results" on page 654.
- Review the newly created records to confirm that the data was successfully imported into Aptify.
This topic covers the following sub-topics: <child display>
| Child pages (Children Display) |
|---|