Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
4053 Weergaven

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
Annuleer