Missing Data Notification Scheduler and Patchup data
Budget: ₹400 – ₹750 INR
There is a data table which contains (id, datetime, qtyid and data value) data in MS Sql server. This data table will be data feed by another engine by everday. So we need to check whether the data is available for all the location id (Locationid will be on another table).
Scheduler has to check the data availability daily to avoid missing data. if there is missing data found for any of the location, it has to record this on new table. It will be later used for acknowledge and patchup.
Windows Service has to create for the scheduler to check and input the missing info on new table as mentioned above. Notify the customer by desktop notification on Client PC (Windows).
Create the User Interface on Desktop application to show all the above missing locations. So that user check all the missing info retrieved from the new table. Allow the user to acknowledge this notification, so that it will remove from this list. Provide link to patchup data .
Patchup is another window menu, It will help the customer to choose the previous months data for the missing datetime and fill the gap. Give the month and year to choose, so that you can copy the same period of data and paste it into by changing the month and year of required.
Scheduler has to check the data availability daily to avoid missing data. if there is missing data found for any of the location, it has to record this on new table. It will be later used for acknowledge and patchup.
Windows Service has to create for the scheduler to check and input the missing info on new table as mentioned above. Notify the customer by desktop notification on Client PC (Windows).
Create the User Interface on Desktop application to show all the above missing locations. So that user check all the missing info retrieved from the new table. Allow the user to acknowledge this notification, so that it will remove from this list. Provide link to patchup data .
Patchup is another window menu, It will help the customer to choose the previous months data for the missing datetime and fill the gap. Give the month and year to choose, so that you can copy the same period of data and paste it into by changing the month and year of required.