Versions Compared

Key

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

This feature is in beta, so you may not yet have access to it.

In this article, we show you how to use the Tātou Office Bulk Import feature to quickly import timesheets into TatouTātou.

Timesheets are grouped into Jobs based on them sharing the same values in these columns:

  • date,

  • start_time,

  • end_time,

  • rate_type,

  • rate,

  • leader_staff_id,

  • task,

  • client,

  • location and

  • block.

Before you start

...

Warning

Always double-check your import data is accurate and matches the import template exactly. Bulk importing updates a lot of data at once and cannot be undone. If in doubt, upload in small batches and check as you go.

Format requirements

Using the template, create a new row for each Timesheet Entry, and fill out the appropriate details. A list of the spreadsheet columns and what they mean can be found below:

...

2 Optional for non-Australia customers

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@957
sortmodified
showSpacefalse
reversetrue
typepage
cqllabel in ( "kb-how-to-article" , "bulk-import" ) and type = "page" and space = "KB"
labelskb-how-to-article

...