I am using extract table data and then wirte range workbook. Process works perfectly in studio however when deployed to orchestrator extract table data does not write any data it is giving a blank excel. How can I fix this. i tried delay and re indicating but no luck.
Extract Table Data may return blank in Orchestrator because the UI is not fully loaded in unattended mode. Make sure Use Application or Browser activity runs in the foreground with WaitForReady set to Complete and verify that the robot has proper screen resolution and active session to interact with the UI.
Happy Automation
- Make sure the site from where you are extracting is loaded completely..use check app states to check loads and wait for page load complete options
- Are you checking the right file?..if you are relative filepath and if it is a file inside your package then when running from orchestrator the relative path would be different as it runs from a different location. In that case you need to use some absolute path like c:\botfolder etc
cheers
Add a log message before writing the datatable to an excel file to log how many rows got extracted by table extraction. This will help you to narrow down the root cause to work upon.
Can you check the path where the file is located.
If you are saving the file in Data\Input or Data\Output folder
Check the file on Virtual machine C Drive
HI, I have it saving to a different local c drive path and i can see it saving to the correct place with time stamp and date however it is empty I also tried the fixes above with no luck
oh I see, so there is no file path issue here
You are trying to scrape the data table from Webpage and store it in excel, is that correct?
Next thing would be to check the data scrapped from the webpage is extracted properly
Before Extraction, Add some static wait for any latency or you can add check app state
After extraction, can you add a log message with datatable rowCount , so we can confirm the data is extracted.
And - you said it works fine in attended mode (studio and trigger from assistant ), right
Yes it works fine in attended mode from studio. I Havent run it from assistant. The row count says 25 which is the correct amount of rows. However this from testing it in studio. In orchestrator it says 0 rows
It seems like an issue with Page loading, did you add a static wait and try ( just for testing, not recommended)?
or change this property to complete- Wait for page load in properties of Extract Table Data
Here is an example
Unfortunately that did not work either
That’s unusual, once you run it from the orchestrator, can you jump into that Virtual machine using Bomgar or just open the VM back again to monitor the run. That way you can verify that the page is loaded, but still the extract data table is not working.
Adn also which version of Studio and which browser are you using?
unfortunately i dont have acess to go in and watch it. sudio version is 2023.10.5. it is a desktop application not a website
oh okay. Are you running it on the same machine where you developed the process?
If yes, you can open the UiPath assistant on the machine and trigger it. Then you can watch the process run in foreground.
Can you share the screenshot of your workflow?
Thank you everyone for your help, i had to change the selector to make the application dynamic since we test in test app and run in prd app.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.