The purpose of this project is to automate the interaction of a windows application, process the output, and deliver it to the end users on their mobile devices. It can be split into four stages:
Stage 1 the Windows macro:
You'll need to write a macro that automatically clicks, waits for events to happen on the screen, and enters keystrokes depending on what is showing on the screen, the only tricky part here is I need today's day and tomorrow's day entered in one of the fields.
Stage 2 Process the data:
It's in this stage that users get their push notifications, and the records that are to be displayed on their devices is formatted. Stage 1 produces a text file. This text file must be parsed into records for an SQL database. It will have two persistent tables. Both tables will compare new records with the old records. If the new record doesn't exist, it is added to the table, along with an added timestamp. If it exists, then nothing is done. If the old record exists but it isn't in the new record, it is given a "deleted" timestamp and not processed further. A third table will exist with rules on when which user wants which notification triggered. If the new table A data doesn't already exist and it matches a trigger rule, a push notification for that user is generated.
Stage 3 Display the data:
Android and iOS apps must automatically update as new data comes in. The login screen will ask for userid and three letter code. It will have an option to save this. The preference screen will display a list of conditions to trigger notifications. The main screen will have table A and table B buttons, with today and tomorrow buttons underneath that will change which records are displayed below to the appropriate day.
Send me a message if you're interested.