Djuggler Action Reference Card

Action and functions in Djuggler version: 2.1.2

Flow Actions

If To compare variables and values. If Condition Test variables against conditions like File Exists, Folder Exists, Odd or Even number, Is Empty, etc. Else Statement to be used in If or If Condition action. End If Marks the end of an If or If Condition action. Goto Label Used in combination with Label to jump over script lines. Label Marker for the Goto Label action. Return Returns to the next line after the 'Goto Label' call.

Loops Actions

Loop Simple loop, always used in combination with the 'Exit Loop' action. Loop While Loops while a variable meets conditions like equals to, greater than, contains text, etc. Loop Condition Loop while a variable is tested against conditions like File Exists, Folder Exists, Odd or Even number, Is Empty, etc. Loop Range Loops a numeric range with a step and returns the current numeric value in a variable. Loop Files Loops a directory with a file mask and returns file names with the full path in a variable. Loop Folders Loops a directory with a file mask and returns folder names with the full path in a variable. Loop List Loops a list of variables in and returns each variable during the loop. Loop Web Pages Loops web pages with a "Next button" structure. Loop Data Grid Rows Loops the rows in a data grid and returns the current row number as a variable. Loop Data Grid Columns Loops the columns in a data grid and returns the current column number as a variable. Loop XML nodes Loop XML nodes from a given path in a XML document. Loop Matched Text Loops a text source based on a regular expression, returns the matched text and a success variable. Loop Text File Lines Loops a text source lines, returns the current line in a variable. Loop Records Loops a record set retrieved from an SQL database. End Loop Used in combination with a loop action. Exit Loop Exits a loop, typically used in combination with an if statement and the 'Simple Loop' action.

Script Control

Comment Used to place comments between script lines. Wait Pause the script for a number of milliseconds. Suppress Errors and Dialogs Used for a silent script execution without error or other dialogs. Show Errors and Dialogs Used in combination with suppress errors and dialogs. Get Last Error Text Returns the last error text in a variable. Stop Script Execution Halts the script. Pause Script Execution Pauses the script to resume in step mode and inspect variable values. Get Script Path Returns the full file path including a backslash to the current running script. Show Web Viewer Shows the internal Web browser viewer. Show Grid Viewer Shows the internal Grid viewer. Show Text Viewer Shows the internal Text viewer.

Dialogs

Show Message Shows a message dialog to the user. Input Dialog Shows a single line text input dialog to the user, the input is returned in a variable. Choice Dialog Shows a dialog with a Yes or No, the answer is returned in a variable. Open File Dialog Asks the user to point to a file and returns the file name with a complete path in a variable. Save File Dialog Asks the user for a file name and returns the file name with a complete path in a variable. Open Folder Dialog Asks the user to point to a folder and returns with the full path in a variable.

Variables

Set Variable Assigns a value to a text, date or number variable. Add to Variable Adds a value to a text, date or number variable. Subtract from Variable Subtracts a value from a text, date or number variable. Source Text to Variable Converts a complete source text to a variable. Variable to Source Text Converts a variable to a source text. Date To Text Converts a date variable to a text variable based on the locale of the system. Time To Text Converts a text variable to a date variable based on the locale of the system. Parse Date Variable Split a DateTime variable in seconds, hours, minutes, day, month and year. Generate Random Number Creates a random number in a specified range, returned as a variable. Create Guid Create a unique identifier, returned as a variable. Math Expression Provides mathematical calculations with variables like addition, subtraction, division, abs, atan, cos, exp, ln, round, sin, sqrt, sqr, trunc, etc.

Text Files

Open Text File Opens a text file as a text source. Save Text File Saves a text source to a file. Append Line to Text File Appends a value or variable to a file as new line. Append to Text File Appends a value or variable to a file without creating a new line.

Lists

Open List Open a text file and put all lines as separate items in the list variable container. Save List Save the list variable container to a text file. Add Item to List Add a new item to the list variable container. Remove Item from List Remove an item from the list variable container. Remove duplicates from List Remove all duplicate items from a list variable container. Clear List Clear the list variable container. Sort List Sort the list variable container.

XML

