Djuggler Action Reference Card

Actions in Djuggler

Flow

If Compare variables and values. If Condition Test variables against predefined conditions. If Case Test the script against certain conditions. Else Statement to be used in If or If Condition actions. End If Marks the end of an If or If Condition action. Go to Label Jumps to a Label action in the script. Label Marker for the Go to Label action. Return from Label Returns to the next script line after a Go to Label call. Procedure Marker for the Go to Execute Procedure action. End Procedure Returns to the next script line after a Execute Procedure call. Execute Procedure Jumps to a Procedure action in the script.

Loops

Loop Simple loop used in combination with the 'Exit Loop' action. Loop While Loops while a variable meets a certain condition. Loop Condition Loops while a variable is tested against a predefined condition. Loop Range Loops a numeric range. Loop Files Loops a directory and returns file names in a variable. Loop Folders Loops a directory and returns folder names in a variable. Loop List Loops a list and returns each item in a variable. Loop Data Grid Rows Loops rows in a data grid. Loop Data Grid Columns Loops the columns in a data grid. Loop XML Nodes Loops XML nodes from a specific start point. Loop XML Child Nodes Loops XML child nodes. Loop RegEx Loops the matches of a regular expression. Loop Text File Lines Loops a text file and returns the current line. 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.

Script Control

Comment Used to comment scripts. 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 action. On Error Go To Jumps to a label when the script encounters an error. Get Last Error Returns a description of the last encountered error. Clear Last Error Clears the error text found by Get Last Error. Stop Script Execution Halts the script. Pause Script Execution Pauses the execution of the script and continues in step mode. Get Script Properties Returns various script properties like the script path. Show Web Viewer Shows a web browser viewer. Show Grid Viewer Shows a Grid viewer. Show Text Viewer Shows a Text viewer. Show SQL DB Viewer Shows a Database viewer. Write To Log Appends a text line to a log file, including a date time stamp. Missing action Used when an new script is loaded in an older Djuggler version.

Dialogs

Show Message Shows a message dialog to the user. Input Dialog Shows an input dialog to the user. Choice Dialog Shows a dialog with a Yes or No. Open File Dialog Asks the user to point to a file. Save File Dialog Asks the user for a file name. Open Folder Dialog Asks the user to point to a folder.

Deployment

Progress Dialog Shows a dialog with progress information. Show HTML Dialog Shows a dialog based on HTML. Debug Trace Starts an extended log file during script execution.

Variables

Set Variable Assigns a value to a variable. Add to Variable Adds a value to a variable. Subtract from Variable Subtracts a value from a variable. Convert Variable Converts one variable type to another. Clear Variables Clears the content of one ore more variables. Validate Validate the content of a variable to meet specific conditions. Generate a Random Number Returns a random number within a certain range. Create Guid Create a unique identifier, returned as a variable. Math Expression Provides mathematical calculations with variables.

Lists

Open List Open a text file and put all lines in a list. Save List Save a list variable to a text file. Add Item to List Add a new item to the list. Get Item from List Get an item from a list by item number. Get Name Value from List Get an item from a list based on name=value. Remove Item from List Remove an item from a list. Remove Duplicates from List Remove duplicate items from a list. Clear List Clear a list. Sort List Sort a list ascending or descending.

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.

XML

Create XML Document Creates an XML source object. Open XML Document Open an existing XML file in an XML source. Save XML Document Save an XML source to a file. Get XML Root Node Put the root node of an XML source in a Node variable. Find XML Node Finds an XML node from a start node or path. 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. Do SOAP request Make a SOAP request and return the XML.

Web Pages

Get Web Page Opens a URL and return the HTML in a web page source. Post Web Page Opens a URL with the POST method. Download File Saves a URL to disk. Read Next Link Returns the URL of a Next page link. Read Next Link by Title Retruns the URL of a Next Page link based on a Next title. Read Next Image Puts the next image in an image source. Save Image Saves an image source to disk. Get Table Content Puts a HTML table in a data grid source. Get URL status code Returns the status code of a web page.

Web Pages Advanced

