Introduction #
There are following types of Uploads for which a user can import data.
- Opportunities & Deals – This Upload helps to import/update Open & Closed Opportunities data for partners.
- Partner Accounts – This Upload helps to import/update Partner Accounts data.
- Budget & Items – This Upload helps to import/update Budgets & Items data for partners.
- Partner Contacts – This Upload helps to import/update Partner Contacts data for Partners.
- Partner Certifications – This Upload helps to import/update certifications data.
- Channel Account Managers – This Upload helps to import/update data for Channel Account Managers.
- Partner Profile – This Upload helps to import/update Partner Profile data.
- Scorecard Provisioning – This Upload helps to import/update Capabilities scorecard data.
Note:- Templates to be exported are only available for Partner Profile & Scorecard Provisioning.
How to Import data against the Upload Type? #
Step-1: Click on ‘Import’ against any of the upload type.
![](https://successfulchannels.com/wp-content/uploads/2024/07/1-1024x556.png)
Step-2: Select the excel file to be imported & Click open.
Step-3: A popup to map fields will appear. In this popup, mapping of fields will be done. User will map fields of the uploaded excel file with the admin defined fields.
![](https://successfulchannels.com/wp-content/uploads/2024/07/2-1024x589.png)
Match By Field: Select the fields with which user wants to match the data. If data of selected fields already exists in the existing data, then that record will get updated else a new record will be inserted.
Step-4: After Mapping Fields, Click on ‘Import’ button to insert/update the data.
![](https://successfulchannels.com/wp-content/uploads/2024/07/3-1024x820.png)
Step-5: After Successfully uploading data, a popup will appear displaying Diagnostics which means the number of records uploaded & number of records not uploaded.
![](https://successfulchannels.com/wp-content/uploads/2024/07/4-1024x306.png)
On Clicking ‘Total Records’ count, user can export the Diagnostic report which will include all the records either uploaded or not uploaded(if any) with their reason for not being uploaded as an error comment.
How to Export the previously imported excel files? #
Step-1: Click on ‘View’ against any of the Upload Type.
![](https://successfulchannels.com/wp-content/uploads/2024/07/5-1024x552.png)
Step-2: A popup appears which contains 4 columns.
![](https://successfulchannels.com/wp-content/uploads/2024/07/6-1024x297.png)
Columns are as follows:
- File Name:- This column contains the name of the file which was uploaded.
- Date of Upload:- This column contains the date & time on which the file was uploaded.
- Total Records Uploaded:- This column contains the number of records uploaded.
- Action:- This column contains two actions:
a. Export:- This action helps to export the file which was uploaded.
b. Delete:- This action helps to delete the record.