jump to navigation

ExcelToCI and SSL April 7, 2010

Posted by Tipster 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!

Comments»

No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 148 other followers