Import Customers from XLSX
Import PPPoE customers from an XLSX file with field mapping and mismatch review
Import PPPoE customers from an XLSX file with field mapping and mismatch review
On this page
Use Customers → Import XL to create PPPoE customer records from a Microsoft Excel .xlsx file. This workflow is separate from Customers → Import, which reads PPPoE users from a configured MikroTik router.
Test with a small file first. Import creates records immediately after confirmation and has no rollback control. Duplicate or invalid usernames are skipped, but other missing values can produce an incomplete customer record that must be corrected afterward.
Prepare the file
On Customers → Import XL, choose Download Sample Template. The sample contains these headers:
| Sample header | Imported value | Required |
|---|---|---|
username |
PPPoE username | Yes; must be valid and unique |
password |
PPPoE/RADIUS password | No |
name |
Customer name | No |
mobile |
Customer mobile number | No; invalid values are left empty |
package |
Package name | No |
billing_profile |
Billing-profile name | No |
expiry_date |
Package expiry in the selected date format | No |
The field-mapping screen also accepts columns mapped to nid, house_no, road_no, thana, district, status, ip_pool, and ppp_profile. Valid status values are active, suspended, disabled, or expired; any other value becomes active.
Only the username mapping is mandatory. The importer creates PPPoE records, defaults billing to Monthly when no matched profile supplies another billing type, and records the imported account as paid. Treat the remaining fields as operationally required even when the importer permits them to be blank.
Import workflow
- Open Customers → Import XL.
- Select the customer Operator, choose the date format used in the file, and upload an
.xlsxfile. CSV files are not accepted by this screen. - On Map Fields, match spreadsheet headers to system fields. Auto-detected matches are preselected; use Do not import for unwanted columns. Ensure
usernameis mapped. - Select Review & Detect Mismatches. The review shows up to the first 20 rows and compares package, billing profile, IP pool, and PPP profile names with existing records.
- For an unmatched package or billing profile, choose to import without it, map it to an existing record, or create it. IP pool and PPP profile mismatches are informational and may require manual network configuration.
- Review every resolution, then select Import Customers once.
- Read the result counts and row-level warnings or errors. Correct skipped or incomplete records before allowing them onto the network.
New rows are stored as PPPoE customers and synchronised to the customer index and RADIUS attributes. A matching package or billing profile is preferable; importing without one can leave the account unable to provide the intended service or billing behavior.