User/Profile Upload, HR Feed and Delegate Upload

Task

Process / Helpful Hint

Benefit

• HR Feed - Allows clients to maintain user profiles/accounts on a daily, weekly, or bi-weekly basis.

  • It is highly recommended to have an HR feed, if the client has Single Sign-on (SSO) or Open Expense enabled.

• Profile upload - Available as an ad-hoc upload.

  • Upload at any time to create, deactivate or update user accounts/profiles.

    • Used when onboarding user accounts.

    • Mass updates to user accounts including reporting fields.

• HR feed/Profile upload is customizable.

  • You can remove and add columns, allowing for easy upload and clarity.

• Delegate upload - Allows clients to associate delegates to user profiles.

Note: Best used as a one-time Delegate - User account/profile association, before going live. The file may remove delegate/user associations if all data is not on the file, therefore it is best to upload only during on-boarding process. The delegate upload is a full replacement of existing associations.

Best practice: Allow delegates and users to assign associations within their profile settings, once the site is live.

Need to Know

Automated HR Feed processed by Deem.

• SOW is required for an automated HR feed, if processed by Deem (This is a cost item).

  • Contact Deem Channel Sales director.

  • Once SOW has been signed the request will go to the CX Team who will work with the client and/or TMC to set up the process.

    • To prepare you can start by creating the HR feed.

    • For further information please click link Automated HR feed.

Task

Process / Helpful Hint

Download Template

• On the Profiles tab, select Download Templates.

• Select Download Templates with Instructions (Excel)

  • Downloaded file contains not only a template you can customize, but also instructions and database values.

Error Key

• Please see attached example in this Wiki article.

Database List of Values 

• Please see attached example in this Wiki article.

Create User Profile Upload

• The HR feed/User Profile upload may look overwhelming, but keep in mind you can customize.

• Headers are case sensitive.

• Remove any column/columns not needed.

  • Fields required or critical when onboarding user profiles, or HR Feeds.

    • externalID (Typically matches the User Name, but it is recommended to use information that is specific to the user such as their Employee ID. This way if you have an HR feed you have a field that is different and will make changes easier for you.).

    • userInfo.userName

    • userInfo.firstName

    • userInfo.lastName

    • userInfo.email

    • accountStatus

      • Activates or Deactivates account

        • A=Activate

        • D=Deactivate

    • employeeStatus

      • Activates or Deactivates account

        • A=Activate

        • D=Deactivate

  • See attached example within this Wiki article.

File Name/Type Requirements

• Ad hoc Profile Upload file name.

  • siteid_upload

• Ongoing HR Feed file name.

  • siteid_yyyymmdd (example: demodeem_20231201)

• Upload format.

  • .CSV(comma delimited)

Note:  CSV files will remove any leading zeros.

Hint: Save a master file in a .xls format for each client. This will allow you to keep all leading zeros if needed. Also allows for updates or if there are any errors, you can update with ease.

Schedule One time  User Profile Upload 

Steps for one-time upload.

• On the Profiles tab, select Schedule Profile Upload.

Enter the following criteria when scheduling a one-time upload.

• Schedule: Now.

• Job Description: Enter the clients siteID.

Note: Best practice on using the Job Description for an ad hoc upload is to describe the intent or purpose of the upload. 

Example: Add New Users, Adding Employee ID, Updating Department Codes.

• File Source:  Upload from local file.

• File Format: CSV.

• Local File: Select Choose file and locate file to upload.

• Load Type: Select User Profiles.

• Click radio button to the left of Allow New Users.

• Click radio button to the left of Ignore empty double quotes.

• Click Submit.

Once the file has been processed, you will see either Completed or Completed with Errors.

• Completed: Successfully uploaded with no errors detected.

• Completed with Errors: Completed successfully, but with a few errors –  you will need to fix these errors and re-upload the updated file.

  • To see the errors associated with the upload, select Completed with Errors link. Deem will advise you what is causing the error, which you will need to resolve and attempt the upload again.

  • In this case, the file was completed successfully

Upload Single reporting Field

A single reporting field can be easily updated through a user/profile upload. The only fields you will need are the externalID and the reporting field.

Upload Frequent Traveler Programs

