Rob,

please check the code below to import csv file to create Purchase Order, you can manipulate it to create Sale order s per your requirement:

try:

val=base64.decodestring(obj.file)

inp = cStringIO.StringIO(val)

reader = csv.DictReader(inp, quotechar='"', delimiter=',')

except Exception as e:

raise UserError(_('Invalid File!.\nPlease try using another file.'))

Now reader will contain the data from csv file in form of dictionary...... now use it as per your requirement

purchase_order = {}

po_pool = self.env['purchase.order']

po_line_pool = self.env['purchase.order.line']

ven_pool = self.env['res.partner']

part_pool = self.env['part.number']

product_pool = self.env['product.product']

try:

for row in reader:

vendor = row['Vendor Id'].strip()

po = row['PO Number'].strip()

if po not in purchase_order:

po_obj = po_pool.search([('name', '=ilike', po)])

if not po_obj:

po_data ={}

#create PO

vendor_obj = ven_pool.search([('supplier_code', '=ilike', vendor)], limit=1, order="id desc")

if not vendor:

raise UserError(_('''Vendor Id '%s' does not exist in the system''')%(vendor))

try:

cuttoff_date = datetime.datetime.strptime(row['PO Date'].strip(), "%d-%b-%y")

except ValueError:

raise ValidationError(_('''Date '%s' is not in correct format''')%(row['PO Date'].strip()))

po_data = {

'name': po,

'partner_id': vendor_obj.id,

'partner_ref': vendor_obj.supplier_code,

'cuttoff_date': cuttoff_date

}

po_obj = po_pool.create(po_data)

purchase_order[po] = [po_obj, [], []]

line_data = {}

part_number = row['Part Number']

part_obj = part_pool.search([('name', '=ilike', part_number)], limit=1, order="id desc")

if not part_obj:

raise ValidationError(_('''Part '%s' does not exist in the system''')%(part_number))

product_obj = product_pool.search(['|', ('part_number', '=', part_obj.id), ('alt_pt_no_ids', 'in', part_obj.id)], limit=1, order="id desc")

if not product_obj:

raise ValidationError(_('''No product is tagged to part '%s' ''')%(part_number))

line_data.update({

'part_no': part_obj.id,

'product': product_obj.id,

'price_unit': row['Unit Price'].strip(),

'product_qty': 1,

'product_uom': product_obj.uom_id.id,

})

purchase_order[po][1].append((0, 0, line_data))

purchase_order[po][2].append(part_obj)

for key, order in purchase_order.iteritems():

po = order[0]

lines = order[1]

po.write({

'order_line': lines,

'state': 'done',

})

for pno in order[2]:

lines = po_line_pool.search([('order_id', '=', po.id), ('part_no', '=', pno.id)])

history = []

for line in lines:

history.append((4, line.id))

pno.write({'po_history_ids': history})

except Exception as e:

raise UserError(_('%s'%str(e)))

return True