Archives: August 26, 2015

For the next time I need this because my editor is buggy:

<quer:projection alias="Ident" xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:concatenate>
<quer:field path="Candidate,Number"/>
<quer:string>_</quer:string>
<quer:field path="Requisition,Number"/>
</quer:concatenate>
</quer:projection>

One thing about TCC is that you do have to deal with export limits, now 500k records a day sounds like a lot but you have to break those down into 100k chunks and therein lies the rub.  Fortunately there is a way around that, check out this document in the MOS for directions on dealing with this.

Some how and some way I managed to goof up my development box so that for a function projection such as decode, I do not see the function parameters. Yes I know, sigh… So here is the basic decode statement to use for the times when I need a decode:

<quer:projection alias="EEORace_DNP" xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:decode>
<quer:field path="path"/>
<quer:field path="path"/>
<quer:field path="path"/>
</quer:decode>
</quer:projection>

I’m not sure how I’ve been working with TCC for 7 years and didn’t realize that this was an option, I haven’t gone back in to check the documentation to see if it’s there but it would seem to me that I’d have found that by now if it was. Many times we need to return things that are in a list. Well that’s a bit difficult to do unless you can utilize that list to get the correct items. I ran across includedIn that uses a list to do just that. Here’s the snippet to get you on your way.

<quer:filtering xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:includedIn>
<quer:field path="Requisition,ContestNumber"/>
<quer:list>
<quer:string>150000AO</quer:string>
<quer:string>1400013A</quer:string>
</quer:list>
</quer:includedIn>
</quer:filtering>

I think you should probably do this for every zone your in but if you need to make an attachment a resume. You must use attache-file-to-profile-by-type or application by type and use one of the types listed here:

Read More

Took a while to figure this out so figured I’d better put it here for safe keeping…

<quer:projection alias="SSN2" xmlns:quer="http://www.taleo.com/ws/integration/query">
	<quer:replace>
		<quer:replace>
			<quer:field path="Title"/>
			<quer:string>,</quer:string>
			<quer:string/>
		</quer:replace>
		<quer:string>|</quer:string>
		<quer:string/>
	</quer:replace>
</quer:projection>

Needed this for a project and seemed to work pretty well for nesting operations.

<quer:projection alias="SSN2" xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:substring>
<quer:toChar>
<quer:customFunction name="REGEXP_REPLACE">
<quer:field path="Candidate,SocialSecurityNumber"/>
<quer:string>[^[:digit:]]</quer:string>
<quer:string/>
</quer:customFunction>
</quer:toChar>
<quer:integer>6</quer:integer>
<quer:integer>4</quer:integer>
</quer:substring>
</quer:projection>

So I’ve recently been dealing with a Linux installation with TCC and truth be told, don’t try to play this tune unless you can install the (deprecated) 1.6 JRE. Considering they are now Oracle, your would think that they would fix it. NEVER try to use 1.7.X with TCC on Linux, you will have a bad day…

If you’ve used TCC for any length of time, you’ll know that the best way to develop is in the touch points. That being said you’ll have to write a batch or shell script to execute. Here is the formulation of the export:

taleoconnectclient.bat [cfg file to be called] [sq file to be called] [Where the output file goes]

The import is as such:
taleoconnectclient.bat [cfg file to be called] [file to be sent] [response file]

Got this right for exporting a new password based on the last 4 of social as related to information directly in the system:

<quer:projection alias="NewPassword" xmlns:quer="http://www.taleo.com/ws/integration/query">
  <quer:concatenate>
    <quer:string>Taleo</quer:string>
    <quer:substring>
      <quer:toChar>
        <quer:customFunction name="REGEXP_REPLACE">
          <quer:field path="Candidate,SocialSecurityNumber"/>
          <quer:string>[^[:digit:]]</quer:string>
          <quer:string/>
        </quer:customFunction>
      </quer:toChar>
      <quer:integer>6</quer:integer>
      <quer:integer>4</quer:integer>
    </quer:substring>
  </quer:concatenate>
</quer:projection>