I am using odoo.sh.

Since Odoo.sh is providing editor(Python and Odoo shell) to run python code.

How can I run an import script using this?

I can import my xls file data and I can use the path as ell

I have tried the following code but didn't work!

Can someone help me with this?

import odoorpc

import xmlrpc

import sys

import csv

FILE_NAME = "src/import_customer_invoice_data.csv"

HOST_NAME = 'myshurl.odoo.com'

PORT_NUMBER = 443

DB_NAME = 'myshdatabase'

USER_NAME = 'admin'

PASSWORD = 'MyPass'

src_odoo = False

try:

    src_odoo = odoorpc.ODOO(HOST_NAME, port=PORT_NUMBER)

    print(src_odoo)

except:

    print("Connection Error : ", sys.exc_info()[0])

if src_odoo:

    try:

        src_odoo.login(DB_NAME, USER_NAME, PASSWORD)

    except:

        print("Login Error")

    else:

        print("Connection Done!! ", src_odoo)