Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from this space and version 1.7

What is Mass Upload Attributes?

You can enter data for attributes by entering the information directly for the attribute in a process revision.  If you have a large amount of attribute data, it may be preferable to use the Mass Upload Attributes to load the data first into a spreadsheet, and then upload that spreadsheet to the system.

How do you Mass Upload Attributes?

5 Step Process 

  1. Create a process revision
  2. Download the sample template
  3. Modify the template to include attributes to be added
  4. Upload the modified template
  5. Apply the revision

Step 1 - Create a process revision

To create a process revision, click the Menu Icon and select Add/Update Revision under Manage Revisions.

...

Add/Update Revision

...

Image Removed

...

 

Click Add a New Value.
From this screen, an Administrative User can either search for an existing revision to modify, or they can select Add a New Value at the top of the screen if they wish to create a new revision.

...

Create Revision

...

Image Removed

...

 

Enter the information for the Revision, then click Reserve.

...

Manage Revision

...

Image Removed

...

 

 

Click Configure.

...

Revision Configuration

...

Image Removed

...

 

Step 2 - Download the sample template

Click Edit in the Mass Upload Attributes area. 

...

Mass Upload Attributes

...

Image Removed

...

 

Select the Attribute Type, then click Download Sample Template.

...

Download Sample Template

...

Image Removed

...

 

Click the downloaded file to open it.

...

Open Sample Template

...

 Image Removed

...

 

Step 3 - Modify the template to include attributes to be added

The file is comma delimited.  Be sure only Comma is checked in the Separated by, then click OK.

...

Comma Delimited

...

 Image Removed

...

 

Add information for the attributes that you want to add in new rows in the file.  Note that the first Native Parent Attribute Lookup ID must already exist in the system.  All attributes have one "Root" Attribute ID when the system is first implemented.  The lookup ID for the Root Attribute ID is one or two letters followed by 0's, to a length of 10.  L000000000, for Location, BU00000000 for Business Unit, etc.

...

Add Attributes as Rows in Spreadsheet

...

 Image Removed

...

 

Save the file with a new name.

...

Save Spreadsheet

...

 Image Removed

...

 

Step 4 - Upload the modified template

Click Upload.

...

Upload

...

 Image Removed

...

 

Click Choose File.

...

Revision Attributes

...

 Image Removed

...

 

Select the file that you just created.

...

Select File

...

 Image Removed

...

 

Click Upload.

...

Upload

...

 Image Removed

...

 

Note that in this example there are no errors, and 4 attributes will be added.  If there were errors, you could click Errors to see the details.  

Click Push, then click Return to Revision Configuration.

...

Push Changes

...

 Image Removed

...

 

Click Location, and expand to see the new attributes that have been added.

...

Added Attributes

...

Image Removed

...

 

Step 5 - Apply the revision

Click Return to Manage Revisions.

...

Return to Manage Revisions

...

Image Removed

...

 

Click Apply.

...

Apply

...

Image Removed

...