"Time tracking" on Mantis 2.0 ??
Moderators: Developer, Contributor
Re: "Time tracking" on Mantis 2.0 ??
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
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 ??
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.
-
- Posts: 4
- Joined: 21 Mar 2017, 01:42
Re: "Time tracking" on Mantis 2.0 ??
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 ?
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 ??
Can you check inside the db to see if the field exists?
-
- Posts: 4
- Joined: 21 Mar 2017, 01:42
Re: "Time tracking" on Mantis 2.0 ??
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)
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 ??
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 | |
If you want to add the column manually:
| Field | Type | Null | Key | Default | Extra |
+------------------+------------------+------+-----+---------+----------------+
| info | varchar(255) | YES | | NULL | |
-
- Posts: 4
- Joined: 21 Mar 2017, 01:42
Re: "Time tracking" on Mantis 2.0 ??
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
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 ??
That is the next part - which needs to be implemented.
Working on it... any help appreciated.
Working on it... any help appreciated.
-
- Posts: 4
- Joined: 21 Mar 2017, 01:42
Re: "Time tracking" on Mantis 2.0 ??
I will check with my team if we can work on it.
Give us some days to check how the plugins works.
Regards
Diego
Give us some days to check how the plugins works.
Regards
Diego
Re: "Time tracking" on Mantis 2.0 ??
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
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 ??
Epenet or other people
Can you reconfigure Time Tracking to work in version 1.3?, I'm not programmer.
Best Regards
Can you reconfigure Time Tracking to work in version 1.3?, I'm not programmer.
Best Regards
Re: "Time tracking" on Mantis 2.0 ??
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
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 ??
Hi Epenet
The original version is created for MantisBT 1.2, if you install it in version 1.3 does not work.
Regards
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 ??
Hi Dundee,
Then I suggest that you open a separate thread, and hope that one of the v1 developpers sees your message.
Regards,
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 ??
Hi epenet
Best regards, for you help me. I open a new therad.
Best regards, for you help me. I open a new therad.