tag:blogger.com,1999:blog-3797105362200918676.post3054964049138185263..comments2024-03-09T08:35:39.901+00:00Comments on OpenERP Management System: OpenERP steps for Pentaho Kettle/PDIDaniel Reishttp://www.blogger.com/profile/04135640072719248565noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-3797105362200918676.post-76495878629666789232013-06-11T09:59:33.188+01:002013-06-11T09:59:33.188+01:00Joaquin: you can find in the latest development bu...Joaquin: you can find in the latest development build, at http://ci.pentaho.com/view/Data%20Integration/job/KettleDaniel Reishttps://www.blogger.com/profile/04135640072719248565noreply@blogger.comtag:blogger.com,1999:blog-3797105362200918676.post-72322092395700697552013-06-10T11:27:25.822+01:002013-06-10T11:27:25.822+01:00As can download these steps. thanksAs can download these steps. thanksAnonymoushttps://www.blogger.com/profile/05603330748542769223noreply@blogger.comtag:blogger.com,1999:blog-3797105362200918676.post-20327333736595306622013-04-24T21:48:04.682+01:002013-04-24T21:48:04.682+01:00I made some little proposals for improvements :
* ...I made some little proposals for improvements :<br />* http://jira.pentaho.com/browse/PDI-9816<br />* http://jira.pentaho.com/browse/PDI-9814<br />* http://jira.pentaho.com/browse/PDI-9813<br /><br />Hope it could helpAnonymoushttps://www.blogger.com/profile/13096251510656502417noreply@blogger.comtag:blogger.com,1999:blog-3797105362200918676.post-30444204041726305082013-04-24T20:46:10.251+01:002013-04-24T20:46:10.251+01:00Hy,
Thanks for your work. I would like to add som...Hy,<br /><br />Thanks for your work. I would like to add some little comments :<br /><br />First, I read carefully the link here : http://wiki.pentaho.com/display/EAI/OpenERP+Object+Output<br />It is written : If no key value fields are specified, all incoming records are treated as new.<br />Unfortunately, if I don't use any key values fields, I have this issue : http://pastebin.com/k29yzgkZ<br /><br />On a second part, if I want to precise a company_id it's not possible. So for multiple_company environment, how will it work?<br /><br />Anonymoushttps://www.blogger.com/profile/13096251510656502417noreply@blogger.comtag:blogger.com,1999:blog-3797105362200918676.post-80244665807133800982013-03-26T10:49:56.061+00:002013-03-26T10:49:56.061+00:00Thank you! I will look into it when I can. Lacki...Thank you! I will look into it when I can. Lacking a way forward with Pentaho I've instead made my own explicit Google Spreadsheet to OpenERP V7 data pump. <br /><br />https://github.com/martinhbramwell/GData_OpenERP_Data_Pump<br /><br />Any comments greatly appreciated.<br />M H J Bramwellhttps://www.blogger.com/profile/10182110983279661111noreply@blogger.comtag:blogger.com,1999:blog-3797105362200918676.post-23711893541899255672013-03-20T21:57:06.518+00:002013-03-20T21:57:06.518+00:00You can implement the following fix to orm.py in V...You can implement the following fix to orm.py in V7 for the plugin to work:<br /><br />--- openerp/osv/orm.py.orig 2013-03-20 22:21:17.892445229 +1100<br />+++ openerp/osv/orm.py 2013-03-20 22:05:12.474594534 +1100<br />@@ -1499,7 +1499,9 @@ class BaseModel(object):<br /> except ValueError:<br /> # in case of overridden id column<br /> dbid = record['.id']<br />- if not self.search(cr, uid, [('id', '=', dbid)], context=context):<br />+ if dbid == 0:<br />+ dbid = False<br />+ elif not self.search(cr, uid, [('id', '=', dbid)], context=context):<br /> log(dict(extras,<br /> type='error',<br /> record=stream.index,<br /><br />I couldn't get the indentation to work in this comment. You can download the same diff file with better indentation from <a href="https://docs.google.com/file/d/0B-ZNv6Ey9MtwMHdkUEp5NWpZVTg/edit?usp=sharing" rel="nofollow">here</a>Pieter van der Merwehttps://www.blogger.com/profile/15457672161316722280noreply@blogger.comtag:blogger.com,1999:blog-3797105362200918676.post-44139987408237170792013-03-14T13:08:09.091+00:002013-03-14T13:08:09.091+00:00It seems to be that the plugin is for OpenERP V6.1...It seems to be that the plugin is for OpenERP V6.1 and earlier.<br />M H J Bramwellhttps://www.blogger.com/profile/10182110983279661111noreply@blogger.comtag:blogger.com,1999:blog-3797105362200918676.post-45609287398632699402013-03-13T16:46:29.243+00:002013-03-13T16:46:29.243+00:00Do you have any idea how I can get past this . . ....Do you have any idea how I can get past this . . . ?<br /><br />Unknown database identifier '0'<br />Row :{}<br /><br />I happens after launching the transformation.<br />M H J Bramwellhttps://www.blogger.com/profile/10182110983279661111noreply@blogger.comtag:blogger.com,1999:blog-3797105362200918676.post-37643940234943422452013-03-13T15:07:04.980+00:002013-03-13T15:07:04.980+00:00@MHJBramwell Thanks for sharing.@MHJBramwell Thanks for sharing.Daniel Reishttps://www.blogger.com/profile/04135640072719248565noreply@blogger.comtag:blogger.com,1999:blog-3797105362200918676.post-17071771478567876282013-03-13T13:56:28.805+00:002013-03-13T13:56:28.805+00:00I also experienced a failure when trying to test t...I also experienced a failure when trying to test the connection OpenERP. I fixed it by copying (not moving) the jar "kettle-openerp-plugin-TRUNK-SNAPSHOT.jar" from the directory "plugins/kettle-openerp-plugin/" to the directory "libext". Apparently the class loader for connections testing doesn't look in the classpath of the corresponding plugin.M H J Bramwellhttps://www.blogger.com/profile/10182110983279661111noreply@blogger.comtag:blogger.com,1999:blog-3797105362200918676.post-90960897306208435422013-03-13T11:46:35.558+00:002013-03-13T11:46:35.558+00:00I have had to alter your procedure considerably in...I have had to alter your procedure considerably in order to achieve the same result with PDI 4.4.0-stable under Ubuntu 12.04 LTS.<br /><br />Like you, I get the latest snapshot from here: http://ci.pentaho.com/view/Data%20Integration/job/Kettle/<br /><br />From it I was able to obtain only the directory "kettle-openerp-plugin" and the jar "xmlrpc-common-3.1.3.jar". The latter was in a directory "lib", rather than "libext", as you indicate.<br /><br />In order to get the others I had to use http://www.findjar.com/. I got:<br />http://mirrors.ibiblio.org/maven2/org/apache/ws/commons/util/ws-commons-util/1.0.2/ws-commons-util-1.0.2.jar<br />http://mirrors.ibiblio.org/maven2/org/apache/xmlrpc/xmlrpc-common/3.1.3/xmlrpc-common-3.1.3.jar<br /><br />With those in place I get as far as defining a connection to my server and specifying a model name. At the moment of exiting the "Model Name" field I am hit with:<br />NoClassDefFoundError: com/debortoliwines/openerp/api/RowCollection<br /><br />It turns out that the corresponding jar is no longer in the directory "kettle-openerp-plugin". I found a jar "/lib/openerp-java-api-1.0.0.jar" and put that in my "libext" directory.<br /><br />With that done I am at last able to attempt to work with plugin without it failing.<br /><br />Unfortunately, I still have not been able to do anything useful, due to a reported error in my data.<br /><br /> Unexpected error<br /> org.pentaho.di.core.exception.KettleException: <br /> Failed to commit batch: <br /> Unknown database identifier '0'<br /> Row :{}<br /><br />I have no idea what that could mean.M H J Bramwellhttps://www.blogger.com/profile/10182110983279661111noreply@blogger.com