Celoxis provides you with importing clients from spreadsheet which saves a lot of your time and effort.
How does it work?
While importing, Celoxis prompts you to map the relevant fields from the CSV with the fields available in Celoxis.
- There are some mandatory fields in Celoxis like, "Name" and "Email address".
- Other optional fields like login (not required for generic users) can be mapped as per your requirement.
- You can also map the custom fields created for users through the CSV file. For e.g the Date of Birth, Anniversary Date, etc.
- You can ignore or skip starting rows in the CSV by mentioning them under the Number of Top rows to skip box.
- You can also choose the required date format in Celoxis.
To import Clients:
- From main menu, click on View and under People section, click on Clients.
- In the new page, from the action drop-down click on Import CSV.
- Click Browse and select a file.
- Click Next.
- Under the Field Mapping, map the fields of your CSV file with the fields provided. You can now map the custom fields created for a user through the CSV file.
- In the Number of Top rows to skip box, enter the number of rows you want to ignore.
- From the Input Date Format drop-down list, select a date format.
- Click Finish.
You can view the sample file for the CSV import on the Import CSV page (step 3) by clicking on the Sample CSV link.