<< Click to Display Table of Contents >> Navigation: Options > User list import and export |
To allow quick data entry, it is possible to import the user account list from an external CSV file. This section will describe how to do this.
•Select Users in the Options menu, to move to the Users page
First, we export the user list.
•Click the Export button
This will prompt the download of a file that contains the user list (users.csv). This file will serve as a reference of the format that Apresa expects when importing a user list from CSV. The CSV file can be opened in spreadsheet software (for example Excel, and OpenOffice.org). Make sure that the comma is used as the separator character, and all columns are interpreted as text. Using the spreadsheet software, you can edit existing user account data, and add new user accounts by adding new rows of data. For new user accounts, the DB-ID column must be left blank. In the telephones column, the telephone numbers of the user are enumerated, separated by commas. In the "Member of" column, the groups of which the user is a member are enumerated, separated by commas. The changes that you make can be imported back into Apresa, as follows:
•Click the Import button, in the Users screen.
•Input the filename with CSV data, and press the Upload button.
To result of the import will be presented for verification. If any errors are detected (such as a reference to an unknown group), then these errors must be corrected first in the file, before the data can be imported.
•Press the Import button
The user list import is completed.
User group list import and export works similar.
Web client column
The web client settings column controls the display settings of the web client for the user. To edit this refer to the table below. In this table each setting gets a number. Select the numbers of the settings that need to be enabled and, add them together and input this number in the column. E.g. to enable editing of notes, notes(2) and category use 7 (= 1 + 2 + 4)
Edit notes |
1 |
Edit notes(2) |
2 |
Edit categories |
4 |
Set silence |
8 |
Start/Stop |
16 |
Delete |
32 |
Store on demand |
64 |
Editing settings on web client page |
128 |