Dizkus

I have a PN site set up with Qmail and mySql.

I want to use it to automatically enter data received by email into the appropriate mySQL table. The data being sent is a list, separated by commas with a stride length of three. The table it should be entered into depends on the email subject line.

Does any one know how I can do this?

There are a few pieces that you need:

1. You have to setup the mail server to forward messages to a script. There's a good writeup and that here:
http://www.theukwebd…p-incoming-mail.php

2. Next, you need to have a script which will access your MySQL tables. You can have the script call the PostNuke functions, and this has been discussed in the forums in a couple of threads, or, you could write your own PHP code to perform the SQL inserts.

3. You'll obviously need some logic in the script to parse the incoming email to get the data you want to actually enter. You'll probably also want to perform some error checking on that data to make sure you're only entering proper information.

So, in short, yes it is possible. How easy it will be depends on how much programming experience you have, I guess.