How to import clients

Here are some quick tips to help you import your client list.

eNoteFile Team avatar
Written by eNoteFile Team
Updated over a week ago

1. Log into eNoteFile

Log in and select Clients from the side menu then click the three dots in the top right to Import Clients.

2. Import Clients

You can upload a CSV (type of excel spreadsheet file) on the clients page. Please note that you’ll have to get it into the correct format for it to import successfully. When you start the import process, you’ll be able to download a template (Clients.csv) to help format your spreadsheet.

  • Download the template: Log in and download the template (see above).

  • Format your list: Once you have the template (Clients.csv), match up the columns with your client list and make sure that the field headings match.

  • Mandatory fields: Make sure that all mandatory fields are filled in.

  • ClientId: Having a unique ID for each client is useful. If a few clients don't import due to an error (missing DOB or invalid mobile number) you can fix these issues and re-upload the same CSV file. eNoteFile import will skip clients that have already been imported by matching the clientId field.

  • BirthDate: Make sure the DOB column has the same date formatting (Example: yyyy-mm-dd). If unknown you can always add a place holder like 01/01/1900.

  • MobilePhone: Make sure that all mobile phones are formatted correctly for your country or leave blank (too many invalid mobile numbers will stop the import).

  • OptOutSms: Make sure that all clients are either opted in or out: 1 = Opt Out and 0 = Opt In.

  • Import your client list – Once formatted correctly, log back in and complete the import process.

  • Import result: You'll get a confirmation message upon successful import. Note, you'll get a list of clients that failed to import along with the reason it failed. Use this list to fix up your CSV file and re-import it (remembering that successfully imported clients matching the clientId will be skipped).

NOTE: When working with a CSV file in Microsoft Excel the program drops the leading 0's (Zeros) for phone/mobile numbers because it is a number. IE 0001 will be seen as 1. More information about managing a CSV file in Microsoft Excel can be found here. You can also Google "managing CSV into Excel without losing zeros" if you don't have experience with working with data spreadsheets.

HELP? 

We understand uploading or importing clients might be tricky and we’re happy to help. Contact us if you need help importing your clients or if you have any questions. 

Did this answer your question?