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

2 replies [Last post]
Guest's picture
Guest

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

Lepa's picture
User offline. Last seen 1 year 39 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Excel to CI

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

Guest's picture
Guest (not verified)
Re: Excel to CI

The values are not defaults. But values copied from the previous row.

I will try with blanks..
Thanks
HH