I found the problem. It's a bug. The filter "CTM:SHR:ValidatePersonExist_203" is attempting to validate the user id on the worklog entry against CTM:People. The problem is that it is using the qualification 'Person ID' = $Person ID$.
Person ID on the CTM:People form is the entry id field! Person ID on the work log form is the user id. It will never work. This filter is there to allow you to validate information that had already been promoted but not in the staging forms anymore. But in it's current form will never work. On Thu, Aug 1, 2013 at 6:27 AM, Vyom Labs Support <itsm.supp...@vyomlabs.com > wrote: > ** > > Hi, **** > > **** > > There are 21 spread sheet tabs(sheet(tab) 2 CTM:People and tab 15 > CTM:PeopleWorklog) on the spreadsheet file People.xls which we keep in > folder: C:\Program Files (x86)\BMC > Software\DataManagementClient\7.6\Spreadsheets\Foundation. **** > > After converting this file to CSV we import this CSV Files, So when data > gets imported before promoting we need to validate it.**** > > So for resolving the issue of 108:invalid person which is on tab 15 > CTM:PeopleWorklog we need to validate all the records on the tab 2 > CTM:People.**** > > Errors on the tab(sheet) 2 can be like 118-invalid company, 119-invalid > department, 162-invalid client type. we need to correct these errors first > then validate again error 108-Invalid Person gets resolved.**** > > --**** > > Regards,**** > > Vilas Auti**** > > **** > > Vyom Labs Pvt. Ltd.**** > > BSM Solutions & Services || ITIL Consulting & Training**** > > Email: [hidden > email]<http://ars-action-request-system.1093659.n2.nabble.com/user/SendEmail.jtp?type=node&node=7583733&i=0> > || Web Site: www.vyomlabs.com Follow Vyom Labs > http://twitter.com/#!/vyomlabs || > http://www.linkedin.com/company/vyom-labs**** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Warren R. Baltimore II > *Sent:* Thursday, August 01, 2013 3:06 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Data Load Console Confusion!**** > > ** ** > > ** **** > > ARS 7.6.04 patch1**** > > ITSM 7.6.04**** > > Windows 2008 R2 Server running against MS SQL. Running user tool on the > server.**** > > **** > > I've uploaded via the Data Load Console about 40000 records into the > People form. Now, I'm trying to load associated Work Log/work history.*** > * > > **** > > I'm using the People spreadsheet and have loaded tab 15 with the > information. Everything is being loaded with an Activity Type of General > Information. Each entry has the same Person ID as the corresponding record > already in CTM:People.**** > > **** > > The problem that I am having is every record when I validate is coming > back with an error 108 - Invalid Person.**** > > **** > > I've followed the workflow on the CTM:LoadPeopleWorkLog form, and from > what I see, the person id should be validated almost immediately as the > record exists in CTM:People, but obviously, something is going wrong....** > ** > > **** > > Has anybody ever seen this happen before? > -- > Warren R. Baltimore II > Remedy Developer > 410-533-5367 **** > > _ARSlist: "Where the Answers Are" and have been for 20 years_ **** > _ARSlist: "Where the Answers Are" and have been for 20 years_ -- Warren R. Baltimore II Remedy Developer 410-533-5367 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
