| Line 2: | Line 2: | ||
= Upload Agreements in Bulk using Excel Add-in = | = Upload Agreements in Bulk using Excel Add-in = | ||
| − | With Microsoft Excel Add-in, you can create and upload agreements in | + | With Microsoft Excel Add-in, you can create and upload agreements in bulk using the familiar Microsoft Excel interface. While uploading Agreements, you can add the actual names of an Agreement’s Primary Owner, instead of using the credentials of the logged in user. This offers you improved usability because the name and email of the logged in user is replaced by those of the Primary Owner, if specified. This is only applicable for ''Create Agreement'' and ''Add Amendment'' in any state. |
| − | + | The Excel Add-in contains a drop-down with the Primary Owner option. As this is an optional field, if the name of the Primary Owner is not specified, then the logged on user is treated as the Primary Owner. | |
<div class="image-green-border">[[File:Bulk Upload Name Primary Owner.png|Upload Agreements in Bulk Usign Excel Add-in - Specify the Primary Owner Name]]</div> | <div class="image-green-border">[[File:Bulk Upload Name Primary Owner.png|Upload Agreements in Bulk Usign Excel Add-in - Specify the Primary Owner Name]]</div> | ||
| − | Each Agreement is assigned a unique agreement ID in ICM known as its Agreement Code. While uploading legacy agreements in bulk using Excel Add-in, the original Agreement code of | + | Each Agreement is assigned a unique agreement ID in ICM known as its Agreement Code. While uploading legacy agreements in bulk using Excel Add-in, if the original Agreement code of Agreements and Amendments is not manually added, the system auto-generates it on '''clicking''' the ''Create'' button in the ''Verify'' section. |
<div class="note-box">'''Note: '''To avoid duplication of legacy code, ensure that the code entered manually does not already exist.</div> | <div class="note-box">'''Note: '''To avoid duplication of legacy code, ensure that the code entered manually does not already exist.</div> | ||
| − | You can navigate to the ''History'' or ''Team'' tab | + | You can navigate to the ''History'' or ''Team'' tab to verify that the Primary Owner Name and Email matches that specified in the Excel Add-in. |
== Uploading Agreements in Bulk == | == Uploading Agreements in Bulk == | ||
| Line 32: | Line 32: | ||
3. In the ''Actions'' group, '''click''' ''Populate Workbook''. A popup window appears verifying if you want to populate the workbook for the selected action as shown in the figure below. | 3. In the ''Actions'' group, '''click''' ''Populate Workbook''. A popup window appears verifying if you want to populate the workbook for the selected action as shown in the figure below. | ||
<div class="image-green-border">[[File:PopulateWorkbook.PNG|Populate Workbook]]</div> | <div class="image-green-border">[[File:PopulateWorkbook.PNG|Populate Workbook]]</div> | ||
| − | 4. '''Click''' ''Yes''. All the attributes related to the selected contract type appear as column headers in the Excel sheet.<br/> 5.'''Enter '''the appropriate information for the attributes. | + | 4. '''Click''' ''Yes''. All the attributes related to the selected contract type appear as column headers in the Excel sheet.<br/> 5. '''Enter '''the appropriate information for the attributes. |
<div class="note-box">'''Note:''' The attributes that appear in red color are mandatory. For example, in the Status attribute, you must select the Draft, Publish, Send For approval, or DirectByPass (execute) state.</div> | <div class="note-box">'''Note:''' The attributes that appear in red color are mandatory. For example, in the Status attribute, you must select the Draft, Publish, Send For approval, or DirectByPass (execute) state.</div> | ||
6. '''Click''' ''Upload''. The ''Agreements created successfully'' popup appears. The Agreement appears in ICM as well as gets listed in the Excel sheet. | 6. '''Click''' ''Upload''. The ''Agreements created successfully'' popup appears. The Agreement appears in ICM as well as gets listed in the Excel sheet. | ||
''7. '''''Navigate''' to the ''History ''or ''Team'' tab to verify that the Primary Owner Name and Email matches what was specified in the Excel Add-in. | ''7. '''''Navigate''' to the ''History ''or ''Team'' tab to verify that the Primary Owner Name and Email matches what was specified in the Excel Add-in. | ||
| + | |||
| + | | ||
| + | |||
| + | | ||
| + | |||
| + | | ||
| + | |||
| + | '''Related Topics:''' [http://int-wiki.cloudapp.net:82/ICMHelpC7/index.php?title=Create_Agreement_Page Create Agreement] | [[Add_Amendment_to_an_Agreement|Add Amendment]] | [[History]] | [[Team]] | | ||
</div> | </div> | ||
Revision as of 10:37, 14 March 2018
Upload Agreements in Bulk using Excel Add-in
With Microsoft Excel Add-in, you can create and upload agreements in bulk using the familiar Microsoft Excel interface. While uploading Agreements, you can add the actual names of an Agreement’s Primary Owner, instead of using the credentials of the logged in user. This offers you improved usability because the name and email of the logged in user is replaced by those of the Primary Owner, if specified. This is only applicable for Create Agreement and Add Amendment in any state.
The Excel Add-in contains a drop-down with the Primary Owner option. As this is an optional field, if the name of the Primary Owner is not specified, then the logged on user is treated as the Primary Owner.
Each Agreement is assigned a unique agreement ID in ICM known as its Agreement Code. While uploading legacy agreements in bulk using Excel Add-in, if the original Agreement code of Agreements and Amendments is not manually added, the system auto-generates it on clicking the Create button in the Verify section.
You can navigate to the History or Team tab to verify that the Primary Owner Name and Email matches that specified in the Excel Add-in.
Uploading Agreements in Bulk
By using ICM Excel Add-In, you can upload bulk of agreements at once.
To upload agreements in bulk:
1. On the ICM Bulk Insert tab, in the Selections group, select a Contract Type from the drop-down list.
2. In the Action list, select an action from the drop-down:
- Create Agreement: to create a new agreement.
- Create Agreement With Association: to create agreement and add associations (associated document/agreement) to it.
- Update Agreement: to update an existing agreement.
- Add Associations To Existing Agreements: to add associations to already created agreements.
- Update Associations Of Existing Agreements: to update the associations of already created agreements.
- Add Amendment: to add amendments to agreements.
- Update Amendment: to update existing amendment.
- Update Associations Of Existing Amendments: to add/update associations of existing amendments.
3. In the Actions group, click Populate Workbook. A popup window appears verifying if you want to populate the workbook for the selected action as shown in the figure below.
4. Click Yes. All the attributes related to the selected contract type appear as column headers in the Excel sheet.
5. Enter the appropriate information for the attributes.
6. Click Upload. The Agreements created successfully popup appears. The Agreement appears in ICM as well as gets listed in the Excel sheet.
7. Navigate to the History or Team tab to verify that the Primary Owner Name and Email matches what was specified in the Excel Add-in.
Related Topics: Create Agreement | Add Amendment | History | Team |
