RoboTask forum

... Enabled=INTEGER|-1 Name=STRING|"Set variable ""_CsvFile"" with value ""{TempDir}\test.csv""" Params=FOLDER [Actions\Action1\Params] _rt_variables_produced=STRING|"_CsvFile" expand=STRING|"1" linecount=STRING|"1" ...

Good morning, I recognized an issue with action 'SQL Query to CSV file'. I want to create a CSV file from sql data and then (if it exists) send it to an email-address. I am using for example {TempDir}\test.csv as target file for the query results. In the ...

... HEX and vice versa to the Value format action. + Added "Do not create file if query result is empty" option to the " SQL query to CSV file " action. * The File Monitor trigger now uses global file time independent of time zone. * Added "Test SQL" function to " ...

You need to cut off EOL symbols from variables voornaam and familienaam Look at my example below. Also pay attention: You can read CSV file as UTF-8 file and remove UTF8 text --> Text steps at all ;***************************** ;* RoboTask Task file ;* Do not edit in text editor! ;***************************** ...

I have this text file with names seperated by ; like first;last; I use CSV Open Data, Data Loop, convert to text and create file in mode append to write a new file that has the names like this: first last But my action creates a file like this: first last How ...

a sql query instead of saving in CSV, save in variable table object

... (v 10.3.0.67)" is loaded I 5/22/2025 11:47:53 PM: Plugin "DataBase (v 10.3.0.85)" is loaded I 5/22/2025 11:47:53 PM: Plugin "CSV Data (v 10.3.3.33)" is loaded I 5/22/2025 11:47:53 PM: Plugin "Graphics (v 10.3.0.49)" is loaded I 5/22/2025 11:47:53 PM: Plugin ...

I have tested it with the new version and it seems to work.
Thank you very much!

Download fresh version.
We have added option to "SQL query to CSV file" action to disable file creation if query returns empty result.

I made a rollback of the server and checked the changelog: Screenshot 2025-04-24 125541.png In my opinion the improvement is not good. I need the headers only if the query returns data. If there is no data the file should be empty. Or you should be able to choose whether the header is written even i...