tag:blogger.com,1999:blog-1057792491050874909.post3142305049715142406..comments2015-10-22T15:32:15.418-07:00Comments on Pentaho: Adding the OpenERP datasource to Pentaho Report Designer 3.9Pieter van der Merwehttp://www.blogger.com/profile/15457672161316722280noreply@blogger.comBlogger45125tag:blogger.com,1999:blog-1057792491050874909.post-84260959249458762182015-10-06T23:43:57.293-07:002015-10-06T23:43:57.293-07:00Hi Pieter,
i downloaded openerp data source edito...Hi Pieter,<br /><br />i downloaded openerp data source editor at here : http://ci.pentaho.org/job/datasource-editor-openerp/<br /><br />but i not appear menu opnenerp data access in Data->Add Data Source->Advanced-><br /><br />what can i do?<br /><br />plz answer me..Anonymoushttps://www.blogger.com/profile/07081357733299896904noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-47520680943021000592014-10-10T00:26:59.924-07:002014-10-10T00:26:59.924-07:00I am using pentaho report for openerp 7.0 but my p...I am using pentaho report for openerp 7.0 but my problem is I can't call the quotations<br />product listing field (add an item) product listing is not working when i call the field it call the entire product list of my Quotation.How can i rectify the same? ajohttps://www.blogger.com/profile/02914887115434224615noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-39407375456026578142014-10-10T00:26:27.818-07:002014-10-10T00:26:27.818-07:00This comment has been removed by the author.ajohttps://www.blogger.com/profile/02914887115434224615noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-10587450288630181822014-01-30T05:22:01.810-08:002014-01-30T05:22:01.810-08:00Good morning.
Initially clarify that my English i...Good morning. <br />Initially clarify that my English is not very good. <br />I want to filter a parameter of Pentaho Report Designer (PRD), shops allowed to show to a user, for this I find the solution is to call the session from the OpenERP to PRD and to filter the parameter by idUser session. How I can do this? Is there some other method?. Thanks in advance.<br /><br />Buenos días.<br />Inicialmente aclarar que mi ingles no es muy bueno.<br />Quiero filtrar un parámetro del Pentaho Report Designer (PRD), para mostrar tiendas permitidas a un usuario, para ello la solución que encuentro, es llamar la sesión desde el OpenERP al PRD y poder filtrar el parámetro por el IdUser de la sesión. ¿Cómo puedo hacer esto? ¿Existe algún otro método?. Gracias de antemano.Anonymoushttps://www.blogger.com/profile/10290482682313204715noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-68316644122019953552013-10-02T15:45:50.541-07:002013-10-02T15:45:50.541-07:00Hello again Peter, I saw which my mistake was, I h...Hello again Peter, I saw which my mistake was, I have done all the steps but no option menu appears, Im using PRD 3.9.1, do you think I should try with PRD 3.9.0??<br /><br />Thanks in advance!!Antonio Hdzhttps://www.blogger.com/profile/13310438000426771814noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-4581020050895281882013-10-02T03:02:52.892-07:002013-10-02T03:02:52.892-07:00Hello, I made one report using report designer, No...Hello, I made one report using report designer, Now when I print the report it will display all the records report not my selected record.. <br /><br />Suppose I select 2 employee from list view and than print report than it will print report for all employee.. Anonymoushttps://www.blogger.com/profile/14593595426852983840noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-59127460189816038352013-10-01T18:46:21.712-07:002013-10-01T18:46:21.712-07:00Hello, great information!!
I have a question, wha...Hello, great information!!<br /><br />I have a question, what do yo refer with "the 'lib' directory of your PRD installation", I have downloaded and extracted my PRD in the 'opt' directory, is this equivalent?Antonio Hdzhttps://www.blogger.com/profile/13310438000426771814noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-27190541801217956042013-09-14T20:48:37.512-07:002013-09-14T20:48:37.512-07:00No idea. You should ask WillowIT hereNo idea. You should ask WillowIT <a href="https://github.com/WillowIT/Pentaho-reports-for-OpenERP/issues" rel="nofollow">here</a>Pieter van der Merwehttps://www.blogger.com/profile/15457672161316722280noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-4095665182116589492013-09-14T04:39:48.676-07:002013-09-14T04:39:48.676-07:00Hi again Pieter
After i integrate Pentaho addons w...Hi again Pieter<br />After i integrate Pentaho addons with openERP i cant find pentaho report on action field on version 7, and for java_server and .gitignore where i should place them ??sasaifhttps://www.blogger.com/profile/05896537663217539877noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-32349299584456450862013-09-13T18:31:43.726-07:002013-09-13T18:31:43.726-07:00This article only describes how to setup PRD to ha...This article only describes how to setup PRD to have an OpenERP datasource.<br /><br />To integrate Pentaho with OpenERP you have to follow the project created by WillowIT <a href="https://github.com/WillowIT/Pentaho-reports-for-OpenERP" rel="nofollow">here</a>.Pieter van der Merwehttps://www.blogger.com/profile/15457672161316722280noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-30301136396184495822013-09-13T06:13:56.172-07:002013-09-13T06:13:56.172-07:00Thank you for Answer Peter
my question is what How...Thank you for Answer Peter<br />my question is what How i add Pentaho reports into level object , i dont have customization on openerp 7.0,how to embedd the Pentaho report created with the Pentaho report designer directly in OpenERP<br />sasaifhttps://www.blogger.com/profile/05896537663217539877noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-61790803667354262042013-09-12T05:19:34.130-07:002013-09-12T05:19:34.130-07:00I've just tested it again with OpenERP 7.0 and...I've just tested it again with OpenERP 7.0 and 6.1 and it works for me.<br /><br />Have you disabled the database list when starting OpenERP for example using the --no-database-list option, or setting it in the config file.<br /><br />Enter the database name manually and see if that works. You can also monitor the OpenERP logs to see if there is any error while trying to connect.Pieter van der Merwehttps://www.blogger.com/profile/15457672161316722280noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-6531517644381674542013-09-12T05:19:01.630-07:002013-09-12T05:19:01.630-07:00I've just tested it again with OpenERP 7.0 and...I've just tested it again with OpenERP 7.0 and 6.1 and it works for me.<br /><br />Have you disabled the database list when starting OpenERP for example using the --no-database-list option, or setting it in the config file.<br /><br />Enter the database name manually and see if that works. You can also monitor the OpenERP logs to see if there is any error while trying to connect.Pieter van der Merwehttps://www.blogger.com/profile/15457672161316722280noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-19260267391706075612013-09-12T04:40:22.832-07:002013-09-12T04:40:22.832-07:00Hi Peter
My problem is after i install PRD , I c...Hi Peter <br /><br />My problem is after i install PRD , I cant not have access to Openerp anymore , when i put localhost:8069 it show me Internal Server Error and when I enter my host, port, username and pass but there is no DB to select from<br />sasaifhttps://www.blogger.com/profile/05896537663217539877noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-84236025702771982822013-09-04T17:06:55.799-07:002013-09-04T17:06:55.799-07:00Hi Peter:
I just downloaded PRD Ver 3.9.1, when t...Hi Peter:<br /><br />I just downloaded PRD Ver 3.9.1, when trying to add OpenERP DataSource (Data->Add Data Source->Advanced->OpenERP Data Access); I enter my host, port, username and pass but there is no DB to select from; I tried my localhost and remote server and also tried the Test button.<br />Thanks a lot!<br />MayteAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-16035851405364683952013-08-07T05:27:24.370-07:002013-08-07T05:27:24.370-07:00I have never needed to do this, so I'm guessin...I have never needed to do this, so I'm guessing.<br /><br />Have you had a look some posts in the <a href="http://wiki.pentaho.com/display/COM/Localizing+a+Pentaho+Report" rel="nofollow">Pentaho wiki</a> or <a href="http://forums.pentaho.com/showthread.php?80210-Proper-i18n-in-Pentaho-(-prpt)-reports" rel="nofollow"> forum</a>?<br />Pieter van der Merwehttps://www.blogger.com/profile/15457672161316722280noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-38949138429832862752013-08-06T19:07:45.873-07:002013-08-06T19:07:45.873-07:00How can i display multi language in Pentaho OpenER...How can i display multi language in Pentaho OpenERP Report (i18n support or not)Vũ Ngọc Đườnghttps://www.blogger.com/profile/12344246599232760031noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-19530661851817872532013-05-12T16:20:58.382-07:002013-05-12T16:20:58.382-07:00The link to the issue: https://github.com/WillowIT...The link to the issue: <a href="https://github.com/WillowIT/Pentaho-reports-for-OpenERP/issues/39" rel="nofollow">https://github.com/WillowIT/Pentaho-reports-for-OpenERP/issues/39 </a>Pieter van der Merwehttps://www.blogger.com/profile/15457672161316722280noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-67401434626591741472013-05-12T15:51:25.098-07:002013-05-12T15:51:25.098-07:00Hi
The best place to get support for the OpenERP ...Hi<br /><br />The best place to get support for the OpenERP module is from WillowIT. I see there is already an open call in their issue tracker describing your issue. Best is to follow up with them. My guess is that the Pentaho module can't connect to your OpenERP server because of a firewall or incorrect settings (servername/port number etc).<br /><br />Kind Regards,<br />PieterPieter van der Merwehttps://www.blogger.com/profile/15457672161316722280noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-33198241764569778872013-05-12T12:31:36.551-07:002013-05-12T12:31:36.551-07:00Hi Pieter
i created an openerp report in Pentaho s...Hi Pieter<br />i created an openerp report in Pentaho successfully, then i added this report into openerp, when i click on the link to view the report it gave me this error:<br /><br />10061<br />No connection could be made because the target machine actively refused it<br /><br />(, error(10061, 'No connection could be made because the target machine actively refused it'), ) <br /><br />can u help me plz?ريالhttps://www.blogger.com/profile/12246709300064325132noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-59445788700559144022013-05-08T00:34:04.803-07:002013-05-08T00:34:04.803-07:00Hi Jenny
I haven't had this issue before. It...Hi Jenny<br /><br />I haven't had this issue before. It may be best to post your question on the Pentaho <a href="http://forums.pentaho.com" rel="nofollow">forum</a> or try IRC irc.freenode.net ##pentaho where you will find community members that may be able to help you.<br /><br />Kind Regards,<br />Pieter<br /><br />Pieter van der Merwehttps://www.blogger.com/profile/15457672161316722280noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-57456822830963575682013-05-06T18:17:09.996-07:002013-05-06T18:17:09.996-07:00Hi Pieter,
I am designing a report in pentaho rep...Hi Pieter,<br /><br />I am designing a report in pentaho report designer that contain chinese simplified words, when i print preview, the chinese words appeared, but when I preview using PDF the chinese words won't come out. It is the problem of the adobe reader or in pentaho? because I already insatlled adobe reader X and installed a chinese font pack for adobe reader X but it still wont come out. Or is there something i should do after installing font pack. And fyi I use Sim sun font for this.<br /><br />Sorry for the bad english Thanks for your helpAnonymoushttps://www.blogger.com/profile/01678625041747243525noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-61368312854594778982013-04-22T05:18:59.174-07:002013-04-22T05:18:59.174-07:00I haven't come across this. Check the log fil...I haven't come across this. Check the log file to confirm that OpenERP is running on the IP address and Port you are trying to connect to.<br /><br />Should be something like: openerp.service.wsgi_server: HTTP service (werkzeug) running on 0.0.0.0:8069.<br /><br />Then as a test you could telnet to the IP address/Port that you want to connect to. For example: telnet xxx.xxx.xxx.xxx 8069. You should be able to connect and get a prompt. If you don't then you'll have to find out how the server was configured. Maybe it isn't running on the network interface and only on the loopback (localhost). Maybe somebody changed the port number.<br /><br />Sorry I couldn't be more helpful, my guess is that it is a server configuration issue as I haven't come across an OpenERP installation that doesn't want to connect.Pieter van der Merwehttps://www.blogger.com/profile/15457672161316722280noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-83047775661102369842013-04-21T17:59:29.210-07:002013-04-21T17:59:29.210-07:00Hi Pieter,
I'm using straight PRD to OpenERP ...Hi Pieter,<br /><br />I'm using straight PRD to OpenERP Connection. Host in OpenERP Data Access had already used client's IP address and Firewall had already turned off too, but the problem is still occurred.<br /><br />Do you have any other solution?<br /><br />Thanks,<br />YuliYulianti Leehttps://www.blogger.com/profile/03553832612212957695noreply@blogger.comtag:blogger.com,1999:blog-1057792491050874909.post-86801884642672095222013-04-19T23:21:40.255-07:002013-04-19T23:21:40.255-07:00Hi Yulanti
How are you connecting to the server? ...Hi Yulanti<br /><br />How are you connecting to the server? Are you using the WillowIT OpenERP/Pentaho server or is this a straight PRD to OpenERP connection?<br /><br />Try using the client's IP address in stead of localhost if it is a straight PRD to OpenERP connection. Also check that your client's firewall isn't blocking the connection.<br /><br />If you are using the WillowIT connection then it is best to contact them to find out why it isn't connecting. It will probably be a setup issue.Pieter van der Merwehttps://www.blogger.com/profile/15457672161316722280noreply@blogger.com