RBS Bankline import Hail Mary

[Gasman]

Hi all,

Before I try and construct something myself and possibly reinvent the wheel, I thought I ask here in case someone has already created something to do this.

The charity I volunteer for has changed banks to RBS Bankline. Previously we were with Lloyds Banking Group.

LBG for all its faults has a nice feature whereby one can add multiple payments to a virtual list and then authorise them in one foul swoop.

RBS forces you to authorise each payment individually if you enter them manually, as I would do with LBG. However speaking to Bankline support, one can emulate this by importing what they call an Adhoc Bulk Payment List. This obviously has to be in a certain format and they do not supply a template.

The best they can do is supply import specification, which I have attached, just for interest.

Has anyone created an import DB/Template for RBS Bankline at all please.?

I have asked the charity, but do not hold out much hope to be honest.

TIA

 

[arnelgp]

mr.gasman, good for you.
i am sure you can do it.
the file format is only csv and all fields and examples are on the later part of the pdf.
goodluck.

 

[Gasman]

mr.gasman, good for you.
i am sure you can do it.
the file format is only csv and all fields and examples are on the later part of the pdf.
goodluck.

Morning arne,

Yes, I know I can do it,albeit slowly, but do not want to create something only to be told 'If you had asked, I have something that does that'

Hence the hail mary.

I know I will only use a few fields and TBH I am thinking an Excel worksheet would be an easier option unless I want to create a full blown system for payments.

The charity even have their own online Financial Management System, which last time I looked, I did not even consider fit for purpose, so I doubt they would have thought of this.

On the plus side it would be something to keep me occupied.

 

[Gasman]

Thank you Pat,

I spent part of today creating a table to match that spec, despite only probably needing around 6 fields. The first example Domestic Payment is fine for my needs, but you never know what will be changed. Even at the moment, some fields are reserved for future use.

I created a table for payee accounts as well and was well on the way to creating a small simple system to create the import file. Nothing elaborate as it was only for my personal use, to make my life easier.

However I have discovered that head office have not given me the facility for uploading payments, so it was all for nought.:banghead: