version 0.9.6 of the OpenERP / Magento connector is out! Added category export button!
Raphael Valyi
I'm very pleased to announce you that the version 0.9.6 of our
OpenERP / Magento has been released. If you have both version 0.9.6 of
the Magento extension and the OpenERP module, then you can export/
update the product categories tree from OpenERP to Magento.
In version 0.9.5, you had to first manually set up the corresponding
magento_id of each exportable OpenERP product category, just like for
the taxes. This is no more required for the product categories. We
could also to a similar enhancement for the tax export, but our stance
is that this is somewhat low priority since tax category creation does
not occur so often so an initial manual setp up here is perfectly
acceptable.
Any way, our next wanted features are:
1) "use native Magento ACL based security for the PHP webservices"
http://code.google.com/p/magento-openerp-smile-synchro/issues/detail?id=6
2) "Product Image synchronization"
http://code.google.com/p/magento-openerp-smile-synchro/issues/detail?id=1
which would actually be a great consequence of 1) because Magento has
a prorduct image import HTTP API (
http://www.magentocommerce.com/wiki/doc/webservices-api/api#product_images_api
) available once we use the native Magento webservices.
3) To some point, we would also like to have product properties or
variants - call them how you want - export from OpenERP to Mangento.
The first step would be to properly use the current Magento system
from OpenERP. Still, as discussed here
http://groups.google.com/group/magento-openerp/browse_thread/thread/a00b7ca42a281849
, that's not very clear to us yet how this would be better done, given
that OpenERP can implement product options in several ways
(attributes, variants, same tables, extra columns...). Any feedback
would be appreciated.
By the way, at Smile.fr we are now working on an advanced sourcing
OpenERP e-commerce open source module to manage boat importations and
propose different prices according to deliveries dates (e.g. boat) and
also to sell products you don't have currently in stock buy you would
trigger the procurement only once some specific conditions are matched
like you can fill a whole boat container. That module is not designed
to work with Magento especially (our customer is using eZPublish and
the Internethic connector) but we think that would be very reasonable
to update Magento to use our module. So any one interested contact us.
Stay tuned. As always, we appreciate your feedback, your suggestions
and your contributions. Help us to make OpenERP and Magento the open
source stack of choice for serious e-commerce.
Best regards,
Raphaël Valyi.
Smile - Motoristes Internet
Raphael Valyi
Google code hosting forces us to include the version number in the
name of the download. That's a bit against OpenERP modules policies
that states that modules should be a zip with an inner directory
having exactly the same name as the zip.
So, we conformed to the Google requirement since now on as it will
better allow to keep track of the past downloads.
As a consequence, you can now have trouble if you just copy the
download zip into your OpenERP bin/addons directory. Here is the error
you might get:
Mon, 25 Aug 2008 10:51:03 ERROR:init:addon:account_ifrs-1.1-1:eval
file /home/rvalyi/DEV/OpenERP4.2.3/server/bin/addons/
account_ifrs-1.1-1/__terp__.py
Traceback (most recent call last):
File "./tinyerp-server.py", line 178, in <module>
addons.register_classes()
File "/home/rvalyi/DEV/OpenERP4.2.3/server/bin/__init__.py", line
243, in register_classes
File "/home/rvalyi/DEV/OpenERP4.2.3/server/bin/__init__.py", line
142, in create_graph
File "/home/rvalyi/DEV/tinyerp-server-4.2.3-rc1/bin/tools/misc.py",
line 206, in file_open
IOError: File not found : /home/rvalyi/DEV/OpenERP4.2.3/server/bin/
addons/account_ifrs-1.1-1/__terp__.py
So instead, you should:
1) either import the module using the OpenERP back office:
Administration > Module management > Import new module,
2) either unzip the download inside your bin/addons directory, remove
the zip and restart the server or click on Adminsitration > Module
management > Update modules list.
Hope this helps,
Raphaël Valyi.
Charles Galpin
I am working on a demo to use magento and openerp for a local
business, and do believe these are the best tools for the job. I was
very happy to see you guys had started this project to create a bridge
between the two.
I have created an issue for this, but wanted to say hi and felt I
should mention in this thread as well that although the category sync
option has been added to the openerp side, the corresponding code is
missing on the magento side in this 0.9.6 release :)
I have found a few other bugs and this bridge will need significant
enhancements made (which I will be happy to help develop) to support
our needs if we get past the demo stage and win the contract, so I'd
like to join the code.google.com group as soon as I can earn your
confidence and trust. Until then, I'd like some guidance as to how I
can get the latest code, and submit patches for the issues I have run
into (assuming they have not already been fixed).
thanks,
charles
Raphael Valyi
very nice to hear from you feedback. I wasn't aware that the last sync
stuff was not inside the PHP part. Probably it's inside the OpenERP
PHP included module though.
I added you as a project member. That simple code and simple doc, so
basically we trust you you wan't screw it up all without us to notice.
But please wait before my collegue Sylvain (part time working on this
project commit his last changes before commiting real code so it will
just be easier to merge and would probably save you some work as his
commit is code clean up and bugfixes.
We are also making our mind about how to get that product porperties/
variants synchro so we will debate on that later on. I'm currently
busy and won'ts spend too much time on it those days but I tink I can
share our ideas, discuss your poposals and let you improve the
connector. You can also omment the code here (any file, any line):
http://code.google.com/p/magento-openerp-smile-synchro/source/browse/#svn/magento_openerp_smile
(yes Google code have such some great stuff). Just too sad we can't
embbed the flash demo directly in the wiki...
I'll come back wit more stuff tomorrow. Feel free to improve the doc
or make proposals on the wiki, we are going to work it out. Very happy
to see some extra fuel getting into the project.
Raphaël Valyi.
Charles Galpin
On Sep 11, 2008, at 6:43 PM, Raphael Valyi wrote:
>
> Hi Charles,
>
> very nice to hear from you feedback. I wasn't aware that the last sync
> stuff was not inside the PHP part. Probably it's inside the OpenERP
> PHP included module though.
I don't think I have made a mistake on this (although it's always
possible). I checked both the code installed via magento, as well as
the download from google code. In fact if you look at whats there,
you'll see there is no category_sync function there, nor anything else
that looks like it syncs categories.
> I added you as a project member. That simple code and simple doc, so
> basically we trust you you wan't screw it up all without us to notice.
Thanks!
> But please wait before my collegue Sylvain (part time working on this
> project commit his last changes before commiting real code so it will
> just be easier to merge and would probably save you some work as his
> commit is code clean up and bugfixes.
Will do.
> We are also making our mind about how to get that product porperties/
> variants synchro so we will debate on that later on. I'm currently
> busy and won'ts spend too much time on it those days but I tink I can
> share our ideas, discuss your poposals and let you improve the
> connector. You can also omment the code here (any file, any line):
> http://code.google.com/p/magento-openerp-smile-synchro/source/browse/#svn/
> magento_openerp_smile
> (yes Google code have such some great stuff).
Wow, I didn't realize that. Very cool. I'll wait for the latest code
and then that looks like a perfect way to discuss some things.
> Just too sad we can't
> embbed the flash demo directly in the wiki...
But I see there is an issue in their issues tracker (#141) to support
embedding gogole video targeted to be implemented in Q3.
I am ashamed to say I have not seen the flash demos yet! For some
reason they fail on my linux (ubuntu 8.0.4) machine, and I recently
freed up some disk space on my mac by deleting some adobe flex
development stuff and that seems to have broken flash support on it
too :) I guess I should look into that...
> I'll come back wit more stuff tomorrow. Feel free to improve the doc
> or make proposals on the wiki, we are going to work it out. Very happy
> to see some extra fuel getting into the project.
Will do, and I hope we get more interest in this too.
charles
Raphael Valyi
the code has finally been commited and we released the 0.9.7 version.
I didn't get time to fix the SVN path, but I'll do it soon. Still, if
you wan to play with the fresh code, go one, this is the last version
and I promise we will more frequently from now on when making changes.
0.9.7 is supposed to fix several bugs like category synch and multi-
store synch. There have been a lot of code clean up too.
Eager to look after your next suggestions.
Raphaël Valyi.
On 12 sep, 04:38, Charles Galpin <cgal...@lhsw.com> wrote:
> Hi Raphael
>
> On Sep 11, 2008, at 6:43 PM, Raphael Valyi wrote:
>
>
>
> > Hi Charles,
>
> > very nice to hear from you feedback. I wasn't aware that the last sync
> > stuff was not inside the PHP part. Probably it's inside the OpenERP
> > PHP included module though.
>
> I don't think I have made a mistake on this (although it's always
> possible). I checked both the code installed via magento, as well as
> the download from google code. In fact if you look at whats there,
> you'll see there is no category_sync function there, nor anything else
> that looks like it syncs categories.
>
> > I added you as a project member. That simple code and simple doc, so
> > basically we trust you you wan't screw it up all without us to notice.
>
> Thanks!
>
> > But please wait before my collegue Sylvain (part time working on this
> > project commit his last changes before commiting real code so it will
> > just be easier to merge and would probably save you some work as his
> > commit is code clean up and bugfixes.
>
> Will do.
>
> > We are also making our mind about how to get that product porperties/
> > variants synchro so we will debate on that later on. I'm currently
> > busy and won'ts spend too much time on it those days but I tink I can
> > share our ideas, discuss your poposals and let you improve the
> > connector. You can also omment the code here (any file, any line):
Charles Galpin
Thanks for letting me know. Yes, it looks like you guys made a lot of
improvements! I'll give more feedback as soon as I can, but I am
currently having a problem getting the updated to magento web to appy.
I am starting openerp-server with --update=all, but the new api fields
are not showing. If you have any advice on how to get this to take
effect, please let me know.
thanks
charles
Raphaël Valyi
What about uninstalling the module and then installing it again with
the new code. Also, make sure you totally remove any old zip file from
the OpenERP module directory, else it will favor the zip over the
fresh code. Also I'm not too sure about how it will upgrade given that
we now have the version number inside the name of the module (we are
almost forced to do that by the Google code repository). May be you
can also try to clean your addons directory and make a new database.
How is it going?
Raphaël.
Charles Galpin
I finally got it installed by uninstalling and re-installing as you
suggested, thanks. I did notice something that is a problem and
possibly a factor in my problems, and that is magento_openerp_smile/
__terp__.py still had 0.9.5 as the version (as did 0.9.6). I fixed
this but still --update or --init didn't enhance the tables and views.
Also in openerp, it thinks 0.9.6 is the lastes and I am not sure how
that gets updated (I assume you submit it to openerp), and that also
may be why it wasn't updating.
I cannot comment on the versioning in the zip, as I manually copied
the directory to the addons directory.
I can now move forward I think (but need to move onto something else
right now) and will give more feedback once I test it.
Thanks again,
charles
Charles Galpin
on Magento 1.1.4 and then 1.1.5 and it works fine. I have not tested
the other features. I'll post in the 0.9.7 thread I started about the
things I ran into since this thread is about 0.9.6.
charles
On Sep 16, 2008, at 11:36 AM, Raphaël Valyi wrote:
>
> How is it going?