Data import from CSV

Top  Download  Previous  Next

You can import asset data to nVision. The condition for successful data import is to place them in a csv file and divide the data so that one file contains assets of one type. You can manage these files in Asset settings / Data sources window.

 

To add a data file for import in nVision:

1.Select the option Assets settings from the main toolbar and then go to the Data sources tab.

2.Click the addButton Import from CSV file button.

3.Enter Name, data Description and Asset type to be assigned to this data.

4.In the CSV Options, indicate the path to the data file, specify the separator and the occurrence of headers. The file preview will be presented below

5. Indicate in Import configuration tab which column (or set of columns) of the source identifies the resource  (is unique for a given resource).

6. Associate the CSV source columns with target field names. If necessary, go to Asset Type (by clicking Configure button) and add to it additional fields corresponding with selected columns.

7. To test the ability to import data, click Test button. then click OK.

The added file will be shown at the list of data sources. Now you can easily import data from this file eg. if its been changed (without the need to reset all the settings):

assetdatasource_zoom40

 

From the data source management window you can add data sources, delete them, change their properties and import data from them, as well as import data from Agents and view import logs.