India

ZestyBeanz Technologies Pvt Ltd Thejaswini, Technopark Thiruvananthapuram,
India – 695581
Phone: +91 471 4063254
Fax : +91 471 2700171

   .

ZestyBeanz Technologies Pvt Ltd, 2987, Manikkath Cross Road, Ravipuram, Kochi, India - 682016, Phone: +91 484 4063254

  UAE

ZestyBeanz Technologies FZE, P.O Box 53261, HFZA, Sharjah, Phone: +971-56-2708993​

  Germany​

ZestyBeanz Technologies UG Fürther Str. 27 90429 Nürnberg Phone: +49-911-28707070

Contact Form


Anonymous's picture

Thanks for sharing..

Thanks for sharing..

Iqbal's picture

Great information. Thanks.

Great information. Thanks.

Prajul P T's picture

Printscreen in OpenERP 7

        Print screen was a feature of OpenERP which enables the user to take the printout of the tree view of the selected records. This feature was available in OpenERP 6.1 GTK client was not available in OpenERP 6.1 web client and OpenERP 7. In OpenERP 7, there is an option to take printout of the tree view. But in OpenERP 7 we cannot select the particular records which we want to print in the report. 

Shyam's picture

Hello, This module is so so

Hello,

This module is so so useful. Thanks for such kind of activity.

But I have one little issue, If I run module in ubuntu its working fine for me but when I work with Centos that time its not generate excel file only pdf file is generated.

Please do nedful help.

Thanks,
Shyam.

Prajul P T's picture

Hi Shyam,       This module

Hi Shyam,

      This module requires an additional python package 'python-xlwt'. Please confirm that this package is installed in your CentOS. Please try this module also module http://zbeanztech.com/blog/advanced-printscreen-openerp-7

Shyam's picture

Hello, Yes I got solution. I

Hello,

Yes I got solution. I installed xlwt package. Now its working fine.

You can put pre require package in __openerp__.py files description.
So non-python or Non-OpenERP user can use understand easily.

Thanks.
Shyam.

Shyam's picture

Hello, Ya I find the

Hello,

Ya I find the solution. There was missing xlwt library.

You can put require package in description.

Thanks.
Shyam

Morad's picture

excellent work

excellent work

Anonymous's picture

I have to print the form view

I have to print the form view so can we print the form view in the same manner.

Gaylene Kanae's picture

I don't even understand how I

I don't even understand how I ended up here, but I thought this publish used to be great. I don't recognise who you are however certainly you are going to a famous blogger in the event you aren't already. Cheers!

Prajul P T's picture

Thanks.......

Thanks.......

Prajul P T's picture

Hi,     It can be done but

Hi,

    It can be done but unfortunately, that functionality is not available now...

Anonymous's picture

hi this module works perfect

hi this module works perfect but the thing is it is printing in excel format if we do in tree view only not in form view, .. how to do that

Jasad Moozhiyan's picture

OpenERP 7 integration with Moodle

OpenERP 7.0, The full featured ERP making the switch from an ERP to a suite of integrated business applications. So far, the world was split between ERPs and best of breed applications. With 7.0, OpenERP combines the key benefits of stand-alone apps (ease of use, quick to deploy, highly customizable, ...) with the integrations and feature coverage only ERPs used to provide to their customers.

Anonymous's picture

iam trying the same

iam trying the same procedure, but the time i enter the moodle configuration in openerp, the popup just disappears, and not saving the data, pls help

Anonymous's picture

I followed your steps but it

I followed your steps but it didn't work. have you tried Moodle 2.6? i guess some of the functions were deprecated.

Anonymous's picture

I just install moodle server

I just install moodle server and integrate it with openERP; i want to open moodle server for the second time and i follow the forum's steps but the page is not reachable?!

Please your helps

JZA's picture

I wonder how does this

I wonder how does this consolidate a Knowledge Management strategy for example to train employees, or deploy on-going training programs.

How does the processing of the courses interact back to the ERP, specially on HR, upper management and modules that interact with the employees performance.

Por example, would a manager know his-her staff has completed the course on the new version of the XYZ software that will be deployed next week?

Josue Rodriguez's picture

Thanks for this example. In

Thanks for this example. In that OS run your OpenERP? Ihave installed OpenERP 7.0 in Centos 6,3 and Moodle 2.4.4, but when i confirm an event, an server error appear: "Fault 404: Unknown error".
Thanks for your answer.

