Skip to main content

Importing NSG and NLPG files

How to import NSG and NLPG data into Alloy

NSG files contain street data. NLPG files contain land and premises data. When imported into Alloy, the data is used to generate a network, providing a visual representation of the data for you to work with.

The following sections explain the five stages of performing a complete import.

Upload files

First, upload your data files to Alloy. To do this quickly, drag them onto the browser window and release over the yellow circle.

NSG data is stored across two CSV files labelled LG and AD respectively. Both are required for importing into Alloy.

NLPG data can be stored in one or more CSV files. Files labelled Patch are incremental and can only build upon existing data. NLPG data is supplementary to NSG data, so it can only be imported if corresponding NSG data already exists in Alloy.

Create the import

Next, create an import item and specify the file(s) to be imported:

  1. Select the Gateway dashboard card and then Create import.
The expanded Gateway dashboard card
  1. Choose NSG or NLPG. If either isn't shown, the relevant module needs enabling for your customer project. Please contact your Alloy administrator!
List of import options
  1. Fill in the following fields:

    • Name * - provide a distinct name that clearly identifies the import.

    • Files * - select the uploaded data file(s) you want to import.

    • Triggers workflows - if left disabled, the create/edit actions of the import won't trigger any event workflows.

The first step of the Create Import process
  1. Select Create to finish. Your new import item will appear in the right panel, with its Status set to Initialising.
The General tab of the new import

A notification will appear when initialisation has finished. Select it to refresh the import's details.

A yellow notification prompts you to refresh the import's details

Configure the import

When the Status of your import item is Initialised, you can configure it:

  1. Select the import to view its details in the right panel. Select More in the action bar and choose Configure.
The General tab of an example import item
  1. In the left panel, select 1 Destination (all other steps are configured automatically).
The steps of the NSG Configuration process
  1. Fill in the following fields and then select Done to finish:

    • Design * - choose the NSG/NLPG design that you wish to update or replace the data on. Alternatively, for NSG imports only, you can make Alloy create a new NSG design instead. Leave this blank and set Mode to Replace.

    • Collection * - choose the collection that the created/edited items will belong to.

    • Mode * - choose one:

      • Update - existing items will be updated with imported values. New items will be created for new import data rows.

      • Replace - all existing items will be deleted. New items will be created for all import data rows.

Caution

Replace mode will delete all items of the chosen design and collection - including network references - before creating the new items. This is irreversible, so please double-check that you want to do this! We recommend contacting Support for advice before using this mode.

The Destination step of the NSG Configuration Process
  1. If you're importing NLPG data, there's an extra step to complete. Select 6 NSG to reference and then choose the existing NSG design that your NLPG data relates to.
The steps of the NLPG Configuration process

Validate the import

  1. To finish configuring your import, select Validate at the bottom of the left panel.
The steps of the NSG Configuration process

A notification will appear when validation has finished. Select it to refresh the import's details.

A yellow notification prompts you to refresh the import's details

If the validation produced any Errors, you can study the log file for more detail and try again. See Reconfiguring an import.

Otherwise, you can proceed to commit the import (even if there are Warnings).

The General tab of a validated import item

Commit the import

Once the import has been configured and validated, you can commit the data changes to Alloy. Select the import to view its details in the right panel. Select More in the action bar and choose Commit.

The More Actions list for the General tab of a validated import

A notification will appear when the commit has finished. Select it to refresh the import's details.

A yellow notification prompts you to refresh the import's details