Never been to CodeSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

4 total

On This Page:

  1. 1 Export to Excel
  2. 2 Export french characters
  3. 3 Levy Export
  4. 4 Forcing an SVN export to overwrite a directory

Export to Excel

to ruby rails export excel by jgoggles on Dec 12, 2008 1 Comments
Controller
class PersonController < ApplicationController
  def export
    headers['Content-Type'] = "application/vnd.ms-excel"
    headers['Content-Disposition'] = 'attachment; filename="report.xls"'
    headers['Cache-Control'] = ''
    @person = People.find(:all)
  end
end


View (link to export)
<%= link_to "Export as Excel", export_person_url %>


View (Export)
#Render partial so your Layout wont be sent to the spreadsheet
<%= render :partial => 'report' %>


Partial
<table border="1">
  <tr>
    <th>Name</th>
  </tr>
  <% @person.each do |p| %>
    <tr>
      <td><%= p.name %></td>
    <% end %>
  </tr>
</table>

Export french characters

to export java jvm options ASCII UTF-8 french characters accents by interpretes on Jun 21, 2008
// description of your code here

java -Dfile.encoding=CP850 YourClassName
export JAVA_OPTS=-Dfile.encoding=UTF-8

Levy Export

to export levy by ppsmith on Nov 28, 2007
SELECT
lev_code id,
pro_catalogue catalogue,
pro_desc description,
pri_vat tax_id,
pri_trade2 trade_value,
COALESCE(NULLIF(pri_per, 0), 1) trade_per,
CASE WHEN lev_disabled = 'Y' THEN 1 WHEN pri_to < NOW() THEN 1 ELSE 0 END is_disabled ,
CASE WHEN lev_modified > pro_modified AND lev_modified > pri_modified THEN lev_modified WHEN pro_modified > lev_modified AND pro_modified > pri_modified THEN pro_modified ELSE pri_modified END updated_at,
pro_code product_id,
pro_stockcode stock_code,
pro_supplier supplier_id
FROM
levy
INNER JOIN product ON lev_product = pro_code
INNER JOIN price ON pri_product = pro_code
WHERE
pri_from <= NOW()
AND NOT EXISTS(SELECT * FROM price p WHERE p.pri_seq <> price.pri_seq AND p.pri_product = price.pri_product AND p.pri_from > price.pri_from)
AND pri_trade2 > 0;
OUTPUT TO 'd:\\levies.csv'

Forcing an SVN export to overwrite a directory

to svn export force sitemanagement by jason on May 27, 2005
You can run --force to make an SVN export overwrite a folder rather than write into it

cd /usr/local/etc/
svn export --force --username user@textdrive.com --password apassword https://svn.textdrive.com/repos/setup/usr/local/etc/apache2

4 total

On This Page:

  1. 1 Export to Excel
  2. 2 Export french characters
  3. 3 Levy Export
  4. 4 Forcing an SVN export to overwrite a directory