Using Database to Fill in Form

Not for spam, but order fulfilment

[mangotude]

I'm not sure where to post this, but it is database driven, so....

We have a site which captures customers requests on database. We then have to place an order (individually) with another provider using their online form, using the information supplied. There is no way to 'get around' this situation, and so currently each order is entered manually.

for sake of simplicity, let's make it that the information we receive is exactly the same as the information we would be entering on the provider's site.

the form is a fairly straightforward, but multi-part form. is there a way that a program could interact with the form page, filling it out with the relevant sql entry?

any advice, general pointers appreciated.

[Birdman]

When you say multipart form, do you mean multiple pages? Either way, it can be done with some careful programming. Perl would be a good language to do it with.

[mangotude]

Hi

Thanks for the response.

I did mean multiple pages, yes.

However, all the information required is fixed before the form process starts - it's just on different pages for 'user convenience'.

Great to hear it could be doable - there is one other aspect - it goes then to a payment page - would it be possible for that to be automated also? it is always the same options, same procedures.

[Birdman]

Here is a thread that may help get you started:

Simulate Form Post Using Perl [webmasterworld.com]

[mangotude]

great. thank you.