Skip to main content

Integrating FOUNDATION with Raken

In this article, learn how to enable the FOUNDATION integration in Raken and export formatted time card CSV files for direct import into FOUNDATION Software.

Written by Carolina Manos

The Raken + FOUNDATION Software integration formats your Raken time card export to match FOUNDATION's import template β€” so you can download a pre-formatted CSV and import it directly into FOUNDATION without any reformatting. Save time and eliminate the errors that come from manual data entry.


Quick Answer

To enable the FOUNDATION integration:

  1. Log into the Raken web app and click Company > Integrations.

  2. Click the FOUNDATION tile and click + Connect.

  3. Export time cards from Time > Timesheets and select FOUNDATION from the download options.

Requires the Performance Plan.


How It Works

This is a flat file / CSV export integration. Once enabled, Raken formats your time card CSV to match the FOUNDATION import template. You download it from Raken and import it into your FOUNDATION account.

Before exporting, make sure the following required fields are complete in Raken β€” FOUNDATION requires all of these for a successful import:

  • Job Number (Project ID # in Raken)

  • Employee ID (Employee No. in Raken)

  • Cost Code

  • Phase Number (if applicable)


How to Enable the Integration

Step 1: Navigate to Integrations

Log into the Raken web app. Click Company in the left side navigation, then click Integrations.

Step 2: Connect FOUNDATION

Click the FOUNDATION tile, then click the orange + Connect button. Your Raken time card CSV exports now use the FOUNDATION format.


How to Export Time Cards for FOUNDATION

  1. Log into the Raken web app and click Time in the left side navigation.

  2. Click Time cards, then click Timesheets.

  3. Select the pay period you want to export.

  4. Click the download icon in the top right and select FOUNDATION. The formatted CSV downloads to your device.

  5. Log into FOUNDATION and import the CSV file. Contact FOUNDATION Support for help with the import process if needed.


Troubleshooting & FAQ

The import is failing β€” what should I check?

Verify that all required fields are complete in Raken: Job Number, Employee ID, Cost Code, and Phase Number (if applicable). Missing or mismatched values are the most common cause of import failures. Contact FOUNDATION Support for import-specific questions.

Does the integration require a custom FOUNDATION configuration?

FOUNDATION integrations can require custom configuration depending on your account setup. If you need assistance, contact your FOUNDATION account representative or FOUNDATION Support.


Technical Specifications

  • Compatibility: Web app only (Raken side)

  • Integration type: CSV flat file export

  • Plan required: Performance Plan

  • Role required: Account Administrator to enable; all users can export


Considerations

  • Requires the Performance Plan and an active FOUNDATION account.

  • Job Number, Employee ID, Cost Code, and Phase Number must be populated in Raken for the import to process correctly.

  • FOUNDATION import configurations may vary β€” contact your FOUNDATION account rep for account-specific setup help.


Related Articles


More Questions?

Feel free to email us or call us at +1 866-438-0646. We're always glad to answer your questions!

Did this answer your question?