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.0.1 (CE and Pro).
Author: Jan Lolling @ cimt ag Berlin

tJasperServerFileCopy

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

tJasperServerFileDelete

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

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*:
1. 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

tGoogleGeocoder

This component takes an address from the input flow and appends lat and lon columns to the output flow for the address. Google\\\\\\\'s geocode API is used to look up the latitude and longitude for the address.

Started with the original tGoogleGeocoder component but rewritten for API v3.
It also supports business API (given a client and signature strings).

Instructions:
The input row must have at least one column that contains an address. Select that column in the components \\\"Address Column\\\" variable.
The output is the same as the input but with two new columns added (lat and lon) which will contain the latitude and longitude coordinates that Google gave for the input address.

tAdvancedCMISOutput

Component for importing content from a CMIS repository.

CMIS (Content Management Interoperability Services) is an OASIS standard enabling information sharing between different Content Management Systems (CMS, ECM, DAM, ...).

This component is build with the Apache Chemistry OpenCMIS Client API.

For source code and documentation, please visit https://github.com/Ekito/talend-cmis-components.

Please review and rate this component.

tAdvancedCMISInput

Component for exporting content from a CMIS repository.

CMIS (Content Management Interoperability Services) is an OASIS standard enabling information sharing between different Content Management Systems (CMS, ECM, DAM, ...).

This component is build with the Apache Chemistry OpenCMIS Client API.

For source code and documentation, please visit https://github.com/Ekito/talend-cmis-components.

Please review and rate this component.

tLDAPHelper

function Helper to extract id from dn

tIGOutput

For an easy way to start using InfiniteGraph with existing data sets, this connector allows data ingest from a variety of Talend input connectors to an InfiniteGraph database. It allows you to map and define vertices and edges and generates Java class files to use with your application.

For more information see: http://wiki.infinitegraph.com

tOpenERPOutput

the source can be found at https://github.com/baumgaro/OpenERP-Talend-Component.git

read more at http://datenpol.at/unternehmen/blog/datenpol-creates-talend-component-for-openerp/

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