ExcelToCI via HTTPS - solved

PeopleTools has a very handy tool for loading excel spreadsheets directly into PeopleSoft via an application class named ExceltoCI (short for Excel to Component Interface). On numerous occasions I've seen requests for help on how to get this to work via secure HTTP. I recently ran across this post from Javier Delgado on how to get the utility to work via an HTTPS connection. You can see the full article here. Special thanks to the PeopleSoft Tipster blog for pointing out Javier's post.

 

Our solution was to modify the ExcelToCI macros to tell them to ignore SSL certificate errors. To do so, we had to do the following changes on the CreateCITemplate.sendSOAPRequest_GetCIShape() and StagingAndSubmission.sendSOAPRequest_SubmitToDB() functions:

  • Replace the following variable declaration:

Dim xHTTP As XMLHTTP

by

Dim xHTTP As New MSXML2.ServerXMLHTTP40
 

 

Have a great one - PC

Recent Stories
Alliance 2020 Session Presentation Proposal

2020 Advisory Group Nominations are Now Open!

"Whiz Wit", "Water Ice" and "Tastykake"