I'm using v7 and trying to import records that has a many2one field linking with another record in a different table. This is an example of the csv file I wish to import:
amount,name,contract_award_date,contract_nature,contract_value,net_payment,note,payment_reference/id,period_covered,period_covered_end,period_covered_start,instr_number,status,system_print_number,wht_rate 600000,Landed Engineering,2013-07-18,Services,12000000,12000000,,__export__.account_bank_payment_24,Jul-13,,,,Ready,,0.05
This is an example of the record its linked to:
id,account_id/id,alternate_cust_reference,amount,analytic_account_id/id,bank_code,bank_name,branch_name,location,channel_name,collections_account,customer_address,customer_phone_number,cust_reference,deposit_slip_number,depositor_name,ref,fee_name,head_subhead,ip,institution_name,institution_id,is_reversal,item_amount,lead_bank_cbn_code,lead_bank_code,lead_bank_name,move_ids/id,note,othercustomer_info,payment_currency,date,payment_logid,name,payment_status,payment_type,period_covered,period_covered_end,period_covered_start,instr_number,product_group_code,receipt_no,sequence,settlement_date,statement_id/id,state,system_print_number,taxpayer_name,terminal_id,third_party_code,transaction_date,type,val_date __export__.account_bank_payment_33,,--N/A--,15000,,FBN,First Bank of Nigeria Plc,ABAJI,ABAJI,Bank Branc,9393939393,,,100000037,892342,G. Heights,Environmental Health and Safety Compliant Certific (FINES AND FEES-MINISTRY OF ENVIRON.),,402/83,18.104.22.168,Rivers State,RST,FALSE,15000,,,,,,|,566,29/07/2013,10951,FBN|BRH|RST|29-07-2013|006254,,Cash,,,,31,HTTPSERVICE,1321003122,,30/07/2013,,Ready,890647B28D06F8,GLORIOUS HEIGHTS (CORPORATE ENTITY) (HASSAN),,,29/07/2013,,
Following the explanation in the import page, I tried to use the name of the corresponding payment record i.e. FBN|BRH|RST|29-07-2013|006254 as the payment reference/id in my import file but this gives an error. The only format that works without error is __export__.account_bank_payment_24.
So, my question: is it possible to use the name as the link in a many2one import or must I use the export id only? Thanks.
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: 8/20/13, 3:24 PM|
|Seen: 1000 times|
|Last updated: 3/16/15, 8:10 AM|