Data Exchange Warnings FAQ

Q: When importing a Data Exchange file, we received the following warning message: “Installation for meter 40912 is dated Jan 27, 2014 12:00 PM, which will remove it from services at other locations over a period from Jan 24, 2014 12:00 PM to present.” Is it safe to ignore these warnings?

A: When you see warning messages such as “Installation for meter XXX is dated YYY, which will remove it from services at other locations over a period from ZZZ to present,” the system is letting you know that you are about to perform an action that will make a service configuration change.

If the change is one that you intended to make, then it is safe to proceed with the import. If, however, you did not want to make the change, then you should cancel the import, locate the row and change the offending data.

To verify that the change you are about to make is one you intended, compare the data as it is in AquaCUE versus the data you are about to import. Focus on the following data as it appears in AquaCUE and in the Data Exchange file being validated:

Meter_ID Register_Number Endpoint_SN Location_ID Service_
Point_ID
Account_ID

 

And these date fields:

 

Meter_
Install_Date
Meter_
Removal_Date
Endpoint_
Install_Date
Endpoint_
Removal_
Date
Service_
Agreement_
Start_Date
Service_
Agreement_
End_Date

 

To see the data in its current state in the system, do one of the following:

  • Download and review the latest Data Exchange file import that pertained to Meter XXX

or

  • Enter the Meter ID in the Search Box and press enter.
  • Expand the Card for Meter XXX.
  • Click the Location, Meter and Endpoint tabs to see the meter ID, register number (if the meter is a compound), endpoint serial number and location ID.

To see the dates and Service_Point_ID for Meter XXX’s location as they are currently stored in the system, do one of the following:

  • Download and review the latest Data Exchange file import that pertained to Meter XXX

or

  • Get the current Location_ID for Meter ID XXX by entering Meter ID XXX into the search box, expanding its card and clicking on the Location tab.
  • Go to Assets>Data Exchange Diagnostics, enter the Location ID for Meter XXX in the Service Location pull-down menu and select it.
  • Compare the most recent dates with those in the Data Exchange file that triggered the warning message.

Remember the warning message states that the action you are about to perform if you accept the Data Exchange import will remove Meter XXX from services at other locations that span a given time frame. Therefore, you should check the following:

 

Field What to look for in What to do if the Data Exchange File answer is
AquaCUE the Data Exchange file No Yes
Meter_ID Is it the Meter you intended? Is it the Meter you intended? Enter the right Meter ID in the Data Exchange file. Check the next field.
Register_
Number
Is the Meter a compound or single-register meter? Does the information match what is in AquaCUE? Make note of the register you are about to update/change. Check the next field.
Endpoint_SN Is it the Endpoint you expected?

If there is no Endpoint associated with the meter, is that what you expected?

Is the Endpoint_SN different from the one in AquaCUE and did you intend it to be different? If no is the desired answer, check the next field.

If no is not the desired answer, enter the correct Endpoint_SN in the Data Exchange file.

If yes is the desired answer, check the next field.
If yes is not the desired answer and you didn’t expect the Endpoint_SN to be different, enter the SN you expected.
Location_ID Is it the Location you intended? Is the Location_ID the same as the one the Meter is associated with in AquaCUE? If no is the desired answer, it means you are using the Data Exchange file to record move the Meter to a new location. If yes is the desired answer, check the Serivce_Point_
ID field.
Service_Point_
ID
What is the Service_Point_
ID?
Is the Service_Point_
ID the same as the one the Meter is currently associated with in AquaCUE?
If no is the desired answer, it means you are using the Data Exchange file to move the Meter to a new service point at a new location or a new service point at the same location. If yes is the desire answer, but the Location ID has changed, it means you are using the Data Exchange file to move the meter to a new location.
Account_ID What is the Account_ID? Is the Account_ID the same as the one the Meter is currently associated with in AquaCUE? If no is the desired answer, it is evidence that you intend to move the meter to a new location with a different account holder. If yes is the desired answer, it could mean that the meter is being moved to a new location that belongs to the previous account holder or you have not updated the Account_ID.

 

When examining dates, you are simply verifying that the date(s) displayed on the Data Exchange Diagnostics page and the date(s) in the warning message align as expected.

 

Meter_
Install_Date
Meter_
Removal_Date
Endpoint_
Install_Date
Endpoint_
Removal_Date
Service_
Agreement_Start_Date
Service_
Agreement_
End_Date

 

The warning message you received stated that your Data Exchange file showed Meter 40912 being installed on Jan 27, 2014. The warning also said Meter 40912 would be removed from services at other locations over a period from YYY to the present. YYY should be its original Meter_Install_Date, which you can verify by looking at its Service Location on the Data Exchange Diagnostics page.

 

If all of those factors line up as expected, it is safe to proceed with the import. If they do not line up as expected, alter your Data Exchange file accordingly.

 

Looked at another way, comparing the data currently in AquaCUE (row 1) and the data in the Data Exchange file that is being validated (row 2) reveals the following:

 

Meter_ID Register_
Number
Endpoint_
SN
Location_
ID
Service_Point_
ID
Account_
ID
Meter_Install_
Date
1 40912 0 17092120 415551 5 626968 2014-01-24
2 40912 0 420561 3 607613 2014-01-27

 

As you can see in this example, the fact that five of the fields contain new data indicates Meter 40912 was clearly moved to a new location that did not have an endpoint on Jan 27, 2014. If that was the result you wanted to achieve, accept the import.

KNOWLEDGE BASE



User Guide