How do I resequence based on date/time from import file?

Meter Reading Route and Sequences

Use Resequence Based on Date/Time from Import File to use the date/time from the import file to renumber the reading sequence for the selected service.

Contents

How do I resequence based on date/time from import file?
Before you get started
1. Resequencing based on date/time from import file

Before you get started

Back up the Utility Management database. See the help topic titled How do I back up the database?

Resequencing based on date/time from import file

1. Open Connect Utility Management > Meters > Modify Reading Route/Sequences.

2. Click to select Resequence Based on Date/Time from Import File.

3. Select a Service.

The routine will use the reading route/sequence assigned to the selected service.

4. Set up the checkbox titled Assign the Same Sequence to All Services.

Use Resequence Based on Date/Time from Import File to use the date/time from the import file to renumber the reading sequence for the selected service.

5. Enter the New Beginning Read Sequence.

Use the beginning read sequence and define the first number to renumber..

6. Enter the Increment Sequences By.

This is the value to increase the sequence number. For example, Jane wants to increase sequence numbers by increments of 10. She uses 10 as the New Beginning Sequence Number and enters 10 in the Increment Sequences By field. When the routine runs, the sequence numbers are assigned like this: 10, 20, 30, 40, 50...

7. Select the Import Format.

The import format is the form that defines the fields and field order that the routine will use to import data from the meter reading file. A list of valid meter reading import formats displays in the Import Format drop-down list.

8. Enter the Import File Name.

The import filename is the filename and file location.

What is the import filename?

The import file is located in the Connect directory. All of the Connect applications are located in the default d:\Connect directory, where you replace d:\ with the appropriate drive letter. If the import file was created and saved to the Connect default directory, then you only need to enter the import filename and extension. For example, ImportFileName.txt
The import file is located in a local or network directory. If you are importing a file that is stored on a disk or hard drive, type in the drive letter and path followed by the import filename and extension. Example: d:\my documents\ImportFileName.txt

9. Click GO (CTRL+G).

The routine uses the read date and time recorded in the import file to reunumber the reading sequence.

Updated on 20Jun2017.