Web Upload Xls Delimited
Task 1 is to complete a web page where users define the layout of their data file. Data files are of type excel or text delimited. In general data files are flat tables.
Task 2 is to complete server side code for uploading and processing of the data file and layout. Processing is required to extract data and package it so it can be ingested by an extant web service.
Some existing code may be useful for task 2. Data file processing code exists. The code requires a layout file. A grammar of sorts describes layout files. At present layout files are generated by a technician upon examination of the contents of the data file. The code ingests the layout and data files, packages the data, and sends it to the web service.
Data files in general are flat files. However metadata is to be considered. E.g. the required column for WEIGHT can be qualified by metadata giving the units, e.g. kilograms; or the required column for WEIGHT can be qualified by a companion units column. (Units are defined by GnuUnits).
A number of test data files of various formats exist.
It is expected that this project will require two iterations. The first iteration has a short-term due-date. The second iteration will commence approximately 3 months later and will respond to additional user requirements and other issues.
Coding is to be done .NET C# using AJAX, JavaScript, etc.
