Wednesday, April 8, 2015

TCC - Exporting Attachments

 

This is something I struggled a lot with, and I am posting this in the hope that the next person struggling with this will find it helpful.

Taleo Enterprise Edition has a complex data model, and this becomes a problem when it comes to mass updates/exports. They provide a windows tool called the Taleo Connect Client (TCC) for this purpose. But the tool does not provide any out-of-box option to export/import files and attachments. For this purpose, consultants were using a custom library called TCCCustomSteps. But there is very little documentation around the subject area, and automating it requires bat files.

cleartext.blogspot.com

1:First, download the TCCCustomSteps library. This used to be hosted on Taleo's knowledge exchange forum, but the links no longer work. You can download a copy from here.

2:Extract the jar files into the \extensions\exernaljars\ folder under your TCC installation.

image

3. There is a product defect in current releases of TCC, you will get jar files when you try to use the TCCCustomsteps library. The fix is to replace commons-lang-2.0.jar with commons-lang-2.6.jar [TCC installation folder]\lib\endorsed.

4. Restart your TCC client.

5. Set up your TCC export and configuration files. Choose XML as the output type in both the files, CSV won't do. In the Projections tab of the export file, map the filename and file contents fields.

image

image

6. Create your TCC config file now, you can choose to create it from the  export file created in the previous step. In the projections tab, remove the StripSoap step, and add an XSL transformation step. cleartext.blogspot.com

image

The XSL step is to filter out only the tags required for the ExtractFile step. Here is the contents of the XSL file:

--------------------------------------------------------------------------------------------------------------------------------------------

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0"
    xmlns:xsl="
http://www.w3.org/1999/XSL/Transform"
    xmlns:to="http://www.taleo.com/ws/integration/toolkit/2005/07"
    xmlns:util="http://www.mavixconsulting.com/2013/XSL/transform"
    exclude-result-prefixes="to util">
<xsl:output method="xml" omit-xml-declaration="yes" indent="yes"/>

<xsl:template match="to:record">
<xsl:element name="file">
    <xsl:attribute name="path">
        <xsl:value-of select="./to:field[@name='FirstName']"/><xsl:value-of select="./to:field[@name='LastName']"/>_<xsl:value-of select="./to:field[@name='AttachedFiles,FileName']"/>
    </xsl:attribute>
    <xsl:element name="content">
        <xsl:value-of select="./to:field[@name='AttachedFiles,FileContent']"/>
    </xsl:element>
</xsl:element>

</xsl:template>
</xsl:stylesheet>

---------------------------------------------------------------------------------------------------------------------------------------

Here is the content of the XML file: cleartext.blogspot.com

---------------------------------------------------------------------------------------------------------------------------------------

<?xml version="1.0" encoding="UTF-8"?>
<files>
[RECORD_OUTPUT]
</files>

---------------------------------------------------------------------------------------------------------------------------------------

7. Add the TCCCustom Step in the config file. For this, add one more "Custom Step" in the "Post-Processing" tab, and select Custom step and "Default custom step" as options.

image

8. For Java Class, enter "com.taleo.integration.client.customstep.xml.ExtractAttachedFilePostStep". Add the remaining values are below:

image

9. Save the config file and run it. The first time you run the export, you might want to change the filter to select a single record and text the export. When the run completes, the file attached will be exported into the output folder.

cleartext.blogspot.com

And that is all. There are other classes in the JAR which can be used to change filters , convert to PDF, and further manipulate the xml file.

 

This article first appeared on cleartext.blogspot.com

25 comments:

  1. Hello Static Variable,
    Thanks for posting this article. I'm the next person struggling with Exporting Attachments.
    I followed the instructions but i'm getting "An internal error occurred during running export script."
    There is no error code or log message. Any advise on troubleshooting it? Thanks much.

    ReplyDelete
    Replies
    1. I have the same issue. If `TCCCustomSteps` is placed in `lib\endorsed` or `extensions\externaljars`, TCC will fail with an internal error as soon as a CFG is run.

      Specs: Windows Server 2012 (64 bit), Taleo Client Connect 15A, TCCCustomSteps_1.5.3.jar, commons-lang-2.6.jar

      Delete
    2. This comment has been removed by the author.

      Delete
    3. This comment has been removed by the author.

      Delete
    4. Looking at the log, it looks like the error is caused by a Java exception. (java.lang.ClassNotFoundException: org.dom4j.ElementHandler)

      https://gist.github.com/stevoisiak/0dc6637efc1c0962e522ec8f5a89724d

      As a workaround, try running your script from the command line with `TaleoConnectClient.bat`.

      Delete
  2. Hi,
    I am unable to download the TCCCustomStep library from Dropbox can you please tell me from where i can get it.
    I want to exports attachments from taleo to System through TCC is there any other way to export attachments from taleo through TCC. Can you provide detail steps how to exports attachments through TCC

    ReplyDelete
    Replies
    1. Were you able to get a copy of the Custom Step library?

      Delete
  3. I am also looking for the Custom Step Library.

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Where can I download TCCCustomSteps library, I really need it to extract CV from TCC. As of now all process of TCC extraction is working well except last step on customsteps, it always said that cannot find JAR file. Please help me to define this problem

    ReplyDelete
  6. Go to ohug.or and seach in the Enterprise Integrations (TCC) SIG

    ReplyDelete
  7. Hi..

    The link to download .jar files is not working. Could you please be kind to provide me the files required for this process.

    Thanks in advance and really appreciate your earliest response.

    Regards
    Siva

    ReplyDelete
  8. Hi team. If you want to save a lot of time in developing exports of attachments from Taleo Recruiting / Onboarding / Transitions, I suggest you contact us at The Cloud Connectors, as we have done this previously and there are quite a few considerations and options to export such data. I personnally worked 17 years at Taleo/Oracle. Cheers, Pierre Laurin. plaurin@thecloudconnectors.com

    ReplyDelete
  9. Brilliant blog I visit this blog it's incredibly awesome. Curiously, in this blog content formed doubtlessly and sensible. The substance of information is helpful.
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training
    Oracle Fusion Financials Online Training
    Big Data and Hadoop Training In Hyderabad
    Workday HCM Online Training

    ReplyDelete
  10. Hi, I am unable to see the screenshots in this article.
    Could you add them again..

    ReplyDelete
  11. Can you please share the screen shots,as its not visible anymore.

    ReplyDelete
  12. Hi, My script is running fine, but there are no documents getting extracted.
    Could you please suggest.

    Regards,
    Taniya

    ReplyDelete
  13. I am also having issue seeing the screenshots.

    ReplyDelete
  14. i am also having issue with the screenshots. Can you upload the screenshots again.

    ReplyDelete
  15. Hi.. I cannot see the screenshots here.
    I also want some guidance regarding downloading the onboarding e-signed docs like Offer letter,agreemnets, etc

    ReplyDelete
  16. Great read! Thank you for such useful insights. Visit here for advanced technical courses on SAP BPC ONLINE TRAINING

    ReplyDelete
  17. Hi...Is anyone know which JAR file is used to unzip the file twice times from Transition entity.

    ReplyDelete
  18. Thank you so much for the above info..Can anyone pls let me know what name and value pairs should be used if we are using the JAR file "com.taleo.integration.client.customstep.xml.ExtractFilesPostStep" to export transition document in PDF form.Operations to perform are Decodebase64 code and unzip doc twice time).

    ReplyDelete