tOpenERPInput

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/

tFileExcelSheetInput

This component works in conjunction with tFileExcelWorkbookOpen.
This component reads a sheet identified by name or index.
The fields can comfortably configured by excel column name or index.
It will always use the current Apache POI 3.9 libs (also for the older xls format).
The sheet name can be retrieved from the output of the new component tFileExcelSheetList.
Can read comment (alternatively to the value) and
can use none empty value of previous row to fill empty values in current row.
Able be configured to ignore cell format errors.
*NEW*: Number format can changed for different languages/countries in advanced options.
*NEW*: Column positions can automatically be adjusted by header line
For using this component, you have to update tFileExcelWorkbookOpen at first!

tNormalizeSchema

This component normalize a schema. It produce multiple output rows for an input row.
This component was motivated by a job for processing EBCDIC files with a lot of large OCCURSE (in sum 1600 columns). It was indeed not possible to handle this by a tMap with joined outputs. tSplitRow needs a configuration in which every field mapping must be set, similar to the amount of work in a tMap.
This component creates a similiar result like tSplitRow but has the following advantages:
* less byte code foot print
* less memory foot print
* much less necessary configuration (especially for large numbers of fields and occurse)
Please take a look into the documentation and follow the instructions for installing user components (if you do not use the Exchange integration in studio)

tFileInputTextFlat

Text flat file input component.
This component imports text files line by line (except if line breaks are within an enclosed field).
Unique Features:
* The field content can be extracted between delimiters or at absolute position.
* You can mix both methods.
* It is not necessary to map all fields in the file to a schema column,
you need to specify only the needed columns (unlike in tFileInputDelimited)
* For delimited fields, the position of the field can be automatically configured with the content of a header line.
* If the header line contains headers different from schema column, you can specify the name in the header matching to the schema column.
* You can specify if a field can be missed within a file (especially if automatically configured).
* For extraction at delimiter you can specify the number of the delimiter where to start of leaf it blank to use simply the schema column index.
* For extraction at absolute position you have to specify the length.
* If the position is not specified the position is the next position after the last (+ last length).
* For number conversion you can specify the locale for the format.
* If a date column in the schema have no date pattern, you can specify the default pattern.
* Tolerant against enclosures within field content even if not beside of the delimiter (feature must be switched on)
For all, who have problems with missing jars: This is a problem caused by Studio very often and has nothing to do with the components (all other has the same problem).
Please do not rate this badly, instead please contact me at: jan.lolling@cimt-ag.de. I can help!
All of my components are motivated from my customers and running in productive environments, none of them are created just for fun!

abvDependencySortRow

Reorder rows based on key dependencies within columns. If a child row contains a column reference to a parent one, the parent row will be reordered to appear before the child row.

abvConcat

Advanced Concatenator; Concat random lists of stuff together with advanced prefix/suffix/replace options.

tFileOutputPDF

tTwitter

Notes

Mongo_263

Frequency table of hours

This indicator helps to analyze the most frequent day hours that appear in date time columns.

Sample Standard Deviation

This indicator computes the sample standard deviation of any numerical column

Variance

This indicator computes the variance of numeric columns

Trimmed

evaluate the number of data which are correctly trimmed

Week Frequency

aggregates Date fields into weeks

Duplicate Rows

this indicator counts the number of duplicate rows.
It's different from the system indicator called "duplicate count" because it counts the number of duplicate rows, not the number of duplicate values.

Length Range Frequency

get length ranges of data.

group data according to their length range.
Ranges are the following:
data of length < 10
data of length < 20
data of length < 30
data of length >= 30
null data

Order of Magnitude

measure the order of magnitude of numerical data

phone_area_code_freq

Area codes of American phone numbers

udi_average_yearly_income

parses $50K - $70K and return the average value

Product Demo

Product & families, with Cafepress pictures.

Clinical Trials: Janus Model Basics

This is a model of the basic of the Janus Clinical Data Repository.
http://www.fda.gov/ForIndustry/DataStandards/StudyDataStandards/ucm155327.htm

D* Demo Model

Model used in the D* Demo.

Talendshop Demo

Talendshop Demo (Demo Project)