Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

7

Is there any way to preview WebKit report layout while coding (maybe WYSIWYG Editor)?

By
NSC
on 5/16/14, 6:59 AM 21,492 views

I consider to play with WebKit Reporting once again. What is really cumbersome with Reporting in general, is layouting. Therefore, the choice of my next reporting engine would depend on the availability of a graphical layout editor. It is not important, if all the report can be built with it, but for quicker and more comfortable layouting a layout preview is strongly required.

Up to now, I use ReportLab with OpenOffice Report Designer. Report Designer I only use for layout purposes - all the rest I do by directy working with the code, i. e. I build my layout with Report Designer, export it as .rml and push the latter to the directory of my custom report module. I would like to continue with this procedure using WebKit as Reporting Engine. I need not know how to set it up in OpenERP, but if there is any possibility of coding with layout preview.

12

Fabrice Henrion (fhe)

--Fabrice Henrion (fhe)--
5823
| 7 7 8
San Francisco, United States
--Fabrice Henrion (fhe)--

Director Odoo USA

Fabrice Henrion (fhe)
On 5/17/14, 4:41 PM

Are you aware that the latest version of Odoo comes with a QWeb report engine that allows WYSIWYG edition just like for the CMS website builder? It sounds like this is what you are looking for. Create an Odoo Online account and check it out.

Here is how to test it (you must be on v7-SaaS4 or later so I recommend to try it on Odoo Online):

  1. First you have to know that the new QWeb engine allows to output PDF or HTML. It is only when the output is HTML that it can be modified in a WYSIWYG fashion.
  2. Let's assume the Sales module is installed on a fresh Odoo instance. By default, the output of a quotation document is PDF, you can test that by printing a quotation. We want to change this.
  3. Make sure your user has the technical feature checkbox checked and the 'website' module installed. Then go to Settings > Technical > Reports > Reports, then search "sale.order" and enter the record.
  4. Edit the Report Type from PDF to HTML, then Save.
  5. Go back to the Sales app and print a quotation.
  6. A popup appear (or your popup-blocker will notify you). You will see the quotation in that popup and a black bar at the top with the Edit button. You need to make sure you have the access right to edit this so I recommend you do this test as an admin.
  7. From there, it's pretty straightforward. You edit whatever you want. You have to realize that there are 2 types of edition on a record like this: editing this particular record, or editing the quotation template which will have an impact on all records. For example, if you edit a header, it will be a template edition.

For Customize top menu, you can also use the HTML editor directly.

Fabien Pinckaers (fp)
on 5/20/14, 5:16 PM

Hi Fabrice, Thank you, this is exactly what I was looking for and has allowed me to add images to order lines and customise any report easily just using basic HTML/QWeb. This makes customisation extremely easy in v8.

Luke Branch
on 7/4/14, 8:23 AM

Sadly this does not work in Odoo 8 (Version 9.0 Alpha 1). You will get an internal error, Internal Server Error "The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application."

Yenthe
on 8/19/14, 9:52 AM

Does'nt work, the edit button comes up disable, it's there some workaround

Juan Plaza
on 8/22/14, 10:53 AM

Hi, Your solution seems exactly what i am looking for. Unfortunatly, after changind the pdf to html, when I print a quotation I get this error message: Uncaught SyntaxError: Unexpected end of input https://adret.odoo.com/web?#id=4&view_type=form&model=sale.order&menu_id=304&action=378:0 What did I miss? Thanks for your help

Adret, Pascal de Clarens
on 8/30/14, 1:20 AM

Thanks for this. I was began to think that odoo has released de 8 version in early dev stage. This is a great great improvement. Thank you for taking your time to explain this. Regards PS: As GrupoCiTEC has mentioned you need to have the Web Designer module to be able to edit the html. Perhaps editing your answer would be great.

XaRz
on 9/25/14, 6:08 AM

Hello Fabrice, I just pulled the latest v8 and the instructions that you provided do not work, nothing happens and nothing is noted in the log, I can get to a report by using the url e.g.http://localhost:8069/report/html/account.report_invoice/1 but not from the print menu? Is this still in development? TX ER

EUGE Consulting, E.R. Spada II
on 10/7/14, 12:05 AM

Sorry, I could see the pop-up blocker on saas, but was not notified on my local browser.... ER

EUGE Consulting, E.R. Spada II
on 10/7/14, 12:09 AM
5
GrupoCITEC
On 8/9/14, 6:36 PM

