"Time tracking" on Mantis 2.0 ??

General discussion of Mantis.

Moderators: Contributor, Developer

Re: "Time tracking" on Mantis 2.0 ??

Postby epenet » Feb 13, 2017 3:40 am

I started to look at this plugin: https://github.com/mantisbt-plugins/timetracking

I was able to amend for Mantis 2.1.0, and now have an input form with date and two free text fields (category + comment).

I still wonder if this wouldn't benefit the "core" product though...
epenet
 
Posts: 13
Joined: Feb 09, 2017 6:19 am

Re: "Time tracking" on Mantis 2.0 ??

Postby epenet » Feb 13, 2017 4:29 am

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

Re: "Time tracking" on Mantis 2.0 ??

Postby didaquis » Feb 13, 2017 4:58 pm

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

Re: "Time tracking" on Mantis 2.0 ??

Postby capitansigfrido » Mar 21, 2017 6:55 am

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 ?
capitansigfrido
 
Posts: 4
Joined: Mar 20, 2017 8:42 pm

Re: "Time tracking" on Mantis 2.0 ??

Postby epenet » Mar 21, 2017 8:11 am

Can you check inside the db to see if the field exists?
epenet
 
Posts: 13
Joined: Feb 09, 2017 6:19 am

Re: "Time tracking" on Mantis 2.0 ??

Postby capitansigfrido » Mar 21, 2017 6:01 pm

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)
capitansigfrido
 
Posts: 4
Joined: Mar 20, 2017 8:42 pm

Re: "Time tracking" on Mantis 2.0 ??

Postby epenet » Mar 22, 2017 4:44 am

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

Re: "Time tracking" on Mantis 2.0 ??

Postby capitansigfrido » Mar 22, 2017 9:16 am

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
capitansigfrido
 
Posts: 4
Joined: Mar 20, 2017 8:42 pm

Re: "Time tracking" on Mantis 2.0 ??

Postby epenet » Mar 22, 2017 9:21 am

That is the next part - which needs to be implemented.
Working on it... any help appreciated.
epenet
 
Posts: 13
Joined: Feb 09, 2017 6:19 am

Re: "Time tracking" on Mantis 2.0 ??

Postby capitansigfrido » Mar 22, 2017 10:09 am

I will check with my team if we can work on it.
Give us some days to check how the plugins works.

Regards
Diego
capitansigfrido
 
Posts: 4
Joined: Mar 20, 2017 8:42 pm

Re: "Time tracking" on Mantis 2.0 ??

Postby epenet » Mar 29, 2017 2:15 am

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

Re: "Time tracking" on Mantis 2.0 ??

Postby Dundee » Apr 02, 2017 3:46 pm

Epenet or other people

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

Best Regards
Dundee
 
Posts: 15
Joined: Dec 03, 2013 7:25 am

Re: "Time tracking" on Mantis 2.0 ??

Postby epenet » Apr 03, 2017 2:07 am

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

Re: "Time tracking" on Mantis 2.0 ??

Postby Dundee » Apr 03, 2017 10:26 am

Hi Epenet

The original version is created for MantisBT 1.2, if you install it in version 1.3 does not work.


Regards
Dundee
 
Posts: 15
Joined: Dec 03, 2013 7:25 am

Re: "Time tracking" on Mantis 2.0 ??

Postby epenet » Apr 03, 2017 10:38 am

Hi Dundee,

Then I suggest that you open a separate thread, and hope that one of the v1 developpers sees your message.

Regards,
epenet
 
Posts: 13
Joined: Feb 09, 2017 6:19 am

PreviousNext

Return to General Discussion

Who is online

Users browsing this forum: No registered users and 8 guests