Result during upload in banking software:

Error:
Bevat geen bestandsluitrecord (regel:1)

(For security reasons no file attached)

Point it that the file has more lines then 1 and the last line is a '9999' one.

So is there a newline at the end of the file?
It the last line long enough?

Comments

clemens.tolboom’s picture

clemens.tolboom
Primary language Dutch
Location Groningen, 🇳🇱/🇪🇺
commented

Output from creditor.php

..clieop/lib/Samples$ php creditor.php 
0001A220808CLIEOP03PEAR 22011                     
0010B0001234567890001EUR                          
0020APHP: Scripting the web                       
0030B1000000PEAR CLIEOP CLASSES                T  
0100A000000000000690001928373460123456789         
0160ALike we promised, your money                 
0170BDave Mertens                                 
0173BRotterdam                                    
9990A00000000000000690003162941350000001          
9999A                                             
../clieop/lib/Samples$
clemens.tolboom’s picture

clemens.tolboom
Primary language Dutch
Location Groningen, 🇳🇱/🇪🇺
commented

Output from debtor

../clieop/lib/Samples$ php debtor.php 
0001A220808CLIEOP03PEAR 22011                     
0010B1001234567890001EUR                          
0020APHP: Scripting the web                       
0030B1000000PEAR CLIEOP CLASSES                T  
0100A100200000001299501928373460123456789         
0110BDave Mertens                                 
0113BRotterdam                                    
0160AOrdernumber: 8042                            
0160ACustomernumber: 17863                        
9990A00000000000001299503162941350000001          
9999A                                             
../clieop/lib/Samples$
clemens.tolboom’s picture

clemens.tolboom
Primary language Dutch
Location Groningen, 🇳🇱/🇪🇺
commented

So these outputs all have new lines and all lines are equal in length.

gerbrand’s picture

gerbrand commented
Title: Upload to bank fails » Upload to bank fails, error in 0100 transaction line

I've compared the clieop file with one that's generated by some proprietary software.

Find the differences

Clieopatra generates:

0100A100200000000109500012345670139224904         
0110BGerbrand Oudenaarden                         
0160Atest aankoop van 10 euro 95 cent

this drupal module generates:

0100A10020000000059.501392249040123456789         
0110BGerbrand Oudenaarden                         
0113BUtrecht                                      
0160AOrder 43                                     

0100 A 1002  000000001095   0001234567 0139224904   (Clieopatra)

info  type   amount         bank#      bank#  
code         eu 10,95       payer      beneficiary  


0100 A 1002  0000000059.5   0139224904 0123456789    (current module version)
             59,50 euro

Some observations:

  • amount should be formatted in a different way
  • benficiary and payer's account seem to have been switched around

The specs for the 0100 line are as follows:

"Infocode 9 4 0100
Variant code x 1 A
Transaction type 9 4
Amount 9 12
Payer's account number 9 10
Beneficiary's account number x 10
Filler 9"

&
"About the formatting of the amount:
Amount The amount to be transferred in the transaction. This amount is stated in cents
and so there may not be any commas or points. The field of this record must
be preceded by leading zeros. [...]"

(http://www.ingbank.nl/ing/downloadables/eclieop1.pdf)

clemens.tolboom’s picture

clemens.tolboom
Primary language Dutch
Location Groningen, 🇳🇱/🇪🇺
commented
Assigned: Unassigned » clemens.tolboom
Status: Active » Fixed

Amount is now in cents intval( 100* $amount)

Payment source and destination are changed correctly.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.