Prajul P T's picture

Advanced Printscreen for OpenERP 7(Analytic Report Printing)

Printscreen has been and is an attractive feature of OpenERP. But unfortunately this feature was available for OpenERP 6.1 GTK Client. OpenERP 7 provide an functionality to print the current view in PDF. You may have already noticed that i have already published a blog named "Printscreen in OpenERP 7 which was a migrated module from web_export_view with few my own functionality added to it. But now we have developed a new module called web_printscreen_zb with some new features that might be helpful to users of OpenERP 7. 

The main features of this module are:

Anonymous's picture

Hi Prajul, Your module looks

Hi Prajul,

Your module looks like incredible, but when I install it, the new buttons don't appear and I have an error message:

OpenERP Server Error

Client Traceback (most recent call last):
File "/opt/openerp/openerp/addons/web/http.py", line 204, in dispatch
response["result"] = method(self, **self.params)
File "/opt/openerp/openerp/addons/web/controllers/main.py", line 1125, in call_button
action = self._call_kw(req, model, method, args, {})
File "/opt/openerp/openerp/addons/web/controllers/main.py", line 1113, in _call_kw
return getattr(req.session.model(model), method)(*args, **kwargs)
File "/opt/openerp/openerp/addons/web/session.py", line 42, in proxy
result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
File "/opt/openerp/openerp/addons/web/session.py", line 30, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/opt/openerp/openerp/addons/web/session.py", line 103, in send
raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last):
File "/opt/openerp/openerp/addons/web/session.py", line 89, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/opt/openerp/openerp/netsvc.py", line 292, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/opt/openerp/openerp/service/web_services.py", line 626, in dispatch
res = fn(db, uid, *params)
File "/opt/openerp/openerp/osv/osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, **kw or {})
File "/opt/openerp/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, *args, **kwargs)
File "/opt/openerp/openerp/osv/osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/opt/openerp/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/opt/openerp/openerp/addons/base/module/module.py", line 424, in button_immediate_install
return self._button_immediate_function(cr, uid, ids, self.button_install, context=context)
File "/opt/openerp/openerp/addons/base/module/module.py", line 475, in _button_immediate_function
_, pool = pooler.restart_pool(cr.dbname, update_module=True)
File "/opt/openerp/openerp/pooler.py", line 39, in restart_pool
registry = RegistryManager.new(db_name, force_demo, status, update_module)
File "/opt/openerp/openerp/modules/registry.py", line 218, in new
openerp.modules.load_modules(registry.db, force_demo, status, update_module)
File "/opt/openerp/openerp/modules/loading.py", line 345, in load_modules
processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules, update_module)
File "/opt/openerp/openerp/modules/loading.py", line 256, in load_marked_modules
loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
File "/opt/openerp/openerp/modules/loading.py", line 165, in load_module_graph
init_module_models(cr, package.name, models)
File "/opt/openerp/openerp/modules/module.py", line 374, in init_module_models
result = obj._auto_init(cr, {'module': module_name})
File "/opt/openerp/openerp/osv/orm.py", line 3162, in _auto_init
default = self._defaults[k](self, cr, SUPERUSER_ID, context)
File "/opt/openerp/openerp/addons/delivery/stock.py", line 140, in
'weight_uom_id': lambda self,cr,uid,c: self._get_default_uom(cr,uid,c)
File "/opt/openerp/openerp/addons/delivery/stock.py", line 138, in _get_default_uom
return self.pool.get('product.uom').search(cr, uid, [('category_id', '=', uom_categ_id),('factor','=',1)])[0]
IndexError: list index out of range

Can you help me ?

Prajul P T's picture

Hi,      This error is not

Hi,

     This error is not from my module. I think you have deleted some UOM from ERP. There are some UOM which should not be deleted. Please update the product module. But i think you have to do some modification in the product module. The UOM are loaded from the file product_data.xml in product module and this file has <data noupdate="1"> set. Change it to <data noupdate="0"> and update the product module.

Try updating the product module without the above said modification. If the error still exist, please do it as explained above.

Anonymous's picture

Thank you, I've found the

Thank you,

I've found the error and the installation is now completed !
This module is awesome !

Hans Yonathan's picture

Hi Prajul, As Thanks for this

Hi Prajul,

