jump to navigation

ExcelToCI and SSL April 7, 2010

Posted by Duncan in PeopleTools.
trackback

ExcelToCI is a very handy tool in the right circumstances.  It has got significantly easier to use as each new version of PeopleSoft has been released too.  It does have some quirks however.  Among these is that it can be a little difficult to use with SSL.

Many companies use HTTP for test environments, in which case your ExcelToCI upload might be fine in these environments, but in Production (which likely uses HTTPS) there is extra work to do.

If your SSL certificate is valid for the hostname, not expired and was issued by a trusted root certificate authority you might well be fine.  Just change the parameters on the Connection tab and you’re good to go.

If your certificate was issued by a Company stand-alone CA things can be a little trickier.  I faced this issue recently and received a cryptic error message relating to GetCIShape (error number 2146697208 – “The download of the specified resource has failed”).  It took a while to work out what was wrong.  There were no results on MyOracleSupport and Google didn’t turn up anything useful.

It was only when I turned to Bing (yes, I know!) that I found something.

http://javier-ps.blogspot.com/2010/02/exceltoci-under-https-with-ssl.html

Thank you Javier!

Advertisements
%d bloggers like this: