Organisation ObjectAttributeImport

Import of Attributes on Objects

In this view you can import attributes and attribute values to set on the objects.

The attribute values that are imported can be set on an existing attribute or on a new attribute that you can name in the import interface.

Note: If the import file contains objects that don't already exist in Pro 9, you can select to create these objects. So, you can use the object attribute import to create new objects.

How to - Show Import Attributes on Objects

1. Click on the role Organization Management in the navigation tree
2. Select Objects > Import attributes and values

How to - Prepare the Import File

1. Open a new text file
2. Start each row with the name of one of the object you want to set an attribute value on
3. After the name on each row, tab to add attribute values

   • Note that there must always be the same amount of tabs for values on different rows to be set on the same attribute
   • The top row in the file can be used for column headers, e.g. defining the name of the attribute
   • The same number of values must be added on each row
   • To set values on an attribute that is not created, simply add the values in a separate column and you will later be able to connect them to a new attribute using the import interface

4. Save the file

Note: If there are many objects, you can create the import file in Excel and save it as tab separated text file.

Example:

Name	Phone model	IMEI number
Object1	iPhone 4	123456789012
Object2	Samsung S3	234567890123
Object3	Sony Xperia	345678901234

How to - Import Attribute Values on Objects

1. In the select type menu, select the type of object you want to import attributes on
2. Click choose file... to browse to and select the file to import the attributes from
3. Select the node to update attributes and attribute values on in the owner menu

   • Select Ignore if all objects should be updated regardless of owner

4. Check the create new objects if not existing box if you want objects in the import file that don't already exist in Pro 9 to be created
5. Check the first row contains names if the first row in the import file contains column headings and therefore should be disregarded in the import
6. Click upload
7. The result is shown below:

   • In the row named new, check the box if the attribute is new and add a name for the new attribute in the text field
   • In the row named type, select type date, integer, checkbox, text field or drop down list for the new attribute

   -If drop down list is chosen the attribute values in the import file will populate the values to the drop down list

   Note! This will only happen the first time when the attribute is created, additional future list values is entered via manage attributes

   • In the row named connect to, select for each existing attribute what attribute to connect these values to
   • If you only want to add new attribute values, and not update existing values or delete any values, check the only new box

8. Click the save button to save the import