As Thanks for this module development, I have improve this module to become cooler. So here is the log that I improved:

1. Now support for all tree view(I am not talking about listview but treeview, such as tree in Product Category or analytic accounting or Journal Items).
2. Support for windows in "new" mode (popup).
3. Improve link (pdf or excel) to be button like other openERP, so it more elegant to see and more neat.

Need to be improve:
1. Support for form view too, now its not support yet. (This will be hard task)

I want to propose the merge with your branch but I dont know how,
here is the link of my branch: lp:~hans-yonathan/printscreen/trunk

Maybe this will be start for our partnership.

fyi: I have developed many cool module too and I will be happy if we can share our module to each other.

Thank you.

Kevin McMenamin's picture

thanks for this module. The

thanks for this module. The issue I have is the export only works for up to 200 rows of data - after that it just times out. Is this expected behaviour?

Prajul P T's picture

Hi,      This is not the

Hi,

     This is not the expected behavior. We have tested the module with more that 3000 records. Can you please check if there is any error in server log.

Kevin McMenamin's picture

found the error: xlwt set

found the error: xlwt set style making error: More than 4094 XFs (styles)

the solution was: wb = xlwt.Workbook(style_compression=2)

now successfully exporting 5,000 rows of data.

Antoine Morit's picture

This module is awesome ! Just

This module is awesome !
Just have to declare a new tree-view and you have a light report and Excel export !
Many thanks for sharing it..

Hans's picture

Hi Prajul, Great addons, but

Hi Prajul,
Great addons, but I found a bug when I want to print with pdf,
I cannot print it. It doesnt download anything.
There's an error message in the log:

2014-02-17 02:16:52,675 20199 ERROR ONL openerp.addons.web.http.HttpRequest.dis$
Traceback (most recent call last):
File "/opt/openerp70/falinwa_branch/web/http.py", line 285, in dispatch
r = method(self, **self.params)
File "/opt/openerp70/falinwa_branch/web_printscreen_zb/controllers.py", line $
cookies={'fileToken': int(token)})
File "/opt/openerp70/falinwa_branch/web/http.py", line 332, in make_response
response.set_cookie(k, v)
File "/usr/lib/python2.7/dist-packages/werkzeug/wrappers.py", line 992, in se$
self.charset))
File "/usr/lib/python2.7/dist-packages/werkzeug/http.py", line 905, in dump_c$
value = to_bytes(value, charset)
File "/usr/lib/python2.7/dist-packages/werkzeug/_compat.py", line 106, in to_$
raise TypeError('Expected bytes')
TypeError: Expected bytes

This problem only occur on my cloud server, when I try in my local its worked. I used your lasted version module (v4).

Do you know what is the problem?

Thank you.

Prajul P T's picture

Hi,     Can you please check

Hi,

    Can you please check if python-xlwt package is installed in the server. If this don't fix the issue can you please specify from where you are getting the error. ie; while printing which record you are getting the error.

Gopakumar N G's picture

Sales Analysis Report

Are you interested in getting the sales details of your firm from anywhere you go . If you want to check out the trend of your business for a month or in the current year, if you need the sales details of particular product or category at the moment in a precise way, OpenERP provides these functionalities with analysis report and graph views.

  Analysis reports are used for creating dynamic reports in OpenERP. The advantages of analysis reports are:

Anonymous's picture

Hi, I Notice one of your

Hi,

I Notice one of your order analysis page shows cost price & total cost column, which is not the default case. I just followed
http://help.openerp.com/question/17156/add-more-fields-to-pos-order-anal...
http://www.zbeanztech.com/blog/sales-analysis-report

unfortunately I keep getting issue, where cost_price is not exist in pos order model - what am i missing? can anyone help?

ProgrammingError: column report_pos_order.cost_price does not exist
LINE 1: ...ort_pos_order"."product_qty") AS product_qty, sum("report_po...

using Openerp7;

Anonymous's picture

Sometimes I loose my patience

Sometimes I loose my patience so fast.
Just updating the db - its working fine.

bobber seat's picture

Hmm is anyone else having

Hmm is anyone else having problems with the images on this blog loading?
I'm trying to find out if its a problem on my end
or if it's the blog. Any responses would be greatly appreciated.

Janeesh A's picture

Check Writing in OpenERP

 