Wait for Content Reloads a web page until specified content appears. Refresh Browser Source Reloads a web page after a specified delay. Clear IE Cache Clears the cache of Internet Explorer. Clear IE Cookies Clears the cookies of Internet Explorer. Reset Web Page Creates a new instance for Internet Explorer. Get Frame Source Put the source of a HTML frame in a text source variable. Get IE Version Returns the Internet Explorer version in a text variable. Execute JavaScript Executes JavaScript in a Web Page source. Strip HTML Tags Strip all HTML tags from a string or variable. Complete Page Links Completes URL's to a full path in a web page source. Complete Relative URL Completes a variable with a relative URL to a full path.

Web Page DOM

Find Tag Finds a tag in the DOM tree and returns the DOM node. Find Tag Child Finds a tag in the innerHTML of a parent DOM node and returns the found DOM node. Loop Tags Loops specified tags in the DOM Loop Tag Children Loops specified tags within the innerHTML of a parent node in the DOM Get Tag InnerHTML Get the InnerHTML of a DOM node. Get Tag OuterHTML Get the OuterHTML of a DOM node. Get Tag Attribute Value Get the attribute value of a tag in a DOM node. Get Tag Text Get the Text value of a tag in a DOM node. Set Tag InnerHTML Set the InnerHTML of a DOM node. Set Tag Attribute Value Set the attribute value of a tag in a DOM node. Click Tag Click on a tag in the DOM. Get Tag Properties Get the name or id from a tag in the DOM. Reset DOMNode Pointer Set the DOM node position at the start position in the source.

Web Page Forms

Get Form Tag Value Retrieves the innerHTML of a specified FORM tag. Get Form Tag Attribute Value Retrieves the value of an attribute element from a Form tag. Set Form Tag Value Sets the innerHTML of a specified FORM tag. Set Form Tag Attribute Value Sets the value of a specified FORM tag attribute. Click Form Tag Performs a mouse click on a certain tag in an HTML page. Get Select Options Return all options from a SELECT element in a list. Set Select Option Select an option from a SELECT element.

Data Grid

Get Data Cell Value Get the value of a grid cell in a data grid source. Set Data Cell Value Set the value of a grid cell in a data grid source. Store Variable(s) in Grid Put multiple variables in a data grid source. Store Value(s) in Grid Put multiple literal values in a data grid source. Retrieve Value(s) from Grid Get multiple variables from a data grid source. Clear Data Grid Clear a data grid source. Delete Data Grid Row(s) Remove rows from a data grid source. Delete Data Grid Column(s) Remove colums from a data grid source. Append Another Data Grid Append two data grid sources. Sort Data Grid Sort a data grid source on a column. Find in Data Grid Find a string in a data grid source. Compare Grids Compare two data grid sources. Remove Duplicates from Data Grid Remove duplicates in a data grid source.

SQL Database

SQL Connect Open a connection to a SQL database. SQL Disconnect Disconnect a database connection. SQL Query Execute a SQL query on a database connection. Append Record Append an empty record at the end of the record set. Delete Record Delete a record from the record set. Get Field Value Get a field value in the active current record. Set Field Value Set a field value in the active current record. Move to First Record Move the current record pointer to the first record in the active record set. Move to Last Record Move the current record pointer to the last record in the active record set. Move to Next Record Move the current record pointer to next record in the active record. Move to Previous Record Move the current record pointer to the previous record in the active record. Start Transaction Set a start transaction marker in the database. RollBack Transaction RollBack the last transaction. Commit Transaction Commit a transaction to the database. Copy Records to Data Grid Copy the content of an active record set into a Data Grid source.

Source Text Manipulation

Find Text in Source Search for a string 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. Copy Text from Source Between Copy text between two strings, located from the current cursor position. Insert Text in Source Insert a string at the current internal cursor position in a text source. Replace Text in Source Replace strings from the current internal cursor position in a text source. Match Text in Source Use a regular expression to match strings. Reset Text Position Cursor Set the text position cursor at the start position in the source.

Text Manipulation

Replace Text Replace occurrences of a specified string with another string. Find Text from Position Find a text in a text source from a specific cursor position. 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. Split Right Split the right part of a variable on a split character. Split Left Split the left part of a variable on a split character. Trim Trim leading and trailing spaces from a 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 in a variable. Strip HTML Tags Strip all HTML tags from a string or variable.

Text Formatting

