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.
CSV import is the fastest way to get existing customers into Jasiyo when migrating from another billing system, a spreadsheet, or a manual record. Instead of adding customers one by one, you prepare a CSV file and import them all at once.
Download the template
Go to Customers → Import and click Download Template. Open the CSV in Excel or Google Sheets — it has the correct column headers and example rows.
Always use the template from your Jasiyo dashboard — do not rename or reorder columns. The importer matches data by column position and name.
Column reference
| Column | Required? | Notes |
|---|---|---|
| full_name | Yes | Customer's full name |
| username | Yes (PPPoE) | PPPoE login username — must be unique |
| password | Yes (PPPoE) | PPPoE password |
| phone | Recommended | Phone number in format 0712345678 or 254712345678 |
| No | Customer email address | |
| plan_name | Yes | Must match an existing plan name exactly |
| router_name | Yes | Must match an existing router name exactly |
| static_ip | No | Only for static IP customers |
| notes | No | Internal notes |
| expires_at | No | Pre-set expiry date (YYYY-MM-DD). Defaults to plan duration from today. |
Running the import
- Go to Customers → Import
- Click Upload CSV and select your file
- Jasiyo will show a preview with any validation errors highlighted
- Fix any errors in your CSV and re-upload if needed
- Click Confirm Import to create all the customers
- Jasiyo will provision each customer on your router via the phone-home agent in the background
Tips & gotchas
- → Plan names and router names must match exactly — including capitalisation. Check Jasiyo's Plans and Routers pages first.
- → Phone numbers should all be in the same format. Either 07XXXXXXXX or 2547XXXXXXXX — don't mix them in the same file.
- → Duplicate usernames will fail with a validation error. Make sure all PPPoE usernames are unique.
- → If you're importing customers from MikroTik, export them from WinBox (PPP → Secrets → Export) and then reformat the columns to match the Jasiyo template.
- → Large imports (200+ customers) may take a few minutes to fully provision on the router since commands are queued and processed on each 30-second check-in.