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
epenet wrote: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

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.