Create XML Document Creates an XML source object. Open XML Document Open an existing XML file in XML source object. Save XML Document Save an XML source object to a file. Get XML Root Node Get the root node in an XML source object in a Node variable. Find XML Node Finds a XML node from a path and returns a Node variable. Get XML Node Value Get the value of an XML node. Set XML Node Value Sets the value of an XML node. Get XML Child Node Value Get the value of an XML child node. Set XML Child Node Value Sets the value of an XML child node. Get XML Node Attribute Value Gets the attribute value of an XML node. Set XML Node Attribute Value Sets the attribute value of an XML node. Add XML Node Adds an XML node. Delete XML Node Deletes an XML node.

Web Pages

Open Web Page Opens a URL as an internal browser source and in the internal web browser viewer. The page source is based on the HTML document model (DOM). Open page with IE source Opens a URL as an internal web page source without downloading images, scripts, styles, etc. This source is not based on the DOM, but is similar to the Internet Explorer view source function. Run Web Macro Runs a recorded macro. Typically used to record a web login or filling a form with fixed values. Download File Downloads a url as a file and returns a success variable. Typically used for downloading documents or a page source to disk. Get URL status code Returns the status code of a web page, like 200 in a variable. Read Next Link Puts the 'src' attribute value of the next hyperlink from a web source in a variable and places the internal cursor position in the web source after the hyperlink. Read Next Link by Title Puts the 'src' attribute value of the next hyperlink from a web source in a variable based on the hyperlink title and places the internal cursor position in the web source after the hyperlink. Read Next Image Sets an image as an internal image source and returns the image name without the url path. Typically used in combination with the 'Save Image' action to save an image to disk. Save Image Saves an internal image source to disk. Get Table Content Puts a HTML table in an internal data grid. The table number references to the table tag count in the web page source (first table tag found is 1). Optionally the grid values can be stripped from HTML tags. Get Tag Content Puts the attribute name, value and content of a HTML tag in variables and places the internal cursor position in the web source after the tag. Typically used in combination with a loop action to collect data from all tags like a <DIV>.

Web Page Manipulation

Refresh Browser Source Gets the current browser source without reloading the page. Typically used to get the web page source after a dynamic event has fired and updated the HTML document model. Fill Form Field Fills a form element in a web page with a value or variable. Typically used to fill a web form programmatically. Execute JavaScript Execute a JavaScript function in a web page. Typically used to fire an onchange event in the HTML document model. Click Form Element Clicks on a form element in a web page. Typically used to set a checkbox programmatically or click on a button in a web page. Strip HTML Tags Strips all HTML tags from a variable's content. Complete Page Links Completes all hyperlinks to full URL's in an internal browser source. Typically used to change all references like './images/picture.jpg' to 'http://www.mysite.com/images/picture.jpg'.

Data Grid

Get Data Cell Value Get the value of a grid cell from an internal data grid. The grid is referenced by column and row number. Set Data Cell Value Set the value of a grid cell in an internal data grid. The grid is referenced by column and row number. Store Variables in Row Append one or more variables on a row in an internal data grid. Typically used as a quick method to save a complete record of variables to a data grid. Clear Data Grid Clears an internal data grid. Delete Data Grid Rows Deletes a complete data row in an internal data grid. Delete Data Grid Columns Deletes a complete data column in an internal data grid. Append Another Data Grid Appends one internal data grid to another internal data grid. Typically used to combine multiple data grids to one data grid for export.

SQL Database

Connect MSSQL Connect to a Microsoft SQL database server. Connect MySQL Connect to a MySQL database server. Connect Oracle Connect to a Oracle database server. Connect Informix Connect to a Informix database server. Connect DB2 Connect to a DB2 database server. Disconnect Disconnect from a database server. Query Direct Pass a SQL query to a database server.

SQL Record Set

Query for Records Execute a SQL query and return the record set in memory. Append Record Append an empty record at the end of the record set in memory. Typically used in combination with the 'Set Field' action. Delete Record Delete a record from the record set in memory. Get Field Get the field data from a record and put it in a variable. Set Field Set the field data in a record from the record set in memory. Commit Changes Apply any changes in the active memory record set to the database. Move to First Record Move the current record pointer to the first record in the active record set in memory. Move to Last Record Move the current record pointer to the last record in the active record set in memory. Move to Next Record Move the current record pointer to next record in the active record set in memory. Move to Previous Record Move the current record pointer to the previous record in the active record set in memory. Copy Query to Data Grid Copy the complete content of the active record set in memory into a data grid source.

Source Text Manipulation

