Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You can perform this operation by using Import section of the Export & Import tool.

...

Note

Due to compute-intensive nature of bulk processing, please perform this operation when there are no other users in the GMS system. Depending on the size of the data source it may take a while for the entire collection to be processed. Once the processing is over please wait a couple of minutes and then refresh the GMS application to see the changes in XREF records reflected on individual properties.

Method 1 - recommended

This method utilises a user created and configurable configured Custom Profile.

When you open the Export and Import pane, please scroll down the pane until you see a section called Import.

...

UPRN Columns and Cross-reference Column - define the name of the field within the CSV file, which stores the UPRN numbers and cross-reference values

...

Info

When providing the UPRN and Cross-reference column names it is recommended to use the drop down arrow to load the columns from the source data CSV file and select the correct name from the list.

...

Mode - use this switch to select whether, upon execution, the profile should made the changes to the database (Update) or merely return a report of how many records would have been modified (Test) and in what way.

...

Due to intensive nature of bulk processes, please consider performing this operation when there are no other users in the GMS system. Depending on the size of the data source it may take a while for the entire collection to be processed. Once the processing is over please wait a couple of minutes and then refresh the GMS application to see the changes in XREF records reflected on individual propertiesWhen you’re satisfied with the configuration, please click Save to save it and close the window.

If you want to use this import profile, please select it on the list and click Import button.

...

You’ll be asked to open the source data CSV file and once you do that, the processing will begin immediately.

Method 2 - deprecated

This method utilises the predefined import profile called Cross-references and requires the source data in a specific structure.

...