Share
 
 

Demand Update from CSV

Existing customer points and any allocated demand data at nodes in the network can be updated by using the Demand Update Wizard.

The Demand Update Wizard imports data from a CSV file (an example is given below). The wizard matches the Key field of the customer points in the CSV data to the Key field in the Customer Points Table. Any records where the Key fields do not match are ignored. Records where Key fields match are overwritten. If any field contains a value, that value will be used to overwrite the existing value in the Customer Points table.

There are options to update the following fields:
  • Category Type
  • User Category
  • Number of Properties
  • Specific Consumption
  • Average Demand
  • Direct Demand Factor

For details about what should be in these fields, see Customer Point Data Fields .

If the customer point is allocated to a node, node demand data will be replaced with the new data from the customer point.

Note: When updating the Customer Point table, InfoWorks WS Pro always replaces any field where the incoming field is not blank. It is up to you to ensure that the data that is being imported contains valid values for the fields that are being set.

See Demand Update Wizard for detailed information.

Format for Demand Update from CSV Files

The only fields in the CSV file that must have data in it is the Reference field. If the Reference value does not match a customer point already in the database, the record is ignored. All other fields are optional. If any field contains a value, that value will be used to overwrite the existing value in the Customer Points table.

There are no column headers. The columns may be arranged in any order as mapping of the InfoWorks database fields to the CSV fields is defined during the acquisition phase of the Demand Update Process.

An example of the layout of a CSV file to be used for Demand Update is given below where the columns are as follows:
  1. Identifier
  2. X coordinate
  3. Y coordinate
  4. Number of Properties 
AP00978B5FF5,579880.272,113056.695,5
AP00978U5BY5,579880.272,113056.695,15
AP00978U5E55,579879.972,113096.095,8
AP009Q8B5T75,579880.272,111009.695,6
AP00C78W5T95,579879.272,110267.495,4
AP00C88W5275,579879.272,110493.395,1
AP00FQ8B50H5,579879.372,112225.495,1
AP00FQ8B5E15,579879.572,112348.795,1
AP00FQ8B5ED5,579879.772,111214.795,1
AP00K08C5R85,579879.772,111214.795,1
AP01978B53K5,579876.172,112315.095,2
AP019Q8B5T25,579876.272,112401.495,1
AP019Q8B5T65,579876.272,112532.895,1
AP01AR8U54D5,579876.372,111023.395,5
AP01FN8B5FC5,579876.472,110124.595,1
AP01FQ8U59T5,579876.472,110124.595,1
AP01K08V5T95,579876.772,111591.695,1
Parent topic: About customer points
Parent topic: Demand Update Wizard

Related Information

Was this information helpful?