Demand Update Wizard

The Static Demand Update Wizard is used to update demand data imported as Customer Points using data in CSV files. The structure of the CSV file must be known in advance.

The wizard is displayed by selecting Static Demand Update from the Model menu. The Model menu is only visible when there is a network open, and one of the network views is the Current Active WindowThe current Active Window in any Microsoft Windows application has a differently coloured title bar to all the other windows. In the default colour scheme, the active window title bar is blue, all other windows have a grey title bar..

The wizard has two pages:

Using the Wizard

To use the Demand Update wizard:

  1. Choose Static Demand Update from the Model menu. The Model menu is only visible when there is a network open, and one of the network views is the Current Active WindowThe current Active Window in any Microsoft Windows application has a differently coloured title bar to all the other windows. In the default colour scheme, the active window title bar is blue, all other windows have a grey title bar.. This displays the Start Page of the Demand Update wizard.
  2. A progress bar entitled Scanning Customer Point Table may be displayed. Once this has completed, choose the CSV file containing the updated data in the CSV File box.
  3. Click Next to move to the Acquire Page. Link the InfoWorks database fields with fields in the CSV file. The grid has three columns:
  4. The Key field must be mapped. If the Key value does not match a customer point already in the database the record is ignored
  5. Map other fields in the CSV file, depending on what information it contains. All relevant data must be contained in the CSV file. Changes cannot be made to the imported data before update takes place
  6. Click Finish when fields have been mapped correctly. InfoWorks now carries out the update process.

Update Process

When Finish is clicked, InfoWorks attempts to update existing Customer Points:

Please Note

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

Changes to the Customer Point table can be viewed in the Customer Points Grid.


Demand Update from CSV

Demand Update Wizard - Start Page

Demand Update Wizard - Acquire Page

Customer Points