Users can manage their check writing process by installing the account_check_writing module. The module provides users a variety of check writing capabilities:

 

  • Ability to make supplier payments with checks
  • Support printing checks in three formats: Top voucher check, middle voucher check, and bottom voucher check
  • Printing an Individual Check
  • Printing multiple checks in batch

Setup Of Check Writing

Install the account_check_writing module.

Anonymous's picture

printing multiple checks in

printing multiple checks in batch, where ?

Anonymous's picture

can you tell me how to get

can you tell me how to get invoice id from check_wrinting module

phen375's picture

Your style is so unique

Your style is so unique compared to other folks I have read stuff from. Thanks for posting when you have the opportunity, Guess I will just bookmark this page.

phen375 reviews's picture

Hi there it's me, I am also

Hi there it's me, I am also visiting this website on a regular basis, this web page is truly pleasant and the visitors are genuinely sharing fastidious thoughts.

Chandhu Viswanath's picture

Accounting Vouchers in Employee Payslip - OpenERP 6.1

    When it comes to OpenERP 6.1 the pay roll management has witnessed  remarkable changes in  it's way of functioning as compared to it's earlier versions. The absence of  "Pay Salary" button, "Accounting Vouchers" and a lot more. Among them, the absence of "Accounting Vouchers" has created a lot of confusion to the existing users. Here i am trying to explain the changes happened with voucher creation

book keeping adelaide's picture

This is the only time I've

This is the only time I've been to your site. Thank you for sharing more information.

Anonymous's picture

Great thanks a lot!

Great thanks a lot!

Anonymous's picture

What if we want to import

What if we want to import partners with their total receivable and total payable and what if want to import quantity available when importing products. I tried a lot and could not do the same yet. Also I used both import compatible export and export all data export types. If anyone has done RnD on this please reply.

Anonymous's picture

I get the following error

I get the following error whenever I try to import partners and products
ValueError: No such external ID currently defined in the system: __import__.res_partner
ValueError: No such external ID currently defined in the system: 20__export__.product_product_456.
I successfully imported my taxes.

Anonymous's picture

I customize a asset

I customize a asset management functions. However, when I perform import from csv file into the system, the system does not display the data import.
steps are as follows:
Choose imoprt, select file to import, and then select File format option, then click validate. The notification system "Everything Seems valid.". After that I click the Import button. And then the system turn to asset management.
However, the system does not display the data import.
Help me!

pierrecogitae's picture

Another important missing

Another important missing point: how do you read the import wizard from the web interface?

Anonymous's picture

This is great tutorial but

This is great tutorial but it's missing one thing: how to add predefined export as a scheduler job. I know where scheduler is, but I have no idea what should i put into 'Action to trigger' object/function. Any help is welcome :)

Douglas's picture

I am now not positive where

I am now not positive where you are getting your information, however great topic. I must spend a while learning much more or understanding more. Thanks for wonderful information I used to be searching for this information for my mission.

Girish Joshi's picture

Hi, Can anyhelp help in

Hi, Can anyhelp help in Importing Products from CSV in Version 6.1 ? I am not able to import New Product from the List of CSV in 6.1 Version. Also, many2one relationship is set to weird when Updating records via csv in 6.1

Vishnu Devaraj's picture

OpenERP Mass Mail Module ( zb_mass_mail )

      'Mass Mail' is an OpenERP module developed by Zesty Beanz, which addresses the email marketing concerns in a business. The module allows users to flexibly handle  mass emailing. The major features of the module are as follows

 

B&#039;ert's picture

Does this work togeter with

Does this work togeter with openERP 7?

Thank you!

Nellie's picture

Wonderful goods from you,

Wonderful goods from you, man. I've understand your stuff previous to and you're just too magnificent. I really like what you have acquired here, certainly like what you are stating and the way in which you say it. You make it entertaining and you still take care of to keep it smart. I cant wait to read much more from you. This is actually a tremendous site.

netvienna's picture

Hello, I tried to install,

Hello, I tried to install, but it says mail_gateway is necessary, but I cannot find this for 6.1 ?
Any hint
Br
Oliver

Mira's picture

Hi Vishnu, I just

Hi Vishnu,

