You can import into ESY CMS lists of users as Ms. Excel files. The Excel files must be properly formatted in order to be successfully imported.
To format your users data properly, follow the steps below:
- Download the file import_users_example.xls and save it on your computer. Then, open it.
- Now, open the file with the users data you want to import, copy its content and paste it into the import_users_example.xls. If you data are in Excel format, you can copy entire columns and paste them alltogheter. At the end of the operation your file should look something like the below screenshot.
Below is the complete list of available values with some comments:
| id | leave it empty |
| firstname | compulsory, no accents or symbols |
| lastname | compulsory, no accents or symbols |
| password | leave it empty, the import will assign the password "esy" that you can later change |
| compulsory | |
| organisation | optional |
| phone | optional |
| fax | optional |
| job | optional |
| title | optional |
| address | optional |
| city | optional |
| zip | optional |
| country | optional |
| vat | optional |
| priv_update | leave it empty |
| priv_publish | leave it empty |
| priv_archive | leave it empty |
| priv_delete | leave it empty |
| priv_navigation | leave it empty |
| priv_users | leave it empty |
| priv_templates | leave it empty |
| priv_secure | leave it empty |
Once you properly formatted the file (see above), you can proceed to import it as follows:
- Log in to ESY CMS
- Click the tab "Import/Export" located at the bottom-right of the interface. The Import/Export screen appears.
- In the area titled "Import Users", browse for the Excel file
- Then, select the group where you want to import your users and click the button Import XLS.
