Talend Exchange is the place where Talend community can share items related to Talend opensource products, such as Data Integration, Data Quality and Data Master Management. Contribution is open to any user, no specific validation is needed. As soon as you have your forum account, you automatically get a Talend Exchange account.


tSalesforceOutputBulkCustom


  • Author: kkrupa
  • Categories: Component
  • First revision date: 2012-05-21
  • Latest revision date: 2013-01-15
  • Compatible with: Data Integration releases 5.1.0, 5.1.0RC1, 5.1.1, 5.1.2, 5.2.0, 5.2.0M1, 5.2.0M2, 5.2.0RC1, 5.2.0RC2, 5.2.1
  • Downloads: 95

About: Allows column overrides to the CSV output. The allows for such things like parent-key lookups which use dot-notation in the CSV header (which are disallowed for column names due to Java syntax). The submitted component was extended by using the code fro 5.1 RC1.

Revision list

expand/collapse all

Revision 1.1 41 Downloads, Released on 2013-01-15
Download revision 1.1

Compatible with: 5.2.1, 5.2.0, 5.2.0RC2, 5.2.0RC1, 5.2.0M2, 5.2.0M1, 5.1.2, 5.1.1, 5.1.0, 5.1.0RC1

Fixes issue with generated variable names not being unique in some contexts (e.g. multiple map outputs)

Revision 1.0 54 Downloads, Released on 2012-05-21
Download revision 1.0

Compatible with: 5.1.0, 5.1.0RC1

Allows custom header overrides in the CSV output. Useful for SalesForce parent-key lookups which use dot notation in (dot notation disallowed for column names due to Java syntax).

Reviews (1)

This improvement is required if you want to use the external key features available in Salesforce for upserting data.
Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*


Version Author Released on Rating Downloads
Regex

Training export

0.1 cathyc 2014-06-10
9

Training export

Regex

Minutes Seconds

2.1 mhallam 2014-05-26
144

validates minutes:seconds format

Validates 3:56, 59:59,...
Does not validate 60:59 or 59:60.

SQL

hotmail email

2.0 scorreia 2014-05-26
314

filters email from hotmail.com

Regex

Dutch Postal Code

2.0 fcweeber 2014-05-26
112

Postal Code format verfication (Netherlands)

Matches
9999AA|9999 AA
Non Matches
9999aa|9999Aa|9999 aa|9999 aA

Regex

Dutch Phone Number

2.0 fcweeber 2014-05-26
115

Phone Number format verfication (Netherlands)

Local: Dutch Phonenumber format is area code (3 or 4 digits), phone number ( 7 or 6 digits) - total length (10 digits)
International: country code 0031 and then remove zero from area code
Matches
0031121234567|+31123123456|0121234567|012-1234567|0123-123456
Non Matches
012 1234567|1234567
match 02.31.23.45.67.22 or 004923123467223

Regex

Names with unicode characters

2.0 scorreia 2014-05-26
110

Match people names with unicode characters.
Matches Jean-Marc, Jørn, Mc\'Neelan, Pz. López
Does not match I.B.M.

Regex

FR Phone Number (parenthesis allowed)

2.0 scorreia 2014-05-26
324

match French phone numbers in several format:
matches:
0033 1 47 25 00 00
+33 1 47 25 00 00
(33) 1 47 25 00 00
0033147250000
01-47-25-00-00
01 47 25 00 00
Does not match
0147 250 000

Regex

Email Address (with list of top-level domains)

2.0 mzhao 2014-05-26
172

Check the validity of email addresses.

Regex

Regular Text

2.0 scorreia 2014-05-26
91

match regular text

matches regular text such as \"hello Jean-Baptiste\".
does not match text with any special character such as \"# num\", \"test;\"

Regex

Text

2.0 scorreia 2014-05-26
69

match regular text with punctuation correctly placed.

Version Author Released on Rating Downloads
Export

DStar

1.0 ctoum 2010-08-04
1126

D* Industries Demo Model


95 ms