Challenge Overview
This is a small piece of work that consist of an:
Excel file that exist in a predetermined location on the LAN (configurable)
1. We need to write a consol app that when runs will go to the Excel file on the LAN and read it line by line till the end.
1.1. While reading it should parse it
1.2. And write it to one table in the SQL Database.
1.2.1.If the parsing is successful then copy the line to the DB and erase this line from the Excel file.
1.2.2.If Not success the app should return a failure number between 90 and 100
1.2.2.1.1. Keep the faulty line in the Excel file
1.2.2.1.2. You will have to number the possible error between 90 and 100
1.2.2.1.3. Each number should have a distinct meaning
1.2.2.1.3.1. Part of the requirements is a document explaining all possible Error code and their respective meaning –Once again the Error Codes should be between 90-100
2. The “ Connection Manager Upload Utility” explain the requirements in detail
And the package (Zip file contain a .net solution ready to be used for this projectè use it (this is the way we like the project to be organized).
3. In all cases when an error is encountered it has to be logged in the event log using event publisher
__MCE_ITEM__4. In the case or more than one error the exit code would be the last error number