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.Image Removed

...

Method 1 - recommended

This method utilises a user created and configurable Custom Profile.

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

Click the + button to add a new custom profile.

...

Select the newly created profile and click Edit button. An import profile properties window will be show.

...

Here you can:

Name - change the profile name

Source - select the XREF source category from the drop down list

...

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

...

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 properties.

Method 2 - deprecated

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

...

The CSV file for XREF bulk insert requires two columns: UPRN and a column named after cross-ref Source ID (cross-reference source abbreviation).

...