Hi,
I want to write and retreive values from a certain odoo Spreadsheet via an Automated Action or also scheduled Action.
Is this possible?
Thanks!
Friedrich
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Buchhaltung
- Lager
- PoS
- Projekte
- MRP
Diese Frage wurde gekennzeichnet
1
Antworten
122
Ansichten
Hello Friedrich Sauer,
I Hope You are doing well,
Yes, this is definitely possible! You can read and write values from Odoo Spreadsheets using both Automated Actions and Scheduled Actions.
I Hope You are doing well,
Yes, this is definitely possible! You can read and write values from Odoo Spreadsheets using both Automated Actions and Scheduled Actions.
How it works: Odoo Spreadsheets are stored in the documents.document model with the spreadsheet data stored as JSON in the spreadsheet_data field.
Reading from a Spreadsheet:
# In Automated Action or Scheduled Action (Execute Python Code)
spreadsheet = env['documents.document'].search([('name', '=', 'Your Spreadsheet Name')], limit=1)
if spreadsheet and spreadsheet.spreadsheet_data:
import json
data = json.loads(spreadsheet.spreadsheet_data)
# Now you can access the data
sheets = data.get('sheets', [])
cells = sheets[0].get('cells', {}) if sheets else {}
# Access specific cell: cells.get('A1', {}).get('content')
Writing to a Spreadsheet:
import json
spreadsheet = env['documents.document'].search([('name', '=', 'Your Spreadsheet Name')], limit=1)
if spreadsheet:
data = json.loads(spreadsheet.spreadsheet_data or '{}')
# Modify the data structure
if 'sheets' not in data:
data['sheets'] = [{'cells': {}}]
# Example: Set value in cell A1
data['sheets'][0]['cells']['A1'] = {'content': 'New Value'}
spreadsheet.spreadsheet_data = json.dumps(data)
For Scheduled Actions:
Create a Scheduled Action at Settings → Technical → Automation → Scheduled Actions and use the same Python code in the "Python Code" field.
For Automated Actions:
For Automated Actions:
Create an Automated Action on your desired model and trigger it based on record creation, update, or other conditions.
Note: The spreadsheet JSON structure can be complex. You may need to inspect spreadsheet.spreadsheet_data first to understand the exact structure for your specific spreadsheet.
Hope this information helps you.
Thanks & Regards,
Kunjan Patel
Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!
Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!
Registrieren