So I have been checking out some different methods to grasp data such as URL, path, etcetera from a config file (without the use of Orchestrator). When I was using AA I would get it the data from a .txt which I had encrypted. My goal is to stay as close to the source as possible. What are your best practices towards this? Looking forward to be inspired.
You can use excel+dictionary combination, mtn the configurations in an excel, at the beginning read the excel t& store the config in a dictionary. You can pass the dict to child workflows easily.
Hi,
Could you please provide sample workflow to fetch data from config file and used in further process.
@skini76: This is kind of what I use now. What do you specifically mean with the dictionary combination. Can you give an example just to get on the same page?
I use an encoded Excel file and then assign the values to the variables. I am aiming to encrypt it as well so I first need to decrypt it. So pretty much it is like this:
Decrypt an Excel file > Unlock the Excel file > Assign values to given variables (uncertain about the best approach towards this) > Encrypt the Excel file
@Rup_1: Will this work for you?
I am getting the following within the body.
It looks really nice actually. Itâs more has a deeper level of details then mine. I donât have âCaptureScreenShotâ etcetera but I really like the idea!
Column A is key and column B is value
It seems that you have used a package for the âAdd to dictionaryâ function.
If so, can you please tell me which one it is?
I have installed all of them available with the word âdictionaryâ.
Thank you in advance.
(Iâm using the 2018.3.1 version, Enterprise Edition)
Even I donât remember which one, so sharing the screen shot of packages installed.
Hahaha I can imagine! I found I would do them one by one so others would be able to use it as well. Had a match on the first try
Thanks a lot @skini76!
most welcome
Take a look at the UiPath RE Framework.
They use a Excel & Dictionary combo like skini76 suggested. Youâll find it in the Init state machine.
I took the config part of their framework when developing my own.
Another approach i am pursuing is having a âglobalâ config which will be stored in a central location with a marker/trigger to switch between global and local (on the local machine in the project folder) for testing purposes.
Thatâs a clever solution as well! Thank you for your input!