Onezeroart LLC

Appearance

Subscriber Export ​

Overview ​

Subscriber Export allows you to export subscriber data to Excel (XLSX) or CSV files. This feature supports two export types: Re-Import Data (CSV format for re-importing) and Plain Data (XLSX format for reporting). You can filter subscribers by various criteria before exporting.

WHAT IS SUBSCRIBER EXPORT?

Subscriber Export is a data extraction feature that:

  • Two Export Types - Re-Import CSV or Plain XLSX
  • Advanced Filtering - Filter by status, salesperson, package, NAS, location
  • Current Balance - Includes real-time balance for each subscriber
  • Complete Data - Exports 40+ fields including infrastructure data
  • Ready for Re-Import - CSV format matches import requirements
  • Human-Readable - XLSX format with readable names and statuses
  • Activity Logging - Tracks all export operations

Perfect for: Data backup, reporting, analysis, migration, re-importing!

📋 Table of Contents ​

  1. Export Types
  2. Filtering Options
  3. Exported Fields
  4. Step-by-Step Guide
  5. Best Practices
  6. Common Use Cases

Export Types ​

Export Type 1: Re-Import Data (CSV) ​

What It Is:

  • CSV format designed for re-importing
  • Raw data with IDs
  • Matches import CSV structure
  • Can be imported back into system

File Format:

subscribers_exported_20251122211500.csv

Use Cases:

  • Data migration
  • Backup and restore
  • Bulk editing and re-import
  • System migration

Fields Exported (42 fields):

isp_id, branch_id, full_name, username, password, connection_password,
identity, phone, connection_type, nas_id, salesperson_id, package_id,
expiration_date, current_balance, email, address, subarea_id, area_id,
city_id, country_id, department_id, latitude, longitude, profile_status,
sms_status, mac_lock_status, mac_address, static_ip, total_volume,
used_volume, total_session, used_session, discount_type, discount,
box_number, box_address, switch_board, switch_port, electric_socket,
cable_type, uplink_port, fiber_code, fiber_color

Important:

  • Password field is empty (for security)
  • IDs are raw (not names)
  • Current balance included
  • Ready for re-import

Export Type 2: Plain Data (XLSX) ​

What It Is:

  • Excel format for reporting
  • Human-readable data
  • Names instead of IDs
  • Formatted statuses

File Format:

subscribers_exported_20251122211500.xlsx

Use Cases:

  • Reporting
  • Data analysis
  • Sharing with management
  • Documentation

Fields Exported (33 fields):

ID, Fullname, Username, Connection Password, Identity, Phone, Email,
Address, Salesperson, Package, Country, Province, City, Area, Subarea,
Department, ISP, Branch, NAS, Profile Status, Connection Type,
Box Number, Box Address, Uplink Port, Fiber Code, Fiber Color,
Switch Board, Switch Port, Backup Connection, Electric Socket,
Cable Type, Expiration Date, Current Balance

Human-Readable:

  • Profile Status: "Active", "Disable", "Terminated"
  • Connection Type: "Radius PPPoE", "Radius Hotspot"
  • Salesperson: Username (not ID)
  • Package: Name (not ID)
  • Country/Province/City/Area: Names (not IDs)

Filtering Options ​

1. Profile Status ​

What It Is:

  • Filter by subscriber status

Options:

  • 1 = Register
  • 2 = Active
  • 3 = Disable
  • 4 = Terminated

Example:

Export only Active subscribers
Export only Expired subscribers

2. Salesperson ​

What It Is:

  • Filter by salesperson/reseller

Options:

  • Select from dropdown
  • Shows all salespersons in ISP/Branch

Example:

Export subscribers of Reseller A
Export subscribers of specific staff

3. Package ​

What It Is:

  • Filter by internet package

Options:

  • Select from dropdown
  • Shows all packages in ISP/Branch

Example:

Export subscribers on 10 Mbps package
Export subscribers on specific package

