Configure Scoring Defaults by using an Import

Abstract

Product: Workbench.

Configure Scoring Defaults

This process describes configuring default values for the posting scoring options screen in Infinite BrassRing by importing a template into Infinite BrassRing Workbench. Job Code Default Data, and Posting Defaults must be configured before this process is carried out.

Relevant eLearning

Process

Downloading and Completing the Template

1. Download the job code posting defaults by selecting Tools → Forms → Reqs → Req Forms.

2. Select Administer Req Fields for the Req form to have the default posting options.

3. Select Export job code Posting question defaults to Excel.

4. Insert a name for the file and select Launch.

5. Access the file by selecting Tools → Task Manager.

6. Select the View Binoculars icon for the Task Name that was entered.

7. Open and Save the spreadsheet as needed.

8. Select the Defaults tab, and insert a new column A.

9. Add the title to the new Column A as Import Action.

10. For each line item, insert the details that are to be the default values.

    1. Insert Update or Delete in the The Import Action values, depending on whether you are updating the line item or are marking it for deletion.

    2. The Posting Scoring Defaults can be defaulted by adding details the required details to Columns B to H. These headings correspond to the options on the Posting Options window.

        

11. Save the template.

12. In Workbench, select Tools → Import → Profiles.

13. Create a New Import Profile or use an existing Import Profile to import your spreadsheet.

Creating a new Import Profile

It is not required that a new profile is created every time there is an import to run. It is recommended to create one profile per Import Type.

1. Select Add new profile.

    

2. Complete the Import Profile page.

   1. Name your Profile. It is recommended that you name the profile the type of import you are planning to run.

   2. Select Sharing if you would like other Workbench users to see your Import Profile.

   3. Select JCDD – Question Scoring Defaults.

   4. Select your file by selecting Browse.

   5. Select Next.

3. Complete the Map Import Profile page.

   1. The Column Name shows standard option import columns necessary for the import.

   2. The Map To column shows the column headers that are present in your excel sheet. It is recommended to review the Map To column to ensure that there is a column header for each of the standard option import columns. It is recommended that you do an initial export of the current Option List to get the layout needed to be imported. Having the proper column headers on your spreadsheet ensures that your Map To column aligns correctly.

   3. The Overwrite column is used to select the fields you would like to overwrite the option data for. Selecting All checks each box automatically.

   4. Select Finish.

4. If you would like to complete the Import process select Launch. If you would like to come back later to complete the steps, select Close.

5. Selecting Launch opens the Launch Import Profile window.

   1. The Import Type is defaulted to JCDD – Posting Defaults.

   2. Reselect your spreadsheet.

   3. Select Launch.

6. The system processes the spreadsheet and sends you an email when the import is complete. See Completing the Process for more information.

Launching an existing Import Profile

It is not necessary to create a new profile every time there is an import that is needed. It is recommended to create one profile per Import Type. Should you already have created an import profile, double check the settings and the mapping of the profile and use that for your future imports.

1. Select the existing profile and select Launch.

    

2. Selecting Launch opens the Launch Import Profile window.

   1. The Import Type is defaulted to JCDD – Posting Defaults.

   2. Reselect your spreadsheet.

   3. Select Launch.

3. See Completing the Process.

Completing the Process

1. The system processes the spreadsheet and sends an email when the import is complete.

2. Select Tools → Task Manager.

3. On the Task Manager page, there is a Status column that indicates the status of your import. There are five potential Statuses you can encounter:

   • Pending. The import is waiting in line to be processed.

   • Running. The import is being processed. You can select Refresh display link to watch the progress. The number of rows increases as the file is processed.

   • Completed. The import has completed without errors. However, it is important to open the file by using the binoculars icon to review the results.

   • Completed with Errors. The import has completed and has errors that need to be resolved. Open the results file by using the binoculars icon, review the errors, correct them in the original file and reload the file. You can reload the entire original file, with the corrections, or just the JCDD that had to be corrected.

   • Failed. The import failed completely. This can be an issue with the extension of the excel file that you attempted to import, an overall system error or issue, or that the file was too large and timed out. See Reading the Results file and Common Errors for more information.