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


Prajul P T's picture

Send Mail From Any Button From OpenERP

OpenERP enables user to send and receive emails when an action is done from OpenERP. We can configure emails to be send when a sale is confirmed or invoice is paid etc. But to implements these type of functionality, we need to change the functions that is being called from these button actions.

Prajul P T's picture

OpenERP 7 Integration with USPS using stamp.com

USPS is one of the providers of the shipping services. USPS services are used by majority of the users of OpenERP. USPS can be integrated with the delivery of OpenERP to manage delivery form OpenERP itself.

We have created a module that helps us manage shipping through USPS from OpenERP itself. We have archived it by using the stamp.com API. stamp.com is a vendor of the USPS stamps and it provides ways to ship any kind packages and print stamps/shipment labels for that package. To integrate OpenERP with stamp.com API, we need some basic things. They are:

Hestin Jose's picture

Backup and Restore of complete OpenERP in Linux(Ubuntu)

This is just some simple tips for moving an OpenERP server instance and Database from a Linux server to another Linux physical server. Normally Debain based Ubuntu is recommend to install OpenERP. Hope this will help at least some beginners. Good luck :) This process is normally done using linux commands as mentioned below.

1) On Source Server
.ssh to existing OpenERP server as the user running OpenERP

Anonymous's picture

Kindly guide the same topic

Kindly guide the same topic but with WIndows. Thanks.

Luke's picture

Has anyone tried this with

Has anyone tried this with OpenERP 7 yet? I'd like to move my instance of OpenERP 7 from a webserver over to a server on my LAN.

Anonymous's picture

Good tutorial, i very need

Good tutorial, i very need it, thanks you so much !

Ajeesh Kurian's picture

Quickbooks - OpenERP Integration

This integration module aims at transfer of data saved in quickbooks to OpenERP. The following applications is used for this purpose

          a) Quickbook Web Connecter

          b) PHP DevKit from Consolibyte

jyothi's picture

for quickbook integration

for quickbook integration with openerp,i have connector and the php master,how to get the connection settings for openerp.can you give the detailed steps

Anonymous's picture

I want to buy quickbook

I want to buy quickbook openerp integration module.
Looking forward for your quick feedback

saraswathi's picture

Hi ajeeshkurian's,

Hi ajeeshkurian's,

Where i find this module......

shrikant's picture

Hi ajeeshkurian's, The blog

Hi ajeeshkurian's,

The blog is so helpful, but for other information such as product,sale,purchase,supplier do you have any idea?

Reply me

Timothy's picture

Great blog, thanks for the

Great blog, thanks for the info! Hope to test it out soon. Is there a similar solution for Pastel? (another popular accounting package in South Africa)

ajasin's picture

Joomla an easy-use CMS website for non-technical users

Joomla is a specially designed open source Content Management System for websites. The framework and content publishing system are designed for quickly creating highly interactive multi-language Web sites, online communities, media portals, blogs and eCommerce applications. It can be used to easily manage every aspect of your website, from adding content and images to updating a product catalogue, processing credit card payments or taking online reservations.

Anonymous's picture

Traceback (most recent call

Traceback (most recent call last):
File "/home/eagle/openerp/osv/osv.py", line 121, in wrapper
return f(self, dbname, *args, **kwargs)
File "/home/eagle/openerp/osv/osv.py", line 176, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/eagle/openerp/osv/osv.py", line 164, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/home/eagle/tr_barcode/tr_barcode.py", line 98, in generate_image
hr=self_obj.hr_form)
File "/home/eagle/tr_barcode/tr_barcode.py", line 86, in get_image
qrCode.encode()
File "/home/eagle/tr_barcode/qrtools.py", line 117, in encode
self.data_to_string()
File "/usr/lib/python2.7/subprocess.py", line 679, in __init__
errread, errwrite)
File "/usr/lib/python2.7/subprocess.py", line 1249, in _execute_child
raise child_exception
OSError: [Errno 2] No such file or directory

How to solve this error ?? maybe we must set path an image ??

sahad's picture

I got same error as you

I got same error as you got,Please tell me,How can i solve this

tandarts prijzen's picture

Hi! This is my first comment

Hi! This is my first comment here so I just wanted to give a quick shout out and say I truly enjoy reading your blog posts. Can you suggest any other blogs/websites/forums that deal with the same subjects? Thank you!

tandarts apeldoorn loeff's picture

Hi, this weekend is good in

Hi, this weekend is good in support of me, because this occasion i am reading this great educational post here at my residence.

emna's picture

Hello, I have the following

