File format: tcode BIC for SWIFT code uploading in BNKA table

[Former Member]

please can anyone help to upload the input file for BIC tcode?

I have given the following fields in the input file and executed for the test run.

BANK NAME|CITY|STREET|BANK KEY|BANK NUM|SWIFT|BRANCH

After execution it is telling "No data in file for selected countries".

Can anyone tell me why is this error encountered? and the correct file format.

Thanks

Edited by: kavita painter on Dec 15, 2009 12:19 PM

[Former Member]

Hi Kavita,

Do you have a sample BIC file? My company didn 't sign with swift yet and I would like to start testing the transaction in our environment.

Thanks,

Danielle

[Former Member]

Hi Kavita, and Danielle

I'm investigating about mass update via BNKA.

Do you have a sample BIC Database Plus file or file format??

Thanks in advance.

Regards,

Mio

[wesley_green]

Hi there,

That is not really an error. If you specify the country(ies) you intend to upload, then the program will only go after those countries from the upload file. However, if you do not specify any countries, the program assumes that you want to load all countries. Therefore, for each country that is not included in your upload file, the system will write the message "No Data for Selected Country." I hope that makes sense and that it helps.

Regards,

Wes Green

[former_member836506]

I think the key should contain the country code as BNKA Table uses the country code to differentiate between the banks. Also, the order of the fields may not be correct.