DPS Spreadsheet Import

The
DPS Spreadsheet Import
screen is used for performing mass uploads of DPS-searchable criteria. Search times may vary depending on the size of the uploaded spreadsheet. This screen can be accessed by clicking
DPS Spreadsheet Import
from the DPS menu.
When a spreadsheet is uploaded through this screen, the default setting is for each spreadsheet record to be screened along with all Company Partners records flagged for screening within DPS. Screening spreadsheet records without screening Company Partners records requires client-specific configuration. For more information about this option, contact your system administrator.
Uploading a Spreadsheet
Choose an Excel spreadsheet from the local computer, and then click “Submit”. Please confirm your spreadsheet matches the system template prior to clicking “Submit”. In the “Submit All Companies” section of the “DPS Spreadsheet Import” screen, click “Submit Company Table”.
In the
Upload New Companies
section of the
DPS Spreadsheet Import
screen:
  1. Click
    Choose File
    .
  2. Choose an Excel spreadsheet from the local computer, and then click
    Submit
    .
In the Submit All Companies section of the
DPS Spreadsheet Import
screen, click
Submit Company Table
.
After the workflow has successfully processed, the system notifies the designated user(s) with the results by e-mail. The e-mail indicates how many records were screened and blocked, as well as the date of the last list update.
Clients using proactive DPS screening can also be triggered to receive a notification e-mail when a list of companies is submitted, whether or not the companies need to be re-screened at that time.

DPS Spreadsheet Import (New)

The
DPS Spreadsheet Import (NEW)
screen is also used to perform mass uploads of DPS-searchable criteria, including
Screening Profile
and
Entity Type
.
This screen operates in the same way as the
DPS Spreadsheet Import
and can be accessed by choosing
DPS Spreadsheet Import (NEW)
from the DPS menu.