Hello,
I have the following error when i try to generate a QR barcode:
Traceback (most recent call last):
File "netsvc.pyo", line 489, in dispatch
File "service\web_services.pyo", line 599, in dispatch
File "osv\osv.pyo", line 122, in wrapper
File "osv\osv.pyo", line 176, in execute
File "osv\osv.pyo", line 167, in execute_cr
File "C:\Program Files\OpenERP 6.0\Server\addons\tr_barcode\wizard\tr_barcode_wizard.py", line 78, in create_barcode_record
File "C:\Program Files\OpenERP 6.0\Server\addons\tr_barcode\tr_barcode.py", line 53, in generate_image
File "C:\Program Files\OpenERP 6.0\Server\addons\tr_barcode\tr_barcode.py", line 42, in get_image
File "reportlab\graphics\shapes.pyo", line 780, in asString
File "reportlab\graphics\renderPM.pyo", line 656, in drawToString
File "reportlab\graphics\renderPM.pyo", line 651, in drawToFile
File "reportlab\graphics\renderPM.pyo", line 637, in drawToPMCanvas
File "reportlab\graphics\renderPM.pyo", line 50, in draw
File "reportlab\graphics\renderbase.pyo", line 198, in draw
File "reportlab\graphics\renderPM.pyo", line 93, in initState
File "reportlab\graphics\renderPM.pyo", line 87, in applyState
File "reportlab\graphics\renderPM.pyo", line 368, in setFont
File "reportlab\graphics\renderPM.pyo", line 221, in _setFont
RenderPMError: Can't setFont(Times-Roman) missing the T1 files?
Originally : makeT1Font() argument 2 must be string, not None

can you help me please

regards

Anonymous's picture

hello I have the same error

hello
I have the same error that you ;can you help me if you have to find a solution.

e ziggi günstig's picture

Hi theгe, Ι enjoу

Hi theгe, Ι enjoу reading thгough your artіcle pоst. I liκe to write a little cοmment to suppоrt you.

Yoda's picture

I have installed as described

I have installed as described and can do barcodes all but QR.
When I write a small script using get_codes() QR is not in the list
I am using 10.04.4 LTS
Is this to do with reportlab?

Standard39
Extended39
EAN13
FIM
EAN8
Extended93
USPS_4State
Codabar
MSI
POSTNET
Code11
Standard93
I2of5
Code128

Thanks

Wil's picture

Hi Janeesh, I wanted to

Hi Janeesh,

I wanted to import the tr-barcode zip file and received the following error:

Error !

Can not create the module file: /home/pathofinder/openerp-server-5.0.9/bin/addons/tr_barcode/.bzr/repository/indices.zip !

Any clue on how to solve this?

Thank's for your feedback.

Oswaldo's picture

help pleace .... error

help pleace .... error here

Environment Information :
System : Windows-32bit-SP1,_v.178
OS Name : nt
Operating System Release :
Operating System Version : 32bit
Operating System Architecture : 32bit
Operating System Locale : es_VE.cp1252
Python Version : 2.5.2
OpenERP-Client Version : 6.0.3
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
File "netsvc.pyo", line 489, in dispatch
File "service\web_services.pyo", line 599, in dispatch
File "osv\osv.pyo", line 122, in wrapper
File "osv\osv.pyo", line 176, in execute
File "osv\osv.pyo", line 167, in execute_cr
File "C:\Program Files\OpenERP 6.0\Server\addons\tr_barcode\tr_barcode.py", line 53, in generate_image
File "C:\Program Files\OpenERP 6.0\Server\addons\tr_barcode\tr_barcode.py", line 42, in get_image
File "reportlab\graphics\shapes.pyo", line 780, in asString
File "reportlab\graphics\renderPM.pyo", line 656, in drawToString
File "reportlab\graphics\renderPM.pyo", line 651, in drawToFile
File "reportlab\graphics\renderPM.pyo", line 637, in drawToPMCanvas
File "reportlab\graphics\renderPM.pyo", line 50, in draw
File "reportlab\graphics\renderbase.pyo", line 198, in draw
File "reportlab\graphics\renderPM.pyo", line 93, in initState
File "reportlab\graphics\renderPM.pyo", line 87, in applyState
File "reportlab\graphics\renderPM.pyo", line 368, in setFont
File "reportlab\graphics\renderPM.pyo", line 221, in _setFont
RenderPMError: Can't setFont(Times-Roman) missing the T1 files?
Originally : makeT1Font() argument 2 must be string, not None

in openerp 6.0.3

Vishnu Devaraj's picture

Automated Task E-mails for OpenERP Project Management

    'Automated Task E-mails' is a functionality developed by Zesty Beanz for Automating Task notification emails in OpenERP Project Management. The functionality is achieved as a separate module by extending the project managemnet module in OpenERP.

 

