Timesheet Module

Actually I only package it within a Dolibarr module with not more integration

ide.pmpd.eu/dolibarr/build/module_reportico-.4.3.zip

but in the mean time other did the work https://www.dolistore.com/fr/modules/703-Dolireport.html?search_query=reportico&results=2

Thread in french: http://www.dolibarr.fr/forum/11-suggestionsnouvelles-fonctionnalites/52936-integration-de-reportico-reporting?limitstart=0

Br.

Hi,

I am working on a the next version of timesheet that will support invoice generation from the project report and timesheet approval chain (team , project 
)
https://ide.pmpd.eu/dolibarr/htdocs
login:admintester
pwd: admintester

the Invoice part is already done but I am facing some issues for the approval part, either I solve them properly (could be used later to plan workload on task) but it might means that all previous approval could be lost (I might not do the migration script ) or I can apply a work arround (not clean).

Could you tell me if some of you already use the approval mechanism ?

thanks in advance.

Hello,

I installed the module and have been using it a lot. I have not been able to understand how to confure the approvals. Therefore, I am no using the apporval functionality, but I was actually lokking forward to getting help and complete the approval setup and start using it.

Can you please give the highlights on how to configure approvals?

Thanks!

for the current version (1.5.1) it’s pretty simple:
0) config should be done to define if the TS should be grouped by week of user in the approval page

  1. timesheet should be submitted by the user (not only saved)
  2. the manager of the user (N+1 or N+2 base on manager name in the user page) go on the approval page (in the left menu) and elect approved or rejected for the ts on the screen

if there is any remark/improvement/bug you can create a bug on the github https://github.com/delcroip/dolibarr_project_timesheet or send me a mail (it is better to use github)

for everyone else:
Could you tell me if some of you already use the approval mechanism ?

thanks in advance.

br.

1 Like

Now I could activate the approval.

Thank you!!

Hello,

the next version is almost ready for testing, here the changelog:
create invoice from the project report
more translation (ES, DE, IT, FR, US)
tab in the setup for better browsing experience
Week over two month can be splited in 2 so an approval per month is possible.
reports shows time spent in hours and days
better handling of search boxes
favoris in a tab (not a new page)
admin can approve everything
approval per project

here the approval screen for project :

test server:
ide.pmpd.eu/dolibarr/htdocs

some id/pswd:
admintester/admintester
tester/tester
tester1/tester1
tester2/tester2

best regards

Hi,

Here the release candidate for the version 2.0:

module_timesheet-.2.0.rc.zip (136 KB)

Change log from 1.5.1:
- chained approval for project
- create invoice from the project report
- more translation (ES, DE, IT, FR, US)
- tab in the setup for better browsing experience (in JS so config is kept when changing tab)
- Week over two month can be splited in 2 so an approval per month is possible.
- reports shows time in hours and days
- better handling of search boxes
- favoris in a tab (not a new page)

if some could test and provide me feedback on trad and bugs if any
Known limitations:
- approved timesheet in version 1.5.1 won’t show up ( a migration is needed, I’ll look how to do it.)
- in 3.5 the button “invoice” in the project report doesn’t show

Hi, While making the documentation I correct some bugs

here the version correted 2.0.rc1
https://cloud.pmpd.eu/index.php/s/F9fbLvq7Ki2geWZ

here the Documentaiton:
https://cloud.pmpd.eu/index.php/s/MArFKsQxCcTGxKM

Hi,

the new version is on the dolistore, I set a price but for those who don’t want to pay there is a link to have it for free.

br.

1 Like

Does this (your package) still exist? Will it work with 5.0.4?

Hi,

The package doesn’t exist anymore but the github does:

https://github.com/delcroip/dolibarr_reportico

I don’t know if it is still working but you best use reportico in a stand alone mode because newer version were published

1 Like

Dear,

There is a new version of the module available on sourceforge and dolistore:


https://www.dolistore.com/fr/gestion-produits-ou-services/419-Feuille-de-temps.html?search_query=timesheet&results=2

Best regards

Hello

Dolibarr version 7.0.0 isn’t supported yet but I am working on a new version

https://ide.pmpd.eu/dolibarr/build/module_timesheet-2.2.5.zip

Some user have issue seeing the task but I am not able to reproduce it but as soon as I find the root cause I’ll update the module.

if you want to try, please deactivate and re-activate the module to make sure the db change are done

this version, once installed will block a roll back to 2.2.3.5 ( or older) but if you need to roll back I can generate a version 2.2.3.6 that will allow it.

Dear,

please a working verison for Dolibarr 7.0.0

I’ll update Dolistore soon.

if you want to try, please deactivate and re-activate the module to make sure the db change are done

this version, once installed will block a roll back to 2.2.3.5 ( or older) but if you need to roll back I can generate a version 2.2.3.6 that will allow it.

br

1 Like

Great! You have a lot of knowledge about it.

Dear,

FYI,

a version 2.2.8 is available on source forge:
https://sourceforge.net/projects/dolibarr-timesheet/

2.2.8 change log from 2.2.7
- new: add a super total: total of every day present on the timesheet screen

2.2.7 change log from 2.2.6
- fix: error in pgsql while generating the invoice
- fix: link the created invoice to the project
- fix: error in the reports pages with mysql
- fix:ts draft not removed upon timespan change leading to days not accessible
- clean: Invoice creation page: layout improvement

2.2.6 Change log from 2.2.3
- new: support PostGreSQL database
- new/fix: support custom project roles
- new/fix: support Dolibarr 7.0.0
- fix: behaviour of notes in the timesheet pages with favourites
- fix: “not defied” showing instead of project name
- fix: correction of the message when a favourite was added
- clean: enum are not user anymore
- clean: removal of dead code

Dear all ,

FYI,

a version 3.1.2 is available on source forge:
https://sourceforge.net/projects/dolibarr-timesheet/

3.1.2 change log from 2.2.11
- new: button to generate users’ attendance sheet from project report pages
- fix: #57 note were not saved when containing a simple quote
- fix: install in htdoc folder
- fix: #50 boxapproval naming
- fix: format & typo
- fix: #48 timesheet start 1 day in advance
- fix: #55 invoice show close & draf project in the dropdown list

2.2.11 change log from 2.2.10
- fix: background color missing with approval status
- clean: total calculation improvments
- clean: add new trads
- clean: remove display error

2.2.10 change log from 2.2.9
- new: line total header
- new: add a total line every 10 task line
- fix: in day mode, the leading 0 isn’t mandatory anymore (e.g. “.1”)
- clean: use liste_title for totals
- clean: improve total & overtime behaviour
- fix: #49 removing the value in a timesheet will put it a 0

2 Likes

Hi everybody

I made a mistake and install this module on Dolibarrr 7.0.1
I delete it and now, i have this error :

sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context=’’ OR context like ‘%vsmenu%’ ) AND typefield =2 ORDER BY context, label
2019-01-18 16:42:10 ERR IP_Number DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHFIELD Unknown column ‘tooltipinfo’ in ‘field list’

How can i fix it please if you know.

FIRST: YOU SHOULD MAKE/HAVE A BACKUP OF YOUR DATABASE.

Then install 7.0.1 LIKE an UPGRADE !!!

It’s on your own risk, but I think it should fix the database hiccup when it finds differences to the “standard” expected 7.0.1 tables and defined fields.

See the wiki here: https://wiki.dolibarr.org/index.php/Installation_-_Upgrade#Upgrade_Dolibarr

Hello,

I can tell you that this error doesn’t come from the timesheet module.

It seems to come from “myfield” which is a module developped by Patas-monkey

br.

1 Like