Enhancement: Ability to import excel file with list of employees.

[PrabhakarThummalaDOL]

• [ ] Import comma separated excel file (list of employees) to the Data Table.
• [ ] Create a log file with the list of failed records.

[NathayaMDOL]

@mmurthydol , From researching. there is no plugin/builtin to import file to datatable. I found couples article that related to our environment. #2. seems interesting. Please see below.

1. Read Excel Data in AngularJS using Asp.Net Web API in MVC 4 and Show Data in HTML Table
   • https://www.encodedna.com/angularjs/tutorial/read-excel-in-angularjs-using-webapi-and-show-data-in-html-table.htm
2. Read Excel file to Javascript-AngularJS then push that data to HTML Table (need to adjust code from HTML Table to datatable instead).
   • https://www.youtube.com/watch?v=OK60UdWyUdE
   • https://gist.github.com/AbrarJahin/22e7fdcbe1beb3827e7aee1f9d0af72f
   • https://www.aspsnippets.com/Articles/Read-Excel-File-using-AngularJS-and-HTML5-File-API.aspx
   • https://sibaspage.com/blog/read-data-excel-using-angular-js/

[mmurthydol]

@NathayaMDOL Thanks for analysis. Please provide an LOE - level of effort and any technical risks/challenges that you think we might face.

[mmurthydol]

@NathayaMDOL Need analysis on what we can do if data is incomplete/incorrect; how do we report back, etc. Also LOE.

@PrabhakarThummalaDOL Could you please also review. How about Application_Save - what limits does the API support for Upload? What happens on failure in this context?