Anonymous's picture

how to send the wishes for

how to send the wishes for birthday via email template ..??

Ann's picture

I was extremely pleased to

I was extremely pleased to uncover this site. I need to to thank you for
your time for this particularly wonderful
read!! I definitely really liked every little bit of it and I have you book marked to check
out new stuff in your site.

Atul's picture

Vishnu, Its quiet informative

Vishnu,

Its quiet informative stuff you have shared with the users.

We have been trying the similar things into the V7 of OE. But facing last mile connectivity problem.

So when someone finish the task, or start the task, or assign the task than the emails should be generated to project manager, to client, etc.

So do you share some idea how to get those thing done?

Or else just than 1 email how to do write action on button to send the email of that object.

Thank you,

muthunaveen's picture

hi vishnu, Your article

hi vishnu, Your article exactly meets my need. Great. Clarify me that this zb_task_emails.zip can be configured for openERP 6.1 version released recently? kindly reply to my mail muthunavaneethakumar@gmail.com

muthunaveen's picture

hey i have downloaded ur

hey i have downloaded ur zb_task_emails.zip and installed in my OpenErp 6.1 stable version through update modules and did the setting, configurations as mentioned in the blog. I have evolution as my default mail setup. It supports SMTP.

But when i create a new task,start task,assign or edit or delete it shows the following error and am unable to proceed.. can u kindly help me in this regard..

Client Traceback (most recent call last):
File "/home1/naveen/Desktop/a/webclient/addons/web/common/http.py", line 180, in dispatch
response["result"] = method(controller, self, **self.params)
File "/home1/naveen/Desktop/a/webclient/addons/web/controllers/main.py", line 1004, in call_button
action = self.call_common(req, model, method, args, domain_id, context_id)
File "/home1/naveen/Desktop/a/webclient/addons/web/controllers/main.py", line 948, in call_common
return self._call_kw(req, model, method, args, {})
File "/home1/naveen/Desktop/a/webclient/addons/web/controllers/main.py", line 962, in _call_kw
return getattr(req.session.model(model), method)(*args, **kwargs)
File "/home1/naveen/Desktop/a/webclient/addons/web/common/openerplib/main.py", line 250, in proxy
args, kw)
File "/home1/naveen/Desktop/a/webclient/addons/web/common/openerplib/main.py", line 117, in proxy
result = self.connector.send(self.service_name, method, *args)
File "/home1/naveen/Desktop/a/webclient/addons/web/common/http.py", line 611, in send
raise fault

Server Traceback (most recent call last):
File "/home1/naveen/Desktop/a/webclient/addons/web/common/http.py", line 592, in send
result = openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/home1/naveen/Desktop/a/server/openerp/netsvc.py", line 360, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/home1/naveen/Desktop/a/server/openerp/service/web_services.py", line 572, in dispatch
res = fn(db, uid, *params)
File "/home1/naveen/Desktop/a/server/openerp/osv/osv.py", line 167, in execute_kw
return self.execute(db, uid, obj, method, *args, **kw or {})
File "/home1/naveen/Desktop/a/server/openerp/osv/osv.py", line 121, in wrapper
return f(self, dbname, *args, **kwargs)
File "/home1/naveen/Desktop/a/server/openerp/osv/osv.py", line 176, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/home1/naveen/Desktop/a/server/openerp/osv/osv.py", line 164, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/home1/naveen/Desktop/a/addons/zb_task_emails/project.py", line 44, in do_open
super(task, self).do_open(cr, uid, ids, args)
File "/home1/naveen/Desktop/a/addons/project_mailgate/project_mailgate.py", line 94, in do_open
res = super(project_tasks, self).do_open(cr, uid, ids, context)
File "/home1/naveen/Desktop/a/addons/project/project.py", line 899, in do_open
self.write(cr, uid, [t.id], data, context=context)
File "/home1/naveen/Desktop/a/addons/zb_task_emails/project.py", line 92, in write
result= super(task, self).write(cr, uid, ids, vals, context)
File "/home1/naveen/Desktop/a/addons/project/project.py", line 1049, in write
result = super(task,self).write(cr, uid, ids, vals, context=context)
File "/home1/naveen/Desktop/a/server/openerp/osv/orm.py", line 3833, in write
self._check_concurrency(cr, ids, context)
File "/home1/naveen/Desktop/a/server/openerp/osv/orm.py", line 3599, in _check_concurrency
if not (context.get(self.CONCURRENCY_CHECK_FIELD) and self._log_access):
AttributeError: 'tuple' object has no attribute 'get'

