Hello, I need to check the status of some shipments on a website, if the status is “Delivered” I record it in an excel with the time that appears on the web. the steps that I perform are:
I read the excel
A loop that ends at the end of the excel
I open the web and enter the search code
I do Web Scraping
If the Estado = Entregado enter and save. Here I have the problem since everyone enters, even if the word is not Entregado.
Hello
I attach my problem, the pattern that I have taken is when a shipment has the Estado(status) of Entregado(delivered), but sometimes the shipments are not delivered, as you can see it always shows me that it is Entregado(delivered) even if it is not, if the “IF” is delivered It adds the date, I need to put the real state, I don’t know if it is a problem when defining how to extract the data.
Attach:
My problem I think is here, I am trying in different ways and the failure is that it does not bring me the actual content of the moment but the content that I select the first time. That field varies depending on the status of the order.
Hi I only really need a date and a status, but when selecting with “Web scrapping” it makes me select both, it does not let me choose the same one. I hope to explain myself well.
I enclose two captures, if the status(Estado) is delivered(Entregado), to show me the status and delivery date, if the status(Estado) is different from delivered(Entregado) to show me the status and today’s date (Now.ToString (“dd-MM-yyyy hh : mm ”))
