i download product details from openerp. In that csv file i get image in binary format. When i try to upload data again some of the rows showing padding error ( Incorrect padding ). How to s solve this issue?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
1
Beantwoorden
11026
Weergaven
When exporting images directly from PostgreSQL, convert PostgreSQL's bytea format to base64 using the following in the query:
select encode("product_product"."image",'base64') as "image" from "product_product";
Using .decode('base64') in Python will not work because the data first needs to be decoded from PostgreSQL's bytea format.
See also https://www.odoo.com/forum/help-1/question/export-external-id-directly-from-database-67297
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
Aanmelden| Gerelateerde posts | Antwoorden | Weergaven | Activiteit | |
|---|---|---|---|---|
|
1
mrt. 18
|
3556 | ||
|
1
mrt. 16
|
3482 | ||
|
2
mrt. 15
|
10919 | ||
|
|
1
mrt. 15
|
9112 | ||
|
0
feb. 23
|
2424 |
its a base64 decode error. i try to decode binary image value to .decode('base64') it show same error. how to solve this ?