[resolved] tTurnRow not showing on pallet in talend 5.3.0

One Star

[resolved] tTurnRow not showing on pallet in talend 5.3.0

Hi,
I am not able to find tTurnRow component on pallet after adding it into the TOS_DI-Win32-r101800-V5.3.0\plugins\org.talend.designer.components.localprovider_5.3.0.r101800\components and I have modified
tTurnRow_java.xml file as follows.

<COMPONENT>
<HEADER
PLATEFORM="ALL"
SERIAL=""
VERSION="0.9"
STATUS="ALPHA"
COMPATIBILITY="ALL"
AUTHOR="Talend"
RELEASE_DATE="20080907A"
STARTABLE="false"
SCHEMA_AUTO_PROPAGATE="false"
>
<SIGNATURE/>
</HEADER>
<FAMILIES>
<FAMILY>Custom_Code</FAMILY>
</FAMILIES>
<DOCUMENTATION>
<URL/>
</DOCUMENTATION>

<CONNECTORS>
<CONNECTOR CTYPE="FLOW" MAX_INPUT="1" MAX_OUTPUT="1"/>
<CONNECTOR CTYPE="ITERATE" MAX_OUTPUT="0" MAX_INPUT="0"/>
<CONNECTOR CTYPE="SUBJOB_OK" MAX_INPUT="1" />
<CONNECTOR CTYPE="SUBJOB_ERROR" MAX_INPUT="1" />
<CONNECTOR CTYPE="COMPONENT_OK"/>
<CONNECTOR CTYPE="COMPONENT_ERROR"/>
<CONNECTOR CTYPE="RUN_IF"/>
</CONNECTORS>
<PARAMETERS>
<PARAMETER NAME="SCHEMA" FIELD="SCHEMA_TYPE" REQUIRED="true"
NUM_ROW="10">
<DEFAULT />
</PARAMETER>

<PARAMETER NAME="CONTAIN_COLUMN_AS_HEADER" FIELD="CHECK" NUM_ROW="20" REQUIRED="true" >
<DEFAULT>false</DEFAULT>
</PARAMETER>
</PARAMETERS>
<ADVANCED_PARAMETERS>
<PARAMETER NAME="ADVANCED_SEPARATOR" FIELD="CHECK" REQUIRED="true" NUM_ROW="41" >
<DEFAULT>false</DEFAULT>
</PARAMETER>

<PARAMETER NAME="THOUSANDS_SEPARATOR" FIELD="TEXT" REQUIRED="true" NUM_ROW="41"
SHOW_IF="(ADVANCED_SEPARATOR == 'true')">
<DEFAULT>","</DEFAULT>
</PARAMETER>

<PARAMETER NAME="DECIMAL_SEPARATOR" FIELD="TEXT" REQUIRED="true" NUM_ROW="41"
SHOW_IF="(ADVANCED_SEPARATOR == 'true')">
<DEFAULT>"."</DEFAULT>
</PARAMETER>
</ADVANCED_PARAMETERS>

<CODEGENERATION>
<TEMPLATES INPUT="PIVOUT" OUTPUT="PI">
<TEMPLATE NAME="PIVOUT" COMPONENT="tTurnOut">
<LINK_TO NAME="PI" CTYPE="ROWS_END"/>
</TEMPLATE>

<TEMPLATE NAME="PI" COMPONENT="tArrayIn"/>
<TEMPLATE_PARAM SOURCE="self.CONTAIN_COLUMN_AS_HEADER" TARGET="PIVOUT.CONTAIN_COLUMN_AS_HEADER" />
<TEMPLATE_PARAM SOURCE="self.ADVANCED_SEPARATOR" TARGET="PIVOUT.ADVANCED_SEPARATOR" />
<TEMPLATE_PARAM SOURCE="self.THOUSANDS_SEPARATOR" TARGET="PIVOUT.THOUSANDS_SEPARATOR" />
<TEMPLATE_PARAM SOURCE="self.DECIMAL_SEPARATOR" TARGET="PIVOUT.DECIMAL_SEPARATOR" />
<TEMPLATE_PARAM SOURCE="self.SCHEMA" TARGET="PIVOUT.SCHEMA" />
<TEMPLATE_PARAM SOURCE="self.SCHEMA" TARGET="PI.SCHEMA" />
<TEMPLATE_PARAM SOURCE="self.UNIQUE_NAME" TARGET="PIVOUT.DESTINATION" />
<TEMPLATE_PARAM SOURCE="self.UNIQUE_NAME" TARGET="PI.ORIGIN" />
</TEMPLATES>
</CODEGENERATION>

