FrePPLe 2.2 and OpenERP 7

218 views
Skip to first unread message

Jean-sébastien Bordier

unread,
Nov 17, 2014, 8:54:43 AM11/17/14
to freppl...@googlegroups.com
Hello,

I have installed on a Windows 7 SP1, OpenERP 7 and FrePPLe 2.2.
I have followed all the entire documentation but now i'm blocked at these part :http://<host>:<port>/frepple/xml?database=<db>&language=<language>&company=<yourcompany> in which I put my values.

I have an error, an XML error:
Erreur d'analyse XML : aucun élément trouvé
Numéro de ligne 47, Colonne 1 :


I not an XML Specialist so i'dont know what is the probleme.
The FrePPLe error log is :
Start loading data from odoo at 14:36:17
Error connecting to odoo <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<title>404 Not Found</title>
<h1>Not Found</h1>
<p>The requested URL was not found on the server.  If you entered the URL manually please check your spelling and try again.</p>

Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "C:\Program Files (x86)\frePPLe 2.2.beta\bin\custom\freppledb\odoo\commands.py", line 239, in <module>
    odoo_read(db)
  File "C:\Program Files (x86)\frePPLe 2.2.beta\bin\custom\freppledb\odoo\commands.py", line 82, in odoo_read
    raise e
urllib2.HTTPError: HTTP Error 404: NOT FOUND
Error: Error executing Python command

The OpenERP log is :
2014-11-17 13:49:11,305 3916 ERROR openerp.netsvc: Object Error
Object hr.holidays.public.line doesn't exist
Traceback (most recent call last):
File "C:\Program Files (x86)\OpenERP 7.0-20141110-013841\server\.\openerp\netsvc.py", line 296, in dispatch_rpc
File "C:\Program Files (x86)\OpenERP 7.0-20141110-013841\server\.\openerp\service\web_services.py", line 626, in dispatch
File "C:\Program Files (x86)\OpenERP 7.0-20141110-013841\server\.\openerp\osv\osv.py", line 190, in execute_kw
File "C:\Program Files (x86)\OpenERP 7.0-20141110-013841\server\.\openerp\osv\osv.py", line 132, in wrapper
File "C:\Program Files (x86)\OpenERP 7.0-20141110-013841\server\.\openerp\osv\osv.py", line 199, in execute
File "C:\Program Files (x86)\OpenERP 7.0-20141110-013841\server\.\openerp\osv\osv.py", line 186, in execute_cr
except_osv: ('Object Error', "Object hr.holidays.public.line doesn't exist")
2014-11-17 13:49:11,476 3916 ERROR werkzeug: Error on request:
Traceback (most recent call last):
File "werkzeug\serving.py", line 177, in run_wsgi

File "werkzeug\serving.py", line 167, in execute

File "werkzeug\wsgi.py", line 682, in __next__

File "werkzeug\wrappers.py", line 81, in _iter_encoded

File "C:\Program Files (x86)\OpenERP 7.0-20141110-013841\server\openerp\addons\frepple\controllers\outbound.py", line 75, in run
for i in self.export_boms():
File "C:\Program Files (x86)\OpenERP 7.0-20141110-013841\server\openerp\addons\frepple\controllers\outbound.py", line 453, in export_boms
quoteattr(buf), quoteattr(product['name']), quoteattr(location)
File "xml\sax\saxutils.py", line 66, in quoteattr

File "xml\sax\saxutils.py", line 32, in escape

AttributeError: 'tuple' object has no attribute 'replace'


Thanks for your help.

js

Johan De Taeye

unread,
Nov 17, 2014, 12:35:52 PM11/17/14
to freppl...@googlegroups.com

Jean-sebastien,

 

>>This dependency is supposed to be optional, but apparently it’s not. Which is a bug to be corrected…

 

Just tried it out.  If the module is not installed, the log file contains this error message but the connector just continues.

 

The real error in your case is:

>>File "C:\Program Files (x86)\OpenERP 7.0-20141110-013841\server\openerp\addons\frepple\controllers\outbound.py", line 453, in export_boms

