Author Archives: Aron

TCC – Employee Net-Change Musings

November 20, 2020 – 2:51 pm

If you’ve ever done time with TCC you’ll know that the bane of the out of the box integration possibilities is the employee net-change. This is because it’s a marriage of candidate and user and depending on both of those tables to be clean and ready for this is asking a lot.
I ran across a MOS article that actually made clear about the lookups for those two tables. It’s article Doc ID 1047682.1 and here is the PDF defining the candidate/user update columns in the employee net-change sample.

Doc-ID-1047682.1Download
Permalink | Comments Off on TCC – Employee Net-Change Musings

TCC – Text in Export Spec (warning)

November 9, 2020 – 4:37 pm

A long time ago I posted the code to be able to put test in a column in an export specification. This one in case you need to read the original.
There is an oddity with this in that if you alias “Comment” you will get a sax parsing error. The specific error is: “ORA-00936: missing expression”. I’m not sure why but you have to alias your comment as something other than “Comment”

8/20/2021 – Just found out an alias of Union will do the same thing.

Permalink | Comments Off on TCC – Text in Export Spec (warning)

TCC – What Templates Are Active

November 2, 2020 – 3:29 pm

So this is specifically for job templates but can be adapted to anything that needs to find out what languages are active for any given situation.

Permalink | Comments Off on TCC – What Templates Are Active

TCC & Powershell – CSV to Set Filters

October 26, 2020 – 4:41 pm

If you’ve been working with TCC for any length of time you’ll know the purple squirrel, rainbow unicorn and pot at the end of the rainbow is being able to set the filters based on a CSV. This ability would mark a boon for automating ad hoc integrations.

Now there are options, Python could pull it off but Python doesn’t live and play on a stock server I run across 95% of the time. Powershell does however, well it usually lives there, not sure how much play is involved.

In any case, it turns out we can do this whole process in Powershell without a whole bunch of headache.

Permalink | Comments Off on TCC & Powershell – CSV to Set Filters

TCC – LRD when it doesn’t exist

October 19, 2020 – 6:02 pm

As you know the automated process for producing exports relies heavily on the last run date. I’ve always been curious as to what happens when you pull the trigger on one that uses it without a lrd, turns out if there is no lrd file is gives you the last 24 hours and instantiates the lrd. I’ll sleep better tonight knowing this.

Permalink | Comments Off on TCC – LRD when it doesn’t exist

Python – Reading CSV as input

August 10, 2020 – 9:43 pm

One of the more fascinating aspects of python is it’s file manipulation capabilities. I have from time to time needed to process (create) 160 or so new batch files to call warehouse integrations. With proper naming convention in development, this process is handled with 21 lines of python code. Love it!!!

Permalink | Comments Off on Python – Reading CSV as input

Taleo SSO Metadata URL

July 8, 2020 – 1:35 pm

I can’t for the life of me keep track of this so here it is so I know where to look for it.

https://ZONE.taleo.net/smartorg/sp/metadata.jss?target={ENTITY-ID}

https://ZONE.taleo.net/careersection/sp/metadata.jss?target={ENTITY-ID}

Permalink | Comments Off on Taleo SSO Metadata URL

File – Data or No Data

May 26, 2020 – 10:22 am

A lot of the work we do for integration is of course automated. Sometimes we have to extract a data set and then use that export as the import to another integration. This is fine and well if there is data but if you have to run it every, let’s say, 5 minutes, there may very well be a situation where there isn’t anything to pick up. The matter is complicated by the fact that even if there isn’t any information there will be a header row.
This file is now completely useless and if left in place it will run through the process and wind up in the archive and produce a results file meaning you have to dig through empty files to try to find what’s going on.
To fix this I came across a batch file that will check the file and delete it if it has only a header row, a further check makes sure that that if any data is there is ignores the file. For your consideration and my reference here is the file that does this.

Permalink | Comments Off on File – Data or No Data

TCC – Date Certain Step/Status Achieved

April 29, 2020 – 12:31 pm

I ran into an issue trying to get everyone within the last 24 hours that had achieved a certain step/status combination. The hitch was that they could have been moved out of the target step/status so we have to muck around in the history to get it. As it’s a date you need to make sure the projected value you’re comparing to is a date as well since the last 24 hours is always going to be date time. This did the trick. Remember to pay attention to the value types in sub queries like this.

Permalink | Comments Off on TCC – Date Certain Step/Status Achieved

PowerShell – Replace in Files

April 24, 2020 – 12:23 pm

One of the hard parts about working on remote servers is they don’t usually have the proper toolkit to fix things as needed, meaning you have to make the changes in the development workstation, repackage and post, pull, copy, extract and paste in order to get anything done. Fine if it’s the initial load but when you only need to change something in a dozen files or so it can be tedious. So in the spirit of making due with what you have, you can use PowerShell to emulate the replace in file normally invoked from Notepad++ to work around it.
Here is the example:

Permalink | Comments Off on PowerShell – Replace in Files

« Previous Page — Next Page »

« Previous Page — Next Page »