Jasad's picture

Hi Josue, I used Ubuntu 12.04

Hi Josue,
I used Ubuntu 12.04 for testing.The error you getting is 'Page not found' error. So please ensure the configuration part you done is correct.

Josué Rodríguez's picture

Thanks for answer. I

Thanks for answer. I installed now in Ubuntu 12.04 LTS, and error appear:
OpenERP Server Error
Client Traceback (most recent call last):
File "/opt/openerp/server/openerp/addons/web/http.py", line 204, in dispatch
response["result"] = method(self, **self.params)
File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1134, in call_button
action = self._call_kw(req, model, method, args, {})
File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1122, in _call_kw
return getattr(req.session.model(model), method)(*args, **kwargs)
File "/opt/openerp/server/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/server/openerp/addons/web/session.py", line 30, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/opt/openerp/server/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/server/openerp/addons/web/session.py", line 89, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch
res = fn(db, uid, *params)
File "/opt/openerp/server/openerp/osv/osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, **kw or {})
File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, *args, **kwargs)
File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/opt/openerp/server/openerp/addons/event/event.py", line 125, in button_confirm
self.check_registration_limits(cr, uid, ids, context=context)
File "/opt/openerp/server/openerp/addons/event_moodle/event_moodle.py", line 185, in check_registration_limits
response_courses = moodle_pool.create_moodle_courses(cr, uid, moodle_config_wiz_id, dic_courses, context=context)
File "/opt/openerp/server/openerp/addons/event_moodle/event_moodle.py", line 107, in create_moodle_courses
return sock.core_course_create_courses(courses)
File "/usr/lib/python2.7/xmlrpclib.py", line 1224, in __call__
return self.__send(self.__name, args)
File "/usr/lib/python2.7/xmlrpclib.py", line 1578, in __request
verbose=self.__verbose
File "/usr/lib/python2.7/xmlrpclib.py", line 1264, in request
return self.single_request(host, handler, request_body, verbose)
File "/usr/lib/python2.7/xmlrpclib.py", line 1297, in single_request
return self.parse_response(response)
File "/usr/lib/python2.7/xmlrpclib.py", line 1473, in parse_response
return u.close()
File "/usr/lib/python2.7/xmlrpclib.py", line 793, in close
raise Fault(**self._stack[0])
Fault:

Thanks for your help!

Jasad Moozhiyan's picture

This due to failing the

This due to failing the connection establishment to your moodle server. because you may not be correctly activated the web services.So first check that you are activated the web services in your moodle. If activated, then better to create an external services and add functions to it.

ie, In moodle server,Site Administration -> Plugins -> Web services -> External services. Add an external services here and add functions to it. when adding functions ,please make sure that you added atleast the following functions :

  •  core_course_create_courses
  • core_user_create_users
  • enrol_manual_enrol_users

After this create token by selecting this web service, and change the token details in your openerp. when changing the token , make sure that there is no other configuration data in your database. 

Josué Rodríguez's picture

Thanks for your answer! At

Thanks for your answer! At create an external service, add functions and create a new token, the integration works! Thanks for your support.

Now i have a new inconvenient. When i register an member in the event appear this message:

OpenERP Server Error
Client Traceback (most recent call last):
File "/opt/openerp/server/openerp/addons/web/http.py", line 204, in dispatch
response["result"] = method(self, **self.params)
File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1134, in call_button
action = self._call_kw(req, model, method, args, {})
File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1122, in _call_kw
return getattr(req.session.model(model), method)(*args, **kwargs)
File "/opt/openerp/server/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/server/openerp/addons/web/session.py", line 30, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/opt/openerp/server/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/server/openerp/addons/web/session.py", line 89, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch
res = fn(db, uid, *params)
File "/opt/openerp/server/openerp/osv/osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, **kw or {})
File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, *args, **kwargs)
File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/opt/openerp/server/openerp/addons/event/event.py", line 340, in registration_open
res = self.confirm_registration(cr, uid, ids, context=context)
File "/opt/openerp/server/openerp/addons/event_moodle/event_moodle.py", line 253, in confirm_registration
'city': register.city,
File "/opt/openerp/server/openerp/osv/orm.py", line 486, in __getattr__
raise AttributeError(e)
AttributeError: "Field 'city' does not exist in object 'browse_record(event.registration, 2)'"

