{"id":11512,"date":"2021-12-11T11:28:00","date_gmt":"2021-12-11T16:28:00","guid":{"rendered":"https:\/\/manage4.performancescoring.net\/kb\/?p=11512"},"modified":"2025-10-27T17:46:54","modified_gmt":"2025-10-27T22:46:54","slug":"objective-feedback-categories-update-bulk","status":"publish","type":"post","link":"https:\/\/securedb.io\/kb\/?p=11512","title":{"rendered":"Bulk Update Metrics and Feedback Categories"},"content":{"rendered":"\n

You\u2019ve built the organization, set all categories for both Factor and Objective, set all the Can Score In and Is Scored for all the users.  Now you realize you need to add more categories that the customer has requested, and they will need to be added to ALL employees\u2019 Can Score In<\/em> and Is Scored In<\/em> rights.<\/p>\n\n\n\n

That\u2019s a lot of mouse clicks.  This job is made much easier by utilizing Bulk Upload and Import.<\/p>\n\n\n\n

And here’s how:<\/p>\n\n\n\n

WARNING<\/strong>: This is an advanced function designed for use only by Power Users. There is a backup\/test\/revert safety net built-in, but you can still get into trouble if you’re not careful with it.<\/p><\/div>\n\n\n\n

To access Bulk Import\/Update, click on Administration <\/strong>in the left hand menu, then select Bulk Import\/Update<\/strong>.<\/p>\n\n\n\n

Export Existing Data<\/h2>\n\n\n\n

Just below the page title, you’ll find two pill buttons: Import (default) and Export. Click on Export <\/strong>to view the available User Data Tables you can export from the database. <\/p>\n\n\n\n

Choose the data set Users<\/strong> from the dropdown and click the Download <\/strong>button. Your browser will download the data converted to a CSV<\/strong> file you can open in your spreadsheet of choice (i.e., Google Sheets, MS Excel, etc.).

While you are here go ahead and also Select the data set Factor Categories<\/strong> and click download.<\/p>\n\n\n\n

Prepare Import Spreadsheet<\/h2>\n\n\n\n

Open the Factor Categories<\/strong> CSV file. Here you can identify the Category ID<\/strong> for the new category(s) you created. In this example, I added the category Post-Project.  <\/strong>Its ID is 36.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now go ahead and open the User<\/strong> CSV file. You can delete columns User ID,<\/strong> Name<\/strong>, Last Name<\/strong>, Password<\/strong> and role ID<\/strong><\/em>.  This should leave only Email<\/strong> in column A<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n


Now name column B<\/strong> – Can Score In<\/strong> and column C<\/strong> \u2013 Is Scored In<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Since we are adding these to all users in the organization you can paste in the Factor ID <\/strong>of 36
<\/strong>to both Column<\/strong> B<\/strong> and Column<\/strong> C<\/strong>. Then save the file<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Bulk Upload and Import<\/h2>\n\n\n\n

Now return to Bulk Import\/Update<\/strong> select Import and choose the file you just saved<\/p>\n\n\n\n

Once that file has been uploaded and processed, you’ll be given some options to map each column to the correct location in the database. <\/p>\n\n\n\n

Since we want to overwrite anything that matches our inputs, let’s select “Overwrite” from the first dropdown at the top. Then, we see the column headers in the uploaded document and a few example rows. Above each, select where you want this data to go.

For Email<\/strong> Select \u2013 Ignore<\/strong> from the Dropdown; <\/p>\n\n\n\n

For Can Score In<\/strong> \u2013 Select Factor: Can Score In<\/strong> from dropdown;

For Is Scored In<\/strong> \u2013 Select Factor: Is Scored In<\/strong> from dropdown<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Once you’re done mapping each column, click the green Start Import <\/strong>button.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

If the import is successful, you will be greeted with two buttons: Test <\/strong>and Revert<\/strong>. Open the “Test” button in a new browser tab or window. DO NOT close this tab\/window<\/strong>. Check to see if your changes were made the way you wanted them. If anything went wrong, return to this screen and click the red Revert button which will restore the database to what it was just before your import. Once you’re happy, close the window. <\/p>\n\n\n\n

If you receive an error like, “Oops. There was an error importing the data,” please create a Support Ticket. <\/p>\n","protected":false},"excerpt":{"rendered":"

You\u2019ve built the organization, set all categories for both and , set all the Can Score In and Is Scored for all the users.  Now you realize you need to […]<\/p>\n","protected":false},"author":4,"featured_media":15578,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_helpful_status":1,"footnotes":""},"categories":[36],"tags":[11,7,26,22,16],"class_list":["post-11512","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-admin","tag-category","tag-export","tag-feedback","tag-import","tag-objectives"],"wps_subtitle":"Make it easier by utilizing Bulk Upload and Import.","_links":{"self":[{"href":"https:\/\/securedb.io\/kb\/index.php?rest_route=\/wp\/v2\/posts\/11512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/securedb.io\/kb\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/securedb.io\/kb\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/securedb.io\/kb\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/securedb.io\/kb\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11512"}],"version-history":[{"count":17,"href":"https:\/\/securedb.io\/kb\/index.php?rest_route=\/wp\/v2\/posts\/11512\/revisions"}],"predecessor-version":[{"id":20514,"href":"https:\/\/securedb.io\/kb\/index.php?rest_route=\/wp\/v2\/posts\/11512\/revisions\/20514"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/securedb.io\/kb\/index.php?rest_route=\/wp\/v2\/media\/15578"}],"wp:attachment":[{"href":"https:\/\/securedb.io\/kb\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/securedb.io\/kb\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/securedb.io\/kb\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}