Anonymous's picture

Same problem here, any idea

Same problem here, any idea how to solve that?
thx

juan's picture

Para solucionar el tema de la

Para solucionar el tema de la concurrencia, hay que pasarle un entero y no una lista al write del padre, verifiquen esto en la linea del project.py

la seguna lina cambia agregando el [0] al ids

def write(self, cr, uid, ids, vals, context=None):
# if type(ids) == type(1):
# ids = [ids]
# print ids,type(ids)
if type(ids) != type([]):
ids = [ids]

if len(ids) <> 1:
return super(task, self).write(cr, uid, ids, vals, context)
else:
# Controlo que el contexto sea un diccionario y no una tupla, esto pasa cuando cambiamos de estado, NO SE POR QUE pero esto lo soluciona.
if type(context) is tuple:
context = context[0]
result = super(task, self).write(cr, uid, ids[0], vals, context)
#cr.commit()

cualit's picture

Hice los cambios que tu

Hice los cambios que tu sugerías pero sin suerte. Los cambios fueron:

if type(context) is tuple:
context = context[0]
result = super(task, self).write(cr, uid, ids[0], vals, context)
#cr.commit()

Te agradezco si me puedes ayudar.
Estoy probando el módulo en OpenERP Version 6.1.1

Terr Vans's picture

This modification makes the

This modification makes the module work in OpenERP 6.1?
You could show the whole implementation?

cualit's picture

I tested your changes in

I tested your changes in OpenERP Version 6.1.1 without any luck, always getting the same error.
Any help is appreciated.

Bista Solutions's picture

Hi, Thank You for the post

Hi,

Thank You for the post you posted regarding YML.But we are facing some issues while running the YML files in Opernerp 6.1.
We expect some results after running the YML files which will tell us the test cases result we provide in YML file.

Can you please explain us in detail how we can use YML to test our code and what output we expect after running YML in Openerp.

Do YML runs for a file or whole module?

Thanks

Timothy's picture

Yes, please help on how to

