Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie

Hello odoo community,


I'm currently testing the spreadsheet addon but i have a problem.

I can export my spreadsheet into a JSON file, but i don't find any options to import it into a spreadsheet. Is it possible to do this, and if so where can I do that ?


Thank you



 

Awatar
Odrzuć
Najlepsza odpowiedź

Hello, 

I test this way of doing.

I found that (v17) we have to remove de json extension of the file we want to import.

The mime type will be text/plain after the opération but it runs.

I found also that you can not import a file without replacing a file that exist, neither duplicate an attachement. You have to create a virgin file, and replace the file by the one you to import.

Awatar
Odrzuć
Najlepsza odpowiedź

Yes but its not very user friendly to get to.

spreadsheets are basically an attachment in Odoo. (model ir_attachment)

If you enable developer mode and go to settings > Technical > Data Structure > Attachments

You will see all your attachments. If you recently create a spreadsheet it will be at the top of the list.

Look for the name of the spreadsheet and open the attachment.

It will have a File Content field (datas field name in database) with the json file for the spreadsheet. 

I downloaded the file , modified it , cleared the one on the File Content field and reuploaded it.

Awatar
Odrzuć

Hello Bertus.
I've just tried this way of uploading the json file, but it's not converting it into a spreadsheet.
When I go to documents, there is no new spreadsheet
Also, what I see different to the other spreadsheets is the Resource Model and Resource ID.
When I try to do what you say, the Model and ID are left blank, whereas in the other spreadsheet the Model is document.document and the ID is a number, but I cannot modify it.
What is the solution for this?

I created the spreadsheet in the UI first and then modified the json attachment it was linked to in the ir_attachement model.

Powiązane posty Odpowiedzi Widoki Czynność
0
sty 24
1281
2
lis 24
1371
9
kwi 25
3737
0
maj 24
1212
0
wrz 23
1346