| View file | ||
|---|---|---|
|
| View file | ||
|---|---|---|
|
| View file | ||
|---|---|---|
|
| View file | ||
|---|---|---|
|
| View file | ||
|---|---|---|
|
...
To download above documents:
Click on desired document to open it. Then, click on the cloud symbol in the top right corner of your screen to download, save, or print.
Click on the video above to see full demonstration.
| Table of Contents |
|---|
...
Overview
User profile uploads, /HR Feeds, feeds and Delegate delegate uploads provide clients with the ability to manage their user accounts/profiles with ease.
An HR Feed - Allows allows clients to maintain user profiles/accounts on a daily, weekly, or bi-weekly basis.
Strongly recommended. It is highly strongly recommended to have an HR feed , if the a client has Single Sign-on (SSO) or Open Expense enabled.
Recommended. Daily HR feeds are recommended due to the frequency of employment changes.
A profile upload can be used as needed to provide account data.
Upload at any time to create, deactivate, or update user accounts/profiles.
Used whenUse profile uploads for tasks such as onboarding user accounts
.Massand making mass updates to user accounts including reporting fields
.
HR feed/Profile upload is feeds/profile uploads are customizable. You can remove and add columns
, allowing for easy upload and clarity.Delegate
A delegate upload - Allows allows clients to associate delegates to user profiles.
...
A delegate upload is best used before going live as a one-time
...
association between the delegate and user account/profile
...
.
Strongly recommended. Because the delegate upload is a full replacement of existing associations, the file may remove delegate/user associations if all data is not on the file. Therefore,
...
it is
...
recommended to upload only during on-boarding process
...
.
...
Recommended: Allow delegates and users to assign associations within their profile settings
...
after the site is live.
Need to Know
Automated The automated HR Feed is processed by Deem. Contact 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.
...
if you need assistance.
TMC creates and maintain HR feeds for clients.
See the HR Feed Checklist for steps to follow.
Instructions on how to create an HR feed can be found in the following User Profile Upload section.
Additional documents and checklists:
Extract Existing User Accounts/Profiles
Tip! You can skip this step if accounts/profiles do not already exist within the site.
It is recommended to pull a profile extract to ensure that profiles are created properly. Extracts are also helpful when configuring the HR feed.
See User/Profile Extracts for more information.
HR Feed/User Profile Upload Template
To use the HR Feed/User Profile Upload, download the associated template, and review the instructions and support content.
Download Template
To download the HR Feed/User Profile Upload Template:
...
From the Profiles tab, select Download Templates.
Select Download Templates with Instructions (Excel)
...
. This file contains not only a template you can customize,
...
instructions for the template, 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
...
Review the Attached Excel Spreadsheets
Download the attached Excel spreadsheet, UserProfileUploadTemplateInstructions.xls, at the top of this page for use with these instructions. In the spreadsheet:
The Upload Error Responses tab provides an error key with errors and resolutions when uploading data.
The User Database List of Values tab provides an example of the list of values available for your database when uploading your data.
User Profile Upload
When creating a user profile upload, the HR feed/User Profile upload may look overwhelming, but keep in mind you can customize.
...
To use the template:
In UserProfileUploadTemplateInstructions.xls, open the User Upload Template tab.
Remove any column/columns not needed.
...
Complete the following fields, which are required or critical when onboarding user profiles
...
or HR Feeds.
...
Note: Headers are case sensitive.
externalID
Typically matches the User Name, but it is recommended to use information that is
...
unique an individual user such as
...
an 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 an account.
A=Activate
D=Deactivate
employeeStatus
Activates or
...
deactivates an account.
A=Activate
D=Deactivate
...
roleSet.role_1
Value ROLE_TRAVEL_APPROVERuserInfo.travelApproverID
Value externalID of manager
For more information about profile attributes, see Single Sign On - SSO.
File Name
...
and File Type Requirements
The following list includes file name and file type requirements for profile uploads:
Ad hoc Profile Upload file name.
siteid_uploadOngoing HR Feed file name.
20231201
siteid_yyyymmdd (example: demodeem_20231201)
Upload format.
.CSV (comma delimited)
Note: CSV files
...
remove any leading zeros.
Hint: Save a master file in a 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 One-Time User Profile Upload
Steps This section lists steps for a 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 It is recommended to schedule a one-time upload to test HR feed before configuring the ongoing HR feed.
Note: Set up a profile upload to assign approver role to the manager, if a manager from a profile is set up in the approval process. Next, schedule a profile upload to assign the manager to the user accounts. You can then schedule the HR Feed.
To schedule a one-time upload:
Select the Profiles tab.
Select Schedule Profile Upload.
Select the Schedule arrow to select Now.
In Job Description, enter the client's site ID.
Note: For one-time uploads, it is best practice to describe the intent or purpose of the upload.
...
For example: Add New Users, Adding Employee ID, or Updating Department Codes.
In File Source
...
, select Upload from local file.
In File Format
...
, select CSV.
In Local File
...
, select Choose File to locate the file to upload.
In Load Type:
Select the Load Type arrow to select User Profiles.
...
Once the file has been processed, you will see either Completed or Completed with Errors.
...
Select the Allow New Usersradio button.
...
Click radio button to the left of Ignore empty double quotes.
...
Click Submit.
Select the Ignore empty double quotes radio button.
Select Deactivate users not in file only if you want todeactivate any user account/profile that is not present on the file. If you do select this option, also select Allow upload if deactivation > 10% if you believe there may be more than 10% of users that may need to be deactivated.
Select Submit to display the Activity Logs screen.
After the file is processed, either a message is displayed for each file in the Profile Uploads list.Completedindicates the file is successfully uploaded with no errors detected.
Completed with Errors
...
indicates the upload completed successfully, but
...
contains errors. Select the Completed with Errors link
...
In this case, the file was completed successfully
...
to see the associated errors. Correct the errors and upload the updated file again.
Upload a Single Reporting Field
A single reporting field can be easily updated through a user/profile upload. The only required 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 are required to upload all reward programs for users.
The rewards programs are dependent on each other:
If only one or two air
...
, car, or hotel membership numbers are uploaded,
...
but a user’s profile contains several
...
membership numbers that are not
...
on the upload file
...
, these membership numbers are removed.
If uploading air memberships, you do not need to also include the car or hotel membership programs, and vice versa.
...
Schedule HR Feed
Before scheduling an ongoing HR feed, you will want to test to ensure headers and field data is are correct. Conduct Then conduct a one-time upload.
Steps to Note: It is recommended to configure managers as the first users on the HR feed. This order helps to alleviate errors with manager and user association.
To schedule an HR Feed:
...
Select the Profiles tab
...
.
Select Schedule Profile Upload.
...
...
Select the Schedule arrow to choosethe frequency option that best suits the client’s needs.
In Start Date
...
, enter the date to start upload pull from the Deem Vault.
In Time
...
, enter the time to pull
...
Duration: Select one of the options provided.
Job Description: Enter Daily HR Feed, Weekly HR Feed, etc.
...
the file. Times are listed in PST (Pacific Standard Time), which is UTC-8:00.
In Duration, select a duration option.
In Job Description, enter a brief description such as Daily HR Feed or Weekly HR Feed.
In Job Completion Email,enter the email addresses that will receive the success/error report. Email types are: Completed, Completed with Errors, and Failed.
Separate each email address with a comma.
Always include
...
ProfileLoad@deem.com in the email list.
...
Emails types: Completed, Completed with Errors or Failed.
...
In File Source, select Upload from SFTP server.
In File Format
...
, select CSV.
In Secure FTP
...
, select the vault that Deem has
...
created for you.
...
Note: If you do not have Secure FTP set up, please open a Deem Support Case.
In Remote File/File Name Pattern
...
, enter siteID_$yyyy$mm$dd.csv.
Note: The dollar sign $ tells the system to read the date as the current date. If the file name does not contain the current date, the
...
upload will fail.
In Preview File Name
...
, confirm that the file name is correct
...
based on your entry
...
in Step 12.
In Load Type:
Select the arrow to select User Profiles.
Select
...
the
...
Allow New Users radio button.
Select
...
the
...
Ignore empty double quotes radio button.
Select
...
Deactivate users not
...
in file if you want to allow clients to send an upload
...
that contains only active traveler accounts
...
. The system deactivates any profile not listed in the HR feed.
...
A message is displayed to confirm the the deactivation.
Select Submit
...
to display newly scheduled upload on the Schedules screen.
Upload Status
Example below reflects The following example shows status responses you that may encounter with display after an HR feed or Profile upload.:
...
Complete - File indicates the file was successfully uploaded.
Failed - File indicates the file completely failed to upload.:
To research what is causing the errorcause, select the associated job name to the far left of the failed indicatorin the Description column.
In this caseexample, the failure was due to the a file that did not being uploaded 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 - File indicates the file was successfully uploaded minus those who have , but without any files that failed due to an error.
Example below reflects error due toSelect 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
has beenis created or an Approval Role is granted to them.
Note: You can use the profile upload to update the User Name user name if that UserName is the only one data in the file that has changed. For example, if you configure the :
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
...
Select the Profiles tab
...
.
...
Select Download Templates
...
.
...
Creating Delegate Upload
Keep in mind Headers are case-sensitive, below are the headers you will need to complete a delegate upload.
...
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)
headers. Just change the number
External ID of the delegate.
If you have more than one delegate, you can add additionalcolumns 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 attached example to this Wiki article.
...
Saving Delegate Upload
header.
Save a Delegate Upload
To create a delegate upload:
Delegate Upload file name.
siteid_upload_delegateFile 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:
...
Select the Profiles tab
...
.
Select Schedule Profile Upload.
...
Enter the following criteria when scheduling a one-time upload.
Select the Schedule
...
arrow to selectNow.
In Job Description
...
, enter Delegate Upload.
In File Source
...
, selectUpload from local file.
In File Format
...
, selectCSV.
In Local File
...
, select Choose file
...
, then locate file to upload.
Select the Load Type
...
to select User-Delegate Relationship.
Select Submit.
...
...
Upload Status
The Screenshot below reflects following 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.
...
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.