Advanced Computer Services LLC
ACS 5 updatesCustomer support
ACSUtility billing software

Software help

Export and Import Route and Sequence | ACS Utility Billing Help

Export customer route and sequence numbers to a tab-delimited text file, edit them outside ACS, and import the changes back into customer records.

Using this option

  1. Choose Extras > Error Recovery > Export and Import Route and Sequence. Set Path and File Name, then choose Export. Export replaces an existing file at that location.
  2. Keep an untouched copy of the export. Open the working file as tab-delimited text and treat Account Key as text so zeros and account formatting are preserved.
  3. Edit Route and Sequence. Retain the Account Key, Route, and Sequence headings and save as tab-delimited text, not an Excel workbook or comma-delimited file.
  4. Back up the company, return to this option, select the edited file, and choose Import.
  5. Review the completion or error message, then check customer route/sequence values and the resulting reading order.

Notes

The import validates headings, account keys, numeric values, and routes against the company's configured low/high route range before its write pass.

Only Route and Sequence are changed; other columns in the export are for reference. An invalid account or route reports the failing line so it can be corrected.

The validation pass is not a transactional rollback guarantee if a later file or write error occurs. Keep the original export and backup until the results have been checked.

Related help