webscraping wih user&password for send excel by email
Budget: $30 – $250 USD
We need a Webscraping programmed in Python 3.8.17.
More details:
• It must work on Windows 10 and 11.
• It must contain a document called Install.docx that explains step by step all the programs and libraries that must be installed on the Windows machine to run satisfactorily. This document must also include the links to all the executables that must be installed, the commands that must be executed and the necessary confidences so that a developer who has NOT implemented this webscraping can configure its execution.
• Access is to the meraki.com platform
• The parameters cannot be set "hard" in the script, they must be set in an archive called config.txt or config.py. The minimum parameters should be the following:
o <Usuario>
o <password>
o <Email where to send the CSV file>
• User and password validation is performed via POST. The variables are:
o <input name="utf8" type="hidden" value="✓" />
o <input type="hidden" name="authenticity_token" value="" />
o <input type="password" name="password" id="password" value="" class="txt_inpt jsAnalyticsExclude" autocomplete="off" data-testid="login_password" />
o <input type="checkbox" name="remember_user" id="remember_user" value="1" style="vertical-align:middle" />
o <input type="hidden" name="goto" value="manage" />
• The Action of the form is the following:
o <form id="login-form" action="https://n264.meraki.com/10000633564-wire/n/merEwdie/login/login" accept-charset="UTF-8" method="post">
What must be done is the following:
1. Log in to a website with a <User> <password> (NOT will be entered)
2. Once you have logged in, with an active session, you must download the CSV archive with the results of the table that is explained and send it by email to <Email where to send CSV>
3. You must recover all the data from all the result pages. It can be done in 2 ways:
--Scraping the html of the result table, considering all the result pages (1 2 3 4 ......).
--Download CSV at the CSV link
Attached:
1. An example of the CSV that is rescued from the platform
2. Video example of the connection to access and download the CSV file
3. Image example platform
4. Example HTML rescued from the platform
More details:
• It must work on Windows 10 and 11.
• It must contain a document called Install.docx that explains step by step all the programs and libraries that must be installed on the Windows machine to run satisfactorily. This document must also include the links to all the executables that must be installed, the commands that must be executed and the necessary confidences so that a developer who has NOT implemented this webscraping can configure its execution.
• Access is to the meraki.com platform
• The parameters cannot be set "hard" in the script, they must be set in an archive called config.txt or config.py. The minimum parameters should be the following:
o <Usuario>
o <password>
o <Email where to send the CSV file>
• User and password validation is performed via POST. The variables are:
o <input name="utf8" type="hidden" value="✓" />
o <input type="hidden" name="authenticity_token" value="" />
o <input type="password" name="password" id="password" value="" class="txt_inpt jsAnalyticsExclude" autocomplete="off" data-testid="login_password" />
o <input type="checkbox" name="remember_user" id="remember_user" value="1" style="vertical-align:middle" />
o <input type="hidden" name="goto" value="manage" />
• The Action of the form is the following:
o <form id="login-form" action="https://n264.meraki.com/10000633564-wire/n/merEwdie/login/login" accept-charset="UTF-8" method="post">
What must be done is the following:
1. Log in to a website with a <User> <password> (NOT will be entered)
2. Once you have logged in, with an active session, you must download the CSV archive with the results of the table that is explained and send it by email to <Email where to send CSV>
3. You must recover all the data from all the result pages. It can be done in 2 ways:
--Scraping the html of the result table, considering all the result pages (1 2 3 4 ......).
--Download CSV at the CSV link
Attached:
1. An example of the CSV that is rescued from the platform
2. Video example of the connection to access and download the CSV file
3. Image example platform
4. Example HTML rescued from the platform