Page 2 of 3
Re: "Time tracking" on Mantis 2.0 ??
Posted: 13 Feb 2017, 09:29
by epenet
Hi
I had a look at this plugin:
https://github.com/mantisbt-plugins/timetracking, but doesn't work in Mantis 2.
I've started a fork for a v2 compatible plugin:
https://github.com/epenet/timetracking
Re: "Time tracking" on Mantis 2.0 ??
Posted: 13 Feb 2017, 21:58
by didaquis
Thank you very much for your work. I'm not sure, but in the future I might be able to collaborate. In my company we might be interested in creating plugins for MantisBT.
Re: "Time tracking" on Mantis 2.0 ??
Posted: 21 Mar 2017, 11:55
by capitansigfrido
Hi.
I have downloaded and copied the plugin
Installed it and then tried to add a vale in an issue (+2 hours workerd)
Mantis throw this error
Unknown column 'info' in 'field list' para la consulta: INSERT INTO mantis_plugin_TimeTracking_data_table ( user, bug_id, expenditure_date, hours, timestamp, category, info )
VALUES ( '2', '2', '2017-03-21', '2', '2017-03-21 8:50:56', '', '')
What I'm doing wrong ?
Re: "Time tracking" on Mantis 2.0 ??
Posted: 21 Mar 2017, 13:11
by epenet
Can you check inside the db to see if the field exists?
Re: "Time tracking" on Mantis 2.0 ??
Posted: 21 Mar 2017, 23:01
by capitansigfrido
It doesn't exist field "info"
mysql> describe mantis_plugin_TimeTracking_data_table;
+------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| bug_id | int(10) unsigned | YES | | NULL | |
| user | int(10) unsigned | YES | | NULL | |
| expenditure_date | datetime | YES | | NULL | |
| hours | double | YES | | NULL | |
| timestamp | datetime | YES | | NULL | |
| category | varchar(255) | YES | | NULL | |
+------------------+------------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)
Re: "Time tracking" on Mantis 2.0 ??
Posted: 22 Mar 2017, 09:44
by epenet
There was a missing comma on the schema definition. I have now added this on github.
If you want to add the column manually:
| Field | Type | Null | Key | Default | Extra |
+------------------+------------------+------+-----+---------+----------------+
| info | varchar(255) | YES | | NULL | |
Re: "Time tracking" on Mantis 2.0 ??
Posted: 22 Mar 2017, 14:16
by capitansigfrido
Manually added.
It's working now.
I can see an entry with the time spend inside the ticket.
Usuario Fecha efectiva Horas Category Información Fecha entrada (automático)
die1fue 2017-03-22 00:30 Algo BlaBla 2017-03-22 11:11 ART Eliminar!
Suma
00:30
Is there a place to list any kind of report ? For example, time spend by developer per week, month, etc ?
Thanks
Diego
Re: "Time tracking" on Mantis 2.0 ??
Posted: 22 Mar 2017, 14:21
by epenet
That is the next part - which needs to be implemented.
Working on it... any help appreciated.
Re: "Time tracking" on Mantis 2.0 ??
Posted: 22 Mar 2017, 15:09
by capitansigfrido
I will check with my team if we can work on it.
Give us some days to check how the plugins works.
Regards
Diego
Re: "Time tracking" on Mantis 2.0 ??
Posted: 29 Mar 2017, 07:15
by epenet
Hi,
I've finished the migration of the reports on the new plugin.
Version 2.0.3 is available on GitHub:
https://github.com/epenet/timetracking
Re: "Time tracking" on Mantis 2.0 ??
Posted: 02 Apr 2017, 20:46
by Dundee
Epenet or other people
Can you reconfigure Time Tracking to work in version 1.3?, I'm not programmer.
Best Regards
Re: "Time tracking" on Mantis 2.0 ??
Posted: 03 Apr 2017, 07:07
by epenet
Hi @Dundee,
If you want to use it on 1.3, then you will have to use the "original" version:
https://github.com/mantisbt-plugins/timetracking
Regards,
epenet
Re: "Time tracking" on Mantis 2.0 ??
Posted: 03 Apr 2017, 15:26
by Dundee
Hi Epenet
The original version is created for MantisBT 1.2, if you install it in version 1.3 does not work.
Regards
Re: "Time tracking" on Mantis 2.0 ??
Posted: 03 Apr 2017, 15:38
by epenet
Hi Dundee,
Then I suggest that you open a separate thread, and hope that one of the v1 developpers sees your message.
Regards,
Re: "Time tracking" on Mantis 2.0 ??
Posted: 03 Apr 2017, 15:40
by Dundee
Hi epenet
Best regards, for you help me. I open a new therad.