I import data from csvโs on a daily basis using an Import from CSV action. Iโve automated the entire process using selenium, however, Iโm stuck on the last step which is that selenium doesnโt recognize the Import CSV dialog window in Chrome/OSX which means I canโt select the CSV I want to import. Does anyone know of any workarounds/have any ideas how I can automate picking the csv from my local hd or google drive account?
Iโm using Python/OSX/Chrome
@Phil any ideas why the dialogue box wouldnโt show up for RPA?
Is it 1 CSV per day? If so, why canโt the file name be based on the date?
If multiple, then can you can use a loop and rename the files โฆ_done.CSV after import and ignore them.
This assumes selenium can write to that field.
Itโs not a filename issue, itโs the fact that Selenium canโt interact with the โOpen Fileโฆโ dialog window in Chrome because itโs an OSX window, it doesnโt have an XPATH or object ID. My guess is that there might be another library like Robot that I could supplement my script with. Iโm at the point where selenium will click on the appsheet action, it opens the Open File dialog window and now I just need to be able to select the file and press the Enter key and Iโll be golden.
Ok, understood. Iโm sorry I donโt know anyway to overcome the limitation. Iโm not sure if you could do it alternatively. I have a client for whom I developed CSV import using a GAS web app with a trigger. He uploads the csv file to a specific drive folder and the script does the import.
That could work. If i set the download folder to a google drive folder then I can have apps script do the rest. How did you manage to have apps script call the appsheet import csv action?
I didnโt- I directly wrote to the sheet from the script.
Gotcha. In my case, the action is neccessary because itโs triggering virtual columns to update which wouldnโt happen if i was writing directly to the sheet.
Can you trigger the action from the API ?https://help.appsheet.com/en/articles/1979979-invoking-the-api
Iโve never done that before but something tells me thatโs gonna work. Thanks so much for the tip!
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |