we do the same thing and just use cfspreadsheet to retrieve the data, then process the data as required, then insert into backend datasource. we use the login credentials to identify the person uploading them, and attach the userid to the results in the database so we know who completed the questionnaire
>I am looking to see what other developers are using to read excel files as >datasources? > >Here is the scenarios: > >User downloads an Excel file >Loads it on their tablet PC and walks around filling in questions (Yes/No & >Comment type questions) >-- If yes, no comment required >-- If no, comment required > >Once all questions are answered, they upload the excel file to the server. > >I need to read the answers (Yes/No - Comment) and save them to the database. > >I can create the excel file as a single worksheet without any problem. >Since it is multiple users, what is the best approach for obtaining the >results of the questions? > >TIA! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338163 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
