Règles pour la création, la mise à jour et la modification des données

Chaque champ d’un fichier d’échange de données contient des informations accomplissant l’une des actions suivantes lors de l’importation :

  • création de nouvelles données;
  • mise à jour de données existantes;
  • modification d’identifiants uniques (ID).

Pour effectuer ces tâches, le système recherche certains ID faisant office de clés afin d’indiquer au système quels comptes, emplacements, points de raccordement, compteurs et points de terminaison sont associés aux données. C’est pourquoi les champs Account_ID, Location_ID, Service_Point_ID (lorsqu’un emplacement présente plusieurs services), Meter_ID et Endpoint_SN sont obligatoires.

Lorsque vous créez et mettez à jour des données dans votre système, vous pouvez effectuer les actions suivantes :

  • Importer toutes vos données existantes, de nouvelles données ou des données révisées dans un fichier d’échange de données.
    • N’oubliez pas que l’importateur ne met à jour que les champs contenant des données modifiées et que des importations successives des mêmes données sont ignorées.
  • Importer un fichier d’échange de données contenant uniquement des données nouvelles ou révisées.
  • Utilisez plusieurs fichiers d’échange de données pour créer ou mettre à jour n’importe quelle combinaison de champs de données. Par exemple, utilisez un fichier d’échange de données pour mettre à jour les compteurs, un autre pour ouvrir et fermer des comptes et un troisième pour modifier les informations sur l’emplacement.CONSEIL : Choisissez des noms de fichier qui vous permettront de connaître la tâche effectuée en un coup d’œil.

Chaque ligne de données des fichiers d’échange de données doit inclure les ID nécessaires pour associer les données aux comptes, emplacements, points de raccordement, compteurs et points de terminaison adéquats.

Utilisez le tableau des règles d’échange de données ci-dessous pour savoir quels ID sont requis pour créer ou mettre à jour des champs de données. Consultez la section Mise à jour des ID pour obtenir des instructions détaillées sur la manière de modifier ou de corriger des ID.

Règles de l’échange des données

