Reading csv file from config in Re Framework

Help Studio
1

Hello all,
I have a doubt when choosing RE Framework as my template i have to do read input csv file by giving path in config.xlsx file and run this as step one

so how do I do all of this and what all to changes i need to do so that it runs properly

2

RE Framework is poorly designed, IMO, and is overkill for most automations.

Also, using a config file is tedious and unnecessary. Use arguments (parameters) instead. Simpler, no file to manage, no Excel file to read into your automation.

3

@Shreya_Jain_IN

Welcome to our UiPath community.

Add CSV file path in config.xlsx under settings sheet as below.

Name - CSVFilePath
Value - “File path”

You can keep reading CSV file workflow after InitAllSettings workflow. We will assign entire config values to Config variable and it is of type Dictionary.

You can read CSV file like below.

                Config("CSVFilePath").ToString
4

Thank you, so like i initialise only in the InItAllSetting? and dont make a xaml file for it?

5

@Shreya_Jain_IN

CSV file path will be read in InitAllSettings workflow. If you want to read data from CSV file then use Read CSV file activity to read it and it should be after InitAllSettings workflow.

6

I did the same then it gave me validation error like TransactionItem cant be changed from queue item to data row so i deleted this as well. Cause we arent using TransactionItem as of now
Could you show an example of this above?

Thank you

7

@Shreya_Jain_IN

Could you please tell more details about your process. So that I can help you better.

8

I have sent you a message regarding the process

Thank you

9

@Shreya_Jain_IN

Yes. I replied my comments there. Please look into it.

10

Hi @Shreya_Jain_IN,

if you are not using queues and want to use data table itself, you can utilize below re-framework sample project:

This shows what need to be done in get transaction state to read data from datatable instead of queue.

ReFrameWork-WithoutQueues-main.zip (971.0 KB)

And changes that are required to be made to the re-framework are defined in below text document.
Changes for Re-framework(without queues).txt (1.0 KB)

Also sharing the video link below on same:

Re-Framework without Queues || Simple Way || With RPA Challenge Example

Regards
Sonali

11

Thank you so much @sonaliaggarwal47

12

Hi @Shreya_Jain_IN,

Now that your query is resolved, I would suggest to mark solution so this topic can be closed.

If unaware on how to mark solution, please refer below post:

Regards
Sonali

13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.