Export data and schedule exports

Updated

Who can do this: Super Admins, Creators, Integrators and Collaborators

An export is a spreadsheet of your projects, tasks, accounts or users. OnRamp produces it in the background and emails it when it's ready. You can run one export once, or set up a schedule that runs daily, weekly or monthly.

Exports live in Settings > Exports, which has two tabs:

  • History lists every export produced, including the ones a schedule made.

  • Schedules lists repeating exports, which you can pause, edit, run or delete.

Contributors can't open Exports.

Choose what to export

Each export type has its own Status and Date type to use options:

Export

Status

Date type to use

Projects

Active, Completed, Archived, All

Created date, Start date, End date, Completed date, Archived date

Bulk project data

Active, Completed, Archived, All

Created date, Start date, End date, and more

Tasks

Not started, In progress, Blocked, Completed, All

Date created, Start date, Date started, Due date, Date completed

Accounts

Active, Disabled, All

Date created, Date disabled

Internal users

Active, Disabled, All

Date created, Date disabled

Customer users

Active, Disabled, All

Date created, Date disabled

For Accounts, Internal users and Customer users, Active and Disabled export with no time frame. Only All shows Time frame and Date type to use.

Choose the time frame

The time frames are Last 7 days, Last 30 days, This month, Last month, This quarter, Last quarter, This year, Last year and Custom range.

On a schedule, each run works out the dates for the day it runs. This month, This quarter and This year run from the first day of the period through the run day. Last month, Last quarter and Last year cover the whole previous period.

On a schedule, Custom range needs a From date, and To is optional:

You set

Each run covers

From only

From that date through the run date.

From and To

Exactly that window, every run.

Dates are calendar days in the schedule's time zone. A schedule whose To date has passed keeps running with the same window until you pause or delete it. A From date in the future produces an empty file until that date arrives.

Run a one-time export

  1. Go to Settings > Exports and select New export.

  2. Choose the Export, Status, Time frame and Date type to use.

  3. Leave Repeat set to Once. The dialog is titled Create new export.

  4. Select Create.

An Export requested message confirms it. You can leave the page; you'll get an email with a link back to Exports. If the file is about 200 KB or smaller, it's attached to the email too.

Create a schedule

  1. Go to Settings > Exports and select New export.

  2. Choose the Export, Status, Time frame and Date type to use. For a custom range, set From and, optionally, To.

  3. Under Repeat, choose Daily, Weekly or Monthly. The dialog title changes to Create schedule and more fields appear.

  4. Fill in the schedule fields:

    • Day: the weekday for weekly, or a day from 1 to 28 for monthly, so the export runs in every month.

    • Around: the hour the export runs.

    • Time zone: starts as your own.

    • Schedule name: how the schedule appears in the list and the email.

    • Also send to: teammates who get a copy of every run.

    • Other email addresses: addresses outside OnRamp that get a copy.

  5. Select Create.

The schedule appears on the Schedules tab with the dates it covers and its next run time. You can copy up to 20 people in total. Every run is also emailed to you, as the schedule's creator.

What happens on each run

Around the chosen hour, OnRamp works out the date range, produces the file and emails it. If an export was due while OnRamp was unavailable, the schedule catches up with one run, using the date range for the day it was due.

The default email subject is OnRamp Export Completed!, and the message names the schedule. Your organization can customize the Export Finished email. Files up to about 200 KB are attached. The email links to the Exports page, not to a direct download.

The email isn't sent, to you or anyone copied, if your organization turns off the Export Finished email, your organization has paused emails to internal users, or your notifications are paused. The file still appears in History.

Copies to teammates are checked at each run. Teammates who are deactivated or leave drop off, and changed addresses are followed. If the creator is deactivated or leaves, the schedule pauses at its next run. To keep it going, create a new schedule as an active user.

Manage schedules

On the Schedules tab, each row shows the name, export type, Covers (for example, Last 7 days, Aug 10 to the run date or Aug 10 – Aug 24), how it repeats, the next run in the schedule's time zone, and the Last run result. The row menu has:

  • Edit: change any setting, except that Repeat can't be switched to Once. The next run is recalculated from now.

  • Pause or Resume: a paused schedule shows Paused under next run. Runs missed while paused aren't sent.

  • Run now: runs it immediately without changing the schedule.

  • Delete: removes the schedule. Exports it already created stay in History.

Download past exports

The History tab lists each export with When, User, Type, Status and Filename. Search with Search filename or user..., or narrow the list with Filter by User... and Filter by Type.... Statuses include Scheduled, Processing, Completed and Failed.

From a row's menu, select Download. It's unavailable, showing No file available yet, until the file exists. The menu also has Delete for a finished export, or Cancel Export for one still pending. Exports are kept for 90 days.

Only the six export types can be scheduled. View exports and project responses exports also appear in History, labeled View export and Responses, but you start them elsewhere.

More in Reporting & Insights