Nom de la colonne du champ d’échange de données ID requis pour CRÉER ID requis pour METTRE À JOUR
Informations du compte
Account_ID Account_ID Account_ID
Account_First_Name Account_ID Account_ID
Account_Last_Name Account_ID Account_ID
Account_Full_Name Account_ID Account_ID
Account_Email Account_ID Account_ID
Account_Phone Account_ID Account_ID
Billing_Address_Line1 Account_ID Account_ID
Billing_Address_Line2 Account_ID Account_ID
Billing_Address_Line3 Account_ID Account_ID
Billing_City Account_ID Account_ID
Billing_State Account_ID Account_ID
Billing_Zip Account_ID Account_ID
Billing_Country Account_ID Account_ID
Person_ID Account_ID Account_ID
Account_Status Account_ID Account_ID
Nom de la colonnedu champ d’échange de données ID requis pour CRÉER ID requis pour METTRE À JOUR
Emplacement
Location_ID Location_ID Location_ID
Location_Name Location_ID Location_ID
Location_Address_Parity Location_ID Location_ID
Location_Address_Line1 Location_ID Location_ID
Location_Address_Line2 Location_ID Location_ID
Location_Address_Line3 Location_ID Location_ID
Location_City Location_ID Location_ID
Location_State Location_ID Location_ID
Location_Zip Location_ID Location_ID
Location_County_Name Location_ID Location_ID
Location_Country Location_ID Location_ID
Location_Latitude Location_ID Location_ID
Location_Longitude Location_ID Location_ID
Location_Building_Type Account_ID,
Location_ID
Account_ID,
Location_ID
Location_Building_Number Account_ID,
Location_ID
Account_ID,
Location_ID
Location_Site Account_ID,
Location_ID
Account_ID,
Location_ID
Location_Funding Account_ID,
Location_ID
Account_ID,
Location_ID
Location_Main_Use Account_ID,
Location_ID
Account_ID,
Location_ID
Location_Water_Type Account_ID,
Location_ID
Account_ID,
Location_ID
Location_Area Account_ID,
Location_ID
Account_ID,
Location_ID
Location_Irrigated_Area Account_ID,
Location_ID
Account_ID,
Location_ID
Location_Population Account_ID,
Location_ID
Account_ID,
Location_ID
Location_Irrigation Account_ID,
Location_ID
Account_ID,
Location_ID
Location_Year_Built Account_ID,
Location_ID
Account_ID,
Location_ID
Location_Pool Account_ID,
Location_ID
Account_ID,
Location_ID
Location_Bathrooms Account_ID,
Location_ID
Account_ID,
Location_ID
Location_District Account_ID,
Location_ID
Account_ID,
Location_ID
Location_DHS_Code Account_ID,
Location_ID
Account_ID,
Location_ID
Location_ET_Jan Account_ID,
Location_ID
Account_ID,
Location_ID
Location_ET_Feb Account_ID,
Location_ID
Account_ID,
Location_ID
Location_ET_Mar Account_ID,
Location_ID
Account_ID,
Location_ID
Location_ET_Apr Account_ID,
Location_ID
Account_ID,
Location_ID
Location_ET_May Account_ID,
Location_ID
Account_ID,
Location_ID
Location_ET_Jun Account_ID,
Location_ID
Account_ID,
Location_ID
Location_ET_Jul Account_ID,
Location_ID
Account_ID,
Location_ID
Location_ET_Aug Account_ID,
Location_ID
Account_ID,
Location_ID
Location_ET_Sep Account_ID,
Location_ID
Account_ID,
Location_ID
Location_ET_Oct Account_ID,
Location_ID
Account_ID,
Location_ID
Location_ET_Nov Account_ID,
Location_ID
Account_ID,
Location_ID
Location_ET_Dec Account_ID,
Location_ID
Account_ID,
Location_ID
Nom de la colonnedu champ d’échange de données ID requis pour CRÉER ID requis pour METTRE À JOUR
Service_Point_ID Location_ID,Service_Point_ID Location_ID,Service_Point_ID
Service_Point_Type Location_ID,Service_Point_ID Location_ID,Service_Point_ID
Service_Point_Cycle Location_ID,Service_Point_ID Location_ID,Service_Point_ID
Service_Point_Route Location_ID,Service_Point_ID Location_ID,Service_Point_ID
Service_Point_Class_
Code
Location_ID,Service_Point_ID Location_ID,Service_Point_ID
Service_Point_Class_
Code_Normalized
Location_ID,Service_Point_ID Location_ID,Service_Point_ID
Service_Point_Latitude Location_ID,Service_Point_ID Location_ID,Service_Point_ID
Service_Point_Longitude Location_ID,Service_Point_ID Location_ID,Service_Point_ID
Service_Point_Timezone Location_ID,Service_Point_ID Location_ID,Service_Point_ID
Nom de la colonnedu champ d’échange de données ID requis pour CRÉER ID requis pour METTRE À JOUR
Meter_ID Meter_ID,Register_
Number,Register_
Resolution,Register_Unit_Of_Measure
Meter_ID,
Register_Number
Meter_SN (Numéro de série du compteur) Meter_ID,Register_
Number,Register_
Resolution,Register_Unit_Of_Measure
Meter_ID,
Register_Number
Meter_Manufacturer Meter_ID,Register_
Number,Register_
Resolution,Register_Unit_Of_Measure
Meter_ID,
Register_Number
Meter_Model Meter_ID,Register_
Number,Register_
Resolution,Register_Unit_Of_Measure
Meter_ID,
Register_Number
Meter_Size Meter_ID,Register_
Number,Register_
Resolution,Register_Unit_Of_Measure
Meter_ID,
Register_Number
Meter_Note Meter_ID,Register_
Number,Register_
Resolution,Register_Unit_Of_Measure
Meter_ID,
Register_Number
Meter_Continuous_Flow Account_ID,
Location_ID,
Meter_ID
Account_ID,
Location_ID,
Meter_ID
Register_Number Meter_ID,Register_
Number,Register_
Resolution,Register_Unit_Of_Measure
Meter_ID,
Register_Number
Register_Unit_Of_Measure Meter_ID,Register_Number,Register_Resolution,Register_Unit_Of_Measure Meter_ID,
Register_Number
Register_Resolution Meter_ID,Register_
Number,
Register_Resolution,
Register_Unit_Of_Measure
Meter_ID,
Register_Number
Meter_Install_Date Meter_ID,Register_Number,Register_Resolution,Register_Unit_Of_Measure,Location_ID,Service_Point_ID Meter_ID,Register_Number,Location_ID,Service_Point_ID
Meter_Install_Start_Read Meter_ID,Register_Number,Register_Resolution,Register_Unit_Of_Measure,Location_ID,Service_Point_ID Meter_ID,Register_Number,Location_ID,Service_Point_ID
Meter_Removal_Date Meter_ID,Register_Number,Register_Resolution,Register_Unit_Of_Measure,Location_ID,Service_Point_ID Meter_ID,Register_Number,Location_ID,Service_Point_ID
Meter_Removal_End_Read Meter_ID,Register_Number,Register_Resolution,Register_Unit_Of_Measure,Location_ID,Service_Point_ID Meter_ID,Register_Number,Location_ID,Service_Point_ID
Nom de la colonnedu champ d’échange de données ID requis pour CRÉER ID requis pour METTRE À JOUR
SA_Start_Date Account_ID,
Location_ID,
Service_Point_ID
Account_ID,
Location_ID,
Service_Point_ID
SA_End_Date Account_ID,
Location_ID,
Service_Point_ID
Account_ID,
Location_ID,
Service_Point_ID
Configuration du point de terminaison
Endpoint_SN Endpoint_SN,Endpoint_Type,Meter_ID,Location_ID,Account_ID,Service_Point_ID,Register_Number Endpoint_SN,Endpoint_Type,Meter_ID,Location_ID,Account_ID,Service_Point_ID,Register_Number
Endpoint_Type Endpoint_SN,Endpoint_Type,Meter_ID,Location_ID,Account_ID,Service_Point_ID,Register_Number Endpoint_SN,Endpoint_Type,Meter_ID,Location_ID,Account_ID,Service_Point_ID,Register_Number
Endpoint_Install_Date Endpoint_SN,Endpoint_Type,Meter_ID,Location_ID,Account_ID,Service_Point_ID,Register_Number Endpoint_SN,Endpoint_Type,Meter_ID,Location_ID,Account_ID,Service_Point_ID,Register_Number
Endpoint_Removal_Date Endpoint_SN,Endpoint_Type,Meter_ID,Location_ID,Account_ID,Service_Point_ID,Register_Number Endpoint_SN,Endpoint_Type,Meter_ID,Location_ID,Account_ID,Service_Point_ID,Register_Number
Nom de la colonnedu champ d’échange de données ID requis pour CRÉER ID requis pour METTRE À JOUR
Read_Sequence Meter_ID,
Register_Number
Meter_ID,
Register_Number
Alert_Code Meter_ID,
Register_Number
Meter_ID,
Register_Number
High_Read_Limit Meter_ID,
Register_Number
Meter_ID,
Register_Number
Low_Read_Limit Meter_ID,
Register_Number
Meter_ID,
Register_Number
Informations diverses
Utility_Use_1 Account_ID Account_ID
Utility_Use_2 Account_ID Account_ID
Knowledge Base

User Guide
Follow via Email

Enter your email address to get new content notifications by email.

%d bloggers like this: