.Mass Upload Attributes v1.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
- Create or modify a Process Revision
- Download the sample template
- Modify the template to include attributes to be added
- Upload the modified template
- Apply the revision
Step 1 - Create a Process Revision
To create a Process Revision, click the Menu icon and select Create Revision under Revisions.
Add/Update Revision |
---|
Click Add a New Value.
From this page, 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 page if they wish to create a new revision.
Create Revision |
---|
Enter the information for the Revision, then click Reserve.
Manage Revision |
---|
Click Configure.
Process Revision |
---|
Step 2 - Download the sample template
Click Manage Revision Uploads.
Mass Upload Attributes |
---|
Select the Attribute Type, then click Download Sample Template.
Download Sample Template |
---|
Click the downloaded file to open it.
Open Sample Template |
---|
|
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 |
---|
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. LO00000000, for Location, BU00000000 for Business Unit, etc.
Add Attributes as Rows in Spreadsheet |
---|
Save the file with a new name.
Save Spreadsheet |
---|
Step 4 - Upload the modified template
Click Upload.
Upload |
---|
Click Choose File.
Revision Attributes |
---|
Select the file that you just created.
Select File |
---|
Click Upload.
Upload |
---|
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 |
---|
Click Location, and expand to see the new attributes that have been added. Here 'Maryland' locations have been added under 'Eastern US'.
Added Attributes |
---|
Step 5 - Apply the revision
Click Return to Manage Revisions.
Return to Manage Revisions |
---|
Click Apply.
Apply |
---|
© Smart ERP Solutions, Inc.