RoboTask forum

Dataset Loop seems to work (but don't really need a loop) the result is a single value. Now having problems with variables in the SQL statement. The insert statement works: INSERT into Lake_Test(fDate, fTime, fTemperature) values('{vDate}','{vTime}',{line(3)}) But the select statement returns "...

I need to check the data in a file to see if it exists in the database and insert the records that don't. The data is "Date", "Time", and "Temperature" and I need to see if there is already a record in the database for the "Date" and "Time" of each l...

Don't need this now. Just renaming from FILE.CSV to FILE{Year}{MonthNo}{Day}{Hours}{Minutes}.CSV. The Timestamp on the file is preserved.

FTP Sync works using remote to local.

Is there a way of getting the DateTime of a file? I have to download a file on a remote system that I have no control over and is updated every 30 minutes (the name doesn't change, just new time stamp). When I download the file I want to rename it to include the DateTime (i.e. FILE.CSV would become ...

How do you preserve the file datetime when downloading a file using FTP Download?

awesome, thanks for such a quick response. I'll give it a go later today.

I have receive a csv file (ftp download every 30 minutes) that contains temperature reading at 15 minute intervals (the first 2 lines and the last lines are blank). The reading are for the last 7 days but I only need to load any readings I don't already have, in to the database table. The reason for...

Sorry this may have been asked before, but I can't find it. I need to check a remote ftp service for a particular file. When I use the "FTP File Loop" task if I put the file name in the "Remote Folder and File Mask" box it doesn't find the file (welcome.msg). But if I put *.msg i...