As I’m digging through the archives, I’m running across some fairly neat stuff that had been put together while I was working on my degree and needing things to create.

One of them is this Touchpoints which returns counts from all the tables that TCC has access to in the data models. This is helpful to find out how much data is actually in the database in preparation for warehousing or decommissioning. This will help you provision the proper space for either of the situations.

It’s a standard TCC Touchpoints, fill out the configuration information within the configboards directory for the zones to query. Then set the variables within the \bin\windows\Environment.bat file. Line 4 is the directory to the TaleoConnectClient.exe provided from Oracle.
To retrieve all files launch the \bin\windows_FullAll.bat file.

Someone had inquired about doing a data warehouse with TCC. I kind of chuckled because after I finished up my degree in 2022, to kill time and have fun I built one that all you really had to do was install MariaDB, Python & TCC and you had a quick and easy system that brought all the data from Taleo over to a MariaDB instance with Python handling the sticky work. Add to that the one that Taleo built themselves in 2013 and the one that the Cloud Connectors built… Well let’s just say there are options. Here is the original concept doc from Taleo and the last one that I did as a consultant prior to building the aforementioned Maria, Python, and TCC project so you can see what’s there.

In Taleo, if you are going to create a PDF of the offer letter, you have to do so ‘on the fly’ like the system does. A lot of times, you’ll need the image for the token {Other.CompanyLogos1}. But where do you find this image? While logically you’d believe that there’s a media link someplace to see what they are, you’d be half right. It’s not in the system but if you use http://zonename.taleo.net/custom/images/company_logo_XX.gif with XX being 01 – 30, you can see them.

The ramifications of doing it this way are that if you change the image, it’s updated for any link using that image. This means if you change the image it will change on anything that references that gif.

It’s been so long since I’ve worked without these that I forgot that it’s not part an parcel of an implementation if said implementation was done long enough ago. I first got acquainted with TCC in late 2005 and the TCC_Touchpoints weren’t released until November of 2009.

So without further ado, here is the documentation on it as well as an empty touchpoints to get you started.

So it seems that Oracle has release the much awaited TCC 22a.1 to fix the log4j issue. But it seems to have an issue when the TaleoConnectClient.bat is called which is the case for every scheduled integration. Someplace there is a call to saxon8.jar when this release ships with saxon10.jar. While you’ll be able to run the integration in the GUI, once you try to run a CLI job you’ll get something like this:

C:\onedrive_tt\Client\TCC_Touchpoints\bin\Windows>test22-candidateExport.bat > batchRun.txt
Error: Unable to access jarfile C:\TCC\TaleoConnectClient22a1\lib\saxon8.jar
Error: Unable to access jarfile C:\TCC\TaleoConnectClient22a1\lib\saxon8.jar
Error: Unable to access jarfile C:\TCC\TaleoConnectClient22a1\lib\saxon8.jar
Error: Unable to access jarfile C:\TCC\TaleoConnectClient22a1\lib\saxon8.jar
Error: Unable to access jarfile C:\TCC\TaleoConnectClient22a1\lib\saxon8.jar
Error: Unable to access jarfile C:\TCC\TaleoConnectClient22a1\lib\saxon8.jar
Error: Unable to access jarfile C:\TCC\TaleoConnectClient22a1\lib\saxon8.jar

C:\onedrive_tt\Client\TCC_Touchpoints\bin\Windows>CLS
### ERROR - The default endpoint must be defined with a vaild host. ###
Press any key to continue . . . 

Issue was found the issue last week on 4/7, will try to get a case open on it. In any case a work around is to actually put the saxon8.jar in the lib so it will run but it won’t log or return anything so you have to check the profiler.

In normal circumstances, I’d just give a link to where these files live but from the best I can tell their home on the web has been removed. So given that they were released under open source, I’ll provide the files in that spirit as I’m not sure where else they exist.

This is for when you need to have the results file sent to you if there are errors in said results file. This can be a little tricky because you will not get a file if all elements were successful although you can probably do something about that with the trigger rule.
In any case this is the last custom step of the post process and assuming you have the mail host set properly in the config boards, you should be golden.

<cli:CustomStep>
	<cli:JavaClass>com.taleo.integration.client.customstep.mail.SendEmailPostStep</cli:JavaClass>
	<cli:Parameters>
		<cli:Parameter>
			<cli:Name>active</cli:Name>
			<cli:Value>true</cli:Value>
		</cli:Parameter>
		<cli:Parameter>
			<cli:Name>SMTPHost</cli:Name>
			<cli:Value>[MAIL_HOST]</cli:Value>
		</cli:Parameter>
		<cli:Parameter>
			<cli:Name>from</cli:Name>
			<cli:Value>[ALERTING_MAIL_FROM]</cli:Value>
		</cli:Parameter>
		<cli:Parameter>
			<cli:Name>to</cli:Name>
			<cli:Value>[ALERTING_MAIL_ON_ERROR_TO]</cli:Value>
		</cli:Parameter>
		<cli:Parameter>
			<cli:Name>subject</cli:Name>
			<cli:Value>Reporting - Subject/Object of Integration</cli:Value>
		</cli:Parameter>
		<cli:Parameter>
			<cli:Name>messageTemplate</cli:Name>
			<cli:Value>$file.content()</cli:Value>
		</cli:Parameter>
		<cli:Parameter>
			<cli:Name>sendAttachment</cli:Name>
			<cli:Value>true</cli:Value>
		</cli:Parameter>
		<cli:Parameter>
			<cli:Name>triggeringRule</cli:Name>
			<cli:Value>$logic.greaterThan($file.errorCount(),0)</cli:Value>
		</cli:Parameter>
	</cli:Parameters>
</cli:CustomStep>

So word came down through the grapevine that Taleo is no longer being sold by Oracle and the end of life has been set at 4 years, I guess that would be 2025. It’s funny to think back and I’ve been dealing with Taleo in one form or another since 2007, the last 14 years, and just over a quarter of that time it will cease to exist.

Super annoying considering I was planning on doing the TCC thing into retirement but no biggie, there’s bigger and better fish to fry hopefully outside the Oracle sphere of products. Candidly I’m thinking of Workday but I’ve peaked behind the curtain of the ATS portion of the product and it’s a little scary that it’s that convoluted and disoriented. I’m wondering if the decision in 2013 to stick with Taleo vs SalesForce was right, although I can’t be sure, my path is set by a higher order and I’m here to learn and enjoy the ride. Looking forward to what’s around the next bend!

So looping is great if you have a static set that you are pulling, think a big set of resumes. But what if you are using this as part of an ongoing and looping is needed with a LRD. Fear not, this is how you do it.

Pre-processing:
1st step – com.taleo.integration.client.customstep.paging.PagingPreStep
Arguments:
pagingSize
100000
pagingFilename
[CFGFOLDER]\pagefile.pgn

2nd step – com.taleo.integration.client.customstep.lrd.LRDPreStep
Arguments :
lrdFilename
LRD filename, this will be the name as created by the config in the standard LRD location

Post-processing (no arguments needed):
1st step – com.taleo.integration.client.customstep.count.ExportCountPostStep
2nd to last step – com.taleo.integration.client.customstep.paging.PagingPostStep
Last step – com.taleo.integration.client.customstep.lrd.LRDPostStep