Importing Clients into AyaNova from a CSV format file

<< Click to Display Table of Contents >>

Navigation:  PlugIns > Client Import Export >

Importing Clients into AyaNova from a CSV format file

Steps to import:

 

1. Before importing:

Backup your AyaNova database before proceeding

Perform the import on the same computer where the database resides, and where the CSV file is.

 

2. The Client import/export utility must be installed before proceeding.

 

3. From the main menu select Plugins -> ImportExport.csv -> Clients to open the client import/export program

 

ImportExportCSV ImportClientCSV2

 

 

4. Select the menu option Open CSV file, and browse to the location of your csv import file and select it

 

ImportClient1

 

5. The records in your import file will display

 

ImportClient2

 

6. Now you need to tell the utility where to import each field.

 

Drop down the column heading for each, and select the client field you want that to import into. In the example below, we are selecting the Name field for that column.  

 

No problem if the order of your fields in your import file may be different - as you select which you want for your own columns.

 

ImportClient3

 

ImportClient4

 

ImportClient5b

 

If you make an incorrect selection or selections from previous imports are showing, just drop down the list again and select <don't import> to free up that column and that selection again

 

ImportPart5

 

 

7. If you have purchased an ImportExport.csv license, the Duplicate import options menu will display so that you can set what should overwrite or not. Refer to Import duplicate record update options for Client for more details

 

8. Once you have selected what fields you want to import, select the menu option Import data

 

importclient6

 

9.  Your records from your import file will now be imported into AyaNova

 

The time it will take will depend on the number of records to import

10. When the import is finished, a message will display identifying the number of client records imported, the number not imported if duplicates, and if duplicate settings use, how many were updated.

11. Exit out and view your clients in the Clients grid.  Don't forget that you can change the list of rows to view at any time, as well as Refresh

ImportClient8