>>    quoteattr(buf), quoteattr(product['name']), quoteattr(location)

 

I just committed a fix for this connector bug: https://github.com/frePPLe/frePPLe/commit/876d48937281b6552b143e9aed70c94a0e52d041

 

Regards,

 

Johan

Johan De Taeye
+32 477.385.362
Skype jdetaeye

Visit us http://frepple.com
Woluwestraat 17, 1930 Zaventem, Belgium

frepple-logo

 

 

From: Johan De Taeye [mailto:jdet...@frepple.com]
Sent: Monday, November 17, 2014 5:53 PM
To: 'freppl...@googlegroups.com'
Subject: RE: FrePPLe 2.2 and OpenERP 7

 

Installing the ‘hr’ module should resolve this.

 

This dependency is supposed to be optional, but apparently it’s not. Which is a bug to be corrected…

 

Johan

 

 

 

Johan De Taeye
+32 477.385.362
Skype jdetaeye

Visit us http://frepple.com
Woluwestraat 17, 1930 Zaventem, Belgium

frepple-logo

--
You received this message because you are subscribed to the Google Groups "frePPLe users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to frepple-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Jean-sébastien Bordier

unread,
Nov 18, 2014, 3:40:56 AM11/18/14
to freppl...@googlegroups.com
Hello Johan,

Thank you for your answer, I have modified the outbound.py and I've checked that the HR module was installed in OpenERP.
I have restarded FrePPLe and OpenERP services.

I have retry the command : http://<host>:<port>/frepple/xml?database=<db>&language=<language>&company=<yourcompany> and this time i have a page with HTML code and with a top bar :"Aucune information de style ne semble associée à ce fichier XML. L'arbre du document est affiché ci-dessous."

In FrePPLe, in revanche, there is always the same problem I think :

File joined FrePPLe_log.txt and OpenERP-server.log

Js



      
FrePPLe_log.txt
openerp-server.log

Johan De Taeye

unread,
Nov 18, 2014, 5:29:47 PM11/18/14
to freppl...@googlegroups.com

Installing the ‘hr’ module should resolve this.

 

This dependency is supposed to be optional, but apparently it’s not. Which is a bug to be corrected…

 

Johan

 

 

 

Johan De Taeye
+32 477.385.362
Skype jdetaeye

Visit us http://frepple.com
Woluwestraat 17, 1930 Zaventem, Belgium

frepple-logo

 

 

 

 

From: freppl...@googlegroups.com [mailto:freppl...@googlegroups.com] On Behalf Of Jean-sébastien Bordier
Sent: Monday, November 17, 2014 2:55 PM
To: freppl...@googlegroups.com
Subject: FrePPLe 2.2 and OpenERP 7

 

Hello,

--

Johan De Taeye

unread,
Nov 18, 2014, 5:29:47 PM11/18/14
to freppl...@googlegroups.com

From the openerp.log:

>>2014-11-18 08:26:43,275 1936 INFO ? werkzeug: 192.9.200.236 - - [18/Nov/2014 08:26:43] "GET //frepple/xml/?company=my_company&language=fr_FR&database=my_company HTTP/1.1" 404 -

 

Looks like an issue with the parameter odoo.url.   There should only be a single slash at the start of the url.

 

 

Johan De Taeye
+32 477.385.362
Skype jdetaeye

Visit us http://frepple.com
Woluwestraat 17, 1930 Zaventem, Belgium

frepple-logo

 

 

--

Jean-sébastien Bordier

unread,
Nov 19, 2014, 2:55:12 AM11/19/14
to freppl...@googlegroups.com
Hello,

HR module is already installed in OpenERP.....

When I try to access in my browser, to this URL http://myopenerpserver:8069/frepple/xml/ it ask me an id and password but any, i have, work

When I try the command line : frepplectl frepple_run --env=odoo_read,odoo_write, i have this error :
Traceback (most recent call last):
  File "frepplectl.py", line 70, in <module>
  File "django\core\management\__init__.pyo", line 365, in execute_from_command_