Yes, please help on how to check the results of the test. I tried running a test that fails but it doesnt show up on the log: http://stackoverflow.com/questions/14458962/how-do-you-run-openerp-yaml-...
I tried adding a test directory parameter but no luck :(

Sinoj Sebastian's picture

Quickbooks synchronization with OpenERP

Quickbooks is one of the leading Accounting application in the Unites States and OpenERP is one of the fastest developing Open Source ERP. An integration or synchronization between these two great applications can be a great mile stone for the users of both applications.
We were successful in synchronizing OpenERP and Quickbooks and would like to summarize our approach and experience. We are expecting that OpenERP is trying to include the Quickbooks integration as part of US localization and will be available with version 6.1.

Anonymous's picture

i have all these things ,but

i have all these things ,but i dont know how to connect all
thease

Anonymous's picture

Hi, I tried to install

Hi,

I tried to install http://marketplace.intuit.com/webconnector/ but got some errors.
Can you tell me the dependencies of the QuickBooks Connector.

Thanks

Gabriel's picture

I'm very interested in this

I'm very interested in this module. Was it ever finished?

Darci's picture

Hi there, I check your new

Hi there, I check your new stuff on a regular basis.

Your story-telling style is witty, keep doing what you're doing!

Errol's picture

Please contact me by email, I

Please contact me by email, I am interested in this Quickbooks accounting solution for OpenERP.

Thanks,

Errol

Andreas Brueckl's picture

Hello, Our company uses

Hello,

Our company uses OpenERP since about one year. Although OpenERP supports accounting we would like to keep quickbooks for that.

So we would like to synchronize all OpenERP Invoices to Quickbooks. Therefore I would like you to ask if you can provide me more information about your OpenERP module.

Regards,
Andreas

kedar's picture

hi im also trying to

hi
im also trying to integrate the quickbook to openerp.but im stuck in importing the items.as items query gives information for stock on hand and on sale order. but i dont no how to integrate this with openerp real and virtual stock.also im putting the quickbook queries to openerp database directly.please help me for integration of quickbook stock to openerp stock

Sam's picture

Hi Sinoj - I'm interested in

Hi Sinoj - I'm interested in your project, I am looking to sync my OERP with Quickbooks for my accountant. Please get in touch via my email if you can assist.

Thanks
Sam

Aaron's picture

Hi Sam & Sinoj, Could one of

Hi Sam & Sinoj,

Could one of you get in touch with me via email? I'm interested in integrating both Quickbooks and OERP as well.

Thank you,
Aaron

fahad's picture

Remote Support for OpenERP on a server without Public IP....

         Most of us will be connected to Internet either through dailup or
  broadband connection provided by service providers or from the LAN network hidden
 from outside world.In both the cases system make use of either dynamic IP provided by the
 service provider which may change each time newly connected or network private ip which
 cannot be used or not visible to outside world.Now question is how can we access such

Ghazi's picture

Hi Fahad Nice trick bro. I am

Hi Fahad

Nice trick bro.
I am interested in this trick (Dyndns) with open erp but in windows.
any help for me.

thanks

fahad's picture

Hi Ghazi,   You can register

Hi Ghazi,

  You can register at dydns.com with your dynamic ip , You can use ipconfig command at the command prompt
 to view your current dynamic ip provided by the service provider.

  Now you can access openerp by using server and web ports along with the hostname registered.
  thinking that this might help you.please update me if there are any issues or incase of any queries.
      

 
 
 

Ghazi's picture

Hi Fahad Thanks for your tip

Hi Fahad

Thanks for your tip , I follow and registered with dyndns.com
and now I can ping my host successfully.
but I tried to access openerp over web browser and GTK client and it doesn't work.
I think that there is something called IP forwarding should be done.
Any help with this step ( my router is linksys )

Thanks and regards
Ghazi

Vivien Brookshire's picture

I like it when individuals

I like it when individuals come together and share ideas. Great blog, keep it up!

fahad's picture

Hi Ghazi,   Please go

Hi Ghazi,

  Please go through this forum which would might help you..
    http://forums.afterdawn.com/thread_view.cfm/223583

 

Thanks

Ghazi's picture

Hi Fahad I am my way reading

Hi Fahad

I am my way reading throught this forum.
can I have your email address to check on together.

Thanks
Ghazi

fahad's picture

  Hi Ghazi,   You can

 

Hi Ghazi,

  You can contact me at fahad@zbeanztech.com

Eric Caudal's picture

Very interesting trick. I

Very interesting trick.

I solved the problem of the dynamic IP throught dyndns.com and a TP Link routeur.
The routeur automatically broadcast IP changes to dyndns and dyndns provides public DNS services for dynamic IP address (for 30 USD/yr).

Works like a charm as well.

fhe's picture

Hello, no-ip.org does the

Hello,
no-ip.org does the same for free and is very easy to set up. The program launches in the background and is available in the systray.

fahad's picture

 Hello Eric           thanks

 Hello Eric

          thanks for the comment and idea......

Vishnu Devaraj's picture

Sending Emails from OpenERP Using the Module 'smtpclient'

    OpenERP has many methods and modules to handle the emailing functionality flexibly. One among them is the module named 'smtpclient'. Once the module is installed the following menus are created .

 

Menus
Administration/Configuration/Sendmail Services
Administration/Configuration/Sendmail Services/SMTP Servers
Administration/Configuration/Sendmail Services/SMTP Servers/Message Queue
Administration/Configuration/Sendmail Services/SMTP Servers/Sent Email History

muthunaveen's picture

did the above things were

did the above things were same for 6.1 also ?
can support me for 6.1 configuration?

With thanks
naveen

Harun Baris Bulut's picture

Hi vishnu, This is a great

Hi vishnu,

This is a great job. Thank you very much for doing this.

I am having problems with the smtpclient on OpenERP V6. We are using it with Google Apps and when we try to send test mail or verification mail, system just freezes. Then we restart the openerp-web service, that is how we can reach to openerp again.

What do you think the problem is ? If it is long to describe can you get in touch with me personally ?

Thanks

Atul Modi's picture

Thanks buddy for you

Thanks buddy for you comprehensive explanation regarding this.

I have done this rather it was set by my people and now all of sudden i have change the password at that place.

How can I get to change the password for that email ID into the system.

Because when we log to OpenERP 6.0 or higher than we go to
Admin>Administrator>Configuration>SendMail Service>noreply@aristatechnologies.com ID was opened.

Now when I tried to change the password it is greyed out.

How can I change the password as an when I change the password for this account or any other accounts which at associated with OpenERP from inside.

note: I am able to do all change into EMAIL Account through my browser at my domain, but not inside the openERP.

Can you send me reply at info@aristatechnologies.com

thank you,

Juliann's picture

Thanks for ones marvelous

Thanks for ones marvelous posting! I certainly enjoyed reading it, you will be a great author.I will make sure to bookmark your
blog and will come back later on. I want to encourage you to ultimately continue your great writing, have
a nice weekend!

tamleminh's picture

Thank vishnu for your

Thank vishnu for your thread.
I am having problems with the smtpclient on OpenERP V6. We are using it with gmail and when I try to verification mail. but open ERP doesn't have wizard 'send verification code' so I can't verify.Can you help me