4. NAS ​

What It Is:

  • Filter by Network Access Server

Options:

  • Select from dropdown
  • Shows all NAS in ISP/Branch

Example:

Export subscribers on Router A
Export subscribers on specific OLT

5. Country ​

What It Is:

  • Filter by country

Options:

  • Select from dropdown
  • Shows all countries with subscribers

Example:

Export subscribers in Bangladesh
Export subscribers in specific country

6. Province ​

What It Is:

  • Filter by province/state

Options:

  • Select from dropdown
  • Shows all provinces with subscribers

Example:

Export subscribers in Dhaka Division
Export subscribers in specific province

7. City ​

What It Is:

  • Filter by city

Options:

  • Select from dropdown
  • Shows all cities with subscribers

Example:

Export subscribers in Dhaka City
Export subscribers in specific city

8. Area ​

What It Is:

  • Filter by area/locality

Options:

  • Select from dropdown
  • Shows all areas with subscribers

Example:

Export subscribers in Gulshan area
Export subscribers in specific area

Exported Fields ​

Re-Import Data (CSV) - 42 Fields ​

Basic Information:

  1. isp_id - ISP ID
  2. branch_id - Branch ID
  3. full_name - Subscriber full name
  4. username - Login username
  5. password - Empty (for security)
  6. connection_password - Radius password
  7. identity - National ID/Passport
  8. phone - Contact phone
  9. email - Email address
  10. address - Physical address

Service Information: 11. connection_type - 1=PPPoE, 2=Hotspot 12. nas_id - NAS ID 13. salesperson_id - Salesperson ID 14. package_id - Package ID 15. expiration_date - Service expiration 16. current_balance - Real-time balance

Location Information: 17. country_id - Country ID 18. province - Province/State ID 19. city_id - City ID 20. area_id - Area ID 21. subarea_id - Subarea ID 22. department_id - Department ID 23. latitude - GPS latitude 24. longitude - GPS longitude

Status & Settings: 25. profile_status - 1=Register, 2=Active, 3=Disable, 4=Terminated 26. sms_status - SMS notification status 27. mac_lock_status - MAC lock status 28. mac_address - MAC address 29. static_ip - Static IP address

Quota Information: 30. total_volume - Total data quota (MB) 31. used_volume - Used data quota (MB) 32. total_session - Total session quota (minutes) 33. used_session - Used session quota (minutes)

Discount Information: 34. discount_type - Discount type 35. discount - Discount amount

Infrastructure Information: 36. box_number - Distribution box number 37. box_address - Box address 38. switch_board - Switch board 39. switch_port - Switch port 40. electric_socket - Electric socket 41. cable_type - Cable type 42. uplink_port - Uplink port 43. fiber_code - Fiber code 44. fiber_color - Fiber color

Plain Data (XLSX) - 33 Fields ​

Basic Information:

  1. ID - Subscriber ID
  2. Fullname - Full name
  3. Username - Login username
  4. Connection Password - Radius password
  5. Identity - National ID/Passport
  6. Phone - Contact phone
  7. Email - Email address
  8. Address - Physical address

Service Information (Human-Readable): 9. Salesperson - Salesperson username 10. Package - Package name 11. NAS - NAS name 12. Profile Status - "Active", "Disable", "Terminated" 13. Connection Type - "Radius PPPoE", "Radius Hotspot" 14. Expiration Date - Service expiration 15. Current Balance - Real-time balance

Location Information (Human-Readable): 16. Country - Country name 17. Province - Province/State name 18. City - City name 19. Area - Area name 20. Subarea - Subarea name 21. Department - Department name 22. ISP - ISP company name 23. Branch - Branch name

Infrastructure Information: 24. Box Number - Distribution box 25. Box Address - Box address 26. Uplink Port - Uplink port 27. Fiber Code - Fiber code 28. Fiber Color - Fiber color 29. Switch Board - Switch board 30. Switch Port - Switch port 31. Backup Connection - Backup connection 32. Electric Socket - Electric socket 33. Cable Type - Cable type

