Hello, I’m having trouble uploading an xlsx file to SAP.
I’ve tried the xls format, but without success.
Every time I create the file for upload, this pop-up appears.
I’m using the modern mode and I’ve even tried to use the ‘element exists’ to catch the pop-up and be able to move forward… but without success.
I’ve tried to use the ‘read status bar’… without success. I’m starting to run out of ideas…
To move forward I have to click on ‘yes’… then Excel opens and everything goes back to normal…
In SAP, I’m invoking the transaction through the UiPath activity ‘SAP CALL TRANSACTION’.
Any idea or help would be appreciated.
Thanks in advance
Here is the printscreen of the error.
You can use Hot key activity where you can specify the key combination to press, which would be the shortcut to handle the pop-up. In your case you might use the “Alt + Y” to select “Yes.”
I’ve tried it…ti doesn’t work.
I’ve been able to capture the button, and i’ve used an element exists (classic) and also i’ve tried it woth modern activities … used a get atribute to obtain the text inside the pop up…but even though it doesn’t work
Could you let us know whether the same happens when you perform it manually ?
Also, then name starts with ~ indicating that it is a temporary file or it is being used by something else.
Could you let us know how are the activities configured within the workflow ? Are you using the Use Excel File activity and within it are you performing the Upload operation ?
Hi,
To generate the file, the RPA creates a table using the “create Data table” activity, which will generate the structure of the file. Then, I run a SQL query on a certain database that I copy to another DT. The file results from the DT that I extract from the query and that I complete using a lookup table activity to give me the values I want. After everything is complete, I use the append workbook and write workbook activities. I’m not using the “use Excel File” activity, I’ve tried it and it always gave me an error. I confess that I still don’t know how to work well with this new Excel activity.
When I execute it manually, the file opens… as if it were a normal Excel file. But when the popup appears, the “~” really shows up. In terms of activities, I am using the Use application/browser, then the Type into, and the path to upload the file is in a variable “StrPathFile” in which StrPathFile= Path.Combine(path_folderTemp,“fileName_”+Now.ToString(MMM_yy)+“.xlsx”).
You can pause the robot after excel creation and try to upload manually and see whether the poupup persists. In positive case, check if you can open it directly in excel. I guess when you are saving the excel file the file doesn’t persist metadata related to extension. When you are uploading the file to SAP, it doesn’t recognize the format and return it without properly extension and popup shows up.
