Description: A file import page control, or enhancement to existing data grids, which would allow for end users to import a file with additional data, extract and load the data into a grid and store it into an internal entity Requirements:  Control should allow for users to import a file and attach the file to the case Control should validate the file is in correct format (excel, txt, csv) Control should validate the file includes required fields for destination data source If required fields are not present, control should stop execution and return a custom error message Control should validate the fields are in the correct format for destination source If fields are in incorrect format, control should stop execution and return a custom error message Control should populate the associated grid with the results of the import and store the data in an internal entity Control activities should be stored as part of an audit to show which user(s) imported data successfully and the number of rows imported, or which user(s) did not import data successfully and the associated error message Within the Manage Investigate and Search function, the page control should include the following Ability to select destination data source (table) or default to the destination source based on the data grid where the import occurs Ability to select inherited fields for the destination source (for example, if the control is being used to add values to an existing case, and the caseID is a required field, this field can be inherited from the case without having to be imported) Error messages should include the row and column so that users can correct the file and resubmit Business Justification: Necessary for the addition of multiple entries related to customer identified transactions or activities. ... View more