I know that this is not a unique issue, but I have some examples of solutions to this problem, Has solved. I have an intranet asp.net application that I have inherited and I am building on it. A special page is for data entry to submit a claim for approval and we have a form where a record can be recorded at one time and it has been validated in the real time of the database for valid product information. .
I have been asked to add a feature where users can import a large number of records at a time, through each text box and dropdown list, more than 100 records at a time To save time, you can be asked to save time.
Solution I have found that my first option is to create an Excel spreadsheet, which I can open with a link on the page that I have formatted in a template that they copy / paste their data You can save, and then import it to the server and import it into SQL Server as a linked server object.
Due to the nature of this solution and some of the data being imported, I have to program some error in the VB for the spreadsheet and if I ever find a bug properly, There is no guarantee of using the version and it is not that I saved the local copy which can be broken while trying to import.
I have rejected a large text box that I try to parse because I have no control over how to enter data. / P>
Am I missing out on a better and possibly more clear solution?
Unprotected spreadsheet import process is a bad thing, there are many things to break the user process can do. If you are going to load bulk from spreadsheets, then the following components should be included in the process:
-
A template file downloaded by the user, and generated from the application (if the template There is no need to change, it can stay anywhere in just one folder).
-
To ensure that the template has been used.
-
Actual load process
-
A screen where the user can verify what they import, edit and edit .
A check and valid part is a good way to control the upload that can validate the data. The user must inspect the imported data and must approve it manually. It retains the responsibility for accuracy on users, and enables them to view and fix uploads.
Comments
Post a Comment