Search this site
Home‎ > ‎Modules‎ > ‎Module: Report‎ > ‎

Export Reports Data

The export is available from any Report module.

Note: If you want to export your data to Quickbooks, we have a dedicated module for that.

Go to a module: Report, choose the time period and click Export to spreadsheet the bottom right.

 

The export has the CSV(Coma Separated Values) format and can be loaded in your favorite spreadsheet or any other system able to read this format.

Use your own custom ID in exports

If you export your time records to other systems, eg: Accounting, Project Management, Payroll, ERP... you must in general provide an ID to match properly the time records.

You can add an ID for an entity: company, project, subproject, person, task and absence.
The ID you provide will be used instead of the internal one during exports.

There is a field labelled ID, in the details module of these entities.
Here is an example for Project details:





If ID is empty, in the exported data, you get the id BeeBole is using internally: 149.





Now if you specify an ID in the detail screen for that project, like:





You will now get this ID(PR000002342) in the export:



Get less column in your exports

The export above provide all the fields available, while you may want only a subset.
Set the chart format of the report(pie, bar, areachart,...) to Table

Once you have a table report - like below - there is an arrow at the right.


If you click the arrow, the table will pop up in a new window.
You can print that new page or save it as a PDF file.

If you select the table, either with the mouse or by pressing Ctrl+A
You can then copy paste it to your favorite spreadsheet editor.

Note: This table export functionality is not available for Internet Explorer 8 users.