Compares two variables or sources.

If the comparison succeeds, the script actions between the If and End If script lines are executed. The If action can also be used in combination with an Else action.

Tip: The wildcard '*' can be used in a string compariment.

 

Test a "Variable" against a certain condition, like Is Empty, Contains Text, Equal To, Exists in List, etc.

If the comparison succeeds, the script actions between the If Condition and End If script lines are executed. The If Condition action can also be used in combination with an Else action.

Tip: Use this action to verify if a variable is empty, or a file exists or is a positive number, etc.

 

Test the script against a certain condition, like Is Online, Is Compiled Script, etc.

If the comparison succeeds, the script actions between the If Case and End If script lines are executed. The If Case action can also be used in combination with an Else action.

Tip: Use this action to verify if the computer executing the script has an active Internet connection.

 

The Else action can be used in conjunction with an If or If Condition action.

When the If action fails, the lines between Else and End If are executed.

 

The End If action closes an If, If Case or If Condition block.

Structure example:

If ...
... do actions ...
Else
... do actions ...
End If

 

Jumps to a Label action in the script and executes lines from there until a Return action is encountered.

The "Label name" property value should match the exact name of the label to jump to. Use the Return action to jump back to the script position where Go to Label was called.

Note: A Stop Script Execution action may be needed to prevent the script from running into a label without being called by a Go to Label action.

 

The Label action is used as a marker in combination with the Go to Label action.

The Go to Label action can be used to jump to a Label action and resume execution from there. Use the Return action to jump back to the script position where Go to label was called.

Note: Make sure the names in both actions match exactly else the action will be ignored.

 

Use the Return action to indicate the end of label and jump back to position where the Label was called with a Go to label action.

 

The Loop action is a simple infinite loop untill the action Exit Loop is called.

All actions between the begin of the loop and end of the loop are processed infinitely.

Note: An End Loop action is needed to close the loop script logic and an Exit Loop to exit the loop.

 

The While Loop will loop actions while a specified condition is valid and exits automatically when the condition is invalid.

Note: An End Loop action is needed to close the loop in the script logic.

 

The Condition Loop will repeat actions in the loop while a specified condition is valid and automatically exit the loop when the condition is invalid.

Note: An End Loop action is needed to close the loop in the script logic.

 

Loops through a preset numerical range.

The looping process starts with Start Value and will stop when it reaches the Stop Value. With each loop, the Start Value gets incremented by the Step property. The Current Value variable returns the current step value.  If Start Value is larger then Stop Value, the loop will count down.

Note: An End Loop action is needed to close the loop in the script logic.

 

Loops file names in a directory and returns found file names in the "File name" variable. Looping continues until no more files are found.

Note: An End Loop action is needed to close the loop in the script logic.

 

Loops folder names in a directory and returns found folder names in the "Folder name" variable. Looping continues until no more folders are found.

Note: An End Loop action is needed to close the loop in the script logic.

 

Loops Web Pages with a typical "Next" button. The "Next Page Button Recorder" is used to identity a "Next" page button.

A Loop Web Pages action should always be proceeded by a Get Web Page using the DOM source to set the initial Web Page in which the click to the next page is performed.

Tip: The source obtained by Loop Web Pages is the DOM source and might slightly differ from source obtained via the "view source option" in Internet Explorer or other browsers. The Read Next Link by Title action in combination with a simple Loop action can be used as an alternative for the Loop Web Pages action using the HTML source.

 

Web pages with a next page structure like: "1|2|3 >Next" can be looped until the last page using this action. The Next link is identified using the Button recorder behind the three dots. The recorder opens in a new browser window.

Using the Next Page Button Recorder:
1. Put the URL for the first page in the navigation edit box and press the "Go" button. The first page with the Next link structure is loaded in the browser pane.
2. Press the Record button on the right and then click on the Next link in the actual browser pane. The HTML tag identifing the Next link is shown on the right pane.
3. Press the Save Recording and Exit button to save the recording and close the browser window.

Loops all items in a List variable and passes them on to a Text variable.

The loop starts with the first item in the List and stops at the last item. An End Loop action is needed to close the loop in the script logic.

Tip: To loop a sorted list, use the Sort List action before the loop.

 

Loops through all the rows in a data grid.  The first row in a data grid has the number 1. 

The "Current Row" variable returns the current row number, and can be used in actions like Get Date Cell Value to get the content of data grid fields. An End Loop action is needed to close the loop in the script logic.

Tip: To loop a sorted data grid, use the Sort Data Grid action before the loop.

 

Loops through all the columns in a data grid. The first column in a data grid is has the number 1.

The "Current Column" variable returns the current column number, and can be used in actions like Get Date Cell Value to get the content of data grid fields. An End Loop action is needed to close the loop in the script logic.

 

Loops nodes in the xml tree from a specific start point. Optionally returns only nodes with a specific name or path.

Tip: The "Look for" property can be a Node name or (partial) Node path. Path notation is with forward slashes like: 'books/book'.

 

If the complete XML tree is to be looped, use the root node as starting node.

When "Look for" is defined as 'book' the loop will pass all nodes named 'book' to the "Result Node" variable, regardless of where they are from the starting point in the tree.
When "Look for" is defined as 'books/book' all "book" nodes will be returned that reside directly under a parent node named 'books'.

 

Loops child nodes in the xml tree from a specific start point (not recursively, only the child nodes under the starting point).

Optionally returns only nodes with a specific name. If the Name property is not specified, all child nodes are returned.

 

Loops through all the matches of a regular expression and with each loop a match result is returned in the "Returned Match" variable. If there is no more match the loop ends.

Note: When sub expressions are used in the regular expression, a sub expression number should be specified for the returned match variable. 0 means the complete match.

 

Reads a text file in a text source and loops though all the lines. With each pass the "Read Line" variable returns a line that was read from the file. An "End Loop" action is needed to close the loop in the script logic.

Note: For performance reasons the content of the Text File source is not shown in the Text Viewer.

 

Loops all records in a record set related to a SQL database connection. This action needs to be combined with the SQL Query for Records action.

The loop starts with the first record in the record set and runs until the last record is reached.

Note: When the loop finishes it will apply any changes made in the record set to the database automatically.

 

When using a record set, use the following basic structure:

Connect
SQL Query for Records
Loop Records
... actions like Get Field Value...
End Loop
Disconnect

Each Loop action needs an End Loop action to indicate the end of the loop.

Structure example:

Loop While ...
 ... actions ...
End Loop

 

Forces an exit in a loop and is often used in combination with an If or If Condition action.

 

Comments are used to place notes in a script and make a script more readable.

Tip: Use empty comments to separate blocks of code for clarity.

Note: A Comment action is excluded from the script action execute count.

 

Puases the execution of the script for a number of miliseconds.

Property "ms" should contain the number of milliseconds the script should pause.

 

Suppresses all error dialogs and show message dialogs. All feedback to the user in the form of message dialogs that halt the execution of the script are suppressed.

This action is typically used in compiled executable scripts that run on stand alone servers.

Note: The Show Errors and Dialogs action will re-enable dialogs again.

 

Enables all error dialogs and user dialogs after a Suppress Errors and Dialogs action.

 

Jumps to a specified label when the script encounters an error.

Tip: When the Supress Errors & Dialogs action is used this action can be used to catch and handle script errors.

 

Fills the "Last Error variable" with a description of the last encountered error.

Tip: When the Supress Errors & Dialogs action is used this action can be used to catch and handle script errors.

 

Clears the error text found by the "Get Last Error" action.

 

Stops the execution of the script.

Typically used before Label actions or when the script encounters a condition it should stop at all times.

 

Pauses the execution of the script and continues in step mode. This action is typically used in a debug situation.

Note: In a compiled script this action is ignored.

Tip: Inspect the content of variables and sources when paused by clicking the Step button. The script can be resumed with the Resume button in the menu bar controls.

 

Returns various script properties like the script path, script name, build version. It it also reveils information about the Djuggler version and edition used to create the script.

 

Shows or hides up Djuggler's internal web viewer.

Note: This action is typically used in a debug situation.

 

Shows or hides up Djuggler's internal grid viewer.

Note: This action is typically used in a debug situation.

 

Shows or hides up Djuggler's internal text viewer.

Note: This action is typically used in a debug situation.

 

Append a text line to a log file, including a date time stamp.

Note: This action is typically used in a debug situation.

 

When a script is loaded that is created by a more recent version of Djuggler a missing action statement will replace all unkown actions from the new Djuggler version.

 

Displays a text message in a message box.

Note: The Script will be paused until a user presses the OK button in the message box.

 

Presents an input box with a single text line.

The "Answer" variable will contain the answer the user has typed in in the input box.

 

Presents the user with an dialog for Yes or No.