Thanks for your valious help!

Jasad Moozhiyan's picture

Hi Josue, The data you are

Hi Josue,

The data you are fetching to create the registration/user is not correct.So please fetch the correct data and try.

Anoop P's picture

Importing different csv file templates to a single Model(Object) in OpenERP

This in an interesting module in OpenERP which I found useful recently for importing different csv file templates to a single object(model) in OpenERP. For example when we create a crone job (scheduler) to import csv files from different suppliers with their invoices which has different structure to the Customer Invoices in OpenERP. Below is a generic explanation of the existing module.

Prajul P T's picture

Crosstab in iReport

iReport is an reporting tool used for designing jasper report in OpenERP. In OpenERP it is difficult to create a report that has a dynamic column. For instance consider an example of a project report that has details regarding the project task completion date. The task name will be the name of the column. In such cases, the cross tab in report comes handy.

omarantonio's picture

Hi Prajul T. Thanks for your

Hi Prajul T.
Thanks for your help.

I am working with ireport and crosstab and right now i have a issue with a final report.
I need see in each column, the months of year but in order, for example: january, february, march, and so on, but I can to display that columns but in disorder.

The query was written in postgres:

with client as
(

select codclient, sum(total) as totalc
from v_sales
group by codcliente
order by totalc desc

)

select
vc.*,
cp.name as periodname,

date_part('year',cp.enddate) as anio,
date_part('month',cp.enddate) as numeromes,

date_part('month',cp.enddate) || '-' || initcap(fnc_period(cp.startdate, 1000000) ) as namecomplet ,

cp.periodno,

tc.totalc,
cp.enddate

from v_sales vc

inner join c_period cp
on vc.c_period_id = cp.c_period_id

inner join client tc
on tc.codcliente = vc.codcliente

order by namecomplet asc, anio asc;

Thanks a lot...!
Omar

Anonymous's picture

I have created a crosstab, if

I have created a crosstab, if placed in Summary section it works fine, but if in any other section means it is not giving any errors but it is not shown.
I think if we give increment type as Report it should work but it is not. Kindly help.

Anonymous's picture

Hi , In my report i am

Hi ,

In my report i am getting null value for one column even though data is there .Can any one help me and thanx in advance

Anonymous's picture

Hi, Can you please tell me

Hi,

Can you please tell me that how can we add a Serial Number in cross tab.

Anonymous's picture

hi sir,i have a problem when

hi sir,i have a problem when i keep all my subreports one by one in detail band all the reports are overlapping..if i keep them in summary then i have to set it like giving gaps between subreports...so if there will be more data for first subreport then it overlaps with second sub report how to remove it?
and in crosstab if complete row or column is null that is no value i want it to show 0(zero) but it doesnot give that row or column at all...what to do?
thanks...plz reply

Prajul P T's picture

Hi,     For your first

Hi,

    For your first query, ie; the overlapping of subreports , first select the subreport from main report go to properties, there you can see a field "Position Type". Set it to "Float" so that the subreport will not overlap.

      For Your second query, if the data in a crosstab is null it will be shown as null in the report. Please check weather you are retriving the data correctly. For example:

In the above report the the column group is the partner name and the measure is the phone. if there is no phone number for a partner, it will be shown as null.

Please check you are retriving the data correctly.

Hope this helps...

Anonymous's picture

Hi sir ,thanks for the reply

Hi sir ,thanks for the reply first answer which you gave has worked...my second doubt was if we have a task1 in row andtask1...n in column and if its having no value then i should get null/0 but that column is not visible at all what to do...for betteer understanding of my doubt i am trying to show it as table
task1 task2 task3 task4 task5 task6 total
task1 5(somevalue) 6 7 0 0 10 x value
task2 0 0 0 0 0 0 x value
task3 0 0 0 0 0 0 x value
task4 1 2 4 0 0 6 x value
task5 1 2 3 0 0 7 x value
task6 1 1 1 0 0 8 x value
total x x x x x x x value

if this is a cross tab,as u can see that columns task4 and task5 and rows task2 and task3 are having null values so in ireports its completely deleting or not showing that but i want it to display as i shown in the example not considering whether row/column is null...please help waiting for reply...thanks in advance...

Anonymous's picture

hope you will understand the

