Import Data

Tools → Import Data imports users, managers, refill cards or card users from a spreadsheet (Excel or CSV), for example when moving from another system.

How to import

1. Prepare the file. Only the first sheet is used.
2. Click Upload File and choose the file. A preview of the rows is shown.
3. Choose what to import in Import: Users, Managers, Refill Cards or Card Users. (Choose it after uploading, so the column options match.)
4. Above each column, choose which field it contains, or ignore.
5. Tick Ignore Header (first row) if the first row contains titles.
6. For users, tick Update Existing Records to update users that already exist instead of reporting an error.
7. Click Import. The console shows "Verifying Data Integrity...", then "Importing Data..." and the result.

The whole file is checked first. If any row has an error, all errors are listed (with row numbers) and nothing is imported. Fix the file and try again.

Columns

Import Required columns Optional columns Users username, password, profile parent, expiration, firstname, lastname, phone, email, company, city, address, contract_id, national_id, static_ip, traffic_balance (MB) Managers username, password, acl_group firstname, lastname, parent, balance, email, company, phone Refill Cards pin, serialnumber, expiration, value – Card Users username, password, profile, expiration value

Rules

• profile must be the exact profile name; parent must be an existing manager username; acl_group must be the exact permission group name.
• Usernames must be at least 2 characters and unique, both in the file and in the system.
• expiration: use the format YYYY-MM-DD HH:MM:SS. If empty, the user is created already expired.
• If parent is empty, the user or manager belongs to you. Imported users get your site.
• Manager balance is added as a deposit.
• Imported cards are owned by the admin. Refill cards without expiration are valid until 2040.

Required permission: Tools - Import Data and Users - Create