Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
4058 Prikazi

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,41.223.145.177,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.

Avatar
Opusti