Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up

Generates ODF files, given a template (.odt) and data, replacing tags

License

NotificationsYou must be signed in to change notification settings

sandrods/odf-report

Repository files navigation

Gem for generating .odt files by making strings, images, tables and sections replacements in a previously created .odt file.

INSTALL

In your Gemfile

gem'odf-report'

USAGE

Step 1 -- the template

First of all, you need a.odt file to serve as a template.Templates are normal .odt files with[PLACEHOLDERS] forsubstitutions.There arefour kinds of substitutions available:

  • fields
  • tables
  • images
  • sections

Fields

It's just an upcase sentence, surrounded by brackets. It will be replaced by the value you supply.

In the folowing example:

report=ODFReport::Report.new("Users/john/my_template.odt")do |r|r.add_field:user_name,@user.namer.add_field:address,"My new address"end

All occurences of[USER_NAME] found in the file will be replaced by the value of@user.name whereas all[ADDRESS] 'es will containsMy new address

Tables

To use table placeholders, you should create a Table in your document and give it a name. In OpenOffice, it's just a matter of right-clicking the table you just created, chooseTable Properties... and type a name in the Name field.

If you informheader: true, the first row will be treated as aheader and left untouched. The remaining rows will be used as the template for the table.

If you have more than one template row, they will be cycled. This is usefull for making zebra tables.

As withField placeholders, just insert a[FIELD_NAME] in each cell and let the magic takes place.

Taking the folowing example:

report=ODFReport::Report.new("Users/john/my_template.odt")do |r|r.add_field"USER_NAME",@user.nomer.add_field"ADDRESS",@user.addressr.add_table("TABLE_1",@list_of_items,:header=>true)do |t|t.add_column(:item_id,:id)t.add_column(:description){ |item|"==>#{item.description}"}endend

and considering you have a table like this in your template

#IDDescription
[ITEM_ID][DESCRIPTION]

and a collection@list_of_items, it will create one row for each item in the collection, and the replacement will take place accordingly.

Any format applied to the fields in the template will be preserved.

Sections

Sometimes, you have to repeat a whole chunk of a document, in a structure a lot more complex than a table. You can make a Section in your template and use it in this situations. Creating a Section in OpenOffice is as easy as select menuInsert and thenSection..., and then choose a name for it.

Sections are lot like Tables, in the sense that you can pass a collection and have that section repeated for each member of the collection.But, Sections can have anything inside it, even Tablesand nested Sections, as long as you provide the appropriate data structure.

Let's see an example:

@invoices=Invoice.find(:all)report=ODFReport::Report.new("reports/invoice.odt")do |r|r.add_field(:title,"INVOICES REPORT")r.add_field(:date,Date.today)r.add_section("SC_INVOICE",@invoices)do |s|s.add_field(:number){ |invoice|invoice.number.to_s.rjust(5,'0')}s.add_field(:name,:customer_name)s.add_field(:address,:customer_address)s.add_table("TB_ITEMS",:items,header:true)do |t|t.add_column(:id)t.add_column(:product){|item|item.product.name}t.add_column(:value,:product_value)ends.add_field(:total)do |invoice|ifinvoice.status =='CLOSED'invoice.totalelseinvoice.items.sum('product_value')}endends.add_section("SUB_NOTES",:notes)do |s1|s1.add_field(:note_title){ |n|n.title}s1.add_table ...endendend

Note that when you add a Table to a Section, you don't pass the collection itself, but the attribute of the item of that section that will return the collection for that particular Table. Sounds complicated, huh? But once you get it, it's quite straightforward.

In the above example,s.add_table("TB_ITEMS", :items, header: true) do |t|, the:items thing refers to ainvoice.items. Easy, right?

Images

You must put a mock image in your.odt template and give it a name. That name will be used to replace the mock image for the actual image.You can also assign any properties you want to the mock image and they will be kept once the image is replaced.

An image replace would look like this:

report=ODFReport::Report.new("my_template.odt")do |r|r.add_image:graphic1,"/path/to/the/image.jpg"r.add_table("TABLE_WITH_IMAGES",@items)do |t|t.add_column(:id)t.add_column(:product,:product_name)t.add_image('PRODUCT_IMAGE'){ |item|item.image_path}endend

Step 2 -- generating the document

It's fairly simple to generate the document. You can use this inside a Rails application or in a standalone script.

Generating a document in a Rails application

In a controller, you can have a code like this:

defprint@ticket=Ticket.find(params[:id])report=ODFReport::Report.new(Rails.root.join("/app/reports/ticket.odt"))do |r|r.add_field(:id,@ticket.id.to_s)r.add_field(:created_by,@ticket.created_by)r.add_field(:created_at,@ticket.created_at.strftime("%d/%m/%Y - %H:%M"))r.add_field(:type,@ticket.type.name)r.add_field(:status,@ticket.status_text)r.add_field(:date,Time.now.strftime("%d/%m/%Y - %H:%M"))r.add_field(:solution,(@ticket.solution ||''))r.add_table("OPERATORS",@ticket.operators)do |t|t.add_column(:name){ |op|"#{op.name} (#{op.department.short_name})"}endr.add_table("FIELDS",@ticket.fields)do |t|t.add_column(:field_name,:name)t.add_column(:field_value){ |field|field.text_value ||"Empty"}endendsend_datareport.generate,type:'application/vnd.oasis.opendocument.text',disposition:'attachment',filename:'report.odt'end

Generating a document in a standalone script

It's very similar to a Rails app, but you can inform the path where the file will be saved.

report=ODFReport::Report.new("ticket.odt")do |r|...populatesthereport ...endreport.generate("./documents/new_ticket.odt")

Using a template stored in the database (or anywhere besides the file system)

You can provide anio: param, containing the actual file read into a String.

report=ODFReport::Report.new(io:@template.attachment.read)do |r|

REQUIREMENTS

rubyzip: manipulating the contents of the odt file, since it's actually a zip file.nokogiri: parsing and manipulating the document xml files.mime-types: identify images mime types

TROUBLESHOOTING

Placeholder not replaced

If your placeholder is not being replaced, the problem might come from OpenOffice/LibreOffice which, when a placeholder is edited, add some markup that prevents odf-report from identifying the placeholder.

The golden rule is: NEVER edit the placeholders. If you want to change one, delete it an write again, including the []Example: if you have, say, [USER] in your template and you want to change to [USERNAME], you should not edit and type NAME.Delete the PLACEHOLDER [USER] and type [USERNAME].

Word found unreadable content
  • Symptom: You prepare your template file in eg. LibreOffice, and when you open the template in Word it says "Word found unreadable content"
  • Solution: Open your template in LibreOffice, save as.docx, quit LibreOffice. Open the.docx in LibreOffice, save as.odt.
  • Hypothesis: Word does not support all ODT features. Saving as.docx removes those features of the document.

[8]ページ先頭

©2009-2025 Movatter.jp