Guys, how can I import data from CSV file but if for example some lines contains data related to the same "order number"?
Picture below should explain everything.
Same customer, multiple items. I would like to combine it into one single record.
| 143306 | 18-Sep-2015 | 18-Sep-2015 | 250869522623 Full Height Matrox G550 PCI Card F7011-0001G55MDDAP32DB,
260747082667 Matrox G200 MMS Quad Display Graphics Card 4 DVI fp, 261084913104 NVidia NVS285 PCI-E x16 New Shape 128MB Low Profile Card+Dual DVI Splitter Cable | .....
Or maybe every record should contain a table (many2one fields)?
Going that way I added a class:
|class item_list(models.Model): |
_name = 'item.list'
_description = "Item list in record"
nitem_id = fields.Many2one('item_id')
nitem_title = fields.Many2one('item_title')
nquantity = fields.Many2one('quantity')
item_log_id = fields.Many2one('item_list','Product')
|and in main class I added |
|items_list = fields.One2many('item.list','item_log_id', string="Items ordered ⇒")|
Now loading a data from CSV and still got nothing not even one item is added :(
you can use the following format for your csv file to add the data if you are using systems default import functionality.
You don't need to give the order name again in every line, just change the product and quantity in every next line for same orders.:
Order Date,Order Reference,Supplier,Destination,Pricelist,Order Lines / Product,Order Lines / Quantity
2012-12-15,PO00008,ASUSTeK,Stock,Default Purchase Pricelist,ADPT,20
2012-12-15,PO00009,Axelor,Stock,Default Purchase Pricelist,CD,5
Hope this will help you
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 9/21/15, 5:20 AM|
|Seen: 802 times|
|Last updated: 9/22/15, 6:50 AM|