RPA AUTOMATION - Form Fillings
Budget: $30 – $250 USD
OBJECTIVE: Fill a three step form in the polish embassy.
CHALLENGE: The page opens once a week at a random time.
SOLUTION: We visit the page every 15mins, resolve the captcha and see if there are spots left for doing some kind of paperwork.
NOTE: It´s difficult to test because the page where we fill the forms opens only once a week - but I´m attaching HTML files for testing purposes.
>> Images and videos attached.
URL we´re working with: https://secure.e-konsulat.gov.pl/placowki/164/sprawy-paszportowe/wizyty/formularz
(we might need to change the lenguage to spanish or build the script to work with polish)
DATA for filling the forms: https://docs.google.com/spreadsheets/d/1XVIFronu54Xh9PJi4pIkqmqzlstFYoIBTaQL3dLIsl0/edit?usp=sharing
The RPA Software should:
1) Visit https://secure.e-konsulat.gov.pl/placowki/164/sprawy-paszportowe/wizyty/formularz every 15min
2) Complete the form.
Fill the fields
a) "Tipo de servicio"
b) "Quiero una fecha para"
(i.imgur.com/UxInSpk.png)
3) Resolve the captcha
(we have already done this part with anti-captcha.com that has a Chrome extension that solves this easily)
(i.imgur.com/QgXBlbh.png)
4) Complete the fields:
a) "Fecha de la cita previa"
b) "Hora de la cita previa"
(i.imgur.com/aX2H7Y7.png)
5) At this point the page can say "La fecha elegida ya no esta disponible" which means that there are no dates available or it can continue with the process.
a) If it says "La fecha elegida ya no esta disponible" it should try again in 15 minutes.
b) If it continues to the next page, it should go to the following step.
6) If the sytem HAS dates available will show a page like this: i.imgur.com/cakqtMp.png and we want the RPA Software to
a) fill that form with some pre-loaded data in the script.
b) send an email
c) trigger a webhook
7) In the next page it should click the button "Guarda" (i.imgur.com/8KM5eSb.png)
8) And then "Descarga la confirmacion de la visita" (i.imgur.com/YYLjlwx.png)
NOTES:
a) The webpage is made with Angular.
b) The form changes if there are 1, 2, 3, 4 people being registered. We can start with 1 person and then update the script to register 2, 3, 4 people.
In the attachments I´m providing how the form looks like with 1 and 3 people want to register.
CHALLENGE: The page opens once a week at a random time.
SOLUTION: We visit the page every 15mins, resolve the captcha and see if there are spots left for doing some kind of paperwork.
NOTE: It´s difficult to test because the page where we fill the forms opens only once a week - but I´m attaching HTML files for testing purposes.
>> Images and videos attached.
URL we´re working with: https://secure.e-konsulat.gov.pl/placowki/164/sprawy-paszportowe/wizyty/formularz
(we might need to change the lenguage to spanish or build the script to work with polish)
DATA for filling the forms: https://docs.google.com/spreadsheets/d/1XVIFronu54Xh9PJi4pIkqmqzlstFYoIBTaQL3dLIsl0/edit?usp=sharing
The RPA Software should:
1) Visit https://secure.e-konsulat.gov.pl/placowki/164/sprawy-paszportowe/wizyty/formularz every 15min
2) Complete the form.
Fill the fields
a) "Tipo de servicio"
b) "Quiero una fecha para"
(i.imgur.com/UxInSpk.png)
3) Resolve the captcha
(we have already done this part with anti-captcha.com that has a Chrome extension that solves this easily)
(i.imgur.com/QgXBlbh.png)
4) Complete the fields:
a) "Fecha de la cita previa"
b) "Hora de la cita previa"
(i.imgur.com/aX2H7Y7.png)
5) At this point the page can say "La fecha elegida ya no esta disponible" which means that there are no dates available or it can continue with the process.
a) If it says "La fecha elegida ya no esta disponible" it should try again in 15 minutes.
b) If it continues to the next page, it should go to the following step.
6) If the sytem HAS dates available will show a page like this: i.imgur.com/cakqtMp.png and we want the RPA Software to
a) fill that form with some pre-loaded data in the script.
b) send an email
c) trigger a webhook
7) In the next page it should click the button "Guarda" (i.imgur.com/8KM5eSb.png)
8) And then "Descarga la confirmacion de la visita" (i.imgur.com/YYLjlwx.png)
NOTES:
a) The webpage is made with Angular.
b) The form changes if there are 1, 2, 3, 4 people being registered. We can start with 1 person and then update the script to register 2, 3, 4 people.
In the attachments I´m providing how the form looks like with 1 and 3 people want to register.