A Social Network for PeopleSoft Professionals

ExcelToCI and Component Interface Problem

I created a Component Interface and have an ExcelToCI that I am using to upload projects and activities. I am using two prompt tables on the record, one for the project_id and one for the activity_id. When I test the CI in App Designer and put in a bogus Project, App Designer produces an error which is what I would expect because it doesn't exist in my underlying prompt table. However, when trying to upload the same bad Project and Activity via ExcelToCI, ExcelToCI successfully submits it to my table and says "OK" on the spreadsheet input form. Has anyone experienced this issue before? I don't think it is my CI because when testing it it failed saying the value I put in was invalid. Thanks!

Tags: component, exceltoci, interface

0 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by Tushar on November 19, 2009 at 9:24am

This wierd behavior is quite common. One of the reason for this is the sequence number of the CI properties. As a workaround you need to recreate a new CI with no properties and then add each field individually in the sequence that works. The same sequence is then picked by ExcelToCI.

▶ Reply

Permalink Reply by Yasmeen S on December 8, 2009 at 11:59am

Hi Chuck,

You do not need to create component interfaces. There are component interfaces already delivered by Peoplesoft. You can use PROJECT_INTFC_PROJ to load projects, PROJECT_INTFC_ACT to load activities, and PROJECT_STG_RESOURCES to load transactions. Let me know if you have any other questions.