Data Migration / Upload - FAQs
Smart360 Service Areas Management FAQs
Getting Started & Navigation
Q1: How do I access the Service Areas Management module in Smart360? A: Navigate to the main dashboard and click on "Service Areas Management" from the setup menu. You'll see a comprehensive interface with tabs for different entity types (Region, Country, State, City/County, Zone, Division, Areas, Sub-Areas, Premises) and a dashboard showing key performance indicators like Total Premises, Active Consumers, Service Areas count, Monthly Revenue, Active Meters, and Work Orders.
Q2: What user roles have access to Service Areas Management? A: Three primary user roles have access with different permission levels:
- Tenant Admin: Full system access across all utilities and regions, including bulk operations and system-wide analytics
- Utility Admin: Utility-specific access with regional management capabilities, entity management, and operational controls
- CIO Admin: Technical system management with data integrity oversight, audit capabilities, and technical maintenance features
Q3: What is the 9-level hierarchical structure used in Smart360? A: Smart360 uses a comprehensive hierarchy for geographic organization:
- Region → 2. Country → 3. State → 4. City/County → 5. Zone → 6. Division → 7. Areas → 8. Sub-Areas → 9. Premises Each level maintains parent-child relationships with automated validation and constraint enforcement to ensure data integrity.
Dashboard Overview & KPIs
Q4: What key performance indicators are displayed on the Service Areas dashboard? A: The dashboard shows monthly data for critical KPIs:
- Total Premises: Complete count of all premises in the system
- Active Consumers: Count of consumers with active status
- Service Areas: Total count across all hierarchy levels (Region + Country + State + City/County + Zone + Division + Areas + Sub-Areas + Premises)
- Monthly Revenue: Financial performance in millions with percentage growth
- Active Meters: Meter count assigned to active consumers
- Work Orders: Total service order count Progress indicators compare current month to last month for trend analysis.
Q5: How do I interpret the growth trend monitoring? A: The system tracks 6-month growth trends (January through June) with:
- Stacked visualization: Cumulative growth display
- Two-tier tracking: Active consumers count vs. number of premises
- Scale monitoring: Values from 0 to 60,000 scale
- Monthly progression: Sequential tracking for trend analysis This helps identify performance patterns and growth trajectories across your service territories.
Q6: How often is dashboard data updated? A: Dashboard KPIs display monthly data with real-time updates for:
- Consumer status changes (active/inactive)
- New premise additions
- Revenue collection updates
- Work order completions
- Meter activations Progress indicators automatically compare to the previous month to show growth or decline trends.
Entity Creation & Management
Q7: How do I create a new service area entity? A: To create a new entity:
- Select the appropriate tab for the entity type you want to create
- Click the "Add" button (button name matches the selected tab)
- Fill in the mandatory fields:
- Entity Type: Auto-selected based on your tab choice
- Division Name: Must be unique (marked with *)
- Parent Entity: Select from dropdown of existing parent entities (marked with *)
- Add optional information:
- Description: Multi-line text for management responsibilities
- Tags: Add searchable tags for categorization
- Set Status: Active (default) or Inactive
- Click "Create Division" to save
Q8: What validation rules apply when creating entities? A: Several validation rules ensure data integrity:
- Unique names: Division names must be unique across the system
- Mandatory fields: Division Name and Parent Entity are required
- Hierarchy consistency: Parent entity must exist and be appropriate for the entity type
- Status rules: Active entities require active parent entities
- Tag format: Tags follow approved taxonomy standards
- Description length: Must be between 10-500 characters if provided
Q9: How does the parent entity selection work? A: Parent entity selection is hierarchy-dependent:
- Dropdown population: Shows only valid parent entities for your selected entity type
- Hierarchy enforcement: For example, if creating a Premise, only Sub-Area values are displayed
- Real-time filtering: Available options update based on your entity type selection
- Validation: System prevents invalid parent-child relationships
- Mandatory selection: Must select a parent entity before creating the entity
Search & Filtering
Q10: How does the global search functionality work? A: The global search provides comprehensive search capabilities:
- Universal search: Search by any service area name across all entity types
- Auto-complete: Real-time suggestions as you type
- Result display: Shows service area name and entity type
- Direct navigation: Click on results to open the detail view
- Cross-hierarchy: Search spans all 9 hierarchy levels
- Quick access: Fastest way to locate specific entities
Q11: What filtering options are available on each tab? A: Each entity type tab provides consistent filtering:
- Search by name: Find entities by their division name
- Status filter: Filter by Active or Inactive status
- Universal functionality: All tabs (Region through Premises) have the same filtering capabilities
- Real-time results: Filters apply immediately as you type or select
- Combined filtering: Use search and status filter together for precise results
Q12: How do I efficiently navigate between different entity types? A: Navigation is streamlined through:
- Tab structure: Nine tabs for each entity type provide organized access
- Breadcrumb navigation: Shows your current location in the hierarchy
- Drill-down capability: Click entity names to view child entities
- Back navigation: Easy return to parent entity views
- Consistent interface: Same functionality across all tabs for familiar experience
Entity Detail Views
Q13: What information is displayed in the entity detail view? A: Entity detail views provide comprehensive information: Basic Information Section:
- Status, Created by, Last updated, Last updated by
- Child entity count, Entity type, Tags Two-Tab Structure:
- Overview Tab: Consumer count, Meters, Meter readings, Revenue, Bills, Service requests, Complaints, Work orders
- Child Entities Tab: List of child entities with search and filter capabilities (not available for Premises)
- Search functionality: Find child entities by name
- Multi-criteria filtering: Filter by type, status, created by
- List view displays: Name, type, status, created by, consumer count, meters
- Drill-down navigation: Click child entity names to view their details
- Performance monitoring: Track metrics across child entities
- Hierarchical view: Understand parent-child relationships visually
Q15: What operational metrics are tracked for each entity? A: The Overview tab displays comprehensive operational metrics:
- Consumers: Total consumers attached to the entity
- Meters: Total meters attached to the entity
- Meter readings: Total readings for the entity
- Revenue: Total payments received for the entity
- Bills: Total approved bills generated
- Service requests: Total service request count
- Complaints: Total complaints count
- Work orders: Total work orders count All metrics aggregate data from child entities automatically.
Bulk Operations & Data Import
Q16: How do I perform bulk import of service area data? A: The bulk import process follows these steps:
- Select entity type: Choose which entity type to import
- Download template: Click download button to get CSV template with required fields
- Prepare data: Fill template with name, description, parent, status, tags (name and parent are mandatory)
- Upload CSV: Upload your completed file
- Auto-processing: System processes and validates your data
- Review validation: Check validation results and fix any errors
- Complete import: Finalize the import process
Q17: What does the validation process check during import? A: The validation process categorizes records into three types:
- Valid records: No issues found, ready for import
- Warning records: Duplicates found - "duplicate found, it will be replaced with the existing"
- Error records: Critical issues requiring correction:
- "missing name" - Name field is empty
- "wrong parent attached" - Parent entity doesn't exist in system
- "missing parent entity" - Parent field is empty You can edit name, description, and parents to resolve issues.
Q18: How do I handle validation errors during import? A: Error resolution process:
- Review validation results: Check valid, warning, and error counts
- Filter by issue type: Focus on specific validation categories
- Edit problematic records: Correct name, description, and parent fields
- Re-validate: System automatically re-validates edited entries
- Delete rows: Remove problematic records if needed
- Update status: Track progress as issues are resolved All errors must be resolved before completing the import.
Status Management & Entity Lifecycle
Q19: What are the different entity statuses and their meanings? A: Entities can have two primary statuses:
- Active: Entity is operational and included in billing processes, consumer assignments, and operational activities
- Inactive: Entity is excluded from operations but data is preserved for historical reference Status changes affect child entities - inactive entities cannot have active child entities, maintaining hierarchy integrity.
Q20: How do I change an entity's status? A: To change entity status:
Q21: What happens to child entities when I deactivate a parent entity? A: When deactivating parent entities:
- Hierarchy validation: System checks for active child entities
- Cascade consideration: You may need to deactivate child entities first
- Data preservation: All historical data remains intact
- Operational exclusion: Inactive entities are excluded from operations
- Reporting impact: Inactive entities may not appear in operational reports Plan status changes carefully to maintain hierarchy integrity.
Tags & Categorization
Q22: How do I use tags effectively for entity organization? A: Tags provide flexible categorization:
Q23: Can I search entities by their tags? A: Yes, tags enhance search capabilities:
- Tag-based filtering: Use tags to categorize and filter entities
- Search integration: Tags are included in search functionality
- Cross-reference: Find all entities with specific tags
- Organization tool: Group related entities regardless of hierarchy level
- Reporting utility: Use tags for custom reports and analysis
Q24: How do I maintain consistent tagging across my organization? A: Tag management best practices:
- Standardized taxonomy: Develop approved tag naming conventions
- Training: Ensure all users understand tagging standards
- Regular review: Periodically audit and clean up tags
- Documentation: Maintain a list of approved tags and their meanings
- Consistency checks: Review entities for proper tag application
Performance & Analytics
Q25: How do I analyze performance across different service areas? A: Performance analysis tools include:
- Operational metrics: Compare consumer counts, revenue, and service requests across entities
- Child entity analysis: Drill down to see performance at granular levels
- Trend monitoring: Track 6-month growth patterns
- Comparative views: Compare similar entities within the same hierarchy level
- Dashboard insights: Use KPI data to identify high and low-performing areas
- Historical tracking: Monitor changes over time for trend identification
Q26: What reports can I generate from service area data? A: Available reporting includes:
- Hierarchy reports: Complete organizational structure with all entities
- Performance summaries: Operational metrics by entity type
- Growth analysis: Trend reports showing expansion patterns
- Exception reports: Entities requiring attention or maintenance
- Export capabilities: CSV downloads for external analysis
- Custom filtering: Generate reports for specific entity types or regions
Q27: How do I identify underperforming service areas? A: Performance identification strategies:
- Metric comparison: Compare operational metrics across similar entities
- Trend analysis: Identify areas with declining performance
- Exception monitoring: Watch for unusual patterns in service requests or complaints
- Resource allocation: Review meter and consumer ratios
- Revenue analysis: Identify areas with collection challenges
- Child entity performance: Drill down to identify specific problem areas
Data Quality & Maintenance
Q28: How do I ensure data quality across the service area hierarchy? A: Data quality measures include:
- Automated validation: Real-time checks during entity creation and modification
- Hierarchy constraints: Automated parent-child relationship validation
- Unique name enforcement: Prevention of duplicate entity names
- Regular audits: Periodic review of entity data for consistency
- Change tracking: Complete audit trail of all modifications
- Error prevention: Validation rules prevent common data quality issues
Q29: What should I do if I discover data inconsistencies? A: Data inconsistency resolution:
- Identify the scope: Determine how many entities are affected
- Document issues: Record what inconsistencies were found
- Prioritize fixes: Address critical operational issues first
- Use edit functionality: Correct individual entity data through edit forms
- Bulk operations: For large-scale issues, use import functionality to correct multiple entities
- Verify fixes: Confirm that corrections maintain hierarchy integrity
- Prevent recurrence: Implement processes to prevent similar issues
Q30: How do I maintain optimal system performance with large datasets? A: Performance optimization strategies:
- Regular maintenance: Periodically review and clean up unused entities
- Efficient searching: Use specific search terms rather than broad queries
- Filtered views: Apply filters to work with smaller data subsets
- Bulk operations: Use import/export for large-scale changes rather than individual edits
- Status management: Keep inactive entities properly marked to exclude from operations
- Hierarchy planning: Design efficient entity structures to minimize complexity
- Monitor usage: Track system performance and adjust practices as needed