Read the excel lines in sequence and search the site.

  • 137 Views
  • Last Post yesterday
jmiyamura@x2inteligencia.digital posted this 3 weeks ago

Hello!

I am learning to use the Intellibot Components. Please, I want the support.

I have an excel file with many lines of "Processs Numbers". I need read each one "Process Number" to search in the site and to get download of the files.

My questions are:

1. Which component I can use to read "Process Number". For exemple: Line A2:A50. The Line A1 is column name.

2. Which compoment I can use to read each one "Process Number" sequencial. How I use The For Loop component.

3. If the "Process Number" not found, how I proceed to not interrupt the workflow.

 

Do you have any exemple for this process or orientation?

 

Thank you.

Julia

Order By: Standard | Newest | Votes
support@intellibot.io posted this 3 weeks ago

Hi  Jmiyamura,


Welcome to Intellibot.

Please find the answers to your questions as follows.

1. You can use "ReadFromSheet" / "ReadFromRange" methods from Microsoft Excel connector to read the values from Excel.

2. "GetListItem" can be used to retrieve values along with FOR loop.

3. You can use "Decision" component and design the automation flow as per the requirement

We have created a sample automation and attached below. Attachment contains an automation file along with the excel which acts as an input. This automation helps in reading the data from excel and searching the website and writes the results back to excel. Hope this helps!!, please reach out if you have any questions.
Link : Automation
Note: Chrome connector is used in automation, so please ensure "Intellibot Chrome Extension" is added to your chrome(Chrome Extension). 

 

 

Thanks & Regards,

Intellibot Support.

jmiyamura@x2inteligencia.digital posted this 2 weeks ago

Hello! 

Thank you so much for your return.

Helped me a lot.

 

I have a question about the automation example you gave me. I would like to know what the function of "GetOuterTex" that is contained in the Component "Result_text" performs, I don´t understand.

 

Thanks,

support@intellibot.io posted this 2 weeks ago

Hi Julia,

Happy to know that we are able to help you.

GetOuterText method helps in retrieving the text from the element that has been identified using Chrome connector. In our example it helps in knowing whether the website has shown the text "No Results found" after entering the invalid search input.

For more information on OuterText, please refer to the link (https://www.w3schools.com/jsref/prop_node_outertext.asp) 

Thanks & Regards,

Intellibot Support.



jmiyamura@x2inteligencia.digital posted this 2 weeks ago

Hello!

Thanks for the reply.

I want to insert this method in my automation, but I can't see it. Please, how should I do it?

The Chrome Connector is already added.

 

Thanks a lot.

support@intellibot.io posted this 2 weeks ago

Hi ,

You need to identify the elements using Chrome connector if your target application is a web application. Please find the link for information on Chrome connector.

Please feel free to revert for any further queries\clarifications.

Thanks & Regards,

Intellibot Support.

 

 

jmiyamura@x2inteligencia.digital posted this 1 weeks ago

Hi!

I found Getoutertext, now I need to learn how to configure it. Thank you.

 

In the Automation example, the Getoutertext component, does it identify the "No Results" message on the Web page? Is correct?

The Component Input_Search (SendKey), it is running [Enter], is it correct?

 

Please, where can I find the explanation of the Counter component.

 

Thank you.

support@intellibot.io posted this 6 days ago

Hi,

Yes, GetOuterText helps in reading the message when "No Results" found.

Yes, we have used the SendKeys in the search textbox in the website  i.e. search key along with actions(Books[Enter]).

The GetListItem output was formated with send key ([Enter])and sent it as input to input_search Sendkeys as Eg: Books[Enter].

Counter is used to increment/decrement the values. In the sample automation, we have used this to increment the value and formatted the text to get the cellName which will help in setting the values in excel

To learn more about Intellibot, please visit our academy(http://academy.intellibot.io/).

Thanks & Regards,

Intellibot Support.

 

 

jmiyamura@x2inteligencia.digital posted this yesterday

Hello!

Thanks for the reply.

When I adjust the configuration of the GetOuterText component I must delete and insert it again from the surface or the component updates automatically.

 

Thanks a lot.

support@intellibot.io posted this yesterday

Hi,

The Component on the design surface will update automatically, if you recaptured or changed the Locator or Match Attributes to the same element.

Please feel free to revert for any further queries\clarifications.

Thanks & Regards,

Intellibot Support.

Close