Push components to palette failed for these invalid XML files. tGSpreadsheetInput_java.xml please help

Four Stars

Push components to palette failed for these invalid XML files. tGSpreadsheetInput_java.xml please help

 

Screenshot from 2017-06-10 22-47-15.png

 

Four Stars

Re: Push components to palette failed for these invalid XML files. tGSpreadsheetInput_java.xml please help

it's showing error in below xml line 16 as (There is an error on line 16: cvc-complex-type.2.4.a: invalid content was found starting with element 'DOCUMENTATION'. one of '{FAMILIES}' is expected.)

 

<COMPONENT>
  <HEADER
    PLATEFORM="ALL"
    SERIAL=""
    VERSION="0.1"
    STATUS="ALPHA"
    
    COMPATIBILITY="ALL"
    AUTHOR="ThomasFriebel"
    RELEASE_DATE="20090217A"
    STARTABLE="true"
  >
    <SIGNATURE/>
  </HEADER>

  <DOCUMENTATION>
    <URL/>
  </DOCUMENTATION>

  <CONNECTORS>
    <CONNECTOR CTYPE="FLOW" MAX_INPUT="0" MAX_OUTPUT="1"/>
    <CONNECTOR CTYPE="ITERATE" MAX_OUTPUT="1" MAX_INPUT="1"/>
    <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="1"
    />
    <PARAMETER
      NAME="USER"
      FIELD="TEXT"
      NUM_ROW="10"
      REQUIRED="true"
    >
      <DEFAULT>""</DEFAULT>
    </PARAMETER>
 
    <PARAMETER
      NAME="PASSWORD"
      FIELD="TEXT"
      NUM_ROW="20"
      REQUIRED="true"
    >
      <DEFAULT>""</DEFAULT>
    </PARAMETER>

    <PARAMETER
      NAME="USEKEY"
      FIELD="CHECK"
      NUM_ROW="25"
      REQUIRED="false"
    >
      <DEFAULT>true</DEFAULT>
    </PARAMETER>     

    <PARAMETER
      NAME="SPREADSHEET"
      FIELD="TEXT"
      NUM_ROW="30"
      REQUIRED="true"
    >
      <DEFAULT>""</DEFAULT>
    </PARAMETER>     
    <PARAMETER
      NAME="WORKSHEET"
      FIELD="TEXT"
      NUM_ROW="40"
      REQUIRED="false"
    >
      <DEFAULT>""</DEFAULT>
    </PARAMETER>     
    </PARAMETERS>

  <CODEGENERATION>
        <IMPORTS>
            <IMPORT NAME="gclientmeta" MODULE="gdata-client-meta-1.0.jar" REQUIRED="true" />
            <IMPORT NAME="gcore" MODULE="gdata-core-1.0.jar" REQUIRED="true" />
            <IMPORT NAME="gclient" MODULE="gdata-client-1.0.jar" REQUIRED="true" />
            <IMPORT NAME="gspread" MODULE="gdata-spreadsheet-2.0.jar" REQUIRED="true" />
            <IMPORT NAME="gspreadmeta" MODULE="gdata-spreadsheet-meta-2.0.jar" REQUIRED="true" />
        </IMPORTS>
  </CODEGENERATION>

  <RETURNS>
    <RETURN NAME="NB_LINE" TYPE="INTEGER" AVAILABILITY="AFTER"/>
  </RETURNS>

</COMPONENT>

Moderator

Re: Push components to palette failed for these invalid XML files. tGSpreadsheetInput_java.xml please help

Hello,

Do you want to install a custom component into studio?

Have you already checked online document about:TalendHelpCenter:Installing a custom component?

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.
Five Stars

Re: Push components to palette failed for these invalid XML files. tGSpreadsheetInput_java.xml please help

Right click in the XML file and select -> Validate Component XML

Then the error and line will show!

One Star

Re: Push components to palette failed for these invalid XML files. tGSpreadsheetInput_java.xml please help

Do you have the other simple way to solve this problem?

I see it's quite complicated!

Moderator

Re: Push components to palette failed for these invalid XML files. tGSpreadsheetInput_java.xml please help

Hi,

What's the error message you are getting when install a custom component into talend studio?

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.
Four Stars

Re: Push components to palette failed for these invalid XML files. tGSpreadsheetInput_java.xml please help

I am encountering same error with this component. Is there a fix to this xml issue. Please share

Four Stars

Re: Push components to palette failed for these invalid XML files. tGSpreadsheetInput_java.xml please help

Fix for xml is to add the following tag 

 

<FAMILIES>

<FAMILY>Google Drive</FAMILY>

</FAMILIES>

 

this will validate the xml and allow you to push the component. 

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.