User login
Sponsored links
Recent blog posts
- How to resubmit on Integration Broker message with DONE status
- Message cannot be changed. Message referenced in runtime tables (Doc ID 660969.1)
- PeopleSoft Object Type List
- PeopleSoft Data Integrity Error (124,85)
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.
Excel to CI
- Login to post comments
Wed, 06/25/2008 - 1:04am
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
Bookmark/Search this post with
Unanswered Forum Posts
| 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 |
Stay updated
CompShack is a user driven Dev2Dev IT community. Developers can ask questions, help answer questions, or just browse code and articles contributed by users. No registration required.
You can register if you want to contribute code samples, share your knowledge at your own blog, and become adored in the community!
Poll
New forum topics
- Component interface Error: no rows exist for the specified keys
- ADD 24 months starting from current month.(peoplesoft)
- TRC values dropdown
- OHS is rendering XML instead of the view or data
- Search Results
- PS Query - Need Dependency and Prunable examples
- PS HCM AWE - Transaction routing to Requestor for approval, when he is the Delegatee by his 1 up Manager
- how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode
Recent comments
- Re: PeopleCode Check Number and Check Letter Functions
2 years 29 weeks ago - Re: nVision Tabular Report through PIA with prompts
2 years 34 weeks ago - Re: PeopleSoft PeopleTools Meta-Tables
2 years 34 weeks ago - Re: PS Query - Need Dependency and Prunable examples
2 years 36 weeks ago - Re: Search Results
2 years 36 weeks ago - Re: How to schedule appengine using peoplecode
2 years 36 weeks ago - Re: Mark worked in Worklist page
2 years 38 weeks ago - Re: Calculate the sum for a grid field with out using row ...
2 years 40 weeks ago - Re: Invalid SNAC client version
2 years 43 weeks ago - Re: Trace Application Engine Processes Using Process Definitions
2 years 49 weeks ago
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