RoboTask forum

Server was previously running on VMWare Now migrated to Hyper V and the basic module cannot edit tasks E: 24/11/2021 14:45:42: Failed execute 'ExecAction with exception: Class not registered, ClassID: {10E2C785-6746-484D-9481-8B1B8D398E59}' (C:\Program Files (x86)\RoboTask\Plugins\Basic\Basic.rtp) H...

OK, each CSV file is now a single line of text. The equivalent of a single row in excel. No headers nothing. It opens fine in excel and in notepad and looks to me like a CSV file should Here's the contents of one file. 6300595,2158,Tomatin,Top compound,2018-06-04,12:32:00,John Smith,Health and Safet...

I'm in discussions with the 3rd party that produces the CSV Interestingly I've asked for date format to always be yyyy-mm-dd but I'm getting it as dd-mm-yy I've manually edited the CSV to get yyyy-mm-dd but I'll have a look at using date function of robotask *Edit* Actually I'm not getting far with ...

OK, Point 1 I'll look at later

Point 2.
I've added a textloop to process as a filelist
Each entry in file list should be assigned to CSVfile vairable

It seems to work but I'm having issues converting the csv file to date & time usage.Getting closer though

Yes that's exactly what I'm looking at. Thanks. However I've an issue saying that the file cannot be opened when trying to extract the values for ASQL upload The file does exists and the filename assigned to filelist seems to match. That variable is then used later to delete the CSV file so it can't...

Basically I get a CSV file sent in via ftp - basically 2 rows (A header and the data) It's named as Audited-DOCREF or Closed-DOCREF What I want to do it update SQL database record DOCREF with the data So it logs into sql and does a count of records number DOCREF If it find them then it deletes that ...

Great, that's exactly what's needed

Is it possible to perform calculations on variables other than increment. I'd like to subtract one variable from another, but it'snot working with set variable [Actions\Action19] ActionID=STRING|"A_VARIABLES_SET" Enabled=INTEGER|-1 Name=STRING|"Get number imported" Params=FOLDER ...

I must be missing something on the syntax of this. I've a variable - I've ticked the Assign "rows affected" into Variable and entered {COUNTBEFORE}, which a step sets to zero initially. Next step is to run the SQL SELECT ID FROM Ages which in SQL generate 600 rows or so. I've ticked the As...

Currently on V 6.8 and licensed for a couple more months
I don't like upgrading often in case my VB scripts break.

Anyone had problems with the upgrade?
Whats the standard install route - just run the exe?