[resolved] tTurnRow not showing on pallet in talend 5.3.0

[Anonymous]

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

[Anonymous]

Hi,
There is a reference on Talend Help Center Installing a custom component. Hope it will be helpful.
Best regards
Sabrina

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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.

[Anonymous]

Cool, thanks for your feedback!
Shong

[Anonymous]

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!

[Anonymous]

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!

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