OnePlan and Tabular Data for Time Off Import

This integration is designed to streamline the process of importing approved Time Off requests into the OnePlan Time Off section using a CSV UTF-8 file.

OnePlan

To complete the OnePlan setup, you need to be an admin (user with Owner permissions) in OnePlan.

1. Log into your OnePlan group using your OnePlan login credentials.
2. Access the Admin pages by clicking on the settings (gear) icon at the top right of the browser.
3. Navigate to the Integration section in the left-hand navigation panel.
4. Next to the Authentication Keys section click the + Add Key button.
5. Provide a descriptive name or title for the Authentication Key to denote its purpose, then click ADD.
6. Store the OnePlan group name and the Authentication Key securely. This grants access to your OnePlan group for any program. Please note that the key will no longer be visible after the page is refreshed.

Note: It's recommended to generate a new authentication key for every integration and assign a descriptive name to each key, enabling clear association with its corresponding integration. This practice enhances security, simplifies management, and facilitates easier tracking and troubleshooting.

Time Off setup & How to Locate Fields for CSV Import

Finding and Creating Time Off Categories

Time off requests do require the request to have a Category to associate the time off as. The value within the CSV file must match the Category name listed (case sensitive).  To locate and add to the list of available Time Off Categories:

1. Navigate to the OnePlan Admin pages, expand the Time Off Plan in the left-hand navigation panel.
2. Click on Time Off Categories +.
3. Give the new Time Off Category a Name.
4. Click ADD.

Entering Date Values

The date values should be in the format of 2022-05-22 (YYYY-MM-DD). 

Entering Hour Values

The expected initial hours value should be a positive number, allowing up to two decimal places. It’s important to note that the maximum number of hours per day is capped at 8 hours. If updating the Time Off hours to a lesser number (e.g., going from 8 hours down to 5 hours), then negative values will be accepted (-3) to fix the amount of time off being used.

Naming Your CSV File

As the integration lacks a specific field for file names, it is imperative that the CSV UTF-8 file be named TimeOff.csv to ensure proper identification and compatibility.

OneConnect Setup Process

To complete the OneConnect setup, you need to be an Administrator or Editor in the OneConnect group you wish to set the integration up in.

1. Go to https://my.oneconnect.ai (or https://eu.oneconnect.ai for European customers utilizing eu.oneplan.ai).
2. Navigate to Tabular Data and OnePlan Time Off Import. Click Configure.

Tabular Data Connector

1. Authorize button: This button must be authenticated by a Microsoft Tenant Administrator. This is required for the service principle connection. Please review this article for more information. 
2. SharePoint or OneDrive URL
   • Enter the SharePoint/OneDrive URL where the file is located (e.g., https://{OrganizationName}.sharepoint.com/sites/{SiteName}).
3. Folder Path
   • Enter the folder path where the file is located.
4. Additional Options
   • Expand the section for additional configuration options.
5. (Optional - Checkbox) Use Last Modified File instead of File Name
   • Used only when connecting to OneDrive. When checked the last edited file will be used from the specified location.
6. Test Connection
   • Click Test to verify the correctness of the connection settings to SharePoint/OneDrive.
   • A notification indicating Connected Successfully should appear in the top-right corner of the browser upon successful testing.
7. Save Changes
   • After verifying the connection, click Save to retain the configured settings.

OnePlan Connector

1. Group Name
   • Input the name of the OnePlan Group name you intend to integrate with.
2. Authentication Key
   • Paste the generated OnePlan Authentication Key obtained from OnePlan.
3. Additional Options
   • Expand the section for additional configuration options.
4. (Optional) Alternate OnePlan Environment URL
   • If using an environment other than the default (https://my.oneplan.ai), select the appropriate URL from the available options:
     • https://au.oneplan.ai 
     • https://ca.oneplan.ai 
     • https://eu.oneplan.ai
5. Test Connection
   • Click Test to verify the correctness of the connection settings to OnePlan.
   • A notification indicating Connected Successfully should appear in the top-right corner of the browser upon successful testing.
6. Save Changes
   • After verifying the connection, click Save to retain the configured settings.

Integration Information

Default Field Mappings

TimeOff - TimeOff Section

Currently, default field mappings are not predefined for this integration.

Mandatory Fields

The integration does not currently have the ability to map fields between Tabular Data to OnePlan. Because of this, the CSV column names must have: Resource Name, Email, Start, End, Category, and Hours.

Default Scheduled Strategies

SyncTimeOff

This strategy synchronizes Time Off from Tabular Data to OnePlan Time Off.

Recommended Suggestions

Allocating the Same Hours of Time Off for Multiple Consecutive Days

If allocating the same time off for multiple consecutive days, then a single row listing the Start date and the End date with the Hours value will suffice as is.

Allocating Unique Hours for Multiple Consecutive Days

If allocating a different amount of time for each day, a unique row will have to be entered within the .CSV file for each day.

Integration Limitations

Time Off Requests Only Apply to Non-Generic Resources

Time off allocation is exclusive to non-generic resources. Generic resources will not feature the time-off button as part of their functionality.

Integration does not set or update timesheets

This integration exclusively pertains to the setup of Time Off requests. It's important to note that Timesheets data remains unaffected by the operations of this integration.

Does not Allocate Notes to Time Off 

At present, this integration lacks the capability to update or set notes for Time Off. Please be aware of this limitation in the current functionality.

• TimeOff.csv109 Bytes