...
- Remove the example rows (if any) such that the row 37 is the first one containing the actual data
- Populate column L (OSreference) based on the NGR-coordinate of the discharge or abstraction point (column N and O).
- Define concatenate functions for cell B14, B15, B16, B17, B19, B20. The actual contents depends on data availability.
- Verify that the column(s) as used for the concatenate functions are properly populated with appropriate information (i.e. preferably no empty cells, 'unknowns, 'na' etc.). If necessary apply an 'IF-construction on the concatenate function. This verification is especially critical for columns being used in location names.
Anchor | ||||
---|---|---|---|---|
|
...
- Create a backup-file with name XXX_LocationsProcessed_originals_versionnumber.xls.
- Open the spreadsheet NGMS-locations_Generator.xls.
- Activate the data-spreadsheet and run the macro 'SortLocationsAddParents' held in the NGMS_Locations_generator-spreadsheet.
- The macro asks what to items to process. Normally you would like to process all. Dependent on the model size it can take up to 2 hours (e.g. YNN).
- Check the results
- Are the newly generated worksheets properly filled ?
- Did the concatenate functions give proper results (especially for parents) ?
- Is the IDMapping OK ?
- If anything is incorrect:
- Fix the error in the _org worksheet
- Remove the associated worksheets generated by the macro.
- Save again under the same name (possibly with a version number)
- Run the macro 'SortLocationsAddParents' again and pick only the relevant location types.
- Check again.
If everything seems OK one can continue with the generation of the XML-files
- Create a backup with name XXX_LocationsResults_versionnumber.xls
- Run macro 'create_XMLfiles'.
- The macro creates XML-files in the directory of the data-spreadsheet.
- The macro overwrites existing files
- You can skip location types to be generated (e.g. if you want to update a branches file), but be aware:
If you skip any of the location types listed, your Locations.xml file might not be complete.
- Check the contents of the files. It might be wise to validate with an XML-validation tool.
- Copy the files which are OK to your configuration:
- Locations.XML, LocationSets.xml, Branches.xml, Polygons.xml --> region-root\Config\RegionConfigFiles
- IdMap files --> \Config\IdMapfiles
- Leave the Grids.xml file to be updated in the next step
...