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>
If you ever get this on an export it may be because you used the keyword ‘Initial’ someplace as an alias. Not much fun tracking that down…