The "Answer" variable will contain the answer Yes or No.

Note: When using a If action to verify the "Answer" variable, compare to 'Yes' or 'No' (case sensitive).

 

Shows an open file dialog asking the user to choose a file.

The file will be passed on to the "Answer" variable and contains the fully qualified path with directory and File name.

 

Shows a save file dialog asking the user to choose a file.

The file will be passed on to the "Answer" variable and contains the fully qualified path with directory and File name.

 

Shows a dialog asking the user to choose a directory.

The directory path will be passed on to the "Answer" variable. It will contain a fully qualified directory, trailed by a backslash ("\").

 

Shows a dialog with an optional progress bar.

This action is typically used for compiled executable scripts.

Tip: The Loop rows action contains a property Total number of rows that can be used for Maximum Value property in this action.

 

A custom dialog in HTML used for advanced input controls or as a HTML viewer.

Note: Only a HTML form submit will close the dialog and continue the script when the mode is set to INPUT.
All form values are returned in a List variable. The post url for the form can be anything like "#" or leave it empty like "".

Tip: Use the Get Name Value from List action to access individual values from the form post data.

 

Starts a trace containing all executed action and variables. Typically used to debug a deployed script.

 

Replaces the current content of a variable.

 

Adds to the content to a variable.

Adding is done differently for each variable type. If the variable is text, the content is appended to the current text in "Variable". If the variable is a number, the content is added arithmetically.

 

Subtracts from a variable.

Subtracts are done differently for each variable type. If the variable is text, the content is subtracted from the current text in "Variable". If the variable is a number, the content is subtracted arithmetically.

 

Converts one variable type to another, like a number variable to a text variable.

Tip: A cursor position can only be remembered in source, like a Web Page or Text Source. Use this action to convert a Text variable to a Text Source.

 

Clears the content of one ore more variables.

Note: Number variables will be set to 0, date variables will get the date 12/30/1899 when cleared.

 

Validate the content of a variable to meet specific conditions, like is a number or is not empty, or matches a regular expression, etc.

When the validation fails the action can jump to a Label or write to a log file.

Tip: Use this action to verify the content of variables before writing them to any output as a database or file.

 

Returns a random number within a certain range.

When the range is set to a minimum 1 and the maximum to 5, the action chooses a number randomly between 1 and 5.

 

Returns a Globally Unique Identifier as a text variable.

Tip: Guid's are typically used to create a unique identifier in a Data Grid or as file name for example.

 

This action can be used for mathematical calculations.

A few examples of valid expressions: "4+2", "sqrt(9)", "(4+2)/sqrt(9)".

 

Within the expression, Djuggler variables can be used by putting the variable name between square brackets.
Example: if the script contains a number variable named "Number1", it can be used in the expression like "(4+2)/sqrt([Number1])".

Operators that can be used:
+ : Addition
- : Subtraction
* : Multiplication
/ : Division
^ : Exponential (only positive numbers for the base)
( : Open parenthesis
) : Close parenthesis

Functions that can be used:
ABS (Range: -1e4932..1e4932)
ATAN (Range: -1e4932..1e4932)
COS (Range: -1e18..1e18)
EXP (Range: -11356..11356)
LN (Range: 0..1e4932)
ROUND (Range: -1e9..1e9)
SIN (Range: -1e18..1e18)
SQRT (Range: 0..1e4932)
SQR (Range: -1e2446..1e2446)
TRUNC (Range: -1e9..1e9)

Reads a Text file and places the content of each text line as a collection item in the "List variable".

 

Stores the items of the "List variable" in a text file.

Note: Each item is stored on a new line in the text file.

 

AAdds an item to a "List variable". New items will be placed at the end of the list.

 

Get an item from a "List variable" by the item number.

Note: The first item in the list has the number 1.

 

Gets the value part based on the name part of a item from a "List variable". 

When list items are stored as a name-value combination separted by an equal sign, like for example: "color=red", color is the name part and red is the value part.
This action will return the value part when the name part is given and is typically used in combination with an Advanced HTML dialog action.

 

Removes an item from a "List variable".

Note: If there are more than one matches to the item, only the first occurring item in the list is removed!

 

Removes duplicated items from a List.

After executing this action, only unique items remain.

 

Removes all the items from a List.

After executing this action, the list will be empty.

 

Sort the items in a List.

Lists can be sorted ascending or descending, depending on the value set in the "Direction" property.

 

Opens a "Text file" and places the content in the Text source.

 

A Text File source can be manipulated by Text Manipulation and Source Text Manipulation actions.

Saves a "Text File" source to a file.

 

A Text File source can be manipulated by Text Manipulation and Source Text Manipulation actions.

Appends a line to a text file.

The property "Text" is written to the end of the file. This action works directly on the file, there is no need to use the Open Text File first.

Note: Use the Append to Text File action to append text without a new line.

 

Appends the property "Text" to a text file.

The text is appended to the end of the file without a new line. This action works directly on the file, there is no need to use the Open Text File first.

 

Create a new "XML Document" in memory that can be saved later.

Provide a document source as reference to the XML document. If the "Root Name" property is set, the document root node will have that name, else "xml" will be used.

When a XML node variable is provided in the "Result Node" property it can be used as a reference node to do further processing, like adding a node to the root node.

 

Opens an XML Document from a file.

The XML file is opened into the "XML Document source".

 

Saves an XML Document source to a file.

 

Returns the root of the "XML document" in a XML node variable.

Tip: Use the found root node in combination with the Add XML node action to add a new node under the root node for example.

 

Finds a single XML node in the xml tree from a specific start point based on Node name or Node path.

The "Look for" property can be a Node name or (partial) Node path. Path notation is with forward slashes like: 'books/book'.

 

Tip: If the complete XML tree is to be looped, use the root node as starting node.

When "Look for" is defined as 'book' the loop will pass all nodes named 'book' to the "Result Node" variable, regardless of where they are from the starting point in the tree.
When "Look for" is defined as 'books/book' all "book" nodes will be returned that reside directly under a parent node named 'books'.

 

Returns the value of a XML node in a text variable.

 

Sets the value of an XML node, optionally as CDATA.

Note: When setting a value in default format special characters as '>' will be translated automatically.

 

Returns the value of a child node from an XML parent node in a text variable.

Tip: Use this action in combination with the Find XML node to set the parent node for example.

 

Sets the value of a child node from a parent XML node, optionally in CDATA.

 

Returns an attribute value of a XML node.

 

Sets an attribute value of a XML node.

 

Adds a new XML node to a parent XML node and returns the added node in a XML node variable.

 

Deletes an XML node.

 

Deletes an XML node.

 

Sends a SOAP request to a server and waits for the SOAP response in XML format.

 

Opens a Web Page and puts the HTML content in the Web Page source as DOM or HTML source. The DOM source enables advanced actions like Click Form Element. The HTML source is the raw html as served by a web server.

HTML source is faster then the DOM source because only requests the source from a web server and won't request pictures, style sheets, etc. Note that the DOM source and HTML source have minor differences in the HTML like the usage of quotes and the tag attribute order.

Tip: To inspect the source, use the Djuggler's Inspector from the menu and the Inspect button.

 

Opens a Web Page by the Post method and returns the HTML in a Web Page source.

The Post Data property should contain variables separated by ampersants like: "age=28&gender=male".

Tip: When the post data contains special characters like spaces, the post data should be URL encoded with the Convert Text action.

 

Records and automates an entire "manual" browse action, complete with typed urls, mouse clicks and filled form fields.

The Web Inspector is launched in Recorder mode by clicking on the three dots behind the recorder property. The browse recording is started by clicking the Record button, followed by clicking the Stop button and Close.

When running a script, the exact sequence of events is replayed on the Web Page variable in this action. Note that this browsing is done from the current page in the Web Page variable.

 

Downloads a file, document, image or Web Page source and saves it to disk.

Note: When a non existing file is specified, the browser source returned by the server will be downloaded as document, typically 404 information. Use the Get URL status code action to verify if a file really exists.

 

Reads the next hyperlink ('A' tag) in a Web Browser source and returns the "URL" and "Title" of the hyperlink.

Note: This action moves the source cursor position in the Web Page source like the Source Text Manipulation actions.

Tip: Use this action in a loop to collect all hyperlinks in a Web Page.

 

Searches for a text in a Web Page source and returns the nearest URL in a variable.

Tip: Use this action to find a typical 'Next page' link by searching for a text like 'Next >'.

 

Searches a "Web Page" source for the next image and returns it as "Image" variable.

The Save Image action can save the image variable. The name of the found image is returned in the "Image Name" variable.

Note: This action moves the source cursor position in the Web Page source like the Source Text Manipulation actions.

Tip: Use this action in a loop to collect all images in a Web Page.

 

Save an Image variable to disk. Typically used in combination with the Read Next Image action.

Note: When the File name is not specified, the File name from the image is used.

 

Puts data from a HTML table in a "Data Grid" source, based on table number or table that contains a specific text string.

The "Table Number" variable to indicates the HTML table to use. For example Table Number 3 will collect data from the thrid <TABLE> tag found in the HTML. As an alternative a table can be found based on a unique text string.

NOTE: This action uses the DOM source and won't work on a Get Web Page by HTML source!

 

Returns the status code of a URL. For example 404 if the page can not be found.

The "Is URL valid" property can be used to verify if a URL has a valid syntax. Yes or No is returned.

 

Refresh the browser source until content appears or disappears.
This action is typically needed after an AJAX event.

Note: Either the appear text or disappear text can be set, but don't set both at the same time.

 

An AJAX event requests a partial update of a webpage from the web server that will alter the source after the complete page has been requested. The Wait for Content action assists in detecting when the AJAX event has completed by waiting until a know text has appeared or disappeared in the browser source.

Get the Web Page's source after a delay without reloading the Web Page.

Tip: As an alternative the Wait for Content action can be used to refresh the browser source after an AJAX event.

 

Use this action to obtain any changed HTML source due to dynamic reloading of the Web Page after an AJAX event for example.

Clears the Internet Explorer Cache.

Note: This action will also clear the cache for the regular IE browser.

 

Clears all Internet Explorer Cookies.

Note: This action will also clear the cookies for the regular IE browser.

 

Resets a webpage source.

Tip: Use this action to clear a server side session with a Web Page source.

 

Puts the Internet Explorer version in a text variable.

Tip: IE6 and IE7+ have a different DOM source. Scripts that work in IE7+ will not necessarily work in IE6. Verify the IE version with this action when creating scripts for others.

 

Executes JavaScript in a Web Page source. This can either be an existing JavaScript function found in the HTML source or JavaScript in the action property.

Tip: The Execute JavaScript is used in combination with the Refresh Browser Source or Wait for Content action to handle AJAX enabled web sites. See the AJAX demo scripts.

 

Removes all HTML tags from a text or variable with only the actual readable text as result.

Tip: To remove all tags from a HTML source, convert the Web Page source to a text variable by using the Convert Variable action.

 

Completes all links (a href's) in a Web Page source's content.

Example: A link like "./support/index.htm"; would be translated into something like "http://www.mysite.com//support/index.htm".

 

Tip: Calling Get Web Page after a Complete Page Links action refills the Web Page source, so to complete all links in the new page, you would have to call Complete Page Links again.

Completes a relative URL to a full URL.

 

Example: "./support.asp" is completed to "http://www.djuggler.com/support.asp".

Note that completion of a URL depends on the Web Page where it was obtained from. Always use the correct Web Page source to complete a URL.

Retrieves the value (innerHTML) of a specified HTML tag. You can specify tag attribute/value combinations to indicate a specific tag.

If more than one tag matches the specifications the value of the first matching tag is returned.

 

Example:
The HTML contains a tag "<TD width=36><b>some content</b></TD>".
To retrieve this tag's content, you should specify the Tag Name as "TD", Attribute Name as "width" and Attribute Value as "36". In the Result Variable, "<b>some content</b>" will be returned.

Retrieves the value (innerText) of a specified HTML tag. All HTML within the tag's content is stripped. You can specify tag attribute/value combinations to indicate a specific tag.
If more than one tag matches the spcifications, the value of the first matching tag is returned.

 

Example:
The HTML contains a tag "<TD width=36><b>some content</b></TD>".
To retrieve the tag's content, specify the Tag Name as "TD", Attribute Name as "width" and Attribute Value as "36". In the Result Variable, "some content" will be returned.

Retrieves an element attribute value of a specified HTML tag. 
If more than one tags match the specification, the value of the first matching tag is returned.

 

Example:
The HTML contains a tag "<table id=table1 width=300>".
To retrieve the attribute width value, specify the Tag Name as "TABLE", Attribute Name as "id" and Attribute Value as "table1". Result Attribute Name as "width" and in the Result Variable, "300" will be returned.

Searches the first tag that matches the Tag Name, Attribute Name and Attribute Value. With the found tag, the the value (innerHTML) is set.

Tip: If you want to set an INPUT tag value like a typicall username box, use the Set (Form) Element Atribute Value action.

Note: You can also leave empty the first Attribute Name and Attribute Value just to match on Tag Name.

 

Example:
The HTML contains a tag "<TD width=36><b>some content</b></TD>".
To set this tag's content, you should specify the Tag Name as "TD", Attribute Name as "width" and Attribute Value as "36". In Content you could set "other content", and the tag will then read "<TD width=36><b>other content</b></TD>".

Searches the first tag that matches the Tag Name, Attribute Name and Attribute Value. Optionally, a 2nd and 3rd Attribute Name and Value is matched as well. When the tag is found, the value of the Attribute Name to set content for is set with Content. Be aware that more than one tag can match the specifications, so be as specific (use more attributes) as you can.

 

You can also leave empty the first Attribute Name and Attribute Value just to match on Tag Name.

Example:
The HTML contains a tag "<TD width=36 height=3><b>some content</b></TD>".
To set this tag's content, you should specify the Tag Name as "TD", Attribute Name as "width" and Attribute Value as "36". If you set Attribute Name to set content for to "height" and Content to "6", and the tag will then read "<TD width=36 height=6><b>other content</b></TD>".

Searches the first tag that matches the Tag Name, Attribute Name and Attribute Value. Optionally, a 2nd and 3rd Attribute Name and Value is matched as well. When the tag is found, a mouse click on the element is performed. Be aware that more than one tag can match the specifications, so be as specific (use more attributes) as you can.

You can also leave empty the first Attribute Name and Attribute Value just to match on Tag Name.

 

Retrieves the value (innerHTML) of a specified FORM tag. You can specify tag attribute/value combinations to indicate a specific tag.
If more than one tag matches the spcifications, the value of the first matching tag is returned. This action is similar to Get Element Value, but additionally you can specify form attributes (typically name="form1") to indicate the form. This makes this action more specific in indicating the right tag.

Example:
The HTML contains a tag "<form name="form1"><textarea rows="2" cols="20">a text line</textarea></form>".
To retrieve this tag's content, you should specify the Tag Name as "textarea", Form Attribute Name as "name" and Form Attribute Value as "form1", Attribute Name as "rows" and Attribute Value as "2". In the Result Variable, "a text line" will be returned.

 

Retrieves the value of an attribute element from a Form tag.

If more than one tag matches the spcifications, the value of the first matching tag is returned.

This action is similar to Get Element Attribute Value, but in addition a specific form can be specified.

 

Example:
The HTML contains <form id="form1"><input type=text id="firstname" value="John"></form>.
To retrieve the input value John, properties should be used like:
Form Attribute Name with "id" and Form Attribute Value with "form1", Tag Name with "input", Attribute Name with "id", Attribute Value with "firstname" and Result Attribute Name with "value". In the Result Variable, "John" will be returned.

Sets the value (innerHTML) of a specified FORM tag. You can specify tag attribute/value combinations to indicate a specific tag.
If more than one tag matches the specifications, the value of the first matching tag is returned. This action is similar to Set Element Value, but additionally you can specify form attributes (typically name="form1") to indicate the form. This makes this action more specific in indicating the right tag.

Example:
The HTML contains a tag "<form name="form1"><textarea rows="2" cols="20">a text line</textarea></form>".
To retrieve this tag's content, you should specify the Tag Name as "textarea", Form Attribute Name as "name" and Form Attribute Value as "form1", Attribute Name as "rows" and Attribute Value as "2" and the Result Variable with "new line". The HTML in the web document will be changed to "<form name="form1"><textarea rows="2" cols="20">new line</textarea></form>".

 

Sets the value of a specified FORM tag attribute. You can specify tag attribute/value combinations to indicate a specific tag.
If more than one tag matches the specifications, the value of the first matching tag is returned. This action is similar to Set Element Attribute Value, but additionally you can specify form attributes (typically name="form1") to indicate the form. This makes this action more specific in indicating the right tag.

Example:
The HTML contains a tag "<form name="form1"><input type=text id="firstname" value="John"></form>".
To retrieve this tag's content, you should fill in the Tag Name with "input", Form Attribute Name with "name" and Form Attribute Value with "form1", Attribute Name with "rows", Attribute Value with "2", Attribute Name to set with "firstname" and the Result Variable with "Simon". The HTML in the web document will be changed to read: "<form name="form1"><input type=text id="firstname" value="Simon"></form>".

 

Performs a mouse click on a certain element in an HTML page. Typically used to click on a submit button programmatically.

Tip: The Djuggler Web Inspector can inspect the tag information needed for this action.

 

Gets all options from a SELECT element on a form and puts them in a list. This way you can build a loop that iterates all options in a SELECT dropdown. The action returns a list of option values and a list of option descriptions.

 

Example:
<select name="cardropdown">
  <option value="1">Volvo</option>
  <option value="2">Saab</option>
  <option value="3">Mercedes</option>
  <option value="4">Audi</option>
</select>
To get all options, fill in SELECT Name with "cardropdown". Two list will be returned: Option List containing "1,2,3,4" and Description List containing "Volvo,Saab,Mercedes,Audi".

Select a option from a SELECT element on a form. This way you can change a SELECT dropdown in a Web Page. Use either the option value or the option description to indicate which option you wish to select.

 

Example:
<select name="cardropdown">
  <option value="1">Volvo</option>
  <option value="2">Saab</option>
  <option value="3">Mercedes</option>
  <option value="4">Audi</option>
</select>
To select an option, fill in SELECT Name with "cardropdown" and set Option Value to "2". The SELECT dropdown will be set to "Saab". Alternatively, you can set Option Description to "Saab" with the same effect.

Copy the value of a Data Grid cell into a variable.

Note: Rows and Column numbers start at "1".

Use the Row and Column variables to specify the cell. 
For example, using Row:2 and Column:3 would get the content from the cell located at the second horizontal row and the third vertical column.

 

Copy the value of a variable into a Data Grid cell.

Note: Rows and Column numbers start at "1".

Use the Row and Column variables to specify the cell. For example, using Row:2 and Column:3 would set the content in the cell located at the second horizontal row and the third vertical column.

 

Stores one or more variables into a Data Grid source. The variable name is used as field name.

If a field name already exists, the corresponding column is used to store the variables data. If the field name is new, a new data column is used.

If more then 6 variables need to be stored in on a single row in the Grid, use a second action and set the Where to Store property to Use current row.

Stores one or more literal values into a Data Grid.

Note: When more then 10 values need to be set, use a second action and set the property Where to store to: Use current Row and Start at column nr 11.

Tip: This action is typically used to create a row header in a Data Grid.

 

Retrieve one or more values from a Data Grid source.

Note: Rows and Column numbers start at "1".

 

Clears the Data Grid.

Note: Data Grids are only limited in data capacity by the available memory in the computer. However when using the Show Grid Viewer action on a large data grid, performance of the script will be greatly reduced due to the limitation of screen/graphics memory.
 

Deletes row(s) from a Data Grid. The Row variable determines which row(s) to delete.

Example: "1,2" deletes rows 1 and 2 and "2-4" deletes rows 2,3 and 4.

Note: Always keep numbers in succession, from low to high. Use comma's to separate row numbers, dashes (-) to indicate a row range. Do not use spaces.

 

The Row property indicates the row number that must be deleted. "2" means the second row in the Data Grid will be deleted.

Multiple rows can be deleted like: "1-4" will delete row 1 through 4 in the Data Grid. "1,2,3,4" does the same.

Example: "1,2,4-6" deletes rows 1, 2, 4, 5 and 6.
Example: "1-2,7-8" deletes rows 1, 2, 7 and 8.

Deletes column(s) from a Data Grid. The Column variable determines which column(s) to delete.

Example: "1,2" deletes columns 1 and 2 and "2-4" would delete columns 2, 3 and 4.

Note: Always keep numbers in succession, from low to high. Use comma's to separate row numbers, dashes (-) to indicate a row range. Do not use spaces.

 

The Column property indicates the column number that must be deleted. "2" means the second column in the Data Grid will be deleted.

Multiple columns can be deleted like: "1-4" will delete column 1 through 4 in the Data Grid. "1,2,3,4" does the same.

Example: "1,2,4-6" deletes columns 1, 2, 4, 5 and 6.
Example: "1-2,7-8" deletes columns 1, 2, 7 and 8.

Example: "1,2,4-6" deletes columns 1, 2, 4, 5 and 6.6.
Example: "1-2,7-8" deletes columns 1, 2, 7 and 8.

Appends one Data Grid to the other.

The "Data Grid to append" property indicates the grid that gets appended to the "Data Grid" variable.

Note: The data is appended at the end of the Data Grid.

 

Sorts the data grid using the column number indicated.

 

Finds the string in the Text To Find property. The matching is done in column Column Number. The row number containing the match is returned in property Result Row. The first row is indicated by a "1". If a match could not be found, "0" (zero) is returned. If there are more than one rows containing a match, the first matching row is returned.

 

Note: The data grid is sorted at the indicated column before the search is done. A binary (fast) search is done at the grid.
 

Compares one Data Grid to another and gives back the desired set of results in the Resulting Data Grid property. Text in the grid is compared at the indicated column number (Compare Rows at column number).

 

The Result Contains property determines the resulting set after comparing the grids. You can obtain sets containing the difference between the grids, a set containing matching rows in the set, or a set of rows missing in one grid which are present in the other. The set is returned in the Resulting Data Grid property.

Note: The grids are sorted before the data grids are compared. 
 

Removes duplicates from the data grid using the column number indicated.

Note: The grid is sorted before duplicates are removed.

 

Open a connection to a Microsoft SQL database.
 

Use the SQL Query Direct action for direct SQL update and insert statements, or use the SQL Record Set actions to loop through a record set after a SQL select statement.

When using a record set, use the following basic structure:

Connect
SQL Query for Records
... do actions like Loop Data Grid Rows...
Disconnect

 

When connecting to a database to run "SQL Query Direct" action, use the following basic structure:

... do actions...
Connect
SQL Query Direct
Disconnect

Open a connection to a MySQL database.
 

Use the SQL Query Direct action for direct SQL update and insert statements, or use the SQL Record Set actions to loop through a record set after a SQL select statement.

When using a record set, use the following basic structure:

Connect
SQL Query for Records
... do actions like Loop Data Grid Rows...
Disconnect

 

When connecting to a database to run "SQL Query Direct" action, use the following basic structure:

... do actions...
Connect
SQL Query Direct
Disconnect

Open a connection to a Oracle database.
 

Use the SQL Query Direct action for direct SQL update and insert statements, or use the SQL Record Set actions to loop through a record set after a SQL select statement.

When using a record set, use the following basic structure:

Connect
SQL Query for Records
... do actions like Loop Data Grid Rows...
Disconnect

 

When connecting to a database to run "SQL Query Direct" action, use the following basic structure:

... do actions...
Connect
SQL Query Direct
Disconnect

Open a connection to a Informix database.

Use the SQL Query Direct action for direct SQL update and insert statements, or use the SQL Record Set actions to loop through a record set after a SQL select statement.

When using a record set, use the following basic structure:

Connect
SQL Query for Records
... do actions like Loop Data Grid Rows...
Disconnect
 

When connecting to a database to run "SQL Query Direct" action, use the following basic structure:

... do actions...
Connect
SQL Query Direct
Disconnect

Open a connection to a DB2 database.

Use the SQL Query Direct action for direct SQL update and insert statements, or use the SQL Record Set actions to loop through a record set after a SQL select statement.

When using a record set, use the following basic structure:

Connect
SQL Query for Records
... do actions like Loop Data Grid Rows...
Disconnect

 

When connecting to a database to run "SQL Query Direct" action, use the following basic structure:

... do actions...
Connect
SQL Query Direct
Disconnect

Close a connection to a SQL database.

Note: When a SQL Record Set is being used, the close action automatically applies changes made to the current record set to the database.

 

Execute a SQL query directly without returning in a record set in memory.

Note: Changes made by the query are reflected in the database immediately.

Tip: SQL Query Direct is typically used for updating a database or adding new records.

 

When connecting to a database to run a "SQL Query Direct" action, use the following basic structure:

... do actions...
Connect
SQL Query Direct
Disconnect

Always first use a "Connect" action to connect to the server. Next you run a "SQL Query Direct" action. Use "Disconnect" action as the last action to close the database connection.

Execute a SQL query and returns a record set in memory linked to the database connection.
Record sets can be looped with Loop Records. Field values can be set or read with Get and Set Field actions.

Note: Record sets are commited back to the database with the Commit Changes action or on the Disconnect.

 

When using a record set, use the following basic structure:

Connect
SQL Query for Records
... do actions like Loop Data Grid Rows...
Disconnect

First use the Connect action to connect to the server. Next run a SQL Query for Records and create a result set of records in memory, linked to the SQL database connection. Next use actions like Get Field or Delete Record.
Changes in the records set will not be saved to the database until Commit Changes is used or the the Disconnect action is called.

Append a record to the end of the current record set.
The appended record becomes the active, current record, and can directly be used with a Set Field action for example.

Note: Changes will be applied to the database after a Disconnect or Commit Changes action, or after a Loop Records has finished.

 

Remove the active, current record from the record set.

Note: Changes will be applied to the database after a Disconnect or Commit Changes action, or after a Loop Records has finished.

 

Get the value of a field from the active, current record in the record set and copy it to a variable.
Use the "Field Name or Column number" property to indicate which field in the record is to be used.

Note: Changes will be applied to the database after a Disconnect or Commit Changes action, or after a Loop Records has finished.

 

Set the value of a field in the active, current record in the record.
Use the "Field Name or Column number" property to indicate which field in the record is to be used.

Note: Changes will be applied to the database after a Disconnect or Commit Changes action, or after a Loop Records has finished.

 

Apply any changes to the active record set into the database. Use this action to force a commit to the database.

Note: When a Loop Records has finished or Disconnect action is invoked, changes to the database will be commited automatically.

 

Move the current record pointer to the first record in the active record set.

Move the current record pointer to the last record in the active record set.

 

Move the current record pointer to the next record in the active record set.

If the last record is reached, the "Last Record Reached" variable will be set to "Yes".

Tip: Use the "Last Record Reached" variable to exit a simple Loop action when not using the Loop Records action.

 

Move the current record pointer to the previous record in the active record set.

If the first record is reached, the "First Record Reached" variable will be set to "Yes".

Tip: Use the "First Record Reached" variable to exit a simple Loop action when not using the Loop Records action.

 

Copy the complete content of the active record set into a Data Grid source.

 

Finds a text string in the content of source and sets the source cursor to a new position.

Tip: This actions supports one or more asterix ('*') wildcard for a search text like '<TR*>*Name:'. Line breaks in a source must also be mached with '#13#' or by a wildcard '*'.

Note: Source Text Manipulation actions always keep an internal cursor position in the source for reference, while Text Manipulation actions don't have a cursor position.

 

The Find Text in Source action, like Copy Text from Source and Insert Text in Source are Source Text Manipulation actions. Meaning they operate on a source with a cursor position, while normal Text Manipulation actions like Copy Text do also work with sources but without a cursor position.
A cursor position in a source is remembered and used the next time you use a Source Text Manipulation action. This is typically used when collecting a structure of data from HTML table in a loop action for example.

Read from the current cursor position until the text in "Read Until" property is found. The read text is returned in the assigned "Found Text" variable. If no text was not found the Found Text will be empty.

Tip: This actions supports one or more asterix ('*') wildcard for a copy like read until '<TR*><TABLE*>'. Line breaks in a source must also be mached with '#13#' or by a wildcard '*'.

Note: Source Text Manipulation actions always keep an internal cursor position in the source for reference, while Text Manipulation actions don't have a cursor position.

 

The Copy Text from Source action, like Insert Text in Source are Source Text Manipulation actions. Meaning they operate on a source with a cursor position, while normal Text Manipulation actions like Copy Text do also work with sources but without a cursor position.
A cursor position in a source is remembered and used the next time you use a Source Text Manipulation action. This is typically used when collecting a structure of data from HTML table in a loop action for example.

Copy text between a "From Text" and a "To Text" property from the current cursor position in a source and returns the copied text in a variable.

Tip: This actions supports one or more asterix ('*') wildcard for a copy like from '<TR*>*Name:' to '</TR>'. Line breaks in a source must also be mached with '#13#' or by a wildcard '*'.

Note: Source Text Manipulation actions always keep an internal cursor position in the source for reference, while Text Manipulation actions don't have a cursor position.

 

The Copy Text from Source Between action, like Copy Text from Source and Insert Text in Source are Source Text Manipulation actions. Meaning they operate on a source with a cursor position, while normal Text Manipulation actions like Copy Text do also work with sources but without a cursor position.
A cursor position in a source is remembered and used the next time you use a Source Text Manipulation action. This is typically used when collecting a structure of data from HTML table in a loop action for example.

Inserts a text at the current cursor position in the source.

Note: Source Text Manipulation actions always keep an internal cursor position in the source for reference, while Text Manipulation actions don't have a cursor position.

 

The Insert Text in Source action, like Copy Text from Source are Source Text Manipulation actions. Meaning they operate on a source with a cursor position, while normal Text Manipulation actions like Copy Text do also work with sources but without a cursor position.
A cursor position in a source is remembered and used the next time you use a Source Text Manipulation action.

Replace all occurrences of a text from the current cursor position in the source with a new text.

Tip: This actions supports one or more astrix ('*') wildcard for a copy like from '<TR*>*Name:' to '</TR>'. Line breaks in a source must also be matched with '#13#' or by a wildcard '*'.

Note: Source Text Manipulation actions always keep an internal cursor position in the source for reference, while Text Manipulation actions don't have a cursor position.

 

The Replace Text in Source action, like Copy Text from Source are Source Text Manipulation actions. Meaning they operate on a source with a cursor position, while normal Text Manipulation actions like Copy Text do also work with sources but without a cursor position.
A cursor position in a source is remembered and used the next time you use a Source Text Manipulation action.

Matches a regular expression in a source from the current cursor position. The "Mached Text" is returned in a variable.
Tip: More info on regular expressions can be found at: http://www.regular-expressions.info

Note: Source Text Manipulation actions always keep an internal cursor position in the source for reference, while Text Manipulation actions don't have a cursor position.

 

The Match Text in Source action, like Copy Text from Source are Source Text Manipulation actions. Meaning they operate on a source with a cursor position, while normal Text Manipulation actions like Copy Text do also work with sources but without a cursor position.
A cursor position in a source is remembered and used the next time you use a Source Text Manipulation action.

Replace a single or all occurrences of a text with another text in a source or variable.

Note: This text is case sensitive.

Tip: This action supports an '*' as wildcard.

 

Find a text string in the content of source or variable and returns the position of the found text as a number variable. If the text was not found, "Result Position" is set to 0.

A 'position' is the the index position of a character or string. Example: The 'q' in the string 'The quick brown fox' has a position 5. The first character is always 1.

Tip: This actions supports one or more asterix ('*') wildcard for a search text like '<TR*>*Name:'. Line breaks in a source must also be mached with '#13#' or by a wildcard '*'.

 

Copy text from a source or variable, starting at "Start Position" and copying until the "End Position" is reached. The copied text is returned in the "Copied Text".

A 'position' is the the index position of a character or string. Example: The 'q' in the string 'The quick brown fox' has a position 5. The first character is always 1.

Tip: This actions supports one or more asterix ('*') wildcard for a search text like '<TR*>*Name:'. Line breaks in a source must also be mached with '#13#' or by a wildcard '*'.

 

Copy text from a source or variable between two strings. Text is copied from the "From Text" property value until "To Text" property value. The copied text is returned in the "Copied Text" property as variable.

Tip: This actions supports one or more asterix ('*') wildcard for a search text like '<TR*>*Name:'. Line breaks in a source must also be mached with '#13#' or by a wildcard '*'.

 

Insert a string in a source or variable at specific position.

A 'position' is the the index position of a character or string. Example: The 'q' in the string 'The quick brown fox' has a position 5. The first character is always 1.

 

Splits a text variable and returns the right part of the split text.

Example: On the text 'abcdef' with 'cd' as "Split Characters"; 'ef' will be returned as "Split Text".

Note: When the "Split Characters" are not found the complete content of "Text" will be returned in "Split Text".

 

Splits a text variable and returns the left part of the split text.

Example: On the text 'abcdef' with 'cd' as "Split Characters"; 'ab' will be returned as "Split Text".

Note: When the "Split Characters" are not found the complete content of "Text" will be returned in "Split Text".

 

Trims leading and trailing spaces of the content in a text variable.

 

Converts all characters in the content of a text variable to upper case.

 

Converts all characters in the content of a text variable to lower case.

 

Converts the first character in the content of a text variable to upper case.

 

Strips all HTML tags from the content of a text variable.

Example: '<B>Hello <I>World</I></B>' would become 'Hello World'.

 

Formats a number variable.

The formatting syntax is %[Index:][-][Width][.Precision]Type
Example padding: %.6d will format 1234 to 001234 by padding zero's to the length of 6.
Example money: %m will format 1234.9 to $ 1,234.90.
Example rounding: %d will format 1234.95 to 1235.
Example precision: %.2f will format 1234.95345 to 1234.95

 

Convert text of one format to another format.

Supported conversions are UTF-8 to ASCII and vise versa.
And special HTML characters to ASCII. For example '&nbsp' to a space.  

Tip: See the more info for examples.

 

Set the default format settings for decimal, date and time separators and the currency symbol used in the script.

Tip: This action will force a specific format settings, regardless of the computer locale settings when using formatting actions.

 

Convert a Text variable to a Number variable.

 

Convert a Text variable to a DateTime variable.

Tip: See the more help for formatting syntax options.

 

Maps a hash value from one or more variables.

Tip: For usage of hashes see: http://en.wikipedia.org/wiki/Hash_function

 

Matches a regular expression in a variable or source. The "Returned Match" is returned in a text variable.

Tip: More information on regular expressions can be found at: http://www.regular-expressions.info

 

Matches a regular expression in a variable or source and replaces all occurrences of the matches. When sub expressions are used they can be indicated in the Replace Text Property with $1, $2, etc. Open the example script for a demo.

Tip: More info on regular expressions can be found at: http://www.regular-expressions.info

 

Compares one string to another and gives back a match score as a number. The number is used to determine how similar or dissimilar one string is compared to another. For determing the best fuzzy match from a list, use the Fuzzy Best Match action instead.

 

The action will compare a text string in the "Text1" property with a text string in the "Text2" property. It will provide a score as a result in the "Score" property. The Score is a measure of how much the two strings are alike. The Score depends on which algorithm you choose for comparison.

Algorithms: The algorithm determines how strings are compared to each other. Different algorithms have different applications, so it depends on the matching task you have which one is best for you.

DA1. Djuggler native fuzzy string comparison algorithm. In addition to comparing words, it also does a good job comparing "sentences" (strings of words). The lower the Score the better the match. A Score of -300 is a better match than a Score of -50 or 200. Score can be negative as well as positive. For example: compare "Nokia E66" with "Nokia E66" (Score:-300), "Nokia E65" (-279) and "Samsung Soul" (200). From these three strings, Nokia E66 is the best match, while Nokia E65 doesn't do bad either. Samsung Soul compares much worse to Nokia E66. Although not fool proof, negative scores can be considered good matches, while positive scores can be considered bad ones.

Levenshtein. The Levenshtein fuzzy string comparison algorithm. This algorithm calculates the difference between two strings (edit distance). The more differences are found, the higher the Score. A perfect match gets a Score of 0; less perfect matches get a higher score. Score is a positive number starting at zero.

Jaro-Winkler. The Jaro-Winkler fuzzy string comparison algorithm. This algorithm calculates the similarity between two strings. The more similarities are found, the higher the Score. A perfect match gets a Score of 1; the lowest score is 0. Score is a positive number between zero and one. 

Replacement List: you can provide a list variable here containing string replacements. These replacements are performed before the comparison is done. This allows you to correct for different spellings of a word (for example "3rd" and "third") before you compare strings, enhancing the match score. Each replacement is a separate item in the list, separated by an "=". To replace "3rd" with "third", add an item "3rd=third" to the list.

Finds the best (fuzzy) match of a string in a list variable. The best matching string in the list is returned.

 

The action will compare a text string in the "Text" property with a list of strings in the "List" property. It will return the string from the list that best matches the stringin the Text property. The Scoreis a measure of how much the two strings are alike. The score depends on which algorithm you choose for comparison.

Algorithms: The algorithm determines how strings are compared to each other. Different algorithms have different applications, so it depends on the matching task you have which one is best for you.

DA1. Djuggler native fuzzy string comparison algorithm. In addition to comparing words, it also does a good job comparing "sentences" (strings of words). The lower the Score the better the match. A Score of -300 is a better match than a Score of -50 or 200. Score can be negative as well as positive. For example: compare "Nokia E66" with "Nokia E66" (Score:-300), "Nokia E65" (-279) and "Samsung Soul" (200). From these three strings, Nokia E66 is the best match, while Nokia E65 doesn't do bad either. Samsung Soul compares much worse to Nokia E66. Although not fool proof, negative scores can be considered good matches, while positive scores can be considered bad ones.

Levenshtein. The Levenshtein fuzzy string comparison algorithm. This algorithm calculates the difference between two strings (edit distance). The more differences are found, the higher the Score. A perfect match gets a Score of 0; less perfect matches get a higher score. Score is a positive number starting at zero.

Jaro-Winkler. The Jaro-Winkler fuzzy string comparison algorithm. This algorithm calculates the similarity between two strings. The more similarities are found, the higher the Score. A perfect match gets a Score of 1; the lowest score is 0. Score is a positive number between zero and one. 

Replacement List: you can provide a list variable here containing string replacements. These replacements are performed before the comparison is done. This allows you to correct for different spellings of a word (for example "3rd" and "third") before you compare strings, enhancing the match score. Each replacement is a separate item in the list, separated by an "=". To replace "3rd" with "third", add an item "3rd=third" to the list.

Finds the best (fuzzy) match in a data grid column. The best matching string in the list is returned.

 

The action will compare a text string in the "Text" property with a list of strings in the "List" property. It will return the string from the list that best matches the stringin the Text property. The Scoreis a measure of how much the two strings are alike. The score depends on which algorithm you choose for comparison.

Algorithms: The algorithm determines how strings are compared to each other. Different algorithms have different applications, so it depends on the matching task you have which one is best for you.

DA1. Djuggler native fuzzy string comparison algorithm. In addition to comparing words, it also does a good job comparing "sentences" (strings of words). The lower the Score the better the match. A Score of -300 is a better match than a Score of -50 or 200. Score can be negative as well as positive. For example: compare "Nokia E66" with "Nokia E66" (Score:-300), "Nokia E65" (-279) and "Samsung Soul" (200). From these three strings, Nokia E66 is the best match, while Nokia E65 doesn't do bad either. Samsung Soul compares much worse to Nokia E66. Although not fool proof, negative scores can be considered good matches, while positive scores can be considered bad ones.

Levenshtein. The Levenshtein fuzzy string comparison algorithm. This algorithm calculates the difference between two strings (edit distance). The more differences are found, the higher the Score. A perfect match gets a Score of 0; less perfect matches get a higher score. Score is a positive number starting at zero.

Jaro-Winkler. The Jaro-Winkler fuzzy string comparison algorithm. This algorithm calculates the similarity between two strings. The more similarities are found, the higher the Score. A perfect match gets a Score of 1; the lowest score is 0. Score is a positive number between zero and one. 

Replacement List: you can provide a list variable here containing string replacements. These replacements are performed before the comparison is done. This allows you to correct for different spellings of a word (for example "3rd" and "third") before you compare strings, enhancing the match score. Each replacement is a separate item in the list, separated by an "=". To replace "3rd" with "third", add an item "3rd=third" to the list.

Sets the value of a Date-Time variable, based on values for a day, month, year, hours, minutes and seconds.

 

Returns the current date and time in a variable.

Tip: Use the "Date from Date variable to Text" or "Time from Date variable to Text" or "Extract from Date-Time" actions in the 'Variables' group to convert dates and times.

 

Formats a Date variable in a specific format.

Examples:
d/m/y = 5/6/00
dd/mm/yy = 05/06/00
ddd d of mmm yyyy = Mon 5 of Jun 2000
dddd d of mmmm yyyy = Monday 5 of June 2000
ddddd = 05/06/2000
dddddd = 05 June 2000
c = 05/06/2000 01:02:03

 

Returns the day, month, year, hour, minutes and seconds as variables from a date variable.

Tip: Use this action to convert a date variable independent of the computer locale.

 

Adds days, months, years, minutes and/or seconds to a Date-Time variable.

 

Substracts days, months, years, minutes and/or seconds from a Date-Time variable.

 

Give the time span in days, months, years, minutes and seconds from two Date-Time variables.

Note: The span returns an approximation based on an assumption of 365.25 days per year. Fractional years are not counted. Thus, for example, the span reports the difference between Jan 1 and Dec 31 as 0 on non-leap years and 1 on leap years.

 

Give the time span with a fraction in days, months, years, minutes and seconds from two Date-Time variables.

Note: The span returns an approximation based on an assumption of 365.25 days per year.

 

Returns the day name and day number in the week of a given Date-Time.

 

Returns the day name and day number of the month of a given Date-Time.

 

Returns the day name and day number of the year of a given Date-Time.

 

Returns the month name and month number of the year of a given Date-Time.

 

Import an Comma Separated Values file and put the contents in a Data Grid source.

 

This action supports CSV with comma, semi-colon and tab as separators.

Export a Data Grid source to a Comma Separated Values (CSV) file.

CSV files with comma, semi-colon and tab as separators are supported.

 

Very fast method to append lines to a CSV file.

Tip: When writing lots of data to disk, this is the fastest way to create a CSV file without keeping data in memory and the best disk performance.

 

Imports an Excel file and puts the contents in a Data Grid source.

Note: The first Excel sheet is always used for import.

 

This action supports Excel 97, 2000 and 2003 formats.
For Excel 2007 format, please see the separate action for this format.

Export data from a Data Grid source to an Excel file.

 

The exported file is readable in Excel versions 97, 2000 and 2003.

Imports an Excel file from MS Office 2007 and puts the contents in a Data Grid source.

 

This action only supports Excel 2007 format, please see the separate actions for other Excel formats.

Export data from a Data Grid source to an Excel file in Excel format.

 

The exported file is readable in Excel version 2007.

Import an Access file and put the contents in a Data Grid source.

 

This action supports Access 97, 2000 and 2003 formats.

Export data from a Data Grid source to an Access file in Excel format.

 

The exported file is readable in Access versions 97, 2000 and 2003.

Import a DBF file and put the contents in a Data Grid source.

This action supports DBF and FoxPro formats.

 

Export data from a Data Grid source to a DBF file.

 

Export a Data Grid source to SQL Script text file.

 

Copies one or more files to another location.

Tip: Indicate multiple files by using wildcards like: c:\myfiles\*.*.

 

Moves one or more files to another location.

Tip: Indicate multiple files by using wildcards like: c:\myfiles\*.*.

 

Deletes a file.

 

Change the name of a file or folder.

 

Create a new folder.

Tip: You can create several nested folders at once, i.e. "c:\folder1\folder2" creates the full path indicated including 'folder1' if it did not exist already.

 

Copies a folder including files to another location.

 

Moves a folder including files to another location.

 

Deletes an existing folder.

 

Retrieves various information about a given file, like: size, creation date, etc.

 

Retrieves various information about a the path of a given file, like drive, file extension, etc.

 

Deliver mail directly at the receiver's mail server without relaying through an SMTP host.

Tip: Read the more help for embedding images in HTML email.
 

The minimum properties required to send an e-mail are the "To", "From", "Subject" and "Body" properties.

The "To" property can only be a single email address, valid notations are 'john.doe@someplace.com' or 'John <john.doe@someplace.com>' or '"John Doe" <john.doe@someplace.com>'.

The "Body" property is the plain text part of the message, this can be either plain text or a File name that should be loaded as the body text.

The "HTML Body" property is the HTML part of the message that will be included and can either be HTML text or a local File name.

If the HTML contains pictures (GIF, JPG or PNG) with a local reference, they will be embedded inline.
Example: '<img scr="c:\mypicture.jpg">' will be embedded inline because is has a local reference; '<img scr="http://somedomain/mypicture.jpg">' will NOT be embedded inline.

The "Attachments" property is a comma separated list of local File names, e.g. 'c:\myfile.doc, c:\myfile2.txt'.

If the "DNS" property is given, that DNS is used to auto resolve the MX records, otherwise the first DNS from the local system will be used.

The "Result" property contains the result of the action, a message with a specific error or success message.

 

Send Mail by SMTP will send a plain text or html e-mail via an SMTP host.

Tip: Read the more help for embedding images in HTML email.

 

The "To", "CC" and "BCC" properties can be a single email address or multiple e-mail addresses separated by a comma, valid notations are 'john.doe@someplace.com, jane.doe@someplace.com' or 'John <john.doe@someplace.com>' or  '"John Doe" <john.doe@someplace.com>, "Jane Doe" <jane.doe@someplace.com>'.

The "Body" property is the plain text part of the message, this can be either plain text or a File name that should be loaded as the body text.

The "HTML Body" property is the HTML part of the message that will be included and can either be HTML text or a local File name.

If the HTML contains pictures (GIF, JPG or PNG) with a local reference, they will be embedded inline.
Example: '<img scr="c:\mypicture.jpg">' will be embedded inline because is has a local reference; '<img scr="http://somedomain/mypicture.jpg">' will NOT be embedded inline.

The "Attachments" property is a comma separated list of local File names, e.g. 'c:\myfile.doc, c:\myfile2.txt'.

If the "DNS" property is given, that DNS is used to auto resolve the mx records, otherwise the first DNS from the local system will be used.

The "Result" property contains the result of the action, a message with a specific error or success message.

Optionally a specific SMTP "Port", "Username" and "Password" can be specified for the SMTP connection.

Send a raw e-mail message file to a smtp host.

 

A raw e-mail message file is a text file that contains headers, addresses and content for an e-mail message.
These files are typically found in message queues of mail servers and used by programs as the Microsoft SMTP service.

A simple and minimal raw message file may look like:

TO: john.doe@someplace.com
FROM: jane.doe@someplace.com
SUBJECT: message from jane

Hello John,
Bye Jane.
 

This action executes a shell command.

For example, using 'notepad.exe' as "Command" property value will bring up Windows notepad editor.

Note: Use quotes when File names or parameters contain spaces.

 

This action allows you to run a DOS application and catch its output in a variable.

Example: 'ipconfig.exe /all' as "Command line" property value will catch ip information output in a variable.

Note: Use quotes when File names or parameters contain spaces.

 

A Djuggler compiled script can be called with parameters. This action reads a parameter and assigns it to a text variable to be used in the script.

Example: Set "Param name" to '/log' and call the compiled script as 'myscript.exe /log=c:\temp\mylogfile.txt'.

Tip: Use the "Default value" property value to test the parameter when not running as a compiled script.

 

Close a Windows Window by it's dialog title.

This action is typically used to close a dialog outside the Djuggler environment.
 

Returns the path to the special Windows folders, like the Temp folder or My Documents (Personal folder), etc as a text variable.

 

Returns various system information, like Computer name, User name, IP Address, etc as a text variable.

 

Put a variable or source content in the Windows clipboard.
This is a typical action used in debugging a script.

 

Returns a registry value as a text variable.

 

This is a deprecated action, please use the Get Web Page action.

Opens a Web Page and puts the HTML source as in the IE 'view source' option in the content in the Web Page source.

Note: This is not the DOM source as shown in the Djuggler Web Inspector. This is the source as served by a webserver without interpretation of Internet Explorer.

 

This action is deprecated, use the Get Table Content action instead.

Collects all data from a HTML table to a "Data Grid" source.

The "Table Number" variable to indicates the HTML table to use. For example Table Number 3 will collect data from the thrid <TABLE> tag found in the HTML.

Tip: Use the Web Page viewer (F3) to inspect the table number in a Web Page.

 

This action is deprecated, use the Web Page Interaction actions instead.

Reads the content from a HTML tag.

The position of the cursor in the Source is remembered. This means that by calling this action multiple times you can read subsequent tags to get their content.

 

The action looks for the tag specified in the Tag property. If you set Attribute Name and Value, only tags are matched where the tag attribute contain the set value.

For example, say you want to read the content of a html tag specified by the following html: "<TD class='myclass'>some content here...</TD>". Fill in "TD" as Tag, "class" as Attribute and "myclass" as Value. The action will now seek through the html and return the content of the first found tag in the Content property.

This action is deprecated, use the Set Form Element Value action instead.

Fills a field in a form on a Web Page. Typically used for form automation, like a login to a web site.

Example: If the form element looks like "<INPUT Name="usr_name">".
Setting the name to the value "John" is done by settting Field Name to "usr_name" and Value to John.

Tip: The Djuggler Web Inspector can inspect the tag information needed for this action.

 

This action is deprecated, use the Convert Variable action instead.

Returns the date part from a Date variable as a Text variable.

Tip: The date format is based on the computer locale settings. Use the Extract from Date-Time action to convert independent from locale settings.

 

This action is deprecated, use the Convert Variable action instead.

Returns the time part from a Date variable as a Text variable.

Note: The time format is based on the computer locale settings. Use the Extract from Date-Time action to convert independent from locale settings.

 

This action is deprecated, use the Convert Variable action instead.

Copies the content of the Source to a Variable.

If the Source is a Web Page for example, the HTML source of the Web Page is copied to the Variable.

 

This action is deprecated, use the Convert Variable action instead.

Copies the content of the Variable to the Source.

If the Source is a Text File for example, current content of Variable would be copied to the Text File.

 

Compares two variables or sources.

If the comparison succeeds, the script actions between the If and End If script lines are executed. The If action can also be used in combination with an Else action.

Tip: The wildcard '*' can be used in a string compariment.

 

Test a "Variable" against a certain condition, like Is Empty, Contains Text, Equal To, Exists in List, etc.

If the comparison succeeds, the script actions between the If Condition and End If script lines are executed. The If Condition action can also be used in combination with an Else action.

Tip: Use this action to verify if a variable is empty, or a file exists or is a positive number, etc.

 

Test the script against a certain condition, like Is Online, Is Compiled Script, etc.

If the comparison succeeds, the script actions between the If Case and End If script lines are executed. The If Case action can also be used in combination with an Else action.

Tip: Use this action to verify if the computer executing the script has an active Internet connection.

 

The Else action can be used in conjunction with an If or If Condition action.

When the If action fails, the lines between Else and End If are executed.

 

The End If action closes an If, If Case or If Condition block.

Structure example:

If ...
... do actions ...
Else
... do actions ...
End If

 

Jumps to a Label action in the script and executes lines from there until a Return action is encountered.

The "Label name" property value should match the exact name of the label to jump to. Use the Return action to jump back to the script position where Go to Label was called.

Note: A Stop Script Execution action may be needed to prevent the script from running into a label without being called by a Go to Label action.

 

The Label action is used as a marker in combination with the Go to Label action.

The Go to Label action can be used to jump to a Label action and resume execution from there. Use the Return action to jump back to the script position where Go to label was called.

Note: Make sure the names in both actions match exactly else the action will be ignored.

 

Use the Return action to indicate the end of label and jump back to position where the Label was called with a Go to label action.

 

The Loop action is a simple infinite loop untill the action Exit Loop is called.

All actions between the begin of the loop and end of the loop are processed infinitely.

Note: An End Loop action is needed to close the loop script logic and an Exit Loop to exit the loop.

 

The While Loop will loop actions while a specified condition is valid and exits automatically when the condition is invalid.

Note: An End Loop action is needed to close the loop in the script logic.

 

The Condition Loop will repeat actions in the loop while a specified condition is valid and automatically exit the loop when the condition is invalid.

Note: An End Loop action is needed to close the loop in the script logic.

 

Loops through a preset numerical range.

The looping process starts with Start Value and will stop when it reaches the Stop Value. With each loop, the Start Value gets incremented by the Step property. The Current Value variable returns the current step value.  If Start Value is larger then Stop Value, the loop will count down.

Note: An End Loop action is needed to close the loop in the script logic.

 

Loops file names in a directory and returns found file names in the "File name" variable. Looping continues until no more files are found.

Note: An End Loop action is needed to close the loop in the script logic.

 

Loops folder names in a directory and returns found folder names in the "Folder name" variable. Looping continues until no more folders are found.

Note: An End Loop action is needed to close the loop in the script logic.

 

Loops Web Pages with a typical "Next" button. The "Next Page Button Recorder" is used to identity a "Next" page button.

A Loop Web Pages action should always be proceeded by a Get Web Page using the DOM source to set the initial Web Page in which the click to the next page is performed.

Tip: The source obtained by Loop Web Pages is the DOM source and might slightly differ from source obtained via the "view source option" in Internet Explorer or other browsers. The Read Next Link by Title action in combination with a simple Loop action can be used as an alternative for the Loop Web Pages action using the HTML source.

 

Web pages with a next page structure like: "1|2|3 >Next" can be looped until the last page using this action. The Next link is identified using the Button recorder behind the three dots. The recorder opens in a new browser window.

Using the Next Page Button Recorder:
1. Put the URL for the first page in the navigation edit box and press the "Go" button. The first page with the Next link structure is loaded in the browser pane.
2. Press the Record button on the right and then click on the Next link in the actual browser pane. The HTML tag identifing the Next link is shown on the right pane.
3. Press the Save Recording and Exit button to save the recording and close the browser window.

Loops all items in a List variable and passes them on to a Text variable.

The loop starts with the first item in the List and stops at the last item. An End Loop action is needed to close the loop in the script logic.

Tip: To loop a sorted list, use the Sort List action before the loop.

 

Loops through all the rows in a data grid.  The first row in a data grid has the number 1. 

The "Current Row" variable returns the current row number, and can be used in actions like Get Date Cell Value to get the content of data grid fields. An End Loop action is needed to close the loop in the script logic.

Tip: To loop a sorted data grid, use the Sort Data Grid action before the loop.

 

Loops through all the columns in a data grid. The first column in a data grid is has the number 1.

The "Current Column" variable returns the current column number, and can be used in actions like Get Date Cell Value to get the content of data grid fields. An End Loop action is needed to close the loop in the script logic.

 

Loops nodes in the xml tree from a specific start point. Optionally returns only nodes with a specific name or path.

Tip: The "Look for" property can be a Node name or (partial) Node path. Path notation is with forward slashes like: 'books/book'.

 

If the complete XML tree is to be looped, use the root node as starting node.

When "Look for" is defined as 'book' the loop will pass all nodes named 'book' to the "Result Node" variable, regardless of where they are from the starting point in the tree.
When "Look for" is defined as 'books/book' all "book" nodes will be returned that reside directly under a parent node named 'books'.

 

Loops child nodes in the xml tree from a specific start point (not recursively, only the child nodes under the starting point).

Optionally returns only nodes with a specific name. If the Name property is not specified, all child nodes are returned.

 

Loops through all the matches of a regular expression and with each loop a match result is returned in the "Returned Match" variable. If there is no more match the loop ends.

Note: When sub expressions are used in the regular expression, a sub expression number should be specified for the returned match variable. 0 means the complete match.

 

Reads a text file in a text source and loops though all the lines. With each pass the "Read Line" variable returns a line that was read from the file. An "End Loop" action is needed to close the loop in the script logic.

Note: For performance reasons the content of the Text File source is not shown in the Text Viewer.

 

Loops all records in a record set related to a SQL database connection. This action needs to be combined with the SQL Query for Records action.

The loop starts with the first record in the record set and runs until the last record is reached.

Note: When the loop finishes it will apply any changes made in the record set to the database automatically.

 

When using a record set, use the following basic structure:

Connect
SQL Query for Records
Loop Records
... actions like Get Field Value...
End Loop
Disconnect

Each Loop action needs an End Loop action to indicate the end of the loop.

Structure example:

Loop While ...
 ... actions ...
End Loop

 

Forces an exit in a loop and is often used in combination with an If or If Condition action.

 

Comments are used to place notes in a script and make a script more readable.

Tip: Use empty comments to separate blocks of code for clarity.

Note: A Comment action is excluded from the script action execute count.

 

Puases the execution of the script for a number of miliseconds.

Property "ms" should contain the number of milliseconds the script should pause.

 

Suppresses all error dialogs and show message dialogs. All feedback to the user in the form of message dialogs that halt the execution of the script are suppressed.

This action is typically used in compiled executable scripts that run on stand alone servers.

Note: The Show Errors and Dialogs action will re-enable dialogs again.

 

Enables all error dialogs and user dialogs after a Suppress Errors and Dialogs action.

 

Jumps to a specified label when the script encounters an error.

Tip: When the Supress Errors & Dialogs action is used this action can be used to catch and handle script errors.

 

Fills the "Last Error variable" with a description of the last encountered error.

Tip: When the Supress Errors & Dialogs action is used this action can be used to catch and handle script errors.

 

Clears the error text found by the "Get Last Error" action.

 

Stops the execution of the script.

Typically used before Label actions or when the script encounters a condition it should stop at all times.

 

Pauses the execution of the script and continues in step mode. This action is typically used in a debug situation.

Note: In a compiled script this action is ignored.

Tip: Inspect the content of variables and sources when paused by clicking the Step button. The script can be resumed with the Resume button in the menu bar controls.

 

Returns various script properties like the script path, script name, build version. It it also reveils information about the Djuggler version and edition used to create the script.

 

Shows or hides up Djuggler's internal web viewer.

Note: This action is typically used in a debug situation.

 

Shows or hides up Djuggler's internal grid viewer.

Note: This action is typically used in a debug situation.

 

Shows or hides up Djuggler's internal text viewer.

Note: This action is typically used in a debug situation.

 

Append a text line to a log file, including a date time stamp.

Note: This action is typically used in a debug situation.

 

When a script is loaded that is created by a more recent version of Djuggler a missing action statement will replace all unkown actions from the new Djuggler version.

 

Displays a text message in a message box.

Note: The Script will be paused until a user presses the OK button in the message box.

 

Presents an input box with a single text line.

The "Answer" variable will contain the answer the user has typed in in the input box.

 

Presents the user with an dialog for Yes or No.

The "Answer" variable will contain the answer Yes or No.

Note: When using a If action to verify the "Answer" variable, compare to 'Yes' or 'No' (case sensitive).

 

Shows an open file dialog asking the user to choose a file.

The file will be passed on to the "Answer" variable and contains the fully qualified path with directory and File name.

 

Shows a save file dialog asking the user to choose a file.

The file will be passed on to the "Answer" variable and contains the fully qualified path with directory and File name.

 

Shows a dialog asking the user to choose a directory.

The directory path will be passed on to the "Answer" variable. It will contain a fully qualified directory, trailed by a backslash ("\").

 

Shows a dialog with an optional progress bar.

This action is typically used for compiled executable scripts.

Tip: The Loop rows action contains a property Total number of rows that can be used for Maximum Value property in this action.