IBAN accounts upper case

Sometimes I do not understand

IBAN is a public specification requiring capital letters and OpenERP does exactly the contrary and it's classified as a wish. ???

http://www.daniweb.com/forums/thread238464.html

IMHO we also should store IBAN formatted as done in the last lines of the attached code and ONLY remove blanks for EDI.

It is impossible to proof read a 22 digit string without formatting.

Hello Ferdinand,

I have gone through your post and also the article about the International Bank Account Number on wikipedia link you sent.
In order to maintain the integrity of the IBAN they have talked about the algorithm to calculate and validate the checksum.

Example:
                IBAN: GB82 WEST 1234 5698 7654 32
                Rearrange: W E S T12345698765432 G B82
                Modulus: 3214282912345698765432161182 mod 97 = 1

I have replaced each letter in the string with two digits, thereby expanding the string, where A=10, B=11, ..., Z=35.
The attachment contains the changes for the validation of the IBAN in accordance with the algorithm.

Please apply the changes and advice us.

Thank you.

I am almost sure that this patch will NOT return capital letters as required by the specs.

Hello Ferdinand,

I need to clarify as you have talked about:

Replace the letters in the string with digits, expanding the string as necessary, such that A=10, B=11 and Z=35. Each alphabetic character is therefore replaced by 2 digits.

This is what has been stated over here also: http://en.wikipedia.org/wiki/International_Bank_Account_Number

So when we enter the IBAN number:
Behaviour 1:
                    IBAN(entered): GB82 WEST 1234 5698 7654 32
                    IBAN(saved): 3214282912345698765432161182 mod 97 = 1
Behaviour 2:
                    IBAN(entered): gb82 west 1234 5698 7654 32
                    IBAN(saved): GB82 WEST 1234 5698 7654 32

Do you want the IBAN to be replaced by the numbers respectively starting from A=10, B=11, ..., Z=35?
Or you want the lower case letters to be converted into uppercase?

Can you please specify with an example, what should be the actual behaviour?

Thank you for guiding us.

if it is necessary/simple to calculate the checksum I am fine to convert
letters to lower case, but the user must see upper case and it must also be
stored in upper case.

Behaviour 2 is correct,
but the user will not enter the blanks - expanding should be done by the
system

what to do is remove existing blanks and regroup using the code in the link

but we have to notify the "payment" code because it needs to remove the blanks
before sending the account to the bank

well i just want to emphasize that it must be possible to enter the iban code with or without blanks ....
then calculate the checksum
then store store IBAN in uppercase and grouped

the paymodule must remove the blanks for EDI

the only thing to change is to put all letters in uppercase.

One should consider things mentioned on bug 635682.
Thanks.

Resetting importance to Low to keep it in the radar for rc2

Hello Ferdinand,

We have applied your patch in Addons3 branch. Revision ID: mra@mra-laptop-20101123044448-uxcvkfqibbec96xl
and revno: 4688

Thank you for contribution,
rha