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.
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.
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
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.
8. For Java Class, enter "com.taleo.integration.client.customstep.xml.ExtractAttachedFilePostStep". Add the remaining values are below:
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
Hello Static Variable,
ReplyDeleteThanks 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.
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.
DeleteSpecs: Windows Server 2012 (64 bit), Taleo Client Connect 15A, TCCCustomSteps_1.5.3.jar, commons-lang-2.6.jar
This comment has been removed by the author.
DeleteThis comment has been removed by the author.
DeleteLooking at the log, it looks like the error is caused by a Java exception. (java.lang.ClassNotFoundException: org.dom4j.ElementHandler)
Deletehttps://gist.github.com/stevoisiak/0dc6637efc1c0962e522ec8f5a89724d
As a workaround, try running your script from the command line with `TaleoConnectClient.bat`.
Hi,
ReplyDeleteI 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
Were you able to get a copy of the Custom Step library?
DeleteI am also looking for the Custom Step Library.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteWhere 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
ReplyDeleteGo to ohug.or and seach in the Enterprise Integrations (TCC) SIG
ReplyDeleteOhug.org
ReplyDeleteHi..
ReplyDeleteThe 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
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
ReplyDeleteBrilliant blog I visit this blog it's incredibly awesome. Curiously, in this blog content formed doubtlessly and sensible. The substance of information is helpful.
ReplyDeleteOracle 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
Hi, I am unable to see the screenshots in this article.
ReplyDeleteCould you add them again..
Hi Murali,
DeleteDid you get screenshots yet.
Can you please share the screen shots,as its not visible anymore.
ReplyDeleteHi, My script is running fine, but there are no documents getting extracted.
ReplyDeleteCould you please suggest.
Regards,
Taniya
I am also having issue seeing the screenshots.
ReplyDeletei am also having issue with the screenshots. Can you upload the screenshots again.
ReplyDeleteHi.. I cannot see the screenshots here.
ReplyDeleteI also want some guidance regarding downloading the onboarding e-signed docs like Offer letter,agreemnets, etc
Great read! Thank you for such useful insights. Visit here for advanced technical courses on SAP BPC ONLINE TRAINING
ReplyDeleteHi...Is anyone know which JAR file is used to unzip the file twice times from Transition entity.
ReplyDeleteThank 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