ExcelToCI

Related PeopleSoft Wiki Articles

Resources on the Internet

Link Site Description
Import Data with ExcelToCI ERP Associates Explains how to import data using ExcelToCI, including how to connect, load data, and deal with errors. There also some useful comments posted after the article.
ExcelToCI with SSL Javaier's PeopleSoft Blog Explains how to get ExcelToCI working with SSL
ExcelToCI Utility Hexaware Goes through ExcelToCI and how it works.
ExcelToCI limitations Javier's PeopleSoft Blog Talks about some of the significant limitations of ExcelToCI.
ExcelToCI Troubleshooting Guide The World is not Enough Word document that goes through using ExcelToCI and testing/troubleshooting.

Security

As discussed in this forum post, ensure that the user connecting with ExcelToCI has access to the WEBLIB_SOAPTOCI web library through an appropriate permission list.

If they don't have access they will get the error message:
"The response text is not valid XML. Login data cleared"

You can use the following SQL to get a list of permission lists with access to the web library.

select distinct CLASSID from PSAUTHWEBLIBVW where MENUNAME = 'WEBLIB_SOAPTOCI';

And either give the user one of those permission lists or add the web library to web library security in a permission list they already have.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License