I just installed your module and it's great but I don't seem to manage to use the "Import Email addresses" function from Members tab. No matter what I use I get an error and the most frustrating part is that it doesn't show me the error it just appears a message letting me know that there's an error. Please let me know if this is a bug or I'm doing something wrong.

Stay At Home's picture

Thаnks foг your peгѕonal

Thаnks foг your peгѕonal marvelous posting! Ι definitely enjoyеd reading it, you саn be a great author.I ωill be ѕure to bookmaгk your blog and will often come back at some point. I ωant to encourage cοntinue your great job, have a niсe mоrning!

Anonymous's picture

Sorry for the stupid question

Sorry for the stupid question but I am novice for Python and OpenERP.
How can xlrd and xlutils be installed on Windows. OpenERP is installed with all-in-one installer. There is no python installation on the server. I see only python25.dll in /OpenERP6.01/Server directory.

latest gadgets reviews's picture

when the next update will

when the next update will come out? Don't forget, software has to be up-to-date all the time, or ppl wont use it anymore.

Anonymous's picture

I'm newby for mass mailing in

I'm newby for mass mailing in OpenERP.

Untill now, I'm using "Phplist". I have a html template on it. How to use the some template in OpenERP email template?

Also, May you show me, step by step, how to send an mass mail to members? I'm confused, because of compaign functionnalities?

Vishnu Devaraj's picture

Once the mass mail module is

Once the mass mail module is installed, you will get the menu  "“Mass Mailing > Mass Mail Templates” . Create a new record. Here you can paste the html code and later choose the record as your template.

Anonymous's picture

Nice to very useful info for

Nice to very useful info for me.Because i'm new in blogging and i'm need good tutorial like your post.

fahad's picture

OpenERP development environment in Windows using Eclipse.

 In this blog we will go through some steps required in setting up OpenERP for customization under eclipse in windows.
Before going into the details, let me remind every one that Linux distros preferably ubuntu is the best platform to do developments in OpenERP. This may be useful to only those insit development to be done in Windows.

Versions Used:

Khin's picture

I installed OpenERP7

I installed OpenERP7 (Allinone),Python25, Eclipse(Indigo) in Window XP. Now I want to customize some feature in existing module (hr_payroll).I can't debug OpenERP in Eclipse. I didn't find this file (openerp-server.py) in my location(C:\Program Files\OpenERP 7.0-20130613-231107\Server\server\..). In Eclipse, I didn't see server folder in browse (Eclipse -> Run -> Debug Configurations -> Python Run -> Double click -> Browse). Can you help me this problem? Thank you very much.

Anonymous's picture

I want to design forms in my

I want to design forms in my project . How can I be able to do this ?

Please help

Titus's picture

I have followed the steps to

I have followed the steps to have openERP on my machine. When I run opeerp-server.py I get this output:

[2013-04-17 15:09:27,352][?] INFO:server:OpenERP version - 6.0.4
[2013-04-17 15:09:27,352][?] INFO:server:addons_path - C:\OpenERP\Server\bin\addons
[2013-04-17 15:09:27,352][?] INFO:server:database hostname - localhost
[2013-04-17 15:09:27,352][?] INFO:server:database port - 5432
[2013-04-17 15:09:27,352][?] INFO:server:database user - Titus
[2013-04-17 15:09:27,352][?] INFO:server:initialising distributed objects services
[2013-04-17 15:09:27,634][?] INFO:web-services:starting HTTP service at 0.0.0.0 port 8069
[2013-04-17 15:09:27,635][?] INFO:web-services:starting HTTPS service at 0.0.0.0 port 8071
[2013-04-17 15:09:27,635][?] INFO:web-services:Registered XML-RPC over HTTP
[2013-04-17 15:09:27,638][?] INFO:web-services:starting NET-RPC service at 0.0.0.0 port 8070
[2013-04-17 15:09:27,638][?] INFO:server:Starting 3 services
[2013-04-17 15:09:27,640][?] INFO:server:OpenERP server is running, waiting for connections...

When I run the openerpclient I get errors as follows

Traceback (most recent call last):
File "C:\OpenERP\Client\bin\openerp-client.py", line 62, in
import gtk
File "C:\Python25\Lib\site-packages\gtk-2.0\gtk\__init__.py", line 38, in
import gobject as _gobject
File "C:\Python25\Lib\site-packages\gtk-2.0\gobject\__init__.py", line 30, in
from gobject.constants import *
File "C:\Python25\Lib\site-packages\gtk-2.0\gobject\constants.py", line 22, in
from _gobject import type_from_name
ImportError: DLL load failed: The specified module could not be found.

