https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292010-12-23T21:53:11ZRedmineRedmine - Feature #5774: Auto schedule issues and Estimated end date for versionshttps://www.redmine.org/issues/5774?journal_id=234312010-12-23T21:53:11ZIlya Kharlamov
<ul></ul><p>I vote for this feature.<br />As an issue reporter, after creating and assigning a new issue, I have no idea what are the assignee's current tasks are, but I would like to see an estimation when does my issue is going to be started and finished. <br />Redmine's current "Start" field must be filled manually and recalculated manually on every change of an issue with higher priority. I imagine this as a new "*Estimated start*" redmine field that is re-calculated automatically on every change of any issue with the same assignee.</p>
<p>For example, today is 23-DEC-2010, the current time is 14:00<br />A developer Doe with 8 hours/day load, starts working at 9 am, is having 3 issues assigned to him:<br />issue # 1, priority Urgent, status:In progess, estimated time:10 hours, 30%done, "*Estimated start*":nil (since status is "In progress")<br />issue # 2, priority High, status:New, estimated time:1 hour, "*Estimated start*": 24-DEC-2010 15:00 (is calculated automatically since he has to spend 7 more hours for issue # 1)<br />issue # 3, priority Normal, status:New, estimated time: 7 hours"*Estimated start*": 24-DEC-2010 16:00<br />Etc.</p>
<p>If you create a new issue with priority High and assign it to the user, "*Estimated start*" for all the issues with lower priorities assigned to this user will be re-calculated automatically.</p> Redmine - Feature #5774: Auto schedule issues and Estimated end date for versionshttps://www.redmine.org/issues/5774?journal_id=286582011-05-05T08:45:16ZMichael Walton
<ul></ul><p>Bump, this is a feature I'd love to see for both myself and the advancement of the software's scope.</p>
<p>The only thing that ms project has over Redmine in my book is auto task scheduling based on resource (programmer) working hours and availability in other projects.</p>
<p>I really think this would bolster Redmine significantly in the team management area and really speed up entry and re-organising of issues.</p>
<p>To allow for flexibility and backwards compatibility with Redmine users you could allow tasks to be in auto or manually scheduled mode (as ms project does quite well).</p>
<p>I'd see it as two parts, a resource time management plugin and the auto scheduling logic plugin and agree with Hans' proposed implementation.</p>
<p>Obviously this feature is most useful to a project manager but would also be useful to programmers as a work queue and for time efficiency.</p>
<p>I understand that this is quite a large feature and would increase the scope and user audience of the Redmine project but I really think for the better.</p>
<p>thanks for the great effort thus far, Redmine is fantastic!</p> Redmine - Feature #5774: Auto schedule issues and Estimated end date for versionshttps://www.redmine.org/issues/5774?journal_id=353252012-01-12T09:38:23ZDaniel Albuschat
<ul></ul><p>I strongly vote for this issue, too. It would make Redmine a killer project management software (while it currently is "just" a superb project management software).</p>
<p>Actually, I'm even consider digging into Redmine development and implement it myself.<br />Since the rule-sets are relatively straight-forward, it should not be THAT hard, I think.<br />The easiest solution would be re-using and updating the original due field and introduce, as Michael Walton explained, a "manual" and "automatic" planning mode for tasks. In this case, the GANTT logic does not need to be touched at all.</p> Redmine - Feature #5774: Auto schedule issues and Estimated end date for versionshttps://www.redmine.org/issues/5774?journal_id=355082012-01-23T09:26:26ZDaniel Albuschat
<ul><li><strong>File</strong> <a href="/attachments/7073">Redmine-1.3.0-AutoScheduleProjects.zip</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/7073/Redmine-1.3.0-AutoScheduleProjects.zip">Redmine-1.3.0-AutoScheduleProjects.zip</a> added</li></ul><p>I did some work on this at the weekend. Of course, I first tried to dig into the Redmine source code, but quickly realized that I don't understand Ruby at all. So, as a proof of concept, I tried to solve this problem on the MySQL database just using database tools (namely procedures and triggers). I have to say that the solution I came up with until now is not that bad. I introduced a new table `user_worktimes' to store they hours a user works per weekday and calculated an issue's due date from the start date and the estimated time. Related tasks (followers, blocked by) are automatically schedule after the due date of the latest predecessor.<br />This works pretty well, but still has some limitations and does not work automatically. I still have to call the stored procedure auto_plan_project(<project-number>), which, of course, is not desireable.<br />I plan on digging into Ruby and the Redmine source code now, but it seems like a lot of efforts.<br />Anyways, just for inspiration, I attached the SQL scripts that I used for my proof-of-concept, db-based solution to the problem.<br />Execute auto_schedule.sql, then auto_plan_project_draft.sql (MySQL only).</p>