Hello,
We are trying to use Excel to CI to load data. The CI has 2 levels with level 1 being effective dates.
The requirement is to load data as is. But we realized, that for certain fields values from the previous row are carrying over. we want those fields to be blank.
How can we prevent the default from being carried over ? ( we want this carry over behaviour to be disabled and just want the values in the data entry sheet to be used.
Is this doable ?
HH
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Do you get the same type of behavior when you enter data online? If so, then are these record defaults? If they are then the only way around it is by writing some PeopleCode to handle the value of the fields if the data is being entered through a Component Interface. There is a PeopleCode built-in function that will prevent the code from firing if it is not called from a CI. I think the function is %CompIntfcName.
Also, instead of not sending any values from the Excel to CI for those fields, try sending like a "Blank" for character fields and zero for number type fields.
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
The values are not defaults. But values copied from the previous row.
I will try with blanks..
Thanks
HH