search

maxrossello / redmine_app_timesheets

A true timesheet plugin using orders, not bound to timelogs over issues
GNU General Public License v2.0
32 stars 10 forks source link

Filtering by order in Spent time page #33

Open seanvl opened 10 years ago

seanvl commented 10 years ago

Great plug in! I am trying to find a way to filter by Order on the Spent time page. I have tried to see if there was a means to do this via redmine but have not found one. Is this something that you could enable? It would be a great help in creating an invoice. Thanks!

maxrossello commented 10 years ago

Hi, it could be a good idea, though I don't think I can accomplish in the very near term. Other standard filtering options are a bit weird too

thank you!

seanvl commented 10 years ago

Hi,

Thanks for your consideration and quick response. If you ever do implement this, even if it takes a long time, I would be extremely grateful.

Sean.

On Oct 15, 2014, at 7:55 AM, maxrossello notifications@github.com wrote:

Hi, it could be a good idea, though I don't think I can accomplish in the very near term. Other standard filtering options are a bit weird too

thank you!

— Reply to this email directly or view it on GitHub.

greyman888 commented 10 years ago

Hi Sean,

I had similar problems so my work around is to export all the data as a csv file and then import it into Microsoft Excel (I'm using the Windows version). Once it was in Excel I was able to filter, apply pivot tables etc. You're only limited by how familiar you are with Excel.

I've attached a link to a cut down version of my Excel Workbook. It has a VBA script in it to import and rearrange the csv file so you'll get a warning when you open it.

http://www.greykg.com/uploads/9/2/8/0/9280783/weekly_time_report_v0.9-cut.xlsm

Here are some basic instructions:

  1. Run the Spent time Report in Redmine - Select User, Order & Order Activity (screen shot in Excel file)
  2. Save the csv file (right at the bottom of the report)
  3. Open the Excel workbook and hit the Refresh button and select the .csv file when prompted
  4. Look at the Pivot Tables in the other tabs to see what you can do with the data

I hope this helps.

seanvl commented 10 years ago

Thanks for the idea. I used a similar work around. It works well enough, I think I might end up looking at creating a report straight from the redmine data base. In theory this should be pretty straight forward, however, I have not looked at the data model yet.

maxrossello commented 10 years ago

Thank you both! @seanvl you can take from time_entries table the ones that have order_id that's not NULL. order_id is a foreign key for the version used as order