Amanda Shafer
Top achievements
Rank 2
Rank 2
Amanda Shafer
asked on 03 Jan 2014, 05:35 PM
Hi -
I'm looking for suggestions on how to best achieve the following using the AsyncUpload control.
Our users are uploading excel files. I need to verify there are certain columns in the excel file. If they are all present, then it will pull data from the spreadsheet and put that into a database. Then the file itself will be put into the database.
At what point should I do the verification for the columns? Can I do this error checking on the temporary file? There is no reason for the excel file to ever make it into the database if the columns are not present and the data cannot be uploaded if it isn't.
Thank you in advance.
I'm looking for suggestions on how to best achieve the following using the AsyncUpload control.
Our users are uploading excel files. I need to verify there are certain columns in the excel file. If they are all present, then it will pull data from the spreadsheet and put that into a database. Then the file itself will be put into the database.
At what point should I do the verification for the columns? Can I do this error checking on the temporary file? There is no reason for the excel file to ever make it into the database if the columns are not present and the data cannot be uploaded if it isn't.
Thank you in advance.
1 Answer, 1 is accepted
0
Hello Amanda,
In such cases we recommend using the OnFileUploaded event where we could check the desired validation rule and mark the file as valid or not.
Hope this will be helpful.
Regards,
Plamen
Telerik
In such cases we recommend using the OnFileUploaded event where we could check the desired validation rule and mark the file as valid or not.
Hope this will be helpful.
Regards,
Plamen
Telerik
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.