Step-by-Step Guide ​

Step 1: Access Export Feature ​

Navigate to Export:

  1. Go to Subscribers menu
  2. Click "Export" button
  3. Export modal/page opens

Step 2: Select Filters (Optional) ​

Apply Filters:

Filter by Status:

  1. Select Profile Status dropdown
  2. Choose status (Active, Disable, etc.)
  3. Only selected status exported

Filter by Salesperson:

  1. Select Salesperson dropdown
  2. Choose salesperson
  3. Only their subscribers exported

Filter by Package:

  1. Select Package dropdown
  2. Choose package
  3. Only package subscribers exported

Filter by NAS:

  1. Select NAS dropdown
  2. Choose NAS
  3. Only NAS subscribers exported

Filter by Location:

  1. Select Country/Province/City/Area
  2. Choose location
  3. Only location subscribers exported

Multiple Filters:

  • Can combine multiple filters
  • All filters applied with AND logic
  • More filters = fewer results

No Filters:

  • Leave all filters empty
  • Exports ALL subscribers in ISP/Branch

Step 3: Select Export Type ​

Choose Export Type:

Option 1: Re-Import Data (CSV)

  1. Select "Re-Import Data" radio button
  2. CSV format selected
  3. Raw data with IDs
  4. Ready for re-import

Option 2: Plain Data (XLSX)

  1. Select "Plain Data" radio button
  2. Excel format selected
  3. Human-readable data
  4. For reporting/analysis

Step 4: Click Export ​

Initiate Export:

  1. Review selected filters
  2. Verify export type
  3. Click "Export" or "Submit" button
  4. System processes request

Step 5: System Processing ​

What Happens:

  1. System queries subscribers based on filters
  2. Calculates current balance for each subscriber
  3. Formats data based on export type
  4. Generates file (CSV or XLSX)
  5. Activity log created
  6. File download initiated

Processing:

1. Apply filters to query
2. Fetch subscriber data
3. For each subscriber:
   - Calculate current balance
   - Add to export array
4. Format data (CSV or XLSX)
5. Generate file
6. Log activity
7. Download file

Step 6: Download File ​

File Download:

Re-Import Data (CSV):

Filename: subscribers_exported_20251122211500.csv
Format: CSV
Size: Varies

Plain Data (XLSX):

Filename: subscribers_exported_20251122211500.xlsx
Format: Excel
Size: Varies

Success Message:

File downloaded successfully

If No Subscribers:

No Subscribers Found.

Step 7: Review Exported Data ​

Open File:

  1. Locate downloaded file
  2. Open with Excel/CSV viewer
  3. Review data

Verify:

  • Correct subscribers exported
  • All fields present
  • Current balance accurate
  • Filters applied correctly

Best Practices ​

Before Exporting ​

1. Plan Your Export

✅ Determine export purpose
✅ Choose appropriate export type
✅ Identify required filters
✅ Estimate data volume

2. Test with Filters

✅ Start with specific filters
✅ Verify filter results
✅ Expand filters if needed
✅ Avoid exporting unnecessary data

3. Choose Correct Export Type

✅ Re-Import CSV: For migration/backup
✅ Plain XLSX: For reporting/analysis
✅ Consider end use

During Export ​

1. Use Appropriate Filters

✅ Filter by status for specific groups
✅ Filter by location for area reports
✅ Filter by package for package analysis
✅ Combine filters for precise results

2. Verify Selection

✅ Review applied filters
✅ Check export type selected
✅ Ensure correct format

3. Monitor Processing

✅ Wait for file generation
✅ Don't close browser
✅ Allow download to complete

After Export ​

1. Verify Data

✅ Open exported file
✅ Check subscriber count
✅ Verify data accuracy
✅ Confirm all fields present

