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
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
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
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)
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.
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 ??
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!
Hi, this weekend is good in support of me, because this occasion i am reading this great educational post here at my residence.
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
hello
I have the same error that you ;can you help me if you have to find a solution.
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.
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
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.
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
same error found.
i'm using openerp 6.1
OS windows 7
here's error
Environment Information :
System : Windows-post2008Server-6.1.7600
OS Name : nt
Operating System Release : post2008Server
Operating System Version : 6.1.7600
Operating System Architecture : 32bit
Operating System Locale : en_US.cp1252
Python Version : 2.6.5
OpenERP-Client Version : 6.1.1
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
File "C:\Program Files\OpenERP 6.1-20121208-001656\Server\server\.\openerp\service\netrpc_server.py", line 64, in run
File "C:\Program Files\OpenERP 6.1-20121208-001656\Server\server\.\openerp\netsvc.py", line 360, in dispatch_rpc
File "C:\Program Files\OpenERP 6.1-20121208-001656\Server\server\.\openerp\service\web_services.py", line 586, in dispatch
File "C:\Program Files\OpenERP 6.1-20121208-001656\Server\server\.\openerp\osv\osv.py", line 121, in wrapper
File "C:\Program Files\OpenERP 6.1-20121208-001656\Server\server\.\openerp\osv\osv.py", line 176, in execute
File "C:\Program Files\OpenERP 6.1-20121208-001656\Server\server\.\openerp\osv\osv.py", line 164, in execute_cr
File "C:\Program Files\OpenERP 6.1-20121208-001656\Server\server\openerp\addons\tr_barcode.zip\tr_barcode\wizard\tr_barcode_wizard.py", line 98, in create_barcode_record
File "C:\Program Files\OpenERP 6.1-20121208-001656\Server\server\openerp\addons\tr_barcode.zip\tr_barcode\tr_barcode.py", line 73, in generate_image
File "C:\Program Files\OpenERP 6.1-20121208-001656\Server\server\openerp\addons\tr_barcode.zip\tr_barcode\tr_barcode.py", line 62, 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
'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.
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,
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
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'
Same problem here, any idea how to solve that?
thx
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()
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
This modification makes the module work in OpenERP 6.1?
You could show the whole implementation?
I tested your changes in OpenERP Version 6.1.1 without any luck, always getting the same error.
Any help is appreciated.
I configured the 2 models as indicated by the post. So far so good.
The problem is that when I try to save or start a task, I get the following error:
* File "/ mnt / data / openerp / server / bin / addons / zb_task_emails.zip / zb_task_emails / project.py", line 85, in pm = tasks.project_id.user_id.id write AttributeError: 'NoneType' object has no attribute 'id'
Could you help me?
Thanks in advance,
Hey great module, thanks man. I was wondering I can't seem to get the URL at the bottom of the email sent to change to the ip address of the server instead of saying localhost. Have you got any ideas?
What is Yaml?
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
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 :(
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.
Please contact me by email, I am interested in this Quickbooks accounting solution for OpenERP.
Thanks,
Errol
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
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
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
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
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
Hi Fahad
Nice trick bro.
I am interested in this trick (Dyndns) with open erp but in windows.
any help for me.
thanks
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.
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
Hi Ghazi,
Please go through this forum which would might help you..
http://forums.afterdawn.com/thread_view.cfm/223583
Thanks
Hi Fahad
I am my way reading throught this forum.
can I have your email address to check on together.
Thanks
Ghazi
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.
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.
Hello Eric
thanks for the comment and idea......
Hi Fahad,
i have an another situation. At the moment im using a Linksys Router with cisco software. But my iSP does not provide me a public ip. Everything what i take is one local ip from iso dhcp. So my internet ip on router is 10.0.0-- and if i check over google my public ip is something else 82..... I have an dyndns.org account and is registered with my linksys router. But everything what is broadcated over dyndns is my local ip and im not able to ping my router.
Does exist any solution for my problem?
many thanks in advance
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
Here, consumers can come by the currency in the index of ?80-?1500 in the service of the epoch of 14-31 days. It means borrowers be struck by to payback the funds close to next payday. Attracted by rebuke and http://newpaydayloanstop.co.uk If you have internet family and PC, it is so easy for you to avail such advance at any time. Pro checking out lend quotes, you should check from internet. Away getting
did the above things were same for 6.1 also ?
can support me for 6.1 configuration?
With thanks
naveen
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
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,
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
Most of the industries or companies process their bulk purchases through the issuing of a "Tender". A single tender may contain variety of products from different domains. These separate products can be called 'tender lines' - Technically. So instead of bidding the whole tender, different prospects will bid different products(tender lines) according to their capacity and volume.
Hello, Mr. Anoop. I'm Duong from Vietnam, Can you share me module Purchase Tender, thank you
nice info though I could search it in Internet. But it is incredible that this was successfully implemented. It will give confidence to existing SAP users to connect to OpenERP (which is really a fantastic open source ERP) and save the additional license costs for their enhancement requirements..!!
Long article - Worth spending time !!
by David Maister 2006
I was helping a prominent global company explore the strategy of achieving high levels of client service. We were discussing ways of investing resources and redesigning processes to accomplish this goal. The longer the discussion continued, the more uncomfortable some members of the organization became.
Nice article. Two thumbs up :D
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.
Good tutorial, i very need
Good tutorial, i very need it, thanks you so much !