What a well elaborated and presented answer! Thanks.

I have written an addon that does a very similar thing just last week, so I have mostly copy-pasted my code, hoping that OP does not have to go through all the headaches that I had with this.

thanks for elaborating my question. whats bom_file?

i am getting garbage value everytime

here is my xml and python:

<record id="view_pack_operation_lot_form_custom" model="ir.ui.view">

<field name="name">stock.pack.operation.lots.form</field>

<field name="model">stock.pack.operation</field>

<field eval="20" name="priority"/>

<field name="inherit_id" ref="stock.view_pack_operation_lot_form" />

<field name="arch" type="xml">

<xpath expr="//button[@name='save']" position="after">

<form string="Import a csv file">

<!-- <group name="main"> -->

<field name="file" />

<!-- </group>

<footer> -->

<button name="import_csv" type="object"

string="Import" class="oe_highlight"/>

<button special="cancel" string="Cancel"/>

<!-- </footer> -->

</form>

</xpath>

</field>

</record>

python:

def import_csv(self, options):

csv_data = self.file

# TODO: guess encoding with chardet? Or https://github.com/aadsm/jschardet

encoding = options.get('encoding', 'utf-8')

if encoding != 'utf-8':

# csv module expect utf-8, see http://docs.python.org/2/library/csv.html

csv_data = csv_data.decode(encoding).encode('utf-8')

csv_iterator = csv.DictReader(base64.b64decode(self.file).split('\n'))

bom_file was an error, it should have been csv_file.

You have a small mistake in your decoding process: at first you have to decode self.file from base64 into plain text and then decode().encode(). I.e.:

csv_data = base64.b64decode(self.file).decode(encoding).encode('utf-8')

csv_iterator = csv.DictReader(csv_data.split('\n'))

That should hopefully work.

thanks can u guide me how shd i place that value in existing database field model name : "stock.pack.operation.lot" and in addons its "stock_pack_operation".

i dnt know if m doing wrong? m trying to place value in database through file such that it shd display value like clicking on "add item"

example:

http://imgur.com/a/dcj2j

my code is nt placing value in "lot_name" any idea where am wrong?

class stockpackoperartionlot2(models.Model):

_inherit = 'stock.pack.operation.lot'

lot_name = fields.Char('Lot/Serial Number')

class Import2(models.Model):

_name = 'stock.pack.operation'

# _inherit = 'stock.pack.operation'

_inherit = ['stock.pack.operation.lot','stock.pack.operation']

# allow imports to survive for 12h in case user is slow

_transient_max_hours = 12.0

res_model = fields.Char('Model')

file = fields.Binary(string='BOM File', required=True)

file_name = fields.Char('File Name')

file_type = fields.Char('File Type')

@api.multi

def _addfromfile(self,val):

self.lot_name = val

@api.multi

def import_csv(self, options):

""" Returns a CSV-parsed iterator of all empty lines in the file

:throws csv.Error: if an error is detected during CSV parsing

:throws UnicodeDecodeError: if ``options.encoding`` is incorrect

"""

csv_data = self.file

# TODO: guess encoding with chardet? Or https://github.com/aadsm/jschardet

encoding = options.get('encoding', 'utf-8')

if encoding != 'utf-8':

# csv module expect utf-8, see http://docs.python.org/2/library/csv.html

csv_data = csv_data.decode(encoding).encode('utf-8')

# csv_iterator = csv.DictReader(base64.b64decode(self.file).split('\n')) #base64.b64decode(self.file)

csv_data = base64.b64decode(self.file).decode(encoding).encode('utf-8')

# csv_iterator = csv.DictReader(csv_data.split('\n'))

# return base64.b64decode(self.file)

self._addfromfile(csv_data.split('\n')[0])

The Import2 class should be a models.TransientModel and it should not inherit from anything.

What you essentially have to do in the function import_csv(self, options) is to extract the lot_name and either create a new record or modify an existing one.

If you want to create a new record, you can achieve this via:

self.env['stock.pack.operation.lot'].create({

'lot_name': lot_name,

# optionally other parameters, that you want to set if no defaults exist

}

If you want to modify an existing record, you have to somehow pass its id to the wizard, where you would do the following:

self.env['stock.pack.operation.lot'].browse(record_id_that_you_obtained).lot_name = lot_name

Which way do you want to do it?

ok Done thank you very much for this epic help..... !!! plus voted as well