Hello,

I let you know that OOOR, the Ruby / OpenERP connector 1.2.7 has been released on Gemcutter: http://rubygems.org/gems/ooor
to update/install on Ubuntu/Debian:
sudo gem install ooor

Let me recall that OOOR is useful for:

- OpenERP admin scripts/production debugging
- migrations (multi-instances) http://wiki.github.com/rvalyi/ooor/howt ... -migration
- testing (OERPScenario/Cucumber / Rspec) https://launchpad.net/oerpscenario
- Rails apps using OpenERP seamlessly in the backend
- connectivity/initial data loading with the Kettle ETL (http://github.com/rvalyi/terminatooor ; still for hackers because lack of doc currently)
- UML reverse engineering of OpenERP modules http://www.openobject.com/forum/topic14951.html
- illuminate your life forever making you discover what a user friendly client side API means...

see OOOR introduction here eventually:
http://www.akretion.com/en/blog/2010/01 ... hild-play/


new features in OOOR 1.2.7:

- easy API for ir_model data OpenERP absolute_id:
find by ir_model_data (XML/CSV) OpenERP id:
ProductProduct.find('product.product_product_0');
create an absolute id 'p1' in module 'product' along with the resource:
ProductProduct.create(:name=>'p1', :categ_id=>1,
:ir_model_data_id=>['product', 'p1'])
Also documented on project page http://github.com/rvalyi/ooor

- added optional reload option in update and create methods that, if set to false will avoid doing a read round trip after the update/create, thus speeding up. This is especially appreciable in the Kettle ETL if you create/update lot's of resources.

bugfix in OOOR 1.2.7:

- strict exception handling when OpenERP blows out, always raise a RuntimeError "OpenERP server error" (thanks to Joël Grandguillaume from CampToCamp for the report).

- defensive checks against wrong OpenERP RPC calls that was making debugging harder, type! or allowed! calls are now caught early (thanks to Olivier Dony from OpenERP SA for insisting on that one).

- empty one2many / many2many OpenERP relations now always return [] rather than false, so you can always iterate safely on them (thanks to Fabien Lydoire from Taktik for the report).

- no more destroy error even if OpenERP get capricious and suddenly refuse to deal with a single Integer param (thanks to Fabien Lydoire from Taktik for the report).


as usual, OOOR 1.2.7 has been tested against the OERPScenario test suite and does not contain any obvious regression. I also remember that 1.2.6 was a bugfix release with no new feature.


ROAD-MAP:

- enforce the ActiveModel Rails3 interface for easier Rails integration
- Kettle AgileBI prototype; see http://wiki.pentaho.com/display/AGILEBI ... o+Agile+BI
- syntax highlighting in TerminatOOOR Kettle plugin (using Java-Mateview as soon as Pentaho upgrade their SWT lib in Kettle 4)
- schema dump and schema diff to easily spot a schema change introduced by a module/migration and highlight the changes in the UML diagram
- may be flagging OpenERP commits that change schema in a Google Wave or similar for easier implementer life.
- possible basic tree / form support of OpenERP view layer
- easy Rack reverse proxy over the OpenERP web-client to enrich it with Rails/JQuery widgets
- possible (yet unlikely) full blown Rails3 webclient if I get funding for that.
- up to 3x faster using JSON and Tryton search_read method if Tiny follows us here.


Hope you enjoy it.

Hello Raphaël,

Nice to hear about OOOR Release. Seems very interesting I will check it soon.

regarding


We are planning to add search_read and search_browse method in orm and change client accordingly.

Regards,
HDA

Looks a very good concept indeed, but sadly I can't install it under Ubuntu Hardy. I suppose that it doesn't run under ruby 1.8.6 / gem 0.9.4 which is the latest standard installation I have access to on this OS. for example does not recognise tumble as a command.

@gegard,

On other Linux distro, just make sure to update your gem command by downloading the latest rubygems here:
http://rubyforge.org/frs/?group_id=126
then usually:
sudo ruby setup.rb
to get it installed
gem --version
should confirm version 1.3.6

No more need for the gem tumble command.

BTW, I apologize, I pushed release 1.2.7 on Gemcutter only a few hours ago an not when announced due to a rubygems mistake as well on y side. Now it's all sorted out.
sudo gem install ooor
to install/update.

Well, it's hard work and I don't have it running yet. I had to relink /usr/bin/ruby and /usr/bin/gem to the latest versions (of both - not sure whether ruby was needed, but gem was).

And now I have downloaded OOOR but hit another error:

But I see that "RDoc comes with Ruby 1.8.2 or later, and is no longer available as a separate project." so there's nothing to download for RDoc.

(Later... ah, but there is ... don't trust the words on Sourceforge on that.)

And in chasing that I found on your page introducing OOOR that your link to OERPScenario is spelled wrong as https://launchpad.net/oerpsenario.

So it's not an easy path to follow. I won't go on ... this is not a Ruby forum. (Later ... but I'm getting there.)

All right, so for @gegard and the other stuck with dino distros, can you try this:

sudo gem install ooor --no-ri --no-rdoc

It's supposed to skip the rdoc thing, does it work for you?

About the spelling mistake, I'm correcting that: basically C2C registered their Launchpad project first with Tiny English mode on. Only recently they got it fixed by Launchpad so all links were broken... Anyway, thanks for the hint, I'm correcting that.