When uploading a Frequent Traveler reward program, you will be required to upload all reward programs for the user(s). The rewards programs are dependent on each other; If only one or two air reward membership numbers are uploaded, yet the user(s) profile contains several, then file will remove those that are not included on the file. This is the same for car and hotel as well. Keep in mind if uploading air, you do not need to also include the car or hotel membership programs, vice versa.

Schedule HR Feed

Before scheduling an ongoing HR feed, you will want to test to ensure headers and field data is correct. Conduct a one-time upload.

Steps to schedule an HR Feed:

• On the Profiles tab, select Schedule Profile Upload.

• Schedule:  Select from list of schedules which best suits the client’s needs.

• Start Date: Enter date you would like to start upload pull from Deem Vault.

• Time:  Enter time to pull file, keep in mind the times are all in PST.

• Duration: Select one of the options provided.

• Job Description: Enter Daily HR Feed, Weekly HR Feed, etc.

  • Job Completion Email: Enter email address of those who would like to receive the success/error report. Separate each email address with a comma.

    • Always include - ProfileLoad@deem.com.

    • Emails types: Completed, Completed with Errors or Failed.

  • File Source:  Upload from SFTP server.

  • File Format: CSV.

  • Secure FTP: Select Vault Deem has been created for you.

    • You will need to open a Deem Support Case, If you do not have Secure FTP set up.

  • Remote File/File Name Pattern: siteID_$yyyy$mm$dd.csv.

Note: The $ tells the system to read the date as the current date. If the file name does not contain the current date, the file will fail.

• Preview File Name: Confirm file name is correct, automatically displays based on your entry above.

• Load Type: User Profiles.

• Select radio button to the left of Allow New Users.

• Select radio button to the left of Ignore empty double quotes.

• Select radio button next to Deactivate users not on file.

  • This action allows clients to send an upload of only active traveler accounts, and the system will deactivate any profile not listed in the HR feed.

  • Box will appear, allowing you to confirm you would like to deactivate all profiles that do not appear on the file.

• Select Submit.

• You will be directed to the Schedule screen.

Upload Status

Example below reflects status responses you may encounter with an HR feed or Profile upload.

• Complete - File was successfully uploaded.

• Failed - File completely failed to upload.

  • To research what is causing the error, select the job name to the far left of the failed indicator.

  • In this case, the failure was due to the file not being uploaded 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 - File was successfully uploaded minus those who have failed due to an error.

  • Example below reflects error due to the Approval Manager within profile does not exist. The profile will not update until Approval Manager has been created or Approval Role granted to them.

Note: You can use the profile upload to update the User Name if that is the only one in the file that has changed. For example, if you configure the HR feed with the External ID as their employee number, and the UserName is their email address, yet the email address changes. The HR feed will change the External ID automatically for you. But if the External ID and the UserName are the same, you would need to manually update the user account.

Task

Process / Helpful Hint

Template

• On the Profiles tab, select Download Templates.

• Select Download Templates with Instructions (Excel).

Creating Delegate Upload

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

• externalID (ExternalID of User)

• delegateSet.delegate_1.delegateID (ExternalID of Delegate)

  • If you have more than one delegate, you can add additional headers. Just change the number in the header.

Example: delegateSet.delegate_2.delegateID

Example Delegate Upload: below representing two delegates.

• Also attached example to this Wiki article.

Saving 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 .xls format for each client. This will allow you to keep all leading zeros if needed. Also allows for updates and/or if there are any errors with the upload, you can fix any errors with ease.

Schedule Delegate Upload File

Steps for one-time upload

• On the Profiles tab, select Schedule Profile Upload.

Enter the following criteria when scheduling a one-time upload.

• Schedule: Now.

• Job Description: Enter Delegate Upload

• File Source:  Upload from local file.

• File Format: CSV.

• Local File: Select Choose file and locate file to upload.

• Load Type:  Select User-Delegate Relationship.

• Select Submit.

Common Error

The Screenshot below reflects status responses you may encounter with a delegate file

• Complete - File was successfully uploaded.

• Completed with errors - File was successfully uploaded minus those who have 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.

Note: When correcting the error(s) on the delegate upload, you will need to re-upload the entire file to correct the errors. Please do not just upload the corrections, as the delegate upload is a full replacement of existing associations.