Uncategorized

Server Level SSL Encryption

If you are reading this you are more than likely doing so on a web browser and the this site is secured with 256 bit encryption. read more »

TCC

SSO – SP Metadata Generation

There is a URL you need to generate the service provider metadata in Taleo, it’s structured like this:

https://ZoneName/smartorg/sp/metadata.jss?target=EntityID

Where the EntityID is what’s in the “Entity ID or Issuer Identity” under Identity Provider Information in SSO Setup

TCC

TCC – Projection Subquery

I’m not sure why this gives me issues every time but I figured I’d put it here so I can find it next time I need it:


<quer:projection alias="CSWMotive" xmlns:quer="http://www.taleo.com/ws/integration/query">
	<quer:query projectedClass="Application" alias="sqMotives" preventDuplicates="true" pagingsize="1">
		<quer:projections>
			<quer:projection alias="Motive">
				<quer:field path="ProfileInformation,HistoryItems,ApplicationTrackingCSWItem.CSWMotives,Mnemonic"/>
			</quer:projection>
		</quer:projections>
		<quer:filterings>
			<quer:filtering>
				<quer:equal>
					<quer:field path="Number"/>
					<quer:field ownerQuery="MainQuery" path="Number"/>
				</quer:equal>
			</quer:filtering>
			<quer:filtering>
				<quer:equal>
					<quer:field path="ProfileInformation,HistoryItems,ApplicationTrackingCSWItem.Step,Mnemonic"/>
					<quer:field ownerQuery="MainQuery" path="CSWLatestStep,Mnemonic"/>
				</quer:equal>
			</quer:filtering>
			<quer:filtering>
				<quer:equal>
					<quer:field path="ProfileInformation,HistoryItems,ApplicationTrackingCSWItem.Status,Mnemonic"/>
					<quer:field ownerQuery="MainQuery" path="CSWLatestStatus,Mnemonic"/>
				</quer:equal>
			</quer:filtering>
			<quer:filtering>
				<quer:equal>
					<quer:field path="ProfileInformation,HistoryItems,ApplicationTrackingCSWItem.Reverted"/>
					<quer:boolean>false</quer:boolean>
				</quer:equal>
			</quer:filtering>
			<quer:filtering>
				<quer:equal>
					<quer:field path="Candidate,History,ApplicationTrackingCSWItem.Step,Mnemonic"/>
					<quer:string>step_mnemonic</quer:string>
				</quer:equal>
			</quer:filtering>
			<quer:filtering>
				<quer:equal>
					<quer:field path="Candidate,History,ApplicationTrackingCSWItem.Status,Mnemonic"/>
					<quer:string>status_mnemonic</quer:string>
				</quer:equal>
			</quer:filtering>
		</quer:filterings>
	</quer:query>
</quer:projection>

TCC

TCC – Candidate Preferred Phone

When building an export and the spec calls for returning the preferred phone, you can use this decode to avoid all the mouse clicks.

<quer:projection alias="PreferredPhone" xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:decode>
<quer:field path="Candidate,PreferredPhone,Number"/>
<quer:integer>1</quer:integer>
<quer:field path="Candidate,HomePhone"/>
<quer:integer>2</quer:integer>
<quer:field path="Candidate,WorkPhone"/>
<quer:integer>3</quer:integer>
<quer:field path="Candidate,MobilePhone"/>
<quer:integer>4</quer:integer>
<quer:field path="Candidate,PagerPhone"/>
<quer:integer>5</quer:integer>
<quer:field path="Candidate,Fax"/>
</quer:decode>
</quer:projection>
MSSQL

Joins explained

I’ve always had a devil of a time with which join does what. This graphic that I found on StackOverflow had the most amazing graphic that finally set it strait for me, hope it serves you as well.

sql_joins_explained

TCC

TCC – Tab Delimited File

In case you were wondering, here’s how it’s done:

Use the Unicode Hex character code value for the horizontal tabulation character.

Type &#x9; in CSV Value Delimiter.

 

TCC

TCC – Exporting Attached File Content Using Subqueries (Doc ID 1900597.1)

I saw this while I was digging for some other information and it made me wonder if it will work with exporting issues we see with descriptions and qualifications.

Will have that answer soon…

Goal

When executing the sub-query result of a CLOB or BLOB projection, TCC returns the signature of the underlying object (e.g.: oracle.sql.BLOB@334693be), rather than the actual content.

To get the actual content the projections must use a data type cast, but the lob cast in Oracle has a 4000 characters limit, which is insufficient for many attached files.

Solution

In the complex projection, set the projectedValueType to “[B”, example as following

<quer:projection alias=”BLOB” projectedValueType=”[B” xmlns:quer=”http://www.taleo.com/ws/integration/query”>

See the attached sample for a complete example.

References

NOTE:1047850.1 – SD6210 – Exported Attached Files
NOTE:1047912.1 – SD6243 – Base64 String Decoding
BUG:18642011 – EXPORT FILECONTENT IN SUBQUERIES PROJECTIONS

TCC

TCC – Synchronize Custom Fields

One thing that’s really important to remember about TCC is that you have to synchronize the custom fields for any new installation or anytime a UDF has been created in the front end. The feature and product integration packs only have the dictionaries for the standard fields. The custom dictionary is located in the [TCC Installation Directory]\customdictionaries directory.

It is also important to point out that these dictionaries are set by product version.  I.E. if your script is on 13a, you will need to synchonize with 13a, if you synchronized with 15a in TCC you still wouldn’t see the custom fields.

read more »

TCC

TCC – Reset the Collection

User Types and Groups are collections in Taleo. If you need to clear them you can drag the parent entity over to the columns of an import and then you can see the reset the collection is available and checked.  This is a Boolean for the import file.
read more »

TCC

TCC – ISO Locale’s

It always drove me crazy trying to figure out what the ISO codes were for locale, then the light came on and I realized I could export it from the language entity…

read more »