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.