<RETURNS>
<RETURN NAME="PIVOUT_TURNED_ROWS" TYPE="id_Integer" AVAILABILITY="AFTER"/>
</RETURNS>

</COMPONENT>

please let me know what I am doing wrong here, do I need to add anything else.
Thanks

Accepted Solutions
One Star

Re: [resolved] tTurnRow not showing on pallet in talend 5.3.0

Hi,
Thanks, Shong now its showing on to pallet, I am copying and pasting the whole folder tTurnRow which is further containing two folders tTurnRow and tTurnOut, but when I pasted it separately its working.
Thanks.

All Replies
Moderator

Re: [resolved] tTurnRow not showing on pallet in talend 5.3.0

Hi,
There is a reference on Talend Help Center Installing a custom component. Hope it will be helpful.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] tTurnRow not showing on pallet in talend 5.3.0

Hey xdshi,
I Did same as explained in the help center but still I am not getting tTurnRow component on the pallet Smiley Sad
Thanks
Community Manager

Re: [resolved] tTurnRow not showing on pallet in talend 5.3.0

Hi
First of all, please read that article, as Sabrina suggested, to know how to install a custom component.
tTurnRow is a custom component written and shared by mlange on Talend Exchange, but this component is old, it is not compatible with the new releases of Talend Studio, and mlange do not update it!
To get this component work with the new releases of Talend Studio, you have to modify two places.
1. Modify the tTurnRow_java.xml file, add the family element, for example:
<FAMILIES>
<FAMILY>Processing</FAMILY>
</FAMILIES>
<DOCUMENTATION>
<URL/>
</DOCUMENTATION>
2. Modify the tTurnRow_messages.properties file, remove this line from the file:
FAMILY=Processing
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] tTurnRow not showing on pallet in talend 5.3.0

Hi shong,
Thanks for your quick reply, Still I am not able to find tTurnRow component on pallet, I have modified .properties and xml file as explained by you, I am attaching these two files FYR, please tell me what I am missing here, or what i need to do for get it work .
Thanks
xml File:
<COMPONENT>
<HEADER
PLATEFORM="ALL"
SERIAL=""
VERSION="0.9"
STATUS="ALPHA"
COMPATIBILITY="ALL"
AUTHOR="Talend"
RELEASE_DATE="20080907A"
STARTABLE="false"
SCHEMA_AUTO_PROPAGATE="false"
>
<SIGNATURE/>
</HEADER>
<FAMILIES>
<FAMILY>Processing</FAMILY>
</FAMILIES>
<DOCUMENTATION>
<URL/>
</DOCUMENTATION>

<CONNECTORS>
<CONNECTOR CTYPE="FLOW" MAX_INPUT="1" MAX_OUTPUT="1"/>
<CONNECTOR CTYPE="ITERATE" MAX_OUTPUT="0" MAX_INPUT="0"/>
<CONNECTOR CTYPE="SUBJOB_OK" MAX_INPUT="1" />
<CONNECTOR CTYPE="SUBJOB_ERROR" MAX_INPUT="1" />
<CONNECTOR CTYPE="COMPONENT_OK"/>
<CONNECTOR CTYPE="COMPONENT_ERROR"/>
<CONNECTOR CTYPE="RUN_IF"/>
</CONNECTORS>
<PARAMETERS>
<PARAMETER NAME="SCHEMA" FIELD="SCHEMA_TYPE" REQUIRED="true"
NUM_ROW="10">
<DEFAULT />
</PARAMETER>

<PARAMETER NAME="CONTAIN_COLUMN_AS_HEADER" FIELD="CHECK" NUM_ROW="20" REQUIRED="true" >
<DEFAULT>false</DEFAULT>
</PARAMETER>
</PARAMETERS>
<ADVANCED_PARAMETERS>
<PARAMETER NAME="ADVANCED_SEPARATOR" FIELD="CHECK" REQUIRED="true" NUM_ROW="41" >
<DEFAULT>false</DEFAULT>
</PARAMETER>

<PARAMETER NAME="THOUSANDS_SEPARATOR" FIELD="TEXT" REQUIRED="true" NUM_ROW="41"
SHOW_IF="(ADVANCED_SEPARATOR == 'true')">
<DEFAULT>","</DEFAULT>
</PARAMETER>