Kindly help

pfe2013's picture

hi, I want to install

hi, I want to install Openerp-server (6.0.3) on windows with source. i have already download all python packages; but when I execute

Code: python setup.py install

I have this error:

File "C:\serveur\openerp-server-6.0.3\setup.py", line 269, in
z = zipfile.ZipFile(zipfile_path, 'a')
File "C:\Python25\lib\zipfile.py", line 339, in __init__
self.fp = open(file, modeDict[mode])
IOError: [Errno 2] No such file or directory: 'dist\\library.zip'

PFE's picture

Hi After setting up the

Hi
After setting up the development environment on Windows,
when I come to execute openerp-server.py:
error:

[2013-03-04 11:10:10,776][?] INFO:server:OpenERP version - 6.0.3
[2013-03-04 11:10:10,776][?] INFO:server:addons_path - C:\openerp-server-6.0.3\bin\addons
[2013-03-04 11:10:10,776][?] INFO:server:database hostname - localhost
[2013-03-04 11:10:10,776][?] INFO:server:database port - 5432
[2013-03-04 11:10:10,776][?] INFO:server:database user - Hamdi
[2013-03-04 11:10:10,776][?] INFO:server:initialising distributed objects services
Traceback (most recent call last):
File "C:\openerp-server-6.0.3\bin\openerp-server.py", line 94, in
import report
File "C:\openerp-server-6.0.3\bin\report\__init__.py", line 22, in
import interface
File "C:\openerp-server-6.0.3\bin\report\interface.py", line 32, in
import render
File "C:\openerp-server-6.0.3\bin\report\render\__init__.py", line 22, in
from simple import simple
File "C:\openerp-server-6.0.3\bin\report\render\simple.py", line 27, in
from reportlab.platypus import SimpleDocTemplate, Paragraph, Spacer, Table
ImportError: No module named reportlab.platypus

thanks

pfe2013's picture

hi, I want to install

hi, I want to install Openerp-server (6.0.3) on windows with source. i have already download all python packages; but when I execute
Code: python setup.py install

I have this error: Code:

Traceback (most recent call last):
File "C:\serveur\openerp-server-6.0.3\setup.py", line 269, in
z = zipfile.ZipFile(zipfile_path, 'a')
File "C:\Python25\lib\zipfile.py", line 339, in __init__
self.fp = open(file, modeDict[mode])
IOError: [Errno 2] No such file or directory: 'dist\\library.zip'

thanks

Rami's picture

Hi Fahad, Thanks for the

Hi Fahad,

Thanks for the great article .. I need your help to get the server and the client running without eclipse on windows.
What would be the command to do that.

Thanks,
Rami

fahad's picture

Hi Rami, 1)Use commanfd line

Hi Rami,

1)Use commanfd line and cd to directory of the server.
2)Openerp Server could be started using python openerp-server.py

 

Anonymous's picture

I follow the steps, when i

I follow the steps, when i lunch a debug i have a problems :
I dont understand why i have this problem :'( :
Traceback (most recent call last):
File "C:\Users\slim.slim-PC\Desktop\eclipse\plugins\org.python.pydev_2.6.0.2012062818\pysrc\pydevd.py", line 1392, in
debugger.run(setup['file'], None, None)
File "C:\Users\slim.slim-PC\Desktop\eclipse\plugins\org.python.pydev_2.6.0.2012062818\pysrc\pydevd.py", line 1085, in run
pydev_imports.execfile(file, globals, locals) #execute the script
File "C:\OpenErp\openerp-server-6.0.3\bin\openerp-server.py", line 112, in
service.http_server.init_servers()
File "C:\OpenErp\openerp-server-6.0.3\bin\service\http_server.py", line 233, in init_servers
int(tools.config.get('xmlrpc_port', 8069)))
ValueError: invalid literal for int() with base 10: '8069 (change port here if already allinone setup has been installed,say 8059)'

help me please :'(

fahad's picture

Please remove the round

Please remove the round brackets and their contents, which was meant only for understanding.