2. Secure Data

✅ Store file securely
✅ Protect sensitive information
✅ Backup if needed
✅ Delete when no longer needed

3. Use Data Appropriately

✅ Re-Import CSV: Import back if needed
✅ Plain XLSX: Analyze/report
✅ Share with authorized personnel only

Common Use Cases ​

Use Case 1: Data Backup ​

Scenario:

Need to backup all subscriber data
For disaster recovery
Re-import capability required

Steps:

  1. No filters (export all)
  2. Select "Re-Import Data" (CSV)
  3. Export
  4. Store file securely
  5. Can re-import if needed

Result:

  • Complete data backup
  • Ready for re-import
  • Disaster recovery prepared

Use Case 2: Monthly Report ​

Scenario:

Generate monthly subscriber report
For management review
Human-readable format needed

Steps:

  1. Filter by status: Active
  2. Select "Plain Data" (XLSX)
  3. Export
  4. Open in Excel
  5. Share with management

Result:

  • Clean report generated
  • Easy to read
  • Ready for presentation

Use Case 3: Area Analysis ​

Scenario:

Analyze subscribers in specific area
For expansion planning
Detailed data needed

Steps:

  1. Filter by Country/Province/City/Area
  2. Select "Plain Data" (XLSX)
  3. Export
  4. Analyze data
  5. Plan expansion

Result:

  • Area-specific data
  • Subscriber distribution visible
  • Expansion planning data

Use Case 4: Package Migration ​

Scenario:

Migrate subscribers to new system
Package-specific migration
Re-import required

Steps:

  1. Filter by package
  2. Select "Re-Import Data" (CSV)
  3. Export
  4. Migrate to new system
  5. Import CSV

Result:

  • Package subscribers exported
  • Ready for migration
  • Can re-import easily

Use Case 5: Reseller Report ​

Scenario:

Reseller wants subscriber list
For their own records
Human-readable format

Steps:

  1. Filter by salesperson (reseller)
  2. Select "Plain Data" (XLSX)
  3. Export
  4. Share with reseller
  5. Reseller reviews data

Result:

  • Reseller's subscribers only
  • Clean format
  • Easy to review

Use Case 6: Inactive Subscriber Analysis ​

Scenario:

Identify inactive subscribers
For cleanup or reactivation
Detailed analysis needed

Steps:

  1. Filter by status: Disable/Terminated
  2. Select "Plain Data" (XLSX)
  3. Export
  4. Analyze inactive subscribers
  5. Plan cleanup or reactivation

Result:

  • Inactive subscriber list
  • Analysis data ready
  • Cleanup/reactivation plan

Summary ​

Subscriber Export is a powerful data extraction feature that:

✅ Two Export Types:

  • Re-Import CSV: Raw data with IDs, ready for re-import
  • Plain XLSX: Human-readable data for reporting

✅ Advanced Filtering:

  • Profile Status (Active, Disable, etc.)
  • Salesperson (specific reseller)
  • Package (specific package)
  • NAS (specific router/OLT)
  • Location (Country, Province, City, Area)
  • Combine multiple filters

✅ Complete Data:

  • Re-Import: 42 fields including all data
  • Plain: 33 fields with readable names
  • Current balance included (real-time)
  • Infrastructure data included

✅ Use Cases:

  • Data backup and restore
  • Monthly reporting
  • Area analysis
  • Package migration
  • Reseller reports
  • Inactive subscriber analysis

✅ Features:

  • Activity logging
  • No subscriber limit
  • Fast processing
  • Automatic download
  • Timestamped filenames

✅ Security:

  • Password field empty in CSV (security)
  • Permission-based access
  • Secure file generation

Perfect for ISPs wanting flexible data export with multiple formats, advanced filtering, and complete subscriber information!

www.onezeroart.com

© 2025 Onezeroart LLC. All Rights Reserved.