+ Post New Thread
Results 1 to 9 of 9
Web Development Thread, email form -> database in Coding and Web Development; The recent thread about online surveys/forms reminded me of something I wanted to do in the future, and the techs ...
  1. #1

    Join Date
    Jun 2007
    Posts
    43
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    email form -> database

    The recent thread about online surveys/forms reminded me of something I wanted to do in the future, and the techs here probably have a better idea than me how to go about it.

    For our summer school and saturday school we get about 500 applicants each year. At the moment a paper form is filled out and physically returned to the school, and the data is typed into an Access database manually. What I'd ideally like to do is have applicants fill out a website form to apply initially, and use some sort of software to manage the applications better.

    The simplifed workflow would look something like this:

    -----------------------------------------------------
    Online application form filled out=>

    Emailed to office =>

    data is transferred automatically or semi-automatically to some sort of searchable/editable storage (not necessarily a database).

    Office reply by email or post stating whether the applicant has a place reserved or if they have been placed on the waiting list if all places are taken =>

    Applicants can email office at any time for extra info or to cancel. If cancelling, they are taken of the main list and the next person on the waiting list is contacted =>

    Course starts. Everyone finalises payment within first two days. If not, they're taken off the main list and the next person on the waiting list is contacted =>

    Address and info kept for next year, because current participants are contacted earlier to give them preference, before the email form is made public.
    ------------------------------------------------------

    I did some research into this already, looking mostly at 'event management' software and 'email form to database' software/servers, but didn't find anything particularly useful; no software provided a complete solution - basically the office staff would have to keep jumping between software, importing and exporting data as they went.

    However you might know of other 'types' of software that could help with this task. ie. a free SIM/MIS program? A VLE like moodle?

    The other thing I was thinking might be able to handle the job is Outlook 2002, but I've never been an Outlook user (ie. I've never even had it installed on any system I've owned). If Outlook recieved email forms, does it have enough features to allow it to manage the type of workflow outlined above?

    Thanks for any advice.

  2. #2
    ajbritton's Avatar
    Join Date
    Jul 2005
    Location
    Wandsworth
    Posts
    1,632
    Thank Post
    23
    Thanked 75 Times in 45 Posts
    Rep Power
    34

    Re: email form -> database

    I am also interested in automatic email processing.

    I am receiving backup logs from lots of sites. The subject line is a "" delimited, comma separated list which signifies which site the log has come from and if it indicates a success or otherwise.

    I want to import all these logs into a database automatically and produce a daily report which shows which known sites did not report a success.

    I've fiddled with Access's ability to connect a table to a MAP folder, but have not gotten much further.

    EDIT: Sorry! Did not mean to hijack the thread like that.

  3. #3
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    25

    Re: email form -> database

    Many years ago I was responsible for the very first rollout of Tesco home shopping.

    This is in the days when the web was too slow to be totally online so you applied for a CD online which was then posted to your house for you to complete your orders and transfer them.

    The bit I had to do was the recieving of emails (one for each application) and pulling them together into a single database to be printed onto the CD's and then posted (including walk sorting of post codes etc.)

    The Tesco guys wrote the website so that the information was emailed as a CSV attatchment to me.

    I then used Eudora Light as the email client which I set up to save the attachments to a set location on the network (which it did using sequential numbers). This generated a whole host of the CSV files in the one folder.

    Then once a day I used a DOS batch file to collate them into one CSV file (copy command - 'copy *.csv collated.csv' or something like that) and import them into a database.

    As you can probably tell this was about 12 years ago and is probably not totally relevant now, but thought that there might be something of use somewhere in this tale.

    If it was me, I would have a database on the website where the information is put by the form so it can be recalled by the user and ammended much easier.

    Then it is just a question of keeping that database and your local one synchronised.

  4. #4


    tom_newton's Avatar
    Join Date
    Sep 2006
    Location
    Leeds
    Posts
    4,485
    Thank Post
    867
    Thanked 854 Times in 675 Posts
    Rep Power
    197

    Re: email form -> database

    [assumption=unix platform]
    If these emails are knocking about on a pop server, you could use fetchmail or some perl pop3 stuff (plenty on CPAN) to download mails off the server. Assuming these mails are in regular format, a couple of regex's later you have raw data. Then use DBI to poke this data into a db. Run this hourly with cron, or more frequently if you're a masochist, and bob's your mother's brother.

  5. #5

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,413
    Thank Post
    642
    Thanked 964 Times in 664 Posts
    Blog Entries
    2
    Rep Power
    327

    Re: email form -> database

    I'd recommend using something like Zoho Creator. No scripting required and it's free

  6. #6

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,812
    Thank Post
    110
    Thanked 585 Times in 506 Posts
    Blog Entries
    1
    Rep Power
    225

    Re: email form -> database

    Also, if your doing this from scratch, I'd be really careful about handling the submitted data. The last thing you want is to be a spam relay, or suffer from XSS or SQL injection attacks.

  7. #7
    mrforgetful's Avatar
    Join Date
    May 2006
    Posts
    1,639
    Thank Post
    7
    Thanked 15 Times in 15 Posts
    Rep Power
    23

    Re: email form -> database

    Microsoft Access 2007 has a lot of automatic email data processing, worth a look if you use it already.

    Make your database, go through a data collection wizard choosing email as the collection method, choose the fields you want to include etc and that's it I think.

    Outlook will autmatically open the received email replies and automatically import the data into your database.

  8. #8

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,399
    Thank Post
    1,516
    Thanked 1,056 Times in 925 Posts
    Rep Power
    303

    Re: email form -> database

    Quote Originally Posted by mrforgetful
    Microsoft Access 2007 has a lot of automatic email data processing, worth a look if you use it already.

    Make your database, go through a data collection wizard choosing email as the collection method, choose the fields you want to include etc and that's it I think.

    Outlook will autmatically open the received email replies and automatically import the data into your database.
    ooooh thanks thats worth looking into for some projects at work.

  9. #9

    Join Date
    Jun 2007
    Posts
    43
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: email form -> database

    That sounds fantastic, exactly what i need, but unfortunately the budget I have (above webhosting costs) for the website and associated services is 0 euros.

    Zoho Creator also looks good; with web applications like that, in twenty years no-one will be running software on their PC! However, exporting the remote database and incrementing the local one would have to be done manually everyday, and email management would need to be handled manually too.

SHARE:
+ Post New Thread

Similar Threads

  1. ASP online form.
    By Scotmk in forum Coding
    Replies: 1
    Last Post: 20th September 2007, 04:26 PM
  2. Retrieving database from email
    By iatkinson in forum Windows
    Replies: 6
    Last Post: 15th August 2007, 08:43 AM
  3. Web form
    By Halfmad in forum Web Development
    Replies: 12
    Last Post: 2nd May 2007, 12:16 PM
  4. Replies: 4
    Last Post: 28th February 2007, 09:37 AM
  5. Form with Auto Response
    By faza in forum Scripts
    Replies: 6
    Last Post: 10th January 2006, 03:41 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •