"Time tracking" on Mantis 2.0 ??

General discussion of Mantis.

Moderators: Developer, Contributor

epenet
Posts: 13
Joined: 09 Feb 2017, 11:19

Re: "Time tracking" on Mantis 2.0 ??

Post 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
didaquis
Posts: 20
Joined: 28 Nov 2016, 14:16
Location: Barcelona

Re: "Time tracking" on Mantis 2.0 ??

Post 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.
capitansigfrido
Posts: 4
Joined: 21 Mar 2017, 01:42

Re: "Time tracking" on Mantis 2.0 ??

Post 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 ?
epenet
Posts: 13
Joined: 09 Feb 2017, 11:19

Re: "Time tracking" on Mantis 2.0 ??

Post by epenet »

Can you check inside the db to see if the field exists?
capitansigfrido
Posts: 4
Joined: 21 Mar 2017, 01:42

Re: "Time tracking" on Mantis 2.0 ??

Post 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)
epenet
Posts: 13
Joined: 09 Feb 2017, 11:19

Re: "Time tracking" on Mantis 2.0 ??

Post 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 | |
capitansigfrido
Posts: 4
Joined: 21 Mar 2017, 01:42

Re: "Time tracking" on Mantis 2.0 ??

Post 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
epenet
Posts: 13
Joined: 09 Feb 2017, 11:19

Re: "Time tracking" on Mantis 2.0 ??

Post by epenet »

That is the next part - which needs to be implemented.
Working on it... any help appreciated.
capitansigfrido
Posts: 4
Joined: 21 Mar 2017, 01:42

Re: "Time tracking" on Mantis 2.0 ??

Post 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
epenet
Posts: 13
Joined: 09 Feb 2017, 11:19

Re: "Time tracking" on Mantis 2.0 ??

Post 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
Dundee
Posts: 15
Joined: 03 Dec 2013, 12:25

Re: "Time tracking" on Mantis 2.0 ??

Post by Dundee »

Epenet or other people

Can you reconfigure Time Tracking to work in version 1.3?, I'm not programmer.

Best Regards
epenet
Posts: 13
Joined: 09 Feb 2017, 11:19

Re: "Time tracking" on Mantis 2.0 ??

Post 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
Dundee
Posts: 15
Joined: 03 Dec 2013, 12:25

Re: "Time tracking" on Mantis 2.0 ??

Post 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
epenet
Posts: 13
Joined: 09 Feb 2017, 11:19

Re: "Time tracking" on Mantis 2.0 ??

Post 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,
Dundee
Posts: 15
Joined: 03 Dec 2013, 12:25

Re: "Time tracking" on Mantis 2.0 ??

Post by Dundee »

Hi epenet
Best regards, for you help me. I open a new therad.
Post Reply