Format Number Formats a number variable. Convert Text Convert a text source or variable from UTF-8 to ASCII, ASCII to UTF-8, Special HTML chars to ANSI, etc. Locale Settings Sets the locale settings for the script. Convert to Number Convert a Text variable to a Number variable. Convert to Date-Time Convert a Text variable to a DateTime variable. Create Hash Creates a hash value from one or more variables.

Text Matching

Match RegEx Matches a regular expression in a variable or source. Match and Replace RegEx Matches a regular expression and replaces all occurrences of the matches. Fuzzy Compare Compares two values bases on a selected fuzzy logic algorithm. Fuzzy Best Match in List Finds the best fuzzy match of a string in a list variable. Fuzzy Best Match in Data Grid Finds the best fuzzy match in a data grid column.

Date and Time

Set Date-Time Set the value of a Date-Time variable. Get current Date-Time Returns the current date and time. Format Date-Time Formats a Date variable in a specific format. Extract from Date-Time Returns the day, month, year, hour, minutes and seconds as variables from a date variable. Add to Date-Time Adds days, months, years, minutes and/or seconds to a Date-Time variable. Subtract from Date-Time Substract days, months, years, minutes and/or seconds from a Date-Time variable. Date-Time Span Returns the time span from two Date-Time variables. Date-Time Fractional Span Returns the time span with a fraction from two Date-Time variables. Day of the week Returns the day name and day number in the week of a given Date-Time. Day of the month Returns the day name and day number of the month of a given Date-Time. Day of the year Returns the day name and day number of the year of a given Date-Time. Month of the year Returns the month name and month number of the year of a given Date-Time.

Import & Export

Import CSV Import a CSV file into a data grid source. Export to CSV Export a data grid source to CSV. Write Line to CSV Append a CSV record to a text file. Import Excel Import a Microsoft Excel file into a data grid source. Export to Excel Export a data grid source to Microsoft Excel. Import Excel 2007 Import a Microsoft Excel 2007 file into a data grid source. Export to Excel 2007 Export a data grid source to Microsoft Excel 2007. Import Access Import a Microsoft Access file into a data grid source. Export to Access Export a data grid source to Microsoft Access. Import DBF or FoxPro Import a DBF or FoxPro file into a data grid source. Export to DBF Export a data grid source to DBF. Export to SQL Script Export a data grid source to SQL Script

File System

Copy File(s) Copies files on disk. Move File(s) Moves files on disk. 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. Create Folder Creates a new folder on disk. Copy Folder Copy a folder on disk. Move Folder Move a folder on disk. Delete Folder Delete a folder on disk. Get File Information Returns file information like size, file age, etc. Get File Path Information Returns path information like file drive, short path, etc.

Email

Send Mail Direct Sends a plain text or HTML email without using a SMTP relay. Send Mail by SMTP Sends a plain text or HTML email via a SMTP relay. Send Mail Raw Sends an email based on a raw message file.

System

Run shell command Executes a Windows shell command. Pipe DOS Application Pipes the output from a DOS application to a variable. Get Parameter Value Read a command line parameter provided to a compiled executable script. Close Window Close a Windows program based on a window title. Get System Folder Get the file path for system folders like the temp folder, etc. Get System Information Get information as computer name, user name, ip address, etc. Windows Clipboard Get or set a value in the Windows clipboard. Get Registry Data Reads a value from the Windows registry.

Deprecated

Open Web Page Source Deprecated action, replaced by Get Web Page. Get Table Content Deprecated action, replaced by Get Table Content. Read Tag Content Deprecated action, replaced by Web Page Interaction actions. Fill Form Field Deprecated action, replaced by Set Form Element Value. Date to Text Deprecated action, replaced by Convert Variable. Time to Text Deprecated action, replaced by Convert Variable. Convert Source Text to Variable Deprecated action, replaced by Convert Variable. Convert Variable to Source Text Deprecated action, replaced by Convert Variable. Get Element Value Retrieves the innerHTML of a HTML element. Get Element Text Retrieves the innerHTML of a HTML element. Get Element Attribute Value Retrieves an attribute value of a HTML element. Set Element Value Set the innerHTML of an HTML element. Set Element Attribute Value Set the attribute value of a HTML element. Click Element Performs a click on a HTML element. Connect to MSSQL Open a connection to a Microsoft SQL database. Connect to MySQL Open a connection to a MySQL database. Connect to Oracle Open a connection to a Oracle database. SQL Query for Records Return a SQL query in a record set.