line
  File "django\core\management\__init__.pyo", line 358, in execute
  File "django\core\management\base.pyo", line 242, in run_from_argv
  File "django\core\management\base.pyo", line 285, in execute
  File "C:\Program Files (x86)\frePPLe 2.2.beta\bin\custom\freppledb\execute\man
agement\commands\frepple_run.py", line 169, in handle
    raise e
Exception: Failed with exit code 1

When I launched the task "create a plan" in FrePPLe menu, I have the error:
Start loading data from odoo at 08:27:32
Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "C:\Program Files (x86)\frePPLe 2.2.beta\bin\custom\freppledb\odoo\commands.py", line 239, in <module>
    odoo_read(db)
  File "C:\Program Files (x86)\frePPLe 2.2.beta\bin\custom\freppledb\odoo\commands.py", line 85, in odoo_read
    frepple.readXMLdata(f.read(), False, False)
frepple.RuntimeException: Error during XML parsing: Can't update a load
Error: Error executing Python command

Js

Johan De Taeye

unread,
Nov 19, 2014, 3:12:41 AM11/19/14
to freppl...@googlegroups.com
>>frepple.RuntimeException: Error during XML parsing: Can't update a load

 

You’ll get this when a routing loads the same workcenter multiple times.

To overcome this you’ll need to get your hands dirty J and update the function export_boms in the file controllers/outbound.py.

In general, you should see the odoo connector we provide as a starting point that gets you 80%-90% of what is needed. The remaining 10%-20% will need to be updated to your to fit your business case and (likely customized) odoo setup.  A 100% out-of-the-box solution is not achievable.

 

Johan

 

Johan De Taeye
+32 477.385.362
Skype jdetaeye

Visit us http://frepple.com
Woluwestraat 17, 1930 Zaventem, Belgium

frepple-logo

 

 

From: freppl...@googlegroups.com [mailto:freppl...@googlegroups.com] On Behalf Of Jean-sébastien Bordier
Sent: Wednesday, November 19, 2014 8:55 AM
To: freppl...@googlegroups.com
Subject: Re: FrePPLe 2.2 and OpenERP 7

 

Hello,

--

Jean-sébastien Bordier

unread,
Nov 19, 2014, 3:44:50 AM11/19/14
to freppl...@googlegroups.com
Hi Johan,

Sorry to bother you again but I think there has been a misunderstanding. I don't want to customise the software but basically make it work. 
So, do I need a developper to install this software?

I would like to know as well if you'll be able to answer my previous enquires if possible :)

I appreciate your assistance and looking forward to hearing from you at your earliest convenience.

JS






Johan De Taeye

unread,
Nov 19, 2014, 4:05:54 AM11/19/14
to freppl...@googlegroups.com

>>Sorry to bother you again but I think there has been a misunderstanding.

>>I don't want to customise the software but basically make it work. 

>>So, do I need a developper to install this software?

 

Different businesses have specific needs: make-to-order / make-to-stock / engineer-to-order environments are very distinct. Material-intensive, labour-intensive and capacity-intensive industries are very distinct. Companies with a few large customers have different processes than companies with lots of small customers.

So, yes, you need a developer to make your ERP system fit the needs.
So, yes, you need a developer to make your planning tool fit the needs.

 

This applies to commercial packages in these domains, and even more so for open source packages.

 

>>I would like to know as well if you'll be able to answer my previous enquires if possible :)

 

I believe I did.

 

Johan De Taeye
+32 477.385.362
Skype jdetaeye

Visit us http://frepple.com
Woluwestraat 17, 1930 Zaventem, Belgium

frepple-logo

 

 

From: freppl...@googlegroups.com [mailto:freppl...@googlegroups.com] On Behalf Of Jean-sébastien Bordier
Sent: Wednesday, November 19, 2014 9:45 AM
To: freppl...@googlegroups.com
Subject: Re: FrePPLe 2.2 and OpenERP 7

 

Hi Johan,

--

Reply all
Reply to author
Forward
0 new messages