Introduction

InfraLink offers Users the Export All feature, which allows for the export of selected data according to a User-specified schedule or on demand. The Export All feature is also the starting point for most bulk record updates in InfraLink.

When preparing a bulk data import for the purpose of updating records in InfraLink, the User must identify the UUID, the unique record identifier in InfraLink, for each record being updated. InfraLink assigns a UUID to each new data record at the time it is created. The UUID, however, is not typically displayed in standard InfraLink views or details panels. The UUIDs can be easily obtained by exporting data for the desired records. Additionally, the data export file will provide column headers for other record attributes, which can be used in the subsequent Import data file.

Filtering Existing Records

To begin a data export from InfraLink, you must start by selecting the desired records. To do this, use the Main Menu to access the appropriate view for the records in question (e.g., Device Equipment List view, All Assets view, Manage Locations (List View) view, etc.)   

From the appropriate view, filter the listed records down to those which require update. To do this, use the Filters located down the left side of the view.  

Note: The information columns within the view can be customized for the information you wish to extract.  Hovering over a column header in the view will reveal a small arrow. Clicking on that arrow will reveal a drop-down menu. Select the "Columns" option to add or remove the most common information columns within the view. Clicking on "Columns" will display a pop-up list of column options. Simply check a box to add that column to the view or uncheck a box to remove that column from the view. You can also rearrange the columns by clicking on a column header and dragging it to the left or right.

Exporting Data

Once you have filtered the list down to your desired records, click on the  button at the top of the view.  From the Export All drop-down menu, select the Import Friendly (CSV) option.  

An InfraLink pop-up window will then ask if the Export All is to occur now or as scheduled. Select the "Now" option and then click the Create button.

Your browser should indicate download of the exported data in a CSV file, which will contain all filtered records from the view.

Export File

The exported CSV file will include export information at the top, followed by data columns/fields for the exported records. The file will include the UUID for all exported records.

Note: The Import Friendly (CSV) file automatically includes the Action column with data field value "UPDATE" for the User's subsequent Import data file. You can delete the unnecessary export information rows at the top of the file (Rows 1-7 in the sample below) and Save As your subsequent Import data file template. Data field values can be edited to reflect the desired updates to be imported.

Note:  Not all exported data columns can be updated with certain Import features. To be updated, the attribute has to be  direct attribute of the data record being updated. For example, an export of selected Assets may include data columns for Manufacturer and Type. Manufacturer and Type are attributes of the Model and cannot be updated with an Assets Import. Those updates would have to be made at the Model level.