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.
