How To
      Back to home
      1. Help Center
      2. How To

      Bulk Upload Providers

      Follow these steps to create your Provider Directory. Learn how to:

      Download the provider template .csv

      • Navigate to Workspace and then to the Providers tab.
      • From the Providers tab, click the blue 'Add Providers' button.
      • From the dropdown, click 'Download a provider list template' and an automatic download will begin.

      Validate and review the .csv format

      • Users must download and use the provided CSV file template to ensure successful file upload and must adhere to the CSV formatting to avoid upload errors.
      • Provider Name and External ID are mandatory fields. Entries with empty values will not be imported and upload errors will be encountered.
      • Invalid entries and duplicate data on the CSV file is not imported while new versions of existing Provider entries are overwritten.
      • Upload only accepts .csv file extension. Error is encountered if incorrect file is uploaded: Unsupported file type. Please try again.
      • Limit to 2000 rows per file upload

      Mandatory and Optional Fields: 

      • Provider Name: Mandatory, Must not exceed 100 characters. 
      • Provider ID: optional, max length: 50
      • Comments: optional, max length is 4000 characters
        • Contact Information Fields: If Provider entries have no contact information - providers are created but it will display the “Missing contact” tag to the row on the UI)
          • Contact Name: optional, max length: 50
          • Contact email: 1 email address only, no max character limit but email address should be valid
          • Contact number: no max limit but contact phone with country code should be valid (I.e 19713942775)
            • Phone Country Code: Country code (without +) 
            • Contact Number
      • Addresses (both mailing and billing are optional)
        • Mailing Address (all fields max length: 300)
          • Address line 1
          • Address line 2
          • City
          • State / province / region
          • Country: 2 Digit Country Code
          • Zip / postal code: Numeric only
        • Billing same as mailing: True and False are the only accepted values
          • True if the Billing Address is the same as the Mailing address 
          • False if no Billing Address or Billing Address isn’t the same as the Mailing Address
        • Billing Address (all fields max length: 300)
          • Address line 1
          • Address line 2
          • City
          • State / province / region
          • Country: 2 Digit Country Code
          • Zip / postal code: Numeric only
      • External ID: Mandatory

      Upload completed provider file .csv

      • Navigate to Workspace and then to the Providers tab.
      • From the Providers tab, click the blue 'Add Providers' button.
      • Select "Upload provider list"
      • Either drag the completed provider upload file into the yellow box or click the yellow upload box to select the file from the file manager.
      • Click the blue 'Upload file' button.

      • A message will appear to confirm that any new versions of existing providers in the Provider Directory will be overwritten with the newest version from the file you are uploading. If you wish to proceed, click 'Yes, upload provider list'.
      • The system will indicate if the upload was Successful or Failed.

      Outcome: Success or Fail

      Success

      If all entries from the .csv file are uploaded with no errors, you'll see two confirmation messages indicating the upload was successful. 

      You will also receive an email notification if the upload was a success.

      Example upload successes:

      1. Uploading a CSV file with Provider Name and External ID already existing on the workspace but with updated values on other fields will replace or overwrite the existing data for that Provider/External ID based on the CSV file. 
        • Existing: 
          • Provider Name: ProviderName1 / External ID: ExternalID1 / Mailing Address City: New York
        • Upload: 
          • Provider Name: ProviderName0 / External ID: ExternalID0 
          • Provider Name: ProviderName1 / External ID: ExternalID1 / Mailing Address City: Los Angeles
        • Outcome: Successful
          • Provider Name: ProviderName0 / External ID: ExternalID0 is uploaded successfully
          • Mailing Address City of ProviderName1/ExternalID1 is updated to Los Angeles

      Fail

      The outcome is Fail if:

      • all entries from the .csv file are uploaded with errors in its entirety, or
      • a .csv file is uploaded with valid entries and entries with data errors.

      You'll be alerted via two error messages if the upload has failed. Click the 'View upload errors' button to view the error identified by row to help you identify which data should be corrected on your file prior to re-uploading it.

      You will also receive an email notification if the upload failed.

      Example upload fails:

      1. Uploading a CSV file with Provider Name already existing on the workspace but External ID is unique
        • Existing: 
          • Provider Name: ProviderName1 / External ID: ExternalID2
        • Upload: 
          • Provider Name: ProviderName1 / External ID: ExternalID3
        • Outcome: Failed, upload error as Provider Name already exists
      2. Uploading a CSV file with a unique Provider Name but the External ID already exists on the workspace:
        • Existing: 
          • Provider Name: ProviderName2 / External ID: ExternalID2
        • Upload: 
          • Provider Name: ProviderName3 / External ID: ExternalID2
        • Outcome: Failed, upload error as an inline update of the provider name is restricted on the UI
      3. Uploading a CSV file with a unique Provider Name and External ID but has duplicate entries within the CSV:
        • Existing: 
          • Provider Name: ProviderName2 / External ID: ExternalID2
        • Upload: 
          • Provider Name: ProviderName3 / External ID: ExternalID2
          • Provider Name: ProviderName3 / External ID: ExternalID2
        • Outcome: Failed, upload error as entries on the CSV are duplicates even if doesn’t exist on the workspace
      4. Uploading a CSV file with an existing Provider Name and External ID new contact information within the CSV:
        • Existing: 
          • Provider Name: ProviderName2 / External ID: ExternalID2 / Contact Name: John Doe / Contact Email: john.doe@gmail.com
        • Upload: 
          • Provider Name: ProviderName2 / External ID: ExternalID2 / Contact Name: Jane Doe / Contact Email: jane.doe@gmail.com
        • Outcome: Upload is successful but the existing contact name is not replaced, instead new information from the CSV file is added as new contact information to the Provider
      5. Additional validations: Entries on the CSV file shouldn’t be successfully imported if there are:
        • Empty External ID or Provider Name on the CSV
        • Fields exceeded the maximum character limit
        • Incorrect or invalid country code (only accepts 2-letter country code)
        • Contact Info: Contact name exceeds the maximum character limit
        • Contact Info: Incorrect email format
        • Contact Info: Invalid country phone country code contact number
        • Contact Info: Empty contact name but contact email and contact number are populated with valid data.
        • Contact Info: Contact name (with value) but contact email and contact number data are invalid
        • Missing columns on the CSV file.
        • Column positions that are interchanged.