need advice on upload process

2 posts, 0 answers
  1. Amanda Shafer
    Amanda Shafer avatar
    2 posts
    Member since:
    Oct 2012

    Posted 03 Jan 2014 Link to this post

    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.
  2. Plamen
    Plamen avatar
    2818 posts

    Posted 08 Jan 2014 Link to this post

    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.

    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.
Back to Top