BFC Import journal entries with multiple values in variant field

[former_member451232]

Hello,

I would like to import journal entries in BFC (Magnitude / Cartesis) with a field (Variant) which have multiple values.

"D_CA","D_LE","D_DP","D_RU","D_AU","D_CU","D_PE","D_CC","D_VA","D_SC","P_LABEL","D_AC","D_FL","D_T1","D_T2","D_TCURRENCY","D_ANALYSIS1","D_ANALYSIS2","D_LIBRE1","D_ORIACCOUNT","D_DO","D_LIBRE2","D_CUSTOMER","D_PRODUCT","","","P_DEBIT","P_CREDIT"
"ACTUAL", "HIST-IFRS", "2018.08", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""
"", "", "", "0001", "2TOTO16", "EUR", "2018.08", "", "1TOTOB0;ITOTOR0", "", "2018 Opening JE for TOTO", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""
"", "", "", "", "", "", "", "", "", "", "", "A1000", "F02", "", "", "", "", "", "", "", "", "", "", "", "", "", "23532543.620000", ""
"", "", "", "", "", "", "", "", "", "", "", "A2000", "F02", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "11143166.940000"
"", "", "", "", "", "", "", "", "", "", "", "L1000", "F02", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "71703.700000"
"", "", "", "", "", "", "", "", "", "", "", "L2000", "F02", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "12317672.980000"

The field

"1TOTOB0;ITOTOR0"

is rejected

But if we change it manualy after import with one values (instead 2) in the field it's OK.

Is there any way to do it ?

Thank you very much for your help !

[former_member451232 · Accepted solution]

The answer is the character slash.

To use multiple values in a field doing like that :

"1TOTOB0/ITOTOR0"