tJasperServerFileDelete

This component deletes a file within the JasperServer.
This component is tested with JasperServer 4.2.x up to 5.1 (CE and Pro).
Author: Jan Lolling @ cimt ag Berlin
email: jan.lolling@cimt-ag.de

tJasperServerFileList

List all content resources in a folder of a JasperServer (optional including sub directories). This component helps to automatically dowload or synchronize files between locale file system and JasperServer. See also the components tJasperServerFilePut and tJasperServerFileGet
This component is tested with JasperServer 4.2.x up to 5.1 (CE and Pro).
Author: Jan Lolling @ cimt ag Berlin

tJasperServerFileGet

Can download content resources from a JasperServer. This component works well together with tJasperServerFileList component.
It can create local file system is needed and rename the content resource.
This component is tested with JasperServer 4.2.x up to 5.1 (CE and Pro)
Author: Jan Lolling @ cimt ag Berlin

tJasperServerFilePut

Lets you upload files on a Jasper Server. This is a replacement for tJasperServerContentResourceUpload component.
This new component has more useful return values.
Tested with JasperServer version 4.2.x up to 5.1 (CE and Pro)
Author: Jan Lolling @ cimt ag Berlin

tJasperServerFileCopy

This component copies files within the JasperServer.
This component is tested with JasperServer 4.2.x up to 5.1 (CE and Pro).
Author: Jan Lolling @ cimt ag Berlin
email: jan.lolling@cimt-ag.de

tRunTask

This components runs a task within the Talend Administration Center.
Please refer the PDF documentation linked as resource here.
This component uses only Open Source libraries.
This component helps to create much more sofisticated job chains.
* set context parameters
* configure which task cannot run at the same time
* setup the wait for the end of the job by polling or direct response
* at the moment it is not possible to use the job return code because of a missing feature of the TAC web service (but this gap is recognized and in planning for Talend release 5.4).

tFileExcelWorkbookOpen

This component is the base component for all other tFileExcel-components.
This component use the Apache POI library version 3.9.
This components reads a spreadsheet in a workbook or create a new empty workbook in memory.
This workbook can be filled (with sheets) by the component tFileExcelSheetOutput or can be read by tFileExcelSheetList/Input components.
Finally the component tFileExcelWorkbooksave persists the workbook in the same file as read or in a new file.
The component recognize the file format by the filename extension, it is not necessary to configure it (except if you create a new workbook).
*NEW*: can read and write xlsm files.
Bug fixed: reading rows stops if row is empty or does not exists
*NEW*: Memory saving mode for XSLX type
*NEW*: Can read password protected files
*NEW*: support for IFERROR function added

SAP Connection/Table Metadata Wizard

This Talend plug-in completes the Talend Open Studio with the SAP Connection and SAP Table wizards, allowing smooth metadata handling for SAP Tables. The plug-in also contains the required components to download tables from SAP by RFC_READ_TABLE or PLSAP Connector\'s RFCs.

tmapgly

tjargoly

Valid UK Post Codes Upper and Lower Case

SW112LE | SW11 2LE | sw112le12CR0LE | 12CR 0LE | SWLE05

Matches valid UK post codes in both upper and lower case, allowing for one or zero spaces between outcode and incodes.

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 (