Redmine

Hello Peter,

• Create a plugin, which could be a problem if you have no experience with Ruby On Rails
• Use an external reporting tool. I had successes using BIRT

I went both ways. For me it depends on the load and the user experience you which to have.
For big loads I'd recommend BIRT (or similar) with scheduled PDF sent by email for example.
For integrated interactive experience, I'd go for a plugin.

Hope it helps!

Thanks Martin,
I create a plugin with export to csv file. I have a problem with file encoding. Csv file is utf-8 and I need cp1250. I can encoding it after download, but it does not like my boss. Can you help me with this?

I found this on google, but it does not work:

respond_to do |format|
format.html { render :action => 'details', :layout => false if request.xhr? }
format.csv { send_data @timesheet.to_csv, :filename => 'report.csv', :type => 'text/csv, charset=windows-1250, header=present' }
end

Thanks for your help

You could try:

format.csv {
  send_data @timesheet.to_csv.encode('Windows-1250'),
  :disposition => 'attachment; filename=report.csv',
  :type => 'text/csv, charset=windows-1250, header=present'
}

I try it, but it doesnt work for me :(

What's the output?

Internal error

An error occurred on the page you were trying to access.
If you continue to experience problems please contact your Redmine administrator for assistance.

If you are the Redmine administrator, check your log files for details about the error.

Back

This works fine, but output is in UTF8

  respond_to do |format|
      format.html { render :action => 'details', :layout => false if request.xhr? }
      format.csv  { send_data @timesheet.to_csv, :filename => 'timesheet.csv', :type => "text/csv" }
    end

I need help with this:

I have a code:

d e csv_header
csv_data = [
l(:label_date),
l(:jmeno),
l(:zakazka),
l(:ukol),
l(:popiska),
l(:field_hours),
l(:planik),
l(:vycerpane)
]
Redmine::Hook.call_hook(:plugin_timesheet_model_timesheet_csv_header, { :timesheet => self, :csv_data => csv_data})
return csv_data
end

def time_entry_to_csv(time_entry)
    csv_data = [ 
                time_entry.spent_on,
                time_entry.user.name,
                time_entry.project.name,  
                (time_entry.issue.subject if time_entry.issue),
                time_entry.comments,
                time_entry.hours,
                time_entry.issue.estimated_hours,
                time_entry.issue.spent_hours                
               ]
    Redmine::Hook.call_hook(:plugin_timesheet_model_timesheet_time_entry_to_csv, { :timesheet => self, :time_entry => time_entry, :csv_data => csv_data})
    return csv_data
  end@

I need to achieve this - when a comment is blank, so instead display the character "-"

Thanks for your help

This works fine

def time_entry_to_csv(time_entry)
    csv_data = [ 
                time_entry.spent_on,
                time_entry.user.name,
                time_entry.project.name,  
                (time_entry.issue.subject if time_entry.issue),
                if time_entry.comments == "" 
                puts = '-'
                else time_entry.comments
                end,
                time_entry.hours,
                time_entry.issue.estimated_hours,
                time_entry.issue.spent_hours                
               ]

Is your problem solved now?

Yes, all works fine, but I still have a problem with the encoding output csv file

If you upload your plugin, I'll have a look.

Ok, it's working.

My problem is solved now

Please post your solution for reporting here.