Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

1

Export product image name and it's size

By
Vincent
on 2/24/15, 5:27 AM 1,523 views

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.

Any suggestions are welcome.

Vincent
on 2/24/15, 8:18 AM

@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.

Luke Branch
on 2/24/15, 8:39 AM

https://github.com/camptocamp/openerp-connector-magento-docs

Luke Branch
on 2/24/15, 8:39 AM

How magento connector will help ?

Vincent
on 2/24/15, 9:38 AM

@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

Luke Branch
on 2/24/15, 9:18 PM
0
john5000
On 2/25/15, 4:26 PM

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

AD LIBITOM, michel Guénard
on 2/25/15, 7:26 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 2/24/15, 5:27 AM
Seen: 1523 times
Last updated: 3/16/15, 8:10 AM