<PARAMETER NAME="DECIMAL_SEPARATOR" FIELD="TEXT" REQUIRED="true" NUM_ROW="41"
SHOW_IF="(ADVANCED_SEPARATOR == 'true')">
<DEFAULT>"."</DEFAULT>
</PARAMETER>
</ADVANCED_PARAMETERS>

<CODEGENERATION>
<TEMPLATES INPUT="PIVOUT" OUTPUT="PI">
<TEMPLATE NAME="PIVOUT" COMPONENT="tTurnOut">
<LINK_TO NAME="PI" CTYPE="ROWS_END"/>
</TEMPLATE>

<TEMPLATE NAME="PI" COMPONENT="tArrayIn"/>
<TEMPLATE_PARAM SOURCE="self.CONTAIN_COLUMN_AS_HEADER" TARGET="PIVOUT.CONTAIN_COLUMN_AS_HEADER" />
<TEMPLATE_PARAM SOURCE="self.ADVANCED_SEPARATOR" TARGET="PIVOUT.ADVANCED_SEPARATOR" />
<TEMPLATE_PARAM SOURCE="self.THOUSANDS_SEPARATOR" TARGET="PIVOUT.THOUSANDS_SEPARATOR" />
<TEMPLATE_PARAM SOURCE="self.DECIMAL_SEPARATOR" TARGET="PIVOUT.DECIMAL_SEPARATOR" />
<TEMPLATE_PARAM SOURCE="self.SCHEMA" TARGET="PIVOUT.SCHEMA" />
<TEMPLATE_PARAM SOURCE="self.SCHEMA" TARGET="PI.SCHEMA" />
<TEMPLATE_PARAM SOURCE="self.UNIQUE_NAME" TARGET="PIVOUT.DESTINATION" />
<TEMPLATE_PARAM SOURCE="self.UNIQUE_NAME" TARGET="PI.ORIGIN" />
</TEMPLATES>
</CODEGENERATION>

<RETURNS>
<RETURN NAME="PIVOUT_TURNED_ROWS" TYPE="id_Integer" AVAILABILITY="AFTER"/>
</RETURNS>

</COMPONENT>
-----------------------------------------------------------------------------------------------------------------------------------
.properties file:
NAME=tTurnRow
LONG_NAME=Turns incoming Rows and process the whole result to the next component
HELP=org.talend.help.tTurnRow
CONTAIN_COLUMN_AS_HEADER.NAME=Contain Row as Header
ADVANCED_SEPARATOR.NAME=Advanced separator(for number)
DECIMAL_SEPARATOR.NAME=Decimal separator
THOUSANDS_SEPARATOR.NAME=Thousands separator
Community Manager

Re: [resolved] tTurnRow not showing on pallet in talend 5.3.0

Hi
I have tested to install this component into v5.3.0 and it works, so I can confirm that this component is OK after modifying the two files.
after adding it into the TOS_DI-Win32-r101800-V5.3.0\plugins\org.talend.designer.components.localprovider_5.3.0.r101800\components

Please install the custom components to a dedicated folder, follows the steps in Installing a custom component.
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] tTurnRow not showing on pallet in talend 5.3.0

Hi,
Thanks, Shong now its showing on to pallet, I am copying and pasting the whole folder tTurnRow which is further containing two folders tTurnRow and tTurnOut, but when I pasted it separately its working.
Thanks.
Community Manager

Re: [resolved] tTurnRow not showing on pallet in talend 5.3.0

Cool, thanks for your feedback!
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] tTurnRow not showing on pallet in talend 5.3.0

Hi,
I have modify all the xml file; tturnrow.
But I get the error -
Missing jar:turnHelper.jar

Could anyone know how to fix this error, please help?
EDIT--
Now I fix it. I open modules of TOS and install the jar file in this screen, then now it works! Smiley Happy
Community Manager

Re: [resolved] tTurnRow not showing on pallet in talend 5.3.0

Hi,
I have modify all the xml file; tturnrow.
But I get the error -
Missing jar:turnHelper.jar

Could anyone know how to fix this error, please help?
EDIT--
Now I fix it. I open modules of TOS and install the jar file in this screen, then now it works! Smiley Happy

I give the link about how to install external jars in Talend Studio here for the users who might meet the same problem in future.
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business