TaskSculpta - Job Actions List

Alerts and Audio

• Beep - Audio sound alert.
• Siren - Play Siren sound effect.
• Blaster - Play Blaster sound effect.
• TextSpeech - Text to speech.

Checking

• DoesFileExist - Checks a specified file exists. Fails if it doesn't exist.
• DoesFolderExist - Checks a specified folder exists. Fails if it does not exist.
• CheckFileInUse - Check if a specified file is being used by another process.
• CheckInternet - Check for Internet connection / access.

Database

SQLite Database

• SQLiteConnect - Connect and open an SQLite database.
• SQliteTablesToList - Retrieve a list of tables from SQLite and put in a list variable.
• SQLiteUpdate - Perform and Update/Insert/Delete SQL statement on an SQLite Database.
• SQLiteSelectToList - Perform an SQL select statement on an SQLite database and put the results in a list variable.
• SQLiteCSVToTable - Import CSV file data to a new table in SQLite.
• SQLiteTableToCSV - Export data from an SQLite table to a CSV File.
• SQLiteDisconnect - Close open SQLIte database.
• SQLiteCreate - Create new empty SQLite database.
• SQLiteExport - Export an SQLite table to a specified file and format.

ADO Connection Databases

• ADOConnect - Make ADO database connection for other ADO tasks.
• ADOTablesToList - ADO DB Table names to list variable. Requires ADOConnect.
• ADOSelectToList - ADO SQL Select result to list variable. Requires ADOConnect.
• ADOTableToCSV - ADO Table export to CSV File. Requires ADOConnect.
• ADOTableExport - Export a table via an ADO Connection to a specified file and format.
• ADOUpdateSQL - ADO Update/Insert/Alter/Delete SQL Statements. Requires ADOConnect.
• GetADOVer - Get installed ADO version number.

Microsoft Access Database

• AccessRepComp - Access database repair and compact.
• AccessConnect - Make Access database connection for other Access tasks.
• AccessTblExport - Export a table via an Access Connection to a specified file and format.
• AccessTblsToLst - Access DB Table names to list variable. Requires AccessConnect.
• AccessUpdateSQL - Access Update/Insert/Alter/Delete SQL Statements. Requires AccessConnect.
• AccessTblToCSV - Access Table export to CSV File. Requires AccessConnect.
• AccessSelectToList - Access SQL Select result to list variable.
• AccessToSQLite - Export Access table to new table in SQLite database file. Requires AccessConnect.

DBF (dBase,Clipper, Foxpro) Database

• DBFExport - Export a DBF table to a specified file and format.

Oracle Database

• OracleConnect - Connect to an Oracle Database via the Oracle client (WIP).
• OracleDisconnect - Disconnect Oracle Database (WIP).
• OracleUpdate - Execute update script to Oracle Database (WIP).

Dialogs

• MessageBox - Shows a message box with text and or variable.
• OpenFileDialog - Open file dialog, returns filename to variable.
• SelectFolderDialog - Select folder dialog, returns folder path to variable.
• TaskDialog - Multi option dialog.
• InputVariable - Input value to variable.
• YesOrNoBox - Yes or No dialog box.

Files

• FileCopy- Copies a specified file to a specified folder.
• DoesFileExist - Checks a specified file exists. Fails if it doesn't exist.
• OpenFile - Open a file with it's associated application.
• CreateZipFile - Create a specified Zip file.
• DeleteFile - Delete a specified file.
• CreateTextFile - Creates a new text file in a specified folder.
• FileAppend - Append text to text file.
• InsBetweenTags - Insert text between two text tags in a text based file.
• InsertUnder - Insert text underneath a specified target string tag in a text file.
• INIGetValue - Get value from an INI File to a variable.
• INISetValue - Set value in an INI file.

FTP / SFTP

FTP

• FTPConnect - Make basic FTP Server Connection
• FTPChangeDir - Change remote FTP folder. Requires FTPConnect.
• FTPUpload - Upload file to FTP server. Requires FTPConnect.
• FTPDownload - Download file from FTP server. Requires FTPConnect.
• FTPDisconnect - Disconnect FTP server connection. Requires FTPConnect.

