tFileDigester

Checksum of a file, obtained with the Java MessageDigest.

With a Sun JRE 6, theses digest method are supported :
- MD2
- MD5
- SHA-1
- SHA-256
- SHA-384
- SHA-512

With other JRE versions, you can get a runtime "NoSuchAlgorithmException".

tQuickBooksAdvanced

QuickBooks

tWebDavGet

This component gets a file with webdav protocol. After the downloading/installation you have to restart TOS or TIS.
Created by www.openbizz.fr.

tWebDavPut

This component puts file on a server with webdav protocol.
Created by www.openbizz.fr.

tGroovyRow

This component is similar to the tJavaRow component, except it allows users to write Groovy code.

Component Info:

1. The input and output rows, as well as the context object, are converted to Groovy maps (java.util.HashMap) with all the groovy goodness associated with maps. Primitive types are boxed into their object representations within the script and unboxed upon leaving the script.

2. The groovy script is compiled into a class upon first use.

3. One object of this groovy class is instantiated, stored and reused for each row.

4. Users have access to modify the groovy class via the "Advanced Settings" panel, and are reminded of their responsibility for all the potentially wonderful and horrible results such modification might cause.

test_oracleSP

This job design has three instances of tOracleSP to show how to call a oracle stored procedure.

1) procedure with two input values
2) procedure with one input and one output
3) call the function that is shown in the Component Reference Manual

SQL included in the documentation to create tables and stored procedures

Base64

Base64 functions to encode and decode byte arrays, Strings and files.

Useful if you need to write binary data out to ascii format and read it back in.

MD5 functions

Provides functions that return the MD5 hash of either an input file, string, or byte array.

More information about this class is available from:

http://ostermiller.org/utils/MD5.html

Loop on child job error

This Perl jobs shows how to loop on a child job that fails. The child job performs a tFileFetch that sometimes fails and we want to try 20 times before abandon. 10 seconds pause between each try.

The tricks are:

* in the child job, tDie has a return code set to 0 (so that tRunJob considers the child job has on success)
* in the father job, the condition on the tLoop is "as long as the success file does not exist AND we haven't performed at least 20 tries"
* The 10 secondes pause is performed on the "iteration" expression of the tLoop

tOracleOutputBatch

Optimized version of tOracleOutput using addBatch() and executeBatch(). Support only insert statements.

US Zipcode Validation

matches only if 5 numerics are presentnot matches if less than 5 numerics
Zipcode should be of 5 numerics

Swedish personnummer with accepted foreigners

with a "P", "T", or "F" instead of the first of the four last numbers.

This code fixes the problem, but does not check the validity of the date, or the last number.

Swedish Personal Nr (Personnummer)

Simple regex for the Swedish personal number. It's in the form: YYMMDD-xxxx where xxxx is an arbitrary number from 0000-9999.

791231-1234

UK Vehicle Registration Plate Number Plate

AB12 RCY|||CD07 TES|||S33 GTT|||Y999 FVBab12 rcy|||CD07 TIS|||S34 GTT|||Z999 FVB

UK Vehicle Registration Plate / Number Plate format as specified by the DVLA. Accepts both "Prefix" and "New" style. Allows only valid DVLA number combinations as not all are supported. Registration number must be exactly as is displayed on car, hence all letters must be in uppercase and a space seperating the two sets of characters.

Phone Brazil

011 5555-1234|||(011) 5555 1234|||(11) 5555.1234|||1155551234(011 5555-1234|||(01) 5555 1234|||(11) 0555.1234|||(11) 5555 abcd


Matches Brazilian phone numbers, includes DDD (long-distance call) with or without 0. Accepts characters -, . and [space] as separators.

No special chart

QDE|||QDE#RF

Allow only 3 charcters or number without any special characters

Mobile number of India

This expression will be useful to check mobile
number of India. This expression will check
various types of number like number in local
format or international number separated by
hyphen(-) or not.

International phone number

Matches most international formated phonenumber.

International Passport

? 9 characters made up of a combination of numbers and/or letters. Where less than 9 characters it will be padded out to the right with chevrons (

ISBN Checker

Expression to check for a valid ISBN number

DStar

D* Industries Demo Model