Uploading and Processing Import/Update Templates
  • 24 Jan 2024
  • 2 Minutes to read
  • Dark
    Light

Uploading and Processing Import/Update Templates

  • Dark
    Light

Article summary

Uploading & Processing Import/Update Templates

Data Import Manager: Uploading & Processing Import/Update Templates

To navigate to the Data Import Manager screen to upload and process your import/update templates, log into the application as a System Administrator and go to the Manage/Setup top menu item and click Account Maintenance.

Contract Insight Main Menu. Account Maintenance is highlighted.
On the Account Maintenance screen, click Data Import Manager on the side menu.

Data Processing Side Menu. Data Import Manager is highlighted.

The Inbound Integration Wizard: Integration & Import File List page displays where users are able to view, add, and edit templates for the Data Import Manager.
page displays where users are able to view, add, and edit templates


On the Data Import Manager screen, click Manage Files on the side menu.


A close-up of The Inbound Integration Wizard side panel. Manage Files is highlighted.

The Inbound Integration Wizard: Job Scheduler screen displays where a user can upload files for the one off processing, view the summary, status, and history of import templates in the system.


Click Choose File and locate the file locally. After the file has been selected, click Save.

The Inbound Date Import Wizard's File Processing Screen. Choose File and Save File are highlighted.Once saved, the record is now available for processing.

Note: In order to process the file as one off, the number of rows in the file must be fewer than 5000.  If more than 5000, the file must be processed by the scheduler. 

Once the file is uploaded, click the Process Sprocket Icon. A review screen displays.

The Data Import Manager: File Processing screen. A Row of Data on the Manage Integration/Import Files table is highlighted, as well as the Process Sprocket Icon.To process the file, click Process at the top of the list. Click Process only once. Once the rows have been imported, a review of the records displays.

The Review Import pop-up. The Process button is highlighted.
If there are records that did not import, a message describing the issue displays.

The Review Import Pop-up after pressing the process button. The Succesfful Submittal message is highlighted.

The Status Key displays on the side.

When the import was successful, a Green Check Mark Icon (Green Check Mark) displays under the status column. If the import was processed with errors you will see the Yellow Exclamation Mark Icon (Yellow Exclamation Mark)  displays under the status column.

If the status does not contain a Green Check Mark Icon, there were issues processing the import. Make the necessary changes to the excel spreadsheet and start the process again. 


The Data Import Manager: File Processing screen after a new import has been processed. For the new data row, True is highlighted in the Processed Y/N column. A green checkmark is highlighted in the Status column.Clicking the Summary Magnifying Glass Icon (Summary Magnifying Glass) opens the Inbound Data Import: Summary screen on which the status of all the imported records, including records that failed to import, displays.

The Summary Pop-Up that appears after clicking the magnifying glass.

Resubmit any record that failed to import successfully by clicking Edit. The Edit Screen displays.

The edit screen within the summary pop-up
On the left is a breakdown of the fields mapped for the template. in the center is a breakdown of the actual data that was attempted in the import. On the right is the data type for the fields. You can manually fix any error by selecting the text box in the center and inserting the proper data. After all the corrections for the record have been made, click Re-Submit.


Once information has been successfully imported, please check the area into which the data was imported to ensure the information is present.


Was this article helpful?