Read csv file into Odoo sh

26 May 2023

odoo SH sh

Hello All,

I have Odoo sh and a created a custom module.

In this module, I want to read in a CSV file from my local machine into a Dataframe:

df = pd.read_csv('path\test.csv', delimiter=';', encoding='utf-8')

When having Odoo running locally it works, but can someone tell me how to achieve this using Odoo sh?

Thanks!

Kind regards,

Nick

26 May 2023

Best Answer

Thank you.

I have created the module, but the data is dynamic and it updates every hour.

I need to be able to load in the data automatically.

26 May 2023

Best Answer

Create a Python module (e.g., my_module) in your Odoo add-ons folder.
Inside the module, create a Python file (e.g., models.py) and define a model to store the data from the CSV file. For example:
from odoo import models, fields
classMyModel(models.Model):
1. _name = 'my_module.my_model'
2. name = fields.Char(string='Name')
3. email = fields.Char(string='Email') # Add more fields as needed
Create a CSV file (e.g., data.csv) with the corresponding headers and data you want to import. Place it in the module's folder.
In the same Python file (models.py), add a method to read the CSV file and create records in the model. For example:

import csv from odoo import models, api

classMyModel(models.Model): # ...

@api.modeldefimport_data_from_csv(self):

with open('my_module/data.csv', 'r') as file:

csv_data = csv.DictReader(file)

for row in csv_data:

self.create({ 'name': row['Name'], 'email': row['Email'], # Set values for other fields })

Help