Versions Compared

Key

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

You can upload timesheet data from a spreadsheet, by copying and pasting the spreadsheet's cells directly into RSM InTime. When you enter timesheet data using this method, the timesheet will automatically be submitted and follow the approval route that has been set for the placement. You can also import expense items as well. 

The standard RSM InTime format is shown below. RSM InTime also has the facility to import timesheet data from 3rd party systems. In order to do this an Import format must be created and configured to suit the data you wish to import.

You also have the ability to build your own non complex importers. 

...

Ability to create timesheet & expense importers

Any admin user that has the advanced configuration role, can build and edit non-complex timesheet importers, e.g., importers that do not require a script. 

Go to the system configuration cog in the top right hand corner, and within the system section select timesheet import formats. Any timesheet importers that are script based will be greyed out and cannot be selected. Any editable timesheet importers will appear blue and are available to select. Alternatively, you can click on new import format in the top right hand corner.

All fields have a question mark icon providing you with additional help, there are dropdown options for timesheets and expenses.  

Image Modified Image Modified

You will then be able to select or deselect columns. Using the arrows, any columns in the right hand box will be the required data within the import, and any in the left hand box will not be required. You can select multiple columns by holding down the ctrl button on your keyboard when clicking on a chosen column. Once complete, click save. 

Image Modified

To use the import, go to import/export menu option and select import timesheets or import expenses, within the source list dropdown you will find all your importers. 

Image Modified

We can develop additional timesheet import formats

...