Attributes Library Import/Export

Attributes Library Import/Export

Overview

The Attributes library supports bulk workflows for managing attributes; exporting the full attribute list and two dedicated import wizards: Import new for creating multiple attributes and Import update for editing multiple existing attributes.


Notes
Access to the Attributes library is based on your permission level within your analyst group(s). If you do not have access, contact our Support for assistance.



Export Attributes

In the Attributes library, there is no need to select attributes for export; all of them will be exported even if you didn't select any or you only selected some. 

Notes
The list of Analyst groups that attributes belong to cannot be exported.

  1. In the action bar, select Import/export and click Export.

  2. Use the Column picker to choose which columns are included in the file. If you will be using this file for updating existing attributes, we recommend including the Attribute ID as the unique identifier.

  3. Download and open the file.

Notes
The export always contains all attributes included in the analyst group(s) that you have access to. Selecting rows in the table (list) of attributes has no effect on the contents of the export - all of them get exported.


Idea
Run an export first when preparing an Import update file — it provides the attribute IDs required for mapping your updates. 



Import New Attributes


Use Import new option to create brand-new attributes from an imported document (.csv or .dat format). For guidance, see the attached template at the bottom of this page, "AttributeLibrary_Import_Example.csv".

Notes
Attribute names must be unique within each analyst group. Duplicate names in the same group will be rejected.

Alert
The import file should not include an ID column; IDs are generated automatically during the import.

Notes
Import attributes as Inactive if you want to fine-tune the panelist descriptions in the rich text editor after the import, then activate the attributes once they are ready for use.

Notes
Group membership cannot be updated through Import new. It is managed separately using the Add groups and Remove groups actions (see Add or Remove Analyst Groups).

  1. In the Attributes library, in the action bar, select Import/export and click Import new to open the wizard.

  2. If needed, click Download sample CSV to download a template file with the correct format. You can also download it here at the bottom of this page (file named "AttributeLibrary_ImportUpdate_Example.csv").

  3. Prepare your file if you have not already. Name is required for every row and the Status column must be set to Active or Inactive. If this column is not included, all new attributes will be set to Active by default.

  4. Select the Analyst group(s) the new attributes should belong to. Analyst groups cannot be assigned from within the import file - they are always selected in the wizard.

  5. Select the default Font family and Font size to apply to the imported attribute descriptions.

  6. Select your file and run the import.


Alert
Partial imports: valid rows from the file are still imported even if others fail. If any rows fail, download the error file for a list of failed rows and reasons, fix them, and re-import just those rows.



Update Attributes From a File


Use Import update to edit existing attributes from an imported document (.csv or .dat format). For guidance, see the attached template at the bottom of this page, "AttributeLibrary_ImportUpdate_Example.csv".

Alert
AttributeId column is required in the file to map each row to its attribute, however, attribute IDs cannot be changed through an import.

Info
After the AttributeId, include only the columns you want to change. Fields not included in the file will not be modified in the library.

Warning
The Status column must not be included in the file. If this column is included, the rows with data in it will fail.

Notes
Group membership cannot be updated through Import update. It is managed separately using the Add groups and Remove groups actions (see Add or Remove Analyst Groups).

Alert
You need at least Read/Write permissions to the group you are updating attributes in to perform the update.

  1. In the Attributes library, in the action bar, select Import/export and click Import update to open the wizard.

  2. If needed, click Download sample CSV to download a template file with the correct format. You can also download it here at the bottom of this page (file named "AttributeLibrary_ImportUpdate_Example.csv").

  3. Prepare your file if you have not already. AttributeId is required plus one more filed. The AttributeId is required to identify the attribute you wish to update and the other field or fields is what you will be updating. AttributeId cannot be updated.

    The Status column must not be included in the file. If this column is included, the rows with data in it will fail.

  4. Select the default Font family and Font size to apply to the imported attribute descriptions.

  5. Select your file and import it. A confirmation shows how many attributes were updated. If any rows fail, an error file is available to download and review.


    • Related Articles

    • Attributes Library

      Overview The Attributes library is where you can create and manage reusable attributes. Once an attribute is in the library, it can be inserted directly into tests rather than being built from scratch each time. The attributes are not assigned to any ...
    • Import Results

      Overview Compusense is a data collection software that provides a wide range of analysis options and tools within individual tests and across multiple tests . For all your scenarios where you intentionally collected data in different tests, such as ...
    • Products: Attribute Limits

      Overview If you are currently using, or are planning on using the Products library, and would like to incorporate into your reporting various attributes with their limits and targets relevant to specific products, you can set those attributes up in ...
    • Import/Export History

      Overview Import/export history provides a list of transaction activities at the panel level, including activity type and its success. Whether you are importing panelists from a file into the Panelists library, or updating panelist information by ...
    • Build: FCM For Category Attributes

      Overview On your journey through the Compusense® FCM® (Feedback Calibration Method) you have arrived to the point where you want to use Category scale to train your panelists. If you have not already, please go through the steps leading up to this ...