Versions Compared

Key

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

...

  • Placement: This should be the reference code for the placement (for example 'JB001').
  • Rate: This should be the exact name of the rate, as it appears in the timesheet (for example 'Day Rate').
  • Date: The day for which the timesheet data is being entered. The date format is dd/mm/yyyy (for example '18/05/2015').
  • Unit: The number of units that the contractor worked. For example, if the rate is 'Day Rate', you might enter '1'.
  • Comment: Any comment that you want to include for the entry.

Requesting a new timesheet import format to be developed

We can develop custom timesheet import formats to match a spreadsheet / CSV file recieved from an external system. We

The standard charge of typically £180 but it is subject to scoping of the file you supply.

If you can supply support with a sample file and answers to the questions below, we will review.

  1. Can we get the placement reference that matches InTIME? If can, don’t need 2) or 3). If not available uses placement found in 4)
  2. Where can I get the worker from? Reference that matches InTIME ideally, or full name that matches InTIME.
  3. Can I get the Client that matches InTIME? Can only match by name. If not available uses client of placement found in 4)
  4. Where can I get the weekending Date from? If 1) is not available uses date to find current placement for worker in 2) with client in 3) (if available), if more than one gives choice to user.
  5. How can I get rate? We can match by name, pay rate, charge rate, pay amount, charge amount.
  6. How can we get the units for the rate in 4)?
  7. Any extra data in file you want imported into the timesheets? Why and to where?