The client has the vision to automate the roster generation process for pilots.
Pilots used to enter their duty roster manually on a daily basis which takes a lot of time.
The client came to us to resolve the above mention problems. We then started interaction with the client over chat and call to understand their requirements related to roster management.
We developed a robust roster import that can perform the following functions:
For companies having online rosters, the system proves useful. When pilots enter their username and password in such a roster, we directly scape them from that place to ensure quick processing.
Gets users employee number and airline from the roster and checks the database to see if they are in the free two-month trial, a current paid user or if their trial / paid subscription has expired and they need to pay before this roster is processed. (Data currently stored in an Access Database)
In case of payment overdue, it directs the system users to a page featuring a PayPal payment button. Once payment is made, the database is automatically updated in real-time using PayPal Instant Payment Notification (IPN) so that the user can upload his or her roster after making the due payment.
If users save their roster portal username and password with roster import, the system logs in automatically every 6 hours, see if there are any changes to their roster and if there are, it emails them details of the change.
We worked for them for a period of six months on a dedicated hiring basis.