Import
Use the Import tool to import data from external files and third-party database applications, such as CRM, HR, and network inventory systems, directly into your Alloy Navigator database.
You can use the Import tool to import data from these formats:
-
Microsoft Excel workbooks: XLS or XLSX files
-
Text files: TXT or CSV files
-
Other databases accessed through an ADO connection
Before starting the data import, determine the following:
-
The class of Alloy Navigator objects (Computers, Consumables, Persons,
-
The object fields into which your data will be imported.
-
The whereabouts of your source file.
-
Optional: Do you want to use a previously created configuration file? See the tip below.
TIP: When you need to import data from same data source several times or on a regular basis, you may want to create a configuration file that will contain all import configuration settings. Then you can use that file for all subsequent imports, including non-interactive imports via the command line interface. This allows you to schedule recurring data imports on regular basis. For details, see Command-line options for the Import tool.
You can start the Import tool from the Alloy Control Panel.
INFO: For details on running the Import tool in non-interactive mode, from the command line, see Command-line options for the Import tool.