Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

View file
nameUserProfileUploadTemplateInstructions.xls
View file
nameUserDelegateUploadTemplate.csv

...

Extract Existing User Accounts/Profiles

Tip! You can skip this step if accounts/profiles do not already exist within the site.

...

Hint: Save a master file in a an Excel (.xls) format for each client. A master file allows you to:

...

  • Complete indicates the file was successfully uploaded.

  • Failed indicates the file completely failed to upload:

    • To research the cause, select the associated job name in the Description column.

    • In this example, the failure was due to a file that did not upload to the Deem vault at the time of processing. This client does not send the file on Saturdays and Sundays; therefore, they fail those days. 

  • Completed with errors indicates the file was successfully uploaded, but without any files that failed due to an error.
    Select Download from the Error Log column to view the errors for a specific file. The following example shows an error because the Approval Manager within profile does not exist. The profile will not update until an Approval Manager is created or an Approval Role is granted to them.

...

  • The HR feed with the External ID as an employee number and the User Name is an email address, if the email address changes, the HR feed changes the External ID automatically.

  • If the External ID and the UserName are both the same email address, you need to manually update the user account.

Delegate Upload

Template

  1. On Select the Profiles tab, select Download Templates.

    Image RemovedImage Added
  2. Select Download Templates with Instructions (Excel).

    Image Removed

Creating Delegate Upload

Keep in mind Headers are case-sensitive, below are the headers you will need to complete a delegate upload.

...

  1. .

    Image Added
  2. In User Delegate Upload, select Download CSV Template to download the UserDelegateUploadTemplate.csv file.

Create a Delegate Upload

To create a delegate upload:

In the UserDelegateUploadTemplate.csv, add data in the columns for the following headers.
Note: Headers are case sensitive.

  • externalID
    External ID of the user.

  • delegateSet.delegate_1.delegateID (ExternalID of Delegate)
    Note:
    External ID of the delegate.
    If you have more than one delegate, you can add additional headers. Just change the number columns with a header for each delegate. The number of the delegate needs to be changed in the header.

...

  • In this example, a second column is added with a delegateSet.delegate_2.delegateID

...

Example Delegate Upload: below representing two delegates.

  • Also see attached example to this Wiki articleheader.

...

Save a Delegate Upload

To create a delegate upload:

  • Delegate Upload file name.
    siteid_upload_delegate

  • File upload format.
    .CSV(comma delimited).
    Note:

...

  • CSV files will remove any leading zeros.

Hint: Save a master file in an Excel (.xls) format for each client. This will allow A master file allows you to keep :

  • Keep all leading zeros, if needed.

...

  • Easily update data or correct errors.

Schedule a Delegate Upload File

Steps for To schedule a one-time delegate file upload:

  1. On Select the Profiles tab, select .

    Image Added
  2. Select Schedule Profile Upload.

    Image RemovedImage Added
  3. Enter the following criteria when scheduling a one-time upload.

    • Select the Schedule : arrow to selectNow.

    • In Job Description: Enter , enter Delegate Upload.

    • In File Source:  Upload , selectUpload from local file.

    • In File Format: , selectCSV.

    • In Local File: Select , select Choose file and , then locate file to upload.

    • Select the Load TypeSelect to select User-Delegate Relationship.

  4. Select Submit.

    Image Removed

Upload Status

Common Errors

The following screenshot reflects example show status responses you that may encounter be displayed with a delegate file:.

...

Status options are:

  • Complete - File indicates the file was successfully uploaded.

  • Completed with errors - File indicates the file was successfully uploaded minus those who have , but without any files that failed due to an error.  

Error Example:

  • Delegate profile has not been created, therefore could not assign traveler. Account will need to be created and then you can re-upload the file.

  • If the traveler profile or the delegate profile do not exist, you will encounter this error.

...


  • Image Added

    In this example, an error occurred because a delegate profile is missing. Therefore, a traveler cannot be assigned. The delegate account must be created, and then the entire file must be uploaded again.
    Note: When correcting any errors on the delegate upload, you

...

  • must re-upload the

...

  • ENTIRE file to correct the errors

...

  • because the delegate upload is a full replacement of existing associations.

...

  • Please do NOT upload only the corrections.