Hi, just to add that you need to have the 'website' module installed in order to see the EDIT button in the rendered html report

ty! Great tip!

XaRz
on 9/25/14, 6:04 AM

Almost 5 hours lost before found this mandatory tip, thanks!

Damodar D.
on 10/5/14, 6:04 PM
2
Stefan Joachim
On 11/7/14, 2:05 AM

Hi,

I tried to change the layout (move boxes and delete lines), but I'm only able to delete text.
I use the odoo "Version 8.0" installed while using the script:
https://github.com/aschenkels-ictstudio/openerp-install-scripts/blob/master/odoo-v8/ubuntu-14-04/odoo_install.sh

Example, I try to move the customer address from right page site to the left. But I'm not able to do that. I see the "edit" button, and I see in the pull down menu "customize content".

My question, How can I change the layout totally free for printing a pdf report, in this case a invoice? Is ther a complete How to for beginners? I'm not a developer :-) But I'm able to edit HTML and CSS.

Thanks a lot for help

Stefan

 

0
Annette Schoepgens
On 4/14/16, 5:48 AM

HI,

can it be, that this function is not given correctly at the latest Odoo v9 ?

I can change the report print view from PDF  to HTML and open the report. Then it's possible to change some text, but i cannot move/delete/add snippets on this report like website builder.

The left toolbar (from websuite builder) just pop in for a 1/10 second and then pop out. No change to become back the toolbar.

I've seen this on a youtube video and i think thats a great tool to edit the reports.

Thank you

Marco

0
Tankgirl
On 3/6/15, 4:37 AM

As we are discussing the layout of the reports here, I want to ask my question here.
Is there a way (a WYSIWYG way) to edit external_layout_footer and external_layout_header?

I have tried editing it inside a report (with the way explained here) , but when I save it, the header becomes totally different. I don't think this is the right way to edit this.

I know how to edit the header and footer in code mode by the way.

0
mohsel
On 5/20/14, 12:25 PM

Thank you Fabrice, your guide is clear and very helpful, but how can i modify the html templates ? for more technicals customization like adding an amount_to_text field ?

@mohsel, i've been doing some custom work on the saleorder, invoice, and other documents by adding the customisations to a custom module thanks to the tips from Fabrice on QWeb. Please provide some more information on what exactly you'd like to achieve in regards to customisations and i'd be happy to provide you with whatever information I can to help.

Luke Branch
on 11/9/14, 11:53 PM
0

Has there been some change here in the latest 8.0rc1 branch? The edit button comes up disabled here...

0
NSC
On 7/26/14, 9:24 AM

Fabrice, I have just tried what you told, popup opens, but without any toolbar or edit button... What am I doing wrong? I am logged in as admin user and report to print is set to html...

You need to install the web designer module! :)

XaRz
on 9/25/14, 6:05 AM
0
Thomas Fossoul
On 7/23/14, 8:21 AM

Hi,

Do you know if this is possible to edit localy the document when you are on the html editor then save it as pdf ?  

So i need to have the normal template of the sale order (for instance) then i would like edit it just before sending it to the customer (or save it as pdf) without edit the template used each time a generate a sale order...

 

 

 

0
NSC
On 5/20/14, 9:35 AM

Thank you very much, Fabrice! This helps me very much to estimate how to proceed!

At the moment, I have a custom module with 3 different customized rml report templates inside. As I use OpenERP/Odoo Community Version and have some custom modules which also change data models (res.partner where I added some additional fields to), I will need a bit of time to upgrade to v8, because data migration will not be too easy-going. But in the meantime, I could try to convert my .rml templates to HTML code what I think to be not too easy-going, too, but I suppose or hope it will be possible. If not, I have to take the predesigned webkit templates and modify them within v8 to approach my current .rml layout. For that purpose, the information you gave above will be very helpful to me. Maybe I will try like that first. Then I can change to webkit within my v7, install new custom webkit report module designed by the help of v8, copy modified header code where it belongs to (maybe it can also be placed to my custom module - up to now, I have not found out, how to) and my webkit migration should be finished. Whenever I need to change layout, I can do this using v8 till time will have come to change to v8 entirely.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

14 follower(s)

Stats

Asked: 5/16/14, 6:59 AM
Seen: 21492 times
Last updated: 4/14/16, 5:49 AM