Versions Compared

Key

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

View file
nameUser Profile and Delegate ExtractExtracts_20Sept23.pdf

...

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.

Overview

Learn how to pull and profile or delegate extractOn this page:

Table of Contents
minLevel1
maxLevel7

Benefits & Limitations

...

Benefits

...

Benefits

...

  • Pull partial or full extracts

  • Pull separate delegate extract

...

Limitation

6
outlinefalse
stylenone
typelist
printablefalse

Overview

User profile and delegate extracts can be used to review and maintain user profiles and delegate associations.
Note: Secured data such as credit card

...

When pulling extract of vendors, you are unable to pull a specific vendor, will need to clean up the file and remove those you do not need

...

information is encrypted in the extracts.

Extracting:

  • User profiles provides the ability to pull a full extract or to narrow the extract down to specific profile elements.

  • Delegate associations provides the ability to pull an extract showing user-delegate associations. You can use this data to determine which users are delegated to book for or be booked by other users.

You can pull partial or full profile extracts, or pull separate delegate extracts. You can extract as little information or as much information as needed from a user’s account, such as frequent flier memberships to a full user extract. However, there are two exceptions:

  • You cannot pull an extract for a specific vendor. You must remove unneeded vendors from the extracted file.

  • You cannot pull an extract of a specific individual

...

  • . You will need to pull all profiles and filter out

...

  • the unneeded profiles.

User Profile Extract

...

Task

...

Process / Helpful Hint

...

Extract Profile

...

Allows for the ability to pull a full extract, or narrow the extract down to specific profile elements.  Example below will be that of requesting air frequent flier data associated to all profiles.

  • Log into the Deem Dashboard and access the client’s site

  • Click on the Profile tab

  • Click on Extract Profiles

...

  • Filters - To customize the extract click on the top checked box, which will uncheck all boxes.

    • select each field to be extracted

      • ExternalID

      • Domain

      • AccountStatus

      • EmployeeStatus

      • UserName

      • FirstName

      • LastName

      • Email

...

  • If you are looking for only the air frequent flier programs

    • Move to the bottom of the box and select ServicePreferences to expand

    • Expand AirlinePreferences

    • Click on membershipSet

...

  • Under Job Options

    • Enter Job Description

      • Note: Name whatever you want, such as FF Membership

  • Click on Submit

...

  • The Extract Activity logs will appear, you can click on the Refresh button until the completion and download is available

...

Recovering Extract

...

  • Extracts will be housed in Deem, if you would like to come back to pull the report.

    • Click on Profiles tab

    • Click on Extract Activity Logs

...

Delegate Extract

...

Task

...

Process / Helpful Hint

...

Extract

...

Allows access to pull an extract of all delegates and what accounts they are associated with

  • Log into the Deem Dashboard and access the client’s site

  • Click on the Profile tab

  • Click on Extract Profiles

...

  • Extract Type: Change to User-Delegate  Relationships

  • Job Description: Name whatever you would like, in this case will be naming: Delegate Extract

  • Click Submit

...

Recovering Extract

  • Extracts will be housed in Deem, if you would like to come back to pull the report.

    • Click on Profiles tab

    • Click on Extract Activity Logs

...

For user profiles, you can:

  • Initially extract the profile.

  • Retrieve the extracted profile at a later time.

To extract user profile data:

  1. From the Partner Dashboard home page, select the Profiles tab.

    Image Added
  2. Select the Extract Profiles link to display the Extract Profiles page.

    Image Added
  3. In Extract Type, select User Profile.

  4. In Extract By, select the scope of the extraction: Domain, Sub-Domain, Group, or WebService Subscription.

Query

  1. In Type, select either:

    • Full Download to extract all data based on the filters applied in the following section.

    • Selective Download to select a constraint for the extracted data. For each constraint, select from the associated condition options.

      ProfileExtract_SelectiveDownload.pngImage Added
  2. Optional. Select Include only active employees to exclude any employees that do not have an active profile.

Filter

  1. In the Filters section, select the desired filters.
    Tip: To clear all active check boxes, select the top check box to clear that box and all child boxes below it.
    In this example, in addition to the profile filters for user identification, you can specify data for frequent flier programs by:

    1. Scrolling through the filter list to ServicePreferences.

    2. Selecting ServicePreferences to expand the hierarchy.

    3. Expanding AirlinePreferences.

    4. Selecting membershipSet and its child filters.

      Image Added