Find Text in Source Search for a text in a text source and move the internal cursor position of the text source before or after the found text. Copy Text from Source Copy text from the current internal cursor position into a variable. A read until variable can be specified to copy a partial text string. Copy Text from Source Between Copy text between two strings, located from the current cursor position into a variable. Insert Text in Source Insert a text at the current internal cursor position in a text source. Replace Text in Source Replace text strings from the current internal cursor position in a text source. Match Text in Source Use a regular expression to match text strings from the current internal cursor position in a text source. The matched text is returned as a variable.

Text Manipulation

Find Text from Position Find a text in a text source from a specific cursor position. The position of the found text is returned in a variable. Copy Text from Position Copy text from a text source between two specific cursor positions. Copy Text Between Copy text from a text source between two text strings. Insert Text at Position Insert text in a text source at a specific cursor position. Replace Text Replace occurrences of a specified text string with another string in a text source or variable. Match Text Use a regular expression to match a text string in a text source or variable. The matched text is returned in a variable. Match and Replace Text Use a regular expression to replace all matched text strings with another string in a text source. Fuzzy Compare Compares two values bases on a selected fuzzy logic algorithm. Fuzzy Best Match Returns the best fuzzy match from a variable List container. Convert Text Convert a text source or variable from UTF-8 to ASCII, ASCII to UTF-8, Special HTML chars to ANSI, etc. Split Right Split text by returning the right part of a variable based on a split character or string. Split Left Split text by returning the left part of a variable based on a split character or string. Trim Trim leading and trailing spaces from a string or variable. Upper Case Upper case a string or variable. Lower Case Lower case a string or variable. Upper Case First Letter Upper case the first letter of a string or variable. Strip HTML Tags Strip all HTML tags from a string or variable.

Import/Export

Import CSV Import a CSV file into a data grid source. The separator can be specified as semi colon, comma or tab. Export CSV Export a data grid source to a CSV file. The separator can be specified as semi colon, comma or tab. Import Excel Import a Microsoft Excel file into a data grid source. A specific Excel sheet can be specified. Import Excel 2007 Import a Microsoft Excel 2007 file into a data grid source. A specific Excel sheet can be specified. Export Excel Export a data grid source to a Microsoft Excel file. Import Access Import a Microsoft Access file into a data grid source. A specific table name and password can be specified. Export Access Export a data grid source to a Microsoft Access file. Import DBF or FoxPro Import a DBF or FoxPro file into a data grid source. Export DBF Export a data grid source to a DBF file. Export SQL Script Export a data grid source to a text file containing a SQL script with grid values and structure.

File System

Copy Files Copy files on disk. A silent property is provided to suppress overwrite confirmation and error dialogs. Move Files Move files on disk. A silent property is provided to suppress overwrite confirmation and error dialogs. Delete File Delete files on disk. A silent property is provided to suppress overwrite confirmation and error dialogs. Rename File or Folder Rename files or folders on disk. A silent property is provided to suppress error and confirmation dialogs. Create Folder Creates a new folder on disk. A silent property is provided to suppress error dialogs. Copy Folder Copy a folder on disk. A silent property is provided to suppress overwrite confirmation and error dialogs. Move Folder Move a folder on disk. A silent property is provided to suppress overwrite confirmation and error dialogs. Delete Folder Delete a folder on disk. A silent property is provided to suppress overwrite confirmation and error dialogs. Get File Information Provides file information like attributes, size, creation time, file age in days, etc in variables. Get File Path Information Provides path information like file drive, path, short path 8.3 notation, file extension, file name, etc in variables.

Email

Send Mail Direct Sends a plain text or HTML email without using a SMTP relay. It will resolve the SMTP server by looking up MX records via the DNS set in the system. Send Mail by SMTP Sends a plain text or HTML email via a SMTP relay. Pictures referenced in a HTML body are automatically embedded in the message. Send Mail Raw Sends an email based on a raw message file. Typically used to process messages provided by mail servers such as the Microsoft SMTP service.

System

Run shell command Executes a shell command with parameters. The window show property can be set to normal, hidden, maximized and minimized. Pipe DOS Application Pipes the output from a DOS application to a variable. Typically used as a simple plug-in structure for Djuggler scripts. Get parameter value Gets a parameter value passed to the executable. Typically used in combination with a compiled script. Get System Folder Provides system folders from the local system like temp folder, desktop, program files, my documents, system, etc. Get System Information Puts information as computer name, user name, ip address, OS, etc into a variable. Current Date and Time Returns the current date and time in a date variable. Get Registry Data Reads a value from the Windows registry into a variable.