How to enter credentials in Config.xlsx file

[Prasad_Kulkarni]

I dont know how to enter username and password for the website to login in Config.xlsx file

[Priyanka_Ramesh]

welcome to the community!

[rishabhverma]

Hi , Just make two columns , for first column make the header as Username and for second column make the header as Password . Below the headers mention the username and password . save that file.

Now Use “Excel Application Scope” Activity in the sequence and inside that use “Read Range” activity to read the username and password
Rishabh Verma LinkedIn

[kotirpadev (Sivakoti reddy)]

Please refer the links

Assets in Config File

Hello @ALalla917 [sorry for the lengthy response] The last bullet point is directly dependent on the bullet points 1 and 2 Yes you have to take action only in the Orchestrator, but the name has to be the same as what you have in the config.xlsx GetCredential is the activity that we use to get the details of the credential type asset that we create in the Orchestartor. Detailed description on the activity is in the link below: whereas, GetAppCredential - this is one of the sequences what h…

Regarding Assets in Config file

Hello RPA experts, How can i use assets from the config file.My scenario is i am not using orchestrator nor windows credential manger for getting the credential.I have to use excel config file which contain all the assets. In my scenario what will the way to secure my assets and how can i use it in my UiStudio. Can anyone please help me asap?? Regards, Kanthesh

[Prasad_Kulkarni]

Hi
I am using config file in RE framework.

Can you show me the screen shot how you would do it?

Thanks and Regards,
Prasad

[Nithin_P (Nithin Prabhu)]

Hi @Prasad_Kulkarni,

1. Create an Asset of type “Credential” on Orchestrator
2. In the “Settings” sheet in the config file , add a new row with name as “Web_Cred” and value as the name of the asset you created in orchestrator
3. In you login workflow, invoke the “GetAppCredentials.xaml” from Framework Folder and pass “in_Config(“Web_Cred”).ToString” to in_Credential argument
4. You will get the username and password from the out arguments of “GetAppCredentials.xaml”

Regards,
Nithin

[SowmyaLeo (Sowmya Sivakumar)]

@Prasad_Kulkarni

I presume you are trying to pass the credentials to the GetAppCredential sequence.

For this please use the “Settings” tab in the config file where you specify:
Name - This will be the key that will be passed
Value The name of the asset in Orchestrator which holds the credentials (Basically create an asset of Type Credential in the Orchestrator and store the user name and password there.)

When you are passing the argument to the GetAppCredential it would be ConfigVariableName(“Name you have specified”).ToString