Skip to Content
Menu
This question has been flagged

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



 

Avatar
Discard
Best Answer

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.

Avatar
Discard
Best Answer

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.

Avatar
Discard

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.

Related Posts Replies Views Activity
0
Jan 24
982
2
Nov 24
1097
9
Apr 25
3281
0
May 24
849
0
Sep 23
1158