Customer Management5 min read
Import customers via CSV
Bulk import PPPoE, hotspot, or static IP customers into Jasiyo using a CSV file — ideal for migrating from another system.
Importing is the fastest way to get existing customers into Jasiyo when moving from another billing system, a spreadsheet, or paper. There are two routes, and the dialog offers you both.
Import from MikroTik is usually the better one. If your customers already exist as PPPoE secrets on your router, Jasiyo reads them straight off the device — usernames and passwords included — so there is no file to prepare and no chance of a typo. Your router must be online for this. Use CSV when you are coming from a system other than MikroTik.
Download the template
On the PPPoE page, open the menu beside the title and choose Import, then Import from CSV and Download Template. It opens in Excel or Google Sheets with the right headers and three example rows.
The importer reads your header row by name, not by position, so column order does not matter and extra columns are ignored. Several headers have aliases — see the reference below.
Column reference
| Column | Required? | Notes |
|---|---|---|
| username | Yes | The PPPoE login. The only column that must be present. `user` also works. |
| password | No | The PPPoE password. `pass` also works. |
| first_name | No | `firstname` also works. |
| last_name | No | `lastname` also works. |
| phone | No | 0712345678 or 254712345678. `mobile` also works. |
| No | Rejected if it is not a valid address. | |
| account_number | No | Their existing account reference. `account_no` also works. |
| plan | No | Matched against your plan names. Unmatched rows fall back to the plan you pick in the dialog. `plan_name` and `profile` also work. |
| expiry | No | YYYY-MM-DD or DD/MM/YYYY. `expiry_date` also works. |
| status | No | active, suspended, or expired. `disabled` and `blocked` count as suspended. Anything else becomes active. |
| type | No | pppoe, hotspot, or static. Defaults to pppoe. |
Running the import
- Open the menu beside the PPPoE page title and choose Import
- Pick Import from CSV and select your file — .csv only, under 5 MB
- Jasiyo previews every row and flags the ones it cannot accept
- Choose the plan and router that rows without their own should fall back to
- Fix anything flagged, re-upload if you need to, then confirm
- Customers are created and set up on your router in the background
A row is only rejected outright for a missing username or a malformed email address. Everything else is accepted and filled in from your fallback choices, so a wrong plan name will not stop the import — it will quietly put those customers on the fallback plan. Read the preview before confirming.
Tips & gotchas
- → Plan names are matched case-insensitively, so capitalisation does not matter — but a name that does not match at all falls back silently rather than failing. Check your Internet Plans page first and spell them the same way.
- → Keep phone numbers in one format throughout the file, either 07XXXXXXXX or 2547XXXXXXXX. Don't mix them.
- → Usernames must be unique. They are the PPPoE login, so a duplicate would collide with a customer you already have.
- → Coming from MikroTik? Don't export from WinBox and reformat — use Import from MikroTik instead. It reads the secrets off the router directly, keeps the passwords, and skips the file entirely.
- → Import in batches you can check rather than one enormous file. A few hundred customers take a few minutes to finish appearing on the router.
- → Passwords are optional in the file, but a PPPoE customer without one cannot connect. If you do not have them, use the MikroTik import, which brings the existing passwords across.