SmartFusion Modules > System Setup > Data Entry > System File > UB AQ2 Scanner Export Settings

Recent Change: 

6.231
- Added new system setting for exporting utility data  information for AQ2 Scanner.The export will pick up any customer with a balance and would produce a comma delimited file with the Account Number, Customer name, Mailing Address, service address route,sequence and balance. All of the fields would be surrounded by quotes. 
- Added stored procedures and a view to create a SQL Server Agent Job and execute it

Introduction

This system setting allows the creation of an export file with information of customers with a balance for AQ2 Scanner.

In addition, a compatible version of SQL Server with SQL Server Agent functionality is required. Specifically, SQL Server Express is not supported.

Selections

AQ2 Settings

Export Settings
  • Time interval for export (in hours)
  • File path for export
  • Last time synced (MM/dd/yyyyy hh:mm:ss format)- This will get set every time the export file is created.

Export File Layout: Export file created with name as "aq2_YYYYMMDD_organization name.csv"

Field Description
cacct_no Utility account number
ccust_name Customer name
cmailing_addr1 Mailing address line 1
cmailing_addr1 Mailing address line 2
cservice_address Location address
cbalance Customer balance for location
RouteNumber Location route number
RouteSequence Location route sequence