OMNIA CSV Imports 

The OMNIA application provides a simple CSV import utility that can be used to import tagholders, vehicles and visitors. 

1. Create a CSV file with headers and required data. A list of fields available for import can be seen in the table below. 
2. The minimum needed data to import is First Name, Last Name, and ID Number 

Birthday	Fax (H)	Postal Address (W)
Company	Fax (W)	Second Name
Department	First Name	Street Address (H)
Device Serial No	Gender	Street Address (W
Driver’s License No	ID Number	Suffix
Email (H)	Last Name	Title
Email (W)	Mobile Number	Vehicle Color
Email Address	Name of person visiting
Employee No	Position
Employer	Postal Address (H)

CSV Document should resemble this: 

3. Go to the OMNIA Server Application and select the TOOLS tab: 

Click the ‘Browse’ button and browse to your saved CSV file and select the file: 

The Browse box should now show the path to your CSV file. 

4. Move down to Step 2: Column Mapping, before doing anything else, create a New Profile Name. In the left of the table, you will see the column headers from you CSV file, we now need to map those to fields in the database that we want to populate with the import. 

Map the source to destination by clicking on the red DESTINATION rows on the right, these are drop-downs that you can use to map your CSV source to the correct field in the database, save the profile by clicking the save button: 

The saved profiles will be available for subsequent imports using the same .CSV file.

5. Move down to Step 3: Process File, press the Process button  

Review the summary at the bottom to confirm that the import was successful: 

6. Errors or failures are usually caused by the use of special characters, extra spaces before or after records, lines between records or mismatches between source and destination mapping.