Output Destination, File Format, and Job Options

...

  1. In Destination, select from the available storage locations for the file. Extract files are stored on Deem servers.

  2. In File Format, select either:

    • CSV (Comma-Separated Values) files. CSV files use a simple table format with data separated by commas.

    • XML (Extensible Markup Language) files.

Page Properties
hiddentrue

Comment

Status/SME reply

ET: Do we want to provide a brief layperson’s description for XML and XML editors – or will this audience already have familiarity?

This question also applies to the same step in the delegate worklow.

  1. Optional. In Password, enter a password required to view the archived zip file. Passwords:

    • Must contain at least one letter and one number.

    • Cannot contain your user name, first name, or last name, and cannot be a common dictionary word.

  2. In Job Description, enter an easily recognizable description, such as ff membership.

  3. Optional. In Job Completion Email, enter an email address for notification when the extraction download is complete.

Page Properties
hiddentrue

Comment

Status/SME reply

ET: There was no description in the original content for this field and I don’t have connectivity to the server, so I am assuming this is the function and it is enabled?

This question also applies to the same step in the Delegate workflow.

  1. Select Submit to display the Activity Logs page.

    Image Added
  2. When the extract is completed, select the associated Download link to download a ZIP file that contains the extraction file.

Page Properties
hiddentrue

Comment

Status/SME reply

ET: I can’t test. Is it correct that this is downloaded as a ZIP?


Tip: If the Download link does not display, select Refresh to update the page display.

Extract User-Delegate Relationships

For user-delegate associations, you can extract data to show the associations between which users can booked for or be booked by another user. You can:

  • Initially extract the association data.

  • Retrieve the extracted file at a later time.

To extract user-delegate data :

  1. From the Partner Dashboard home page, select the Profiles tab.

    Image Added
  2. Select the Extract Profiles link to display the Extract Profiles page.

    Image Added
  3. In Extract Type, select User-Delegate Relationships.

  4. In Extract By, select the scope of the extraction: Domain, Sub-Domain, Group, or WebService Subscription.

Query

  1. In Type, select either:

    • Full Download to extract all data based on the filters applied in the following section.

    • Selective Download to select a constraint for the extracted data. For each constraint, select from the associated condition options.

      ProfileExtract_SelectiveDownload.pngImage Added
  2. Optional. Select Include only active employees to exclude any employees that do not have an active profile.

Output Destination, File Format, and Job Options

  1. In Destination, select from the available storage locations for the file. Extract files are stored on Deem servers.

  2. In File Format, select either:

    • CSV (Comma-Separated Values) files. CSV files use a simple table format with data separated by commas.

    • XML (Extensible Markup Language) files.

  3. Optional. In Password, enter a password required to view the archived zip file. Passwords:

    • Must contain at least one letter and one number.

    • Cannot contain your user name, first name, or last name, and cannot be a common dictionary word.

  4. In Job Description, enter an easily recognizable description, such as Delegate Extract.

  5. Optional. In Job Completion Email, enter an email address for notification when the extraction download is complete.

  6. When the extract is completed, select the associated Download link to download a zipped file that contains the extraction file.

    Image Added

    Tip: If the Download link does not display, select Refresh to update the page display.

Retrieve Extracted Files

Page Properties
hiddentrue

Comment

Status/SME reply

ET: Changed “Recover” to “Retrieve”. To end users, “recover” usually implies retrieving data that was previously lost or damaged.

Also combined the profile and delegation retrieve sections because they use the same workflow.

Profile and delegation extracts are stored on Deem servers. However, you can view archived extracts in the activity logs.

To view archived profile or delegation extracts:

  1. From the Partner Dashboard home page, select the Profiles tab.

    Image Added
  2. Select the Extract Activity Logs link to display the Activity Logs page. In this example, a profile extract is displayed.

    Image Added
  3. Select Download to download a zipped file that contains the extraction file.

Page Properties
hiddentrue

Comment

Status/SME reply

ET: I can’t test. Is it correct that this is downloaded as a ZIP?