Help me to make a report faster

[Raisa_Aminati]

Hello friends, I wanted to ask a question.

I need a way to work faster. A little bit of background information, my job is to monitor purchase order status on a website named Pronto Xi Financial. While that sounds simple, i mean simple like open the website, log in, select the company, go in the supply chain menu, press FN + F11 to open the purchase order or supplier menu, select purchase order from the dropdown, then hit enter. After that press F and paste the copied purchase order number into the cell, and then hit enter. Lastly copy the status and then paste into excel.

This is simple, but with 200+ of this it can make you feel tired, and in the worse case may create mistake because you no longer can focus and input a wrong status. I ask ChatGPT is there’s any bypass or data fetching that I can use, but ChatGPT said these procedures need consent from the IT team.

So therefore, I search for a chrome extension instead. Originally I was looking for a tool that can automatically update my excel every time there’s an update from the website. But because Pronto requires a log in, it is not easy to bypass.

So i give up on that and instead I search for a chrome extension that can help paste data into excel. What I mean is I only need to copy the data from Pronto, and then paste it into this tools, and this tools is the one who’s going to paste it into excel. This eliminates the need for me to open excel and go back and forth from excel to pronto.

Finally, ChatGPT recommend me UI Vision, ChatGPT recommend to use macro from UI Vision.

The problem is, I haven’t find a tutorial that can make me understand to use UI Vision for my case.

Is there anyone who can help me and explain step by step instruction?

Thank you for the help, and also, if this is not possible to be done, can you guys please give a suggestion to me on how to make my task easier? Maybe by suggesting that I use other tools, or other method, and etc?

[admin]

Hi, ChatGPT made a good suggestion

→ Can you please post a screen video of the task(s) that you need to automate? Then we can suggest the best way(s) to automate this with Ui.Vision.

[Raisa_Aminati]

I heard that you have a service to make custom macro’s, so is there any fees for this? This case is a bit private, do you have email that I can reach out? Or can you email me privately?

[delia598guzman]

@Raisa_Aminati

Hello friends, I wanted to ask a question.

I need a way to work faster. A little bit of background information, my job is to monitor purchase order status on a website named Pronto Xi Financial. While that sounds simple, i mean simple like open the website, log in, select the company, go in the supply chain menu, press FN + F11 to open the purchase order or supplier menu, select purchase order from the dropdown, then hit enter. After that press F and paste the copied purchase order number into the cell, and then hit enter. Lastly copy the status and then paste into excel.

This is simple, but with 200+ of this it can make you feel tired, and in the worse case may create mistake because you no longer can focus and input a wrong status. I ask ChatGPT is there’s any bypass or data fetching that I can use, but ChatGPT said these procedures need consent from the IT team.

So therefore, I search for a chrome extension instead. Originally I was looking for a tool that can automatically update my excel every time there’s an update from the website. But because Pronto requires a log in, it is not easy to bypass.

So i give up on that and instead I search for a chrome extension that can help paste data into excel. What I mean is I only need to copy the data from Pronto, and then paste it into this tools, and this tools is the one who’s going to paste it into excel. This eliminates the need for me to open excel and go back and forth from excel to pronto.

Finally, ChatGPT recommend me UI Vision, ChatGPT recommend to use macro from UI Vision.

The problem is, I haven’t find a tutorial that can make me understand to use UI Vision for my case.

Is there anyone who can help me and explain step by step instruction?

Thank you for the help, and also, if this is not possible to be done, can you guys please give a suggestion to me on how to make my task easier? Maybe by suggesting that I use other tools, or other method, and etc?

Hello @Raisa_Aminati,
You can automate this with UI Vision by recording a macro that copies the PO status from Pronto and pastes it into Excel. Start with the desktop automation feature, use XClick and XType commands to interact with both browser and Excel. For 200+ entries, loop the macro with a CSV file containing PO numbers. If UI Vision feels complex, consider AutoHotkey or Power Automate for more control and easier integration. Illinois E-ZPass

Best Regards,
Delia Guzman

[Raisa_Aminati]

Wow.. Thank you very much for a great response😊 just a quick follow up question, do you know where to learn RPA? I tried to learn from youtube but it is not sufficient.