Hi All
What we need is a script that will allow us to gather custom customer text data from multiple fields per item; store them in some sort of a dated non-public, secure db; and then have a secure means to view each day's results - probably through HTTPS. We might want to download that day's file, as well. The script would also have to do math functions.
This way, the data is gathered, stored, and viewed all in a secure dated environment for each new day.
We need to create a new file for each new day to prevent downloading a file that is being written to at the same moment AND to better track orders. If an order is placed on 01NOV2001, we would simply view or download the /01NOV2001.txt, and everything for that day would be there. The data for 02NOV2001 would be on the /02NOV2001.txt file, and so forth...
We also want to use templates for each db so that we can set up multiple types of databases.
Yes, we know that several really good scripts are out there that can do math, write to db's, encrypt, etc. We currently use AlienForm2, and we are looking into Soupermail.
However, the two things that we have so far not found are 1) the ability to create a new file each day to make sure that the previous day's file cannot be corrupted and is safe to view or, if need be, download; and 2) a secure viewer of the db.
The secure viewer would have to 1) format the output of the raw data into something that our machinery can use and that we can copy right from our browser window, add it to a floppy, and then insert into our machines; and 2) give you the option to create multiple pages so that we could view one section of the db at a time to prevent crashing the browser.
The formatting issue could be something like being able to specify which delimiter you want (pipe, comma, tab, etc.), whether to include any headers/footers, or other stuff.
If the system is mysql-based, the secure viewer could sort any number of ways, including date, and then print to the browser just about any format. The flatfile viewer could look into the data directory and present the user with the optional files to view, plus the formatting options.
None of the secure data would have to be emailed to the admin or anyone else, but could be with an encryption option. The idea is to create a secure environment from start to finish for utilizing the data.
Since SQL is becoming more and more the way to go, and because LinksSQL is so sensibly written and organized, it seemed only logical to look to Gossamer for a great form script with tons of features.
I can only imagine what a flurry of ideas, feature requests, and mods and hacks would come out of offering something like a FormSQL script.
If anyone knows of a form script that can do the dated, secure stuff and viewing that I have mentioned, in addition to math stuff, I would be most grateful for a nudge in the right direction.
Many thanks to all for your help
DT