Exporting Client Information into a csv Format File

Top  Previous  Next

 

1.No other users can be accessing AyaNova
2.Double-click on the ImportClientCSV.exe file to open the program
3.Enter an AyaNova Administrator username and password
i.(default is “manager” with password “letmein” if you have not yet changed it as recommended)

login

4.Select the menu option Export Data

exportdata

5.All clients in the AyaNova v3 database will begin processing into a csv file

processingexport

6.A file called Clients.csv will be placed in the same location where the program file is located.

finsihedexport

7.If you open this file using NotePad, you will also see the format

notepadformat

8.If viewing via NotePad, you will note that each field is quoted (surrounded by quotation marks), as well as divided by a comma.
9.You will also note when viewing that there is always 22 fields, even if a field is empty.

 

Do note that only the following AyaNova v3 Client record's primary contacts information is exported:

ContactFirstName, ContactLastName, PrimaryPhone, Fax, AltPhone, EmailAddress

 

Now you can further “massage” the data to import into another program if  needed.