Webform - redirect to WorldPay AND save data in MySQL/CSV

Hi all,

I am the Online Manager of an international child protection charity based in the UK. Our old online donations system (using CiviCRM and Paypal) has given up the ghost and we want to try something else as we can't upgrade from drupal 5.x for a while and CiviCRM doesn't seem to work well with drupal 5.

We currently use a fundraising CRM system that isn't connected to our website in any way and we'll be looking at integtrating them properly later next year. In the meantime we've got an account with WorldPay and we plan to use that to process our donations.

Until we get a more integrated solution we need a temporary fix as our online donation system is completely broken at the moment.

A temporary solution might be this:

• We create a simple webform that captures people's details (using standard WorldPay variables plus some custom ones of our own - e.g. Gift Aid)
• On submission, the user is then redirected to a (branded) WorldPay page that imports the variables they've already inputted (currency, amount, address etc) and then processes their credit card payment
• but we also want to have our webform data saved in a mysql table or csv file so we can import it into our CRM database once a month.

I'm playing around with our WorldPay sandbox and the html redirects at the moment and that seems relatively straightforward - it's just the capturing of the data before (or after?) it gets submitted to them that's proving difficult.

I've looked into the ubercart and ecommerce modules but they don't seem to integrate easily with Worldpay and we don't need all of their functionality.

Is there a way that I can achieve this in the advanced settings in the Webform module?

Thank you in advance for your help - I'm not much of a developer and this is all quite confusing to me I'm afraid. We're running a tight ship at the moment so we're having to fix the problem internally as much as possible rather than paying a developer to do so.

Ben