How to get list values present in input .csv file in WorkFusion Studio?

Hi All,
I am facing an issue. I have data in input .csv file and I need to get that data in my bot task for calculation. Does anyone know how to do it?

Thank you in advance.

1 Like

Hello @mjana.
You can copy the required data to Table or List variable and then work with them in your script.

1 Like

could you elaborate with some coding example?

There can be different approaches to it, it depends on your use case. What data is stored in the file? Do you need to red all the data or just a part of it? How do you need to use it in the script? Please provide more details.

i need to read all records from an input file provided by me on control tower and then export them with single-column tags.

I don’t think it is what @mjana asked about.

But if you are using Control Tower, you need to use this code to export the values
https://kb.workfusion.com/display/WF/export#export-OutputmultiplevariablesfromBot

Do you mean the input data file you upload in the business process? Or is it some local file that the bot needs to read when executing the process?

yes, the file you upload in the business process

i’m trying to complete the assignment #3 of RPA Core course.

If it is for an assignment check these threads

https://forum-2-new.workfusion.com/t/rpa-core-advanced-assignment-use-bot-context-variables/22035

https://forum-2-new.workfusion.com/t/rpa-developer-level-1-assignments-questions/11647/77

Hope it helps!

2 Likes

you’re a god send, thanks.

1 Like

May be something like this:

2019-08-29%2014_43_23-Edit%20Business%20Process

<?xml version="1.0" encoding="UTF-8"?>
<script>
    <![CDATA[
        log.warn("Started to work!" + id + "; " + link);
        log.warn("" + id + "; " + link);
		log.warn("Finished to work!" + id + "; " + link);
     ]]>
</script>

<export include-original-data="true">
</export>