With FileSculptor you can schedule tasks to automatically convert files between CSV, XLS and XLSX formats. This guide will show how to convert files using the task scheduler from Windows.
First create a project to convert files and save it on a folder. We recommend using a folder path like C:\AutoConv to avoid issues with user permissions. In this example we created a project named autoconvert.fsc which reads the file samplecsv_small.csv and converts it to an Excel file named output.xlsx on the same folder.
Run Task Scheduler, select Task Scheduler Library and create a new task.
Give a name to the new task. If the task will run on a unattended computer, like a server, change the run option to “Run whether user is logged on or not”.
Click on Triggers tab and New button to add one or more triggers to execute the task. It might be executed daily at a given time, hourly or any other supported configuration. For this example, we configured the task to run once, at 12:30pm.
On the Run tab of FileSculptor, there is an Automation section with a Task Scheduler tab where you can find the program path and parameters to use to execute the project.
Click on Actions Tab and New button of Task Scheduler to configure the program to execute with the task. Paste the program path and parameters given by FileSculptor.
If you choose to run the task even if the user is not logged on, Task Scheduler will ask for user credentials.
Save the task and wait for it to run. In our example, we created the task at 12:25pm, scheduled a trigger to run at 12:30pm and logged out of the computer. At 12:32pm we logged on the computer again, and the task had run successfully creating the file output.xlsx. You can add more actions to the task, for example to download an updated input file or move the output file to another location.
Click here to download the AutoConvert sample project used for this guide.