Bulk Importing Time Entrieshubplanner2018-08-07T10:21:08+02:00
Please note: Projects and Resource must already exist in your account before you can bulk upload time entries to Hub Planner. Please follow instructions below.
Bulk Upload New Time Entries
In order to upload new time entries you will need to follow the steps listed below:
Download the CSV Time Entries Template here – You will need this again in Step 5.
Download the Resources CSV Reference file (Located in Settings / Manage Projects / Add New Projects | Bookings (Button top right) / Add Multiple Bookings / Download All Resources). A csv file will be downloaded to your computer. You will use this file to reference the resource ID.
Download the Projects CSV Reference file (Located in Settings / Manage Projects / Add New Projects | Bookings (Button top right) / Add Multiple Bookings / Download All Projects). A csv file will be downloaded to your computer. You will use this file to reference the project ID.
The 2 reference files download in step 2 and 3 are used to find the resource ID and project ID you want to add the time entries to.
First open up the file exportResources.csv (downloaded in step 2) and find the name of the resource you want to add time entries to. Once you find the resource copy or take note of the resource_id for that resource. You will need to paste this value in Step 5.
Next open up the file exportProjects.csv (downloaded in step 3) and find the name of the project you would like to add time entries to. Once you find the project copy or take note of the project_id for that project. You will need to paste this value in Step 5
Open the Time Entries Bulk Upload template file (downloaded in Step 1) and copy and paste the corresponding resource and project id’s to the correct columns.
resource – add your resource_id here
project – add your project_id here
Repeat a row for each time entry you want to create. Additional options can be seen below for updating time entries and some optional parameters.
The following options are valid for uploading time entries via our CSV template which can be downloaded here
id – (optional)
Empty (default creates a new time entry)
Id to update an existing time entry
minutes – (required)
Time Entry duration in minutes.
date – (required)
Date of time entry (Format mm/dd/yyyy)
resource – (required)
Id to associate a resource with the time entry
project – (required)
Id to associate a project with the time entry
categoryName – (optional)
The category name of the time entry, will default to your default category if left blank. Reference your booking category names from the settings page.
status – (required)
UNSUBMITTED – Goes to unsubmitted state
SUBMITTED – Goes to submitted state
note – (optional)
Time Entry note
Bulk Update Existing Time Entries
The first column of the template can be filled in with an existing time entry ID if you want to modify or update it. In order to find the time entry ID you need to Download the Time Entries CSV Reference file (Located in Settings / Manage Projects / Add New Projects (Button top right) / Add Multiple Bookings / Download All Time Entries). Open this file and find the time entry ID you wish to update and use that in the first column of the CSV you will upload.