Skip to content

FlexibleExport Manual

FlexibleExport is a specialized feature of Smart Tech App designed for Excel integration workflows. It allows you to export meter data in a format that maintains perfect alignment with Excel spreadsheets containing meter UUIDs.

Overview

FlexibleExport provides:

  • Excel-compatible TSV output with perfect column alignment
  • UUID order preservation for copy-paste workflows
  • Configurable media preferences (electricity, water, heat)
  • Decimal separator options (comma/dot)
  • Permission-aware processing with user access control

Export Format

FlexibleExport currently supports CSV format only:

  • Standard comma-separated values format
  • Excel-compatible TSV (tab-separated) output for perfect column alignment
  • UTF-8 encoding support
  • Configurable headers and delimiters

Configuration Options

Media Preferences

Configure which values to export for each meter type:

  • Electricity Meters:
  • active_energy: Active energy consumption (kWh)

  • reactive_energy: Reactive energy consumption (kVArh)

  • Water Meters:

  • value: Volume consumption (m³)

  • Heat Meters:

  • value_kwh: Heat consumption in kWh
  • value_gj: Heat consumption in GJ (gigajoules)

Decimal Separator

  • Comma: European format (1500,25)
  • Dot: International format (1500.25)

UUID Processing

  • Empty rows preserved: Maintains Excel alignment
  • Short UUIDs filtered: Headers and descriptions ignored
  • Order preservation: Results match input order exactly

Using FlexibleExport

Via Web Interface

Step 1: Navigate to Export Section

  • Log into Smart Tech App
  • Click on "Export" in the left sidebar

Main Navigation

Step 2: Copy UUIDs from Excel

  • Select the entire UUID column in Excel (including empty cells)
  • Copy the selection (Ctrl+C)
  • Navigate to FlexibleExport in the Smart Tech App
  • Paste UUIDs into the textarea
  • Configure target month and preferences

Copy Data Workflow

Step 3: Export and Paste Results

  • Click "Export" to process the data
  • Copy the export results from Smart Tech App
  • Switch back to Excel
  • Paste the results into adjacent columns

Paste Data Results

Export Results

The FlexibleExport results include three columns:

  • UUID: The meter identifier (matches your input order)
  • Value: The meter reading value (formatted according to decimal separator preference)
  • Comment: Timing information about the reading relative to month end

Comment Column Examples

The comment column provides context about when the reading was taken:

  • Last day of month - Reading taken on the last day of the target month (ideal)
  • 1 day before month end - Reading taken one day before month end
  • 3 days before month end - Reading taken three days before month end
  • Missing timestamp - Technical issue with reading timestamp
  • Meter not found - UUID not found or no access permission
  • No data for specified month - No readings available for the target month
  • Ignored (too short) - UUID too short (likely header text)

Best Practices

  • Excel Workflow: Copy entire UUID columns including empty cells for best alignment
  • Media Preferences: Set consistent preferences across all exports for the same project
  • Month Selection: Use last complete month for most accurate data
  • Permission Management: Ensure users have access to all required concentrators
  • UUID Validation: Clean up headers and short text before copying from Excel

Troubleshooting

Common Issues

"Meter not found" Errors - Check if UUIDs are correct and complete (minimum 20 characters) - Verify you have permission to access the meter's concentrator - Remove headers and descriptive text from UUID list

"No data for specified month" Warnings - Meter may not have been active during that period - Check if meter was recently installed - Try adjacent months to verify meter activity

Permission Denied Messages - Contact administrator to grant access to required concentrators - Check your UserConcentrator permissions - Verify the meter belongs to a concentrator you can access

Excel Alignment Issues - Ensure you're copying the entire column including empty cells - Use TSV format for best Excel compatibility - Paste as "Text" to preserve formatting

Decimal Format Problems - Match decimal separator to your Excel locale settings - Use "comma" for European Excel, "dot" for US Excel - Check regional settings if numbers appear incorrectly