Search code examples
excelinterfacecomponentspeoplesoft

PeopleSoft ExceltoCI - not saving zeros

I am trying to load some data into a custom table PeopleSoft using the delivered ExceltoCI utilty. I have a record with a single key -EMPLID; we are expecting only one row per employee, not effective dated or anything like that. In addition to EMPLID, I have about 9 numeric fields. The upload process appears to work - the status for each row of data is the green OK, but with certain rows of data, when I check online or in my SQL tool, the data is not there. This occurs when all of the 9 numeric fields in the data entry tab of the spreadsheet are set to 0. All other rows load ok. I am able to enter the data containig all zeros online. I have noticed that if I set the default value of one of the numeric fields to 1, everything loads (but not if I set it to 0) through the utility.

Thanks in advance!

Solution

  • Here's what I wound up doing: On one of the numeric fields I placed some PeopleCode in the RowInit event:

    If None(MARKET_PAY.MARKET_LOW) Then MARKET_PAY.MARKET_LOW = 1; MARKET_PAY.MARKET_LOW = 0; End-If;

    It accomplishes what I'm after but feels like a kludge - would be grateful if someone could provide a more elegant or "proper" solution.