Search, imports, and exports
Find the record before changing it
Global search can group results from active sessions, subscribers, leads, tickets, packages, routers, payments, invoices, expenses, vouchers, SMS, equipment, IP bindings, and campaigns. It also offers context actions for the page being viewed.
Press ⌘K on a Mac or Ctrl+K on Windows, or click the search bar at the top. Results appear as you type, with no minimum length. Each of the 14 groups shows up to 5 matches. The group for the page you are on is listed first. Use ↑ and ↓ to move, Enter to open, and Esc to close. Before you type, the box lists up to 5 recent searches.
Search well
Prefer stable identifiers:
- subscriber username/account number/phone/email;
- MAC or framed IP for network incidents;
- receipt/reference/invoice number for money;
- router identity;
- ticket ID/subject;
- voucher code;
- equipment serial number.
Verify the ISP and the record before using a result action. Short/common names can return several valid matches.
Page-specific import/export
Subscribers, payments, leads, tickets, vouchers, analytics, and other workspaces expose purpose-built export or import/export pages. Use them instead of reconstructing data from screenshots.
| Page | Export formats | Notes |
|---|---|---|
| Subscribers | CSV or Excel (XLSX) | Excel is limited to 50,000 rows. CSV has no limit. |
| Payments | CSV | Scopes: all, today, 7 days, 30 days, custom, unreconciled or pending |
| Leads, Tickets | CSV or Excel | |
| Vouchers | CSV or Excel, plus PDF to print | The PDF holds 1,000 vouchers by default and up to 5,000 |
| Analytics | CSV | Needs money access |
Most exports download straight away. The voucher PDF is prepared in the background. You get a notice when it is ready, and its link works once, for 30 minutes.
Export procedure
- Apply scope filters.
- Choose only needed columns.
- Review expected count/date range.
- Export once.
- Reconcile a sample and totals.
- Store with controlled access and remove temporary copies.
Import procedure
Subscribers are imported from Import & export on the Subscribers page. You can upload a file or pull PPPoE secrets live from a MikroTik router. A file can be CSV, XLSX or XLS, up to 10 MB and 50,000 rows. The upload runs in 3 steps: Upload, Map fields and Review.
- Download the current template where offered.
- Preserve headers and required formats.
- Normalize identifiers as text.
- Preview/parse before writing.
- Test a small representative batch.
- Keep the result summary and avoid blind re-upload.
The template has 11 columns: name, first_name, last_name, email, phone, account_number, type, package, nas, password and comment. A row matches an existing subscriber by username, then account number, then phone. You choose what happens to a match:
- Skip duplicates (default): leave the existing subscriber as it is.
- Update existing: fill in blank fields only.
- Overwrite existing: replace values with the file’s.
Rows with an unknown package or router, or no username, are counted as errors and not imported.
Spreadsheet safety
Treat imported formulas, leading =, macros, hidden columns, and altered phone/account number formatting as risks. Use CSV/plain values where the workflow expects them. Inspect files from external parties before upload.
Data minimization
Exports may include personal, financial, message, network, or support data. Share the minimum scope with authorized recipients and follow retention/deletion policy.