Web availabilty calendar management with Python, Selenium and VBA
Budget: €30 – €250 EUR
I have availability calendar hosted on my service provider. Needs are as follows:
1. Read current availability situation from web calendar
2. Mark blocked / available dates to excel spreadsheet (Master calendar)
If a date range is needed to be put blocked / available, there is also a need to:
1. Block availability in web calendar to date range
2. Open availability to date range
More detailed information attached with screen shot from the application and Selenium IDE recording. Temporary access to calendar is given for developement.
Service provider does not have API to control this. This is very unfortunate.
What is expected to be the result:
A VBA code that reads the current availability and updates the excel spreadsheet date value to be “Bolded” if date is blocked/booked and “unbolded” if date is available.
Also selected date range can be either blocked or unblocked with VBA script.
1. Read current availability situation from web calendar
2. Mark blocked / available dates to excel spreadsheet (Master calendar)
If a date range is needed to be put blocked / available, there is also a need to:
1. Block availability in web calendar to date range
2. Open availability to date range
More detailed information attached with screen shot from the application and Selenium IDE recording. Temporary access to calendar is given for developement.
Service provider does not have API to control this. This is very unfortunate.
What is expected to be the result:
A VBA code that reads the current availability and updates the excel spreadsheet date value to be “Bolded” if date is blocked/booked and “unbolded” if date is available.
Also selected date range can be either blocked or unblocked with VBA script.