This question has been flagged
1 Reply
2480 Views
importorderslines
Avatar
Daniele Morelli

Hello everyone.

I am trying to import a bunch of sale orders and their respective lines from a csv file. I read that the correct way to do so is to make a single csv file containing the fields of both orders and lines. That is:

The first line of the order contains the general data of the order, and the data of the first line. The following lines have empty values for the order data and only has data for the specific line.

The following is the actual structure of my file (except i obscured some data for obvious privacy reasons):

The first row contains the column definitions, columns with IGNORE are columns that i do not want link with an odoo field. And yes there are some custom columns in here (Eser, prot, num etc) which are defined in the respective models:

Eser;Prot;Num;IGNORE;IGNORE;IGNORE;IGNORE;IGNORE;IGNORE;IGNORE;Order Date;Order Lines / Sequence;Order Lines / Product;Order Lines / Description;IGNORE;Order Lines / Colli;Order Lines / Unit of Measure;Order Lines / Quantity;Order Lines / Unit Price;Order Lines / Codice IVA;IGNORE;Order Lines / Lotto;IGNORE;IGNORE;Customer / External ID;Order Lines / Tara Totale
2018;FTES;859;AVIS;0;2145.03;2018-12-05 00:00:00;EUR;1;A;2018-12-05 00:00:00;5;B;BANANE T.T.;SF;96;C;1768.2;0.65;NI41;1768.2;2018045648;CI;1149.33;XXXYYY;1.3;
;;;;;;;;;;2018-12-05 00:00:00;10;RA;RAPE;304;20;C;229;0.3;NI41;229;2018046185;IT;68.7;XXXYYY;0.4;
;;;;;;;;;;2018-12-05 00:00:00;15;CAR;CAROTE;IK10;104;C;1040;0.58;NI41;1040;2018046218;IT;603.2;XXXYYY;0.5;
;;;;;;;;;;2018-12-05 00:00:00;20;CIP;CIPOLLOTTI;305;64;C;241;0.5;NI41;241;2018045891;IT;120.5;XXXYYY;0.5;
;;;;;;;;;;2018-12-05 00:00:00;25;CF;CAVOLFIORI;406;65;C;502;0.15;NI41;502;2018046258;IT;75.3;XXXYYY;0.6;
;;;;;;;;;;2018-12-05 00:00:00;30;RAP;RAPANELLI;M20B;32;C;32;4;NI41;;2018046209;IT;128;XXXYYY;;

The import does not return any error, but instead of one order with six lines, Odoo creates six orders with a single line each.

I remember that i was able to do a correct import months ago, but I can't find what is causing this unexpected result now. Am I doing something wrong?

Thank you for any help...

Avatar
Discard
Avatar
Daniele Morelli
Author Best Answer

For some reasons i understood what the problem is one minute after posting the question. I guess i may refer to this thread for future reference.

The problem was that I replicated some fields of the order model even in the csv lines referring to the lines.

This clearly induced odoo to interpret every line as an individual order.


Avatar
Discard
Yenthe Van Ginneken (Mainframe Monkey)

Happens to me all the time too hehe. Happy you've figured it out and thanks for answering your own question!