hope you will understand the above given example..as its not that clearly visible..but please clear my doubt..sorry for any kind of trouble in clarity..

Prajul P T's picture

Hi,      Please send me your

Hi, 

    Please send me your data retrieving details like whether you are using a JDBC connection or XML etc. It would be better if i could have a look at your .jrxml file.

murali's picture

HI, I am Working With

HI,

I am Working With iReport(jasper reports) and OpenERP 6.1.
I downloaded the integration addon of jasper_reports from community.
I am facing some problems while integrating it.
Can U Upload a blog for this?

Regards,
Murali

Prajul P T's picture

XLS Formula in Jasper Report using iReport

Jasper report is an reporting tool used in OpenERP for printing the reports in formats like pdf, Excel, HTML etc. Lets consider an example about the accounting reports. The report contain details regarding the credit amount, debit amount balance etc. It would be very useful if the report is printed in excel format. In excel sheet we will be able to specify the formula based on which each cell value is calculated. So if we are generating the excel sheet from jasper report we should be able to specify the formule in jasper report which should be used in the excel sheet.

Edgar's picture

Hi. Thank you for the

Hi. Thank you for the article. How can we set row numbers dynamically?

Anoj's picture

Hello sir, I am presently

Hello sir,

I am presently working with excel based reports in ireport,

you have aware of excel insert comments property in ms-excel ,which will provides information to particular cell,

so my question is is any option is available in jasper soft ireport or any other solution is there to get dynamic data in each excel cell ?

Prajul P T's picture

Hi,     I didn't get your

Hi,

    I didn't get your question exactly. But there are ways in ireport itself to get dynamic data in excel cell. Please give somemore details so that it would be helpful to me to solve your query correctly.

Anonymous's picture

hi sir... i want to store my

hi sir...
i want to store my jrxml and .jasper files in my running application rather than saving it in other folders.i came to know that we can create a package and store only .jasper files and we can run the application but i am getting file not found exception.
do we have to change it here also?

  1. <defaultValueExpression><![CDATA["C://JasperReports//"]]></defaultValueExpression>

please tell me the way to store these files in my application itself.initially i stored these in c://jasperreports//
what is the way and what are the changes to be made in jrxmls or the code?
please help it is important and urgent and i dont have any idea about it ..
thanks in advance...

Prajul P T's picture

Hi,     I didn't get your

Hi,

    I didn't get your requirement exactly. Are you trying to develop a module with jasper report?

Anonymous's picture

hi sir... i want to store my

hi sir...
i want to store my jrxml and .jasper files in my running application rather than saving it in other folders.i came to know that we can create a package and store only .jasper files and we can run the application but i am getting file not found exception.
do we have to change it here also?

please tell me the way to store these files in my application itself.initially i stored these in c://jasperreports//
what is the way and what are the changes to be made in jrxmls or the code?
please help it is important and urgent and i dont have any idea about it ..
thanks in advance...

wissemnadia's picture

could you send me links to

could you send me links to download Jasper report 4.5.1, iReport 4.5.1 please ?

Prajul P T's picture

Hi, You can download the

Hi,

You can download the iReport 4.5.1 from here . There is no need to download jasper_report4.5.1.jar file. You can find it inside iReport4.5.1 itself. 

  • Extract iReport-4.5.1.tar.gz
  • Go to iReport-4.5.1(Extracted folder) folder -> ireport -> modules -> ext
  • You can find jasperreports-4.5.1.jar file inside.

    If you are using OpenERP jasper_reports module, to update jasperreports-4.5.1.jar and other lib files to latest for iReport_4.5.1, 

  • Open a new terminal window
  • Go to location jasper_reports -> jave -> lib
  • type ./update-jasper-reports.sh <path to iReport 4.5.1 directory>

This will update all the libraries in jasper_reports module to the latest.

Hemang Thanki's picture

Can I use any other formula?

Can I use any other formula? e.g. =BDP(AB21,"PX_CLOSE")

Lipin P's picture

Porting of OpenERP Proxy API to Drupal 7

 I met my success in porting the Drupal 6 module, OpenERP Proxy API  to Drupal 7 (D7). Now it is working with OpenERP 5 and OpenERP 6. I faced many complications to make the data communication between Drupal and OpenERP. Even though we can have  specific methods to  tranfer projects, leads  anything like these from OpenERP or from Drupal and make both to communicate each other, I wished if I had a specific API module in Drupal 6 my task will be easier. Later, I found this module will do the nice. Thanks to BoogieBug  who developped the Drupal6 version

tharsoe's picture

Hi Lipin P, I'm very new to

Hi Lipin P,

I'm very new to openerp and a little experience for drupal. I would like to request you to share a very (very) small module link with openerp and drupal. because I don't know how to do it? Thank you.

Manuel Moura's picture

Hi. Is it possible to share

Hi.
Is it possible to share your D7 version of the OpenERP Proxi API?
I´m trying to install the API module in D6 with OpenERP 6.0 and I get a lot of errors...
Thanks.
MMoura

Tazi's picture

Hey I'm interested in using

Hey
I'm interested in using the OpenERP Proxy API in a project of mine and i want to know if its possible to use Drupal7 as an OpenERP client instead of the default web client

Thanks

Vinod_Kumar's picture

How to restrict multiple logins of a user in OpenERP?

Hi all recently I was assigned the task of restricting multiple logins of a single user in OpenERP. Since I'm a newbie to OpenERP, I searched the web for some kick-start articles but for vain. That is why I'm summarizing my points in this, my first ever, blog.

Tomas Del Bianco's picture

Hi! Great tutorial, I wonder

Hi! Great tutorial, I wonder if it is possible to do this in openerp 7. Thank you!

Anonymous's picture

Thank you very much, it's

Thank you very much, it's very good for me

Mei Mcgonigle's picture

wonderful submit, very

wonderful submit, very informative. I ponder why the opposite specialists of this sector don't notice this. You should continue your writing. I'm confident, you have a huge readers' base already!

Jean Johnson's picture

well written Vinod. A good

well written Vinod. A good feature indeed..

Vinod_Kumar's picture

Thanks Jean.

Thanks Jean.

suraj's picture

Hi vinod i read ur blog u

Hi vinod

i read ur blog u have explained beautyfully........

i have followed steps exactly what u have explained
but i am not able achive the expected result

can u help me out plz

Vishnu Devaraj's picture

ERP for Manufacturing Companies

    In today's aggressive business environment it is essential to be prepared to face a vast and competitive world. Like any other industry manufacturing companies also are facing so much competition. To withstand  the competition, organization must have a proper system and software that supports whole system with integrity. Enterprise Resource Planning is one of the ways to improve and streamline the system.

Runny Taylor's picture

appreciate the writing.. do

appreciate the writing..
do you have any more details about a comparison of OpenERP with others?

Vishnu Devaraj's picture

Runny, i have gone through a

Runny, i have gone through a paper which has a made pretty good effort in comparing open source ERPs. Eventhough, the papaer work is an old one, it worths a read.. http://www.big.tuwien.ac.at/system/theses/20/papers.pdf?1298476232 Here Open ERP is termed as Tiny ERP, which was the old name of the same. The product has been improved so far within these years. The paper will guide you in evaluating an ERP.

Shelton's picture

OpenERP OpenOffice Report Designer

The Openoffice Report Designer is a plugin used to create reports for OpenERP. It is an easy to install and use plugin. The main advantage of this plugin is that anyone can easily create and modify reports for OpenERP.

Installation Procedure

Install using Extension Manager in Openoffice.org Writer

pfe2013's picture

Hi I have a problem about

Hi
I have a problem about editing OpenERP report in OpenOffice:
Window add a field is empty.

nizam2404's picture

Hi, I have 2 problem about

Hi,

I have 2 problem about editing OpenERP report in OpenOffice:

1) i can't Add a loop - after i select Objects to loop on, i can click Ok button but nothing happen (the dialog box still open and not closed after click Ok button)

2) i can't Add a field - no Variable appear in drop down list.

Hope u can help me about this matter. TQ

Anthony's picture

Hi Nizam, Well i'm having a

Hi Nizam,
Well i'm having a bad time because of the same problem as yours.
Did you figure out how to solve this problem?
Contacted openErp for this, they don't seem to care :(
Please advise.

Thanks

Anthony

Anonymous's picture

Firstly add a loop,then try

Firstly add a loop,then try to add field.

Anonymous's picture

Hi Have you tried to switch

Hi

Have you tried to switch over to Fields.
Button: Conversion Brackets -> Fields in Openoffice