SFTP

• SFTPConnect - Make SFTP server connection
• SFTPDisconnect - Disconnect SFTP server connection. Requires SFTPConnect.
• SFTPUpload - Upload file to SFTP server. Requires SFTPConnect.
• SFTPDownload - Download file from SFTP server. Requires SFTPConnect.
• SFTPChangeDir - Change Directory on remote SFTP server. Requires SFTPConnect.
• SFTPMakeDir - Make Directory on remote SFTP server. Requires SFTPConnect.
• SFTPRemoveDir - Remove Directory on remote SFTP server. Requires SFTPConnect.
• SFTPDeleteFile - Delete a specified file on remote SFTP server.

Flow

• Section - Set a section header that you can jump to.
• JumpEquals - Jump to specified section if variable equals given value.
• Terminate - Terminate script at current location. This can be used to end a section after a jump.
• Comment - Non action comment. Useful for putting in notes on the script.
• JumpCase - Case list of variable values to jump to sections.

Folders

• CreateFolder - Create a specified folder.
• DoesFolderExist - Checks a specified folder exists. Fails if it does not exist.
• OpenFolder - Open specified folder in Windows Explorer.
• CopyFolder - Copies a specified folder to a specified path.

Imaging

• CreateQRCode - Create a QRCode containing a message or link and save to a bitmap file.
• ImageConvert - Convert a specified image to another image format.

Lists

• CreateListVariable- Create an empty list that can be populated by actions.
• ListLoad - Load a text file into a list variable.
• ListSave - Save list variable content to a specified text file.
• ListLinesReplace - Search and replace text tokens within lines in a list variable.
• Directory - Get list of files from a specified folder to a list variable.
• ListToXLSX - Saves the contents of a list variable to a basic Excel XLSX file.
• PopulateList - Populate a specified list from a static list of strings.
• ListDedupe - Duplicate lines in a list to a new list.

Network

• SendUDPText - Send text to a UDP port and IP Address.
• OpenURL - Open a URL in the default web browser.
• Ping - basic Ping an IP Address.
• DownloadFile - Download a file from the Internet.

Output

• OutputList - Output list contents to the output panel.
• OutVariables - Output created variables.
• ClearOutput - Clear output window.
• OutputMessage - Send a string or variable to the Output tab.

Programs and Scripts

• ExecuteProgram - Execute a specified program with parameters.
• PythonScript - Execute a Python Script with parameters and get result.
• VBScript - Execute a Visual Basic Script with parameters and get result.
• CMDCommand - Run CMD Prompt commands such as mkdir, ipconfig, set etc.
• PowerShell - Execute a Powershell Script with parameters and get result.

System

• GetUsername - Get User name to a variable.
• GetCompName - Get Computer name to a variable.
• GetCPUCores - Gets the number of CPU Cores. This is needed as some software charge per core.
• GetDateTime - Get Date / Time using specified format.
• CMDCommand - Run CMD Prompt commands such as mkdir, ipconfig, set etc.
• StartService = Start a specified Windows service.
• StopService - Stop a specified Windows service.
• GetGUID - Generate a GUID.
• GetUniqueName - Generate a local unique name.

WMI

• WMISelect - Execute a WMI Select statement and return the results to a list variable.

Variables

• CreateVariable - Create a variable for use is most task action properties input and outputs.
• CreateVarBatch - Create multiple variables in one action. It allows you to go back and add new variables easily.
• INISetValue - Write a value to a section item in an INI file, Useful for persisting data outside of the scripts.
• SetUserEnvVar - Create and write a value to a User system environment variable.
• GetUserEnvVar - Read a value from a User system environment variable and assign it to a script variable.
• GetWinVer - Get Windows Version info to a variable.
• GetFileVer - Get file version number to a variable.
• Inbetween - Get substring in between two string tags.
• SetVariable - Set variable value.
• INIGetValue - Get value from an item in a section of a specified INI File.

XML Files

• XMLGetValue - Get value from a specified branch in a XML file.
• EditXMLFile - Edit a specified XML file branch.