Have a look at a product called "Markbook". Classlists are generated in MSSQL and the teacher downloads the lists to their notebook. They then create their reports offline on the markbook client before uploading them to markbook server. Once this is in MSSQL, you can get your CF hooks into it anyway you want!
-----Original Message----- From: Leon Seremelis [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 November 2003 4:01 PM To: CFAussie Mailing List Subject: [cfaussie] OT: Need Ideas for a dynamically generated file format Hi all, I have quite an interesting problem that I need to solve. I'm working for a school that wants to automate the creation of Student Reports. The requirements are: A) A teacher logs into the current CF intranet system and downloads a dynamically generated template file (word, excel, etc?) which includes their current class/student information. They can then go away and fill out the grades/comments on their notebook PC. B) Once they have finished filling out each student's report results they log back into the system and upload this completed file back onto the server. C) The data then needs to be fed back into the SQL database (preferably automatically). D) Getting the teachers to fill in their reports online is not an option. My main stumbling block at the moment is figuring out what type of file this can be? Currently, the teachers are given manually generated Filemaker Pro files (one for each class) which they fill out and then place into a folder on the network. From this point they are made into one huge Filemaker Pro file and inserted into SQL Server through a DTS package. As an added bonus the template file also has to look/behave as similar as possible to the current Filemaker files they fill out (which contain things like multiple choice drop boxes) so it wont require the teachers to be re-trained. Any ideas would be greatly appreciated. Cheers, Leon. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
