Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hello,
I want to export product image data from odoo database, have tried xml rpc script to get the product image name and it's size but
did't get it.
can any one know how to export the product template images name and it's size.
I am fine with bash script or Psql script.
Thanks in advance.
To do it in plain sql you can use:
select name, length(image), length(image_medium), length(image_small)
from product_template
where image is not null
The actual image file name that was imported is not stored unfortunately in case that is what you needed.
"The actual image file name that was imported is not stored unfortunately in case that is what you needed." I fell that This will negatively impact the reuse of these images for any "Odoo" website to be built according to the mark-up principles pushed by Google (which emphasize the need to publish images with a name that make sense for robots
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Any suggestions are welcome.
@Vincent,
I'd recommend looking into the CamptoCamp Odoo / Magento Connector:
https://www.indiegogo.com/projects/odoo-magento-connector-for-odoo-8-by-camptocamp
If I remember right I think either the 7.0 or 8.0 projects may have implemented something along these lines.
https://github.com/camptocamp/openerp-connector-magento-docs
How magento connector will help ?
@Vincent,
I remember there being a discussion about these types of features being integrated into the connector if i'm not mistaken.
Are you trying to export base64 image data, or convert it into it's original uploaded format?
Max's various repositories for product upload and batch image upload may be of help:
https://github.com/maxmumford/odoo-migrate-product-images