How to get the local path of my Excel file before to launch the Robot?

Certified Senior Developer

Hi,

I have a very simple robotic process that works fine. It opens and reads an Excel file stored in specific local folder and reads some cells values. The path of the Excel file is stored in an Apian Constant and I use the "Open or create Workbook" Appian service to open this file.

My new need would be to make the selected folder path dynamic because I need a user to be able to select a directory from an Appian Interface before to call the robotic process.

I've tried to use the a!fileUploadField fonction to select my Excel file, but I don't see how to get the local directory (the component gets only the filename and the new document ID).


Is there any way to get this local file path?

Otherwise, does a best practice could be to not use a local path, but to save the Excel file in the Appian repositiory first (the Robotic process would open the Appian document, and not the local file) ?

My scenario does not need to store the Excel file in Appian, so I would prefer the 1/ solution if it is possible ?

Regards

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer

    when you say "local", do you actually mean within the Appian filesystem?  because it almost sounds like you mean like the windows filesystem path or something, in which case all bets are off (barring the use of some super-specialized plug-in or something).

    If you're talking about Appian folders, we have pretty high flexibility, up to and including building our own little folder explorer tools (which i've done here or there as needed).  Firstly, if you have a valid file ID, then by virtue of the document() function you also have its folder ID.  And then with that folder ID and the folder() function, you have the parent folder ID, and so-on all the way up to the very root directory.  I'm not really clear what exactly you require here, though.

Reply
  • 0
    Certified Lead Developer

    when you say "local", do you actually mean within the Appian filesystem?  because it almost sounds like you mean like the windows filesystem path or something, in which case all bets are off (barring the use of some super-specialized plug-in or something).

    If you're talking about Appian folders, we have pretty high flexibility, up to and including building our own little folder explorer tools (which i've done here or there as needed).  Firstly, if you have a valid file ID, then by virtue of the document() function you also have its folder ID.  And then with that folder ID and the folder() function, you have the parent folder ID, and so-on all the way up to the very root directory.  I'm not really clear what exactly you require here, though.

Children