TrackerMIS1 (Windows .net desktop application)
Budget: ₹37,500 – ₹75,000 INR
Various sets of Data are maintained in various excel files. An application is required where user can maintain each excel template based on which table structure to be created. An interface required where user can maintain the various data validations rules / constraints for each field for each template. On an ongoing basis, user is required to import data from the excel template which will involve new rows addition /update on existing rows. Application will validate the data in excel file as per the data validation rules maintained for the particular template and import only those records which meet the rules. Others to be updated in a log file with reason for rejections. Interface required where user can maintain Report formats for each Excel template. That should be presented with the list of fields for the template selected and user will define select columns, where columns with operators and values (SQL builder). The SQL built should be saved for later use as ready report option.
To summarise: 1) Maintain Excel Data Source Template by import from excel or screen interface 2) Maintain field data validation rules / criteria 3) Import data from the excel file 4) Define Report formats 5) Generate Reports in excel/csv/pdf formats
- Create / Modify table (as per excel template).
- Maintain Parameters: a screen interface would be required to select each column and define data validation. Data validation can be defined as any or all or combination of below validation types
o Formula ( e.g. BA > B)
o Logical (e.g. Blank Allowed)
o Edit Allowed (e.g. where Data to be frozen once updated)
o Value restriction as per master maintenance (e.g. Values in the particular column must be out of the n values maintained)
- Option to maintain combination of fields which would serve as Unique key for data update/duplicate check
- Option to import data from the excel template. Add / Update from the excel template file. All the validations criteria would be dynamically applied as per maintained parameters
- Option to download report / MIS. Screen will show below
o Select Fields to appear in report
o Select field based on which report to be downloaded i.e. conditions with value (e.g. Closure Status = XXXX and Category = YYYY)
o Select fields for sort order of the report
To summarise: 1) Maintain Excel Data Source Template by import from excel or screen interface 2) Maintain field data validation rules / criteria 3) Import data from the excel file 4) Define Report formats 5) Generate Reports in excel/csv/pdf formats
- Create / Modify table (as per excel template).
- Maintain Parameters: a screen interface would be required to select each column and define data validation. Data validation can be defined as any or all or combination of below validation types
o Formula ( e.g. BA > B)
o Logical (e.g. Blank Allowed)
o Edit Allowed (e.g. where Data to be frozen once updated)
o Value restriction as per master maintenance (e.g. Values in the particular column must be out of the n values maintained)
- Option to maintain combination of fields which would serve as Unique key for data update/duplicate check
- Option to import data from the excel template. Add / Update from the excel template file. All the validations criteria would be dynamically applied as per maintained parameters
- Option to download report / MIS. Screen will show below
o Select Fields to appear in report
o Select field based on which report to be downloaded i.e. conditions with value (e.g. Closure Status = XXXX and Category = YYYY)
o Select fields for sort order of the report