Hi

We would require VCron to process and manipualte various CSV files e.g. extract data to database table and also create csv files from sql/datasets to distribute.

Is VCron a good tool to use for these requirements? I ask as I did not see any csv specific tools in the Tasks list.

If not, other products we have looked at will soon be adding CSV specific tasks to their products, is there similar scope for this in future for VCron?

Many thanks in advance

Lee

It is easy to extract data from database in CSV format. In the output tab of the SQL Task you can control the exact output format you want. Then you can decide, in other Task, what do do with it - like write it to a file.

---

ok, so just setting a delimiter on the results, sounds ok.

What about reading csv files? Any particular issues there or straight forward process also.

Apologies, I have not had a chance to have a go on the trial version.

Thanks

Lee

Hi Lee,

You can use the file read task to read the CSV file.
After that you can set up a loop which uses the output of the file read task as the input of the loop. Tasks in this loop can uses variables to get the right column values.

Sound a bit spooky, but it's easy to setup.

Regards
Erik

---