CSV File Use

[dwatson]

Hi all,

We currently have issues where we need to run scripts, but do not have excel available on the machine that needs to be ran. Deployment is not an option as we have to remotely connect to clients computers. How can I convert my scripts to run on CSV files and not have to rely on excel?

As it stands now, we loop through each row in an excel database.

Thanks!

[trentonponder]

You can loop through each row in a .CSV/Text File.

1 - Save your Excel Files as a .CSV
2 - Use 'Read from CSV/Text' command
3 - Loop through Each row in a .CSV/Text File
4 - Switch all your Excel Column() Variables to FileData Column() variables.


Depending on your setup, you can use AA to automatically save your Excel Files to .CSV as part of the task.

[forumsupport]

Hello,

In that case, you need to edit your task and replace Excel commands with 'Read from CSV/Text file' and 'Loop for Each row in CSV/Text file' command.

If you can upload your task then we can amend it for your convenience.

Hope that helps.

[dwatson]

Hi,

I do not seem to have an option for looping through CSV/TEST. Only an SQL Dataset. It seems to work - sort of nonetheless. So the CSV file seperates by commas (as opposed to columns). I still can't get the information to input to the right place.

Enclosed is a copy of my original task. If you could change it to reflect the CSV files I would be so grateful. I can't seem to get this correct.

Thanks

[forumsupport]

Hello,

If Excel is not installed then Excel commands will not work as they need Excel object for execution.
If you are using version 5.0.2 then 'Read from CSV/Text file' option can be found under 'Database' command and for looping the recordset use 'Loop for Each row in SQL query dataset' . We have amended the task for your convenience. Please copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.

We would recommend you to upgrade to the latest version, 5.5. It is a free upgrade for version 5.0 customers. You can download trial version of Automation Anywhere 5.5.2 from our website:
http://www.automationanywhere.com/download/freeTral.htm

Hope that helps.

[dwatson]

Thank you for amending the file. I do have a read from CSV/Text file, however I was under the assumption the loop command for it would match. To clarify, I do need to use "Loop for Each row in SQL query dataset" function?

In regard to Excel, I think the about to read from the Excel Reader would be a great addition if possible.

Thanks again!

[forumsupport]

Hello,

In version 5.0.2 'Read from CSV/Text file' command is under 'Database' command, hence to loop through the data you need to use, "Loop for Each row in SQL query dataset" command.

For your case, 'Read from CSV/Text file' would be the better option as this command does not require to open the CSV file to read the data from the file compared to Excel commands that actually opens the file and read the data.

Hope that helps.