Re: Data Load Console Confusion!
Hi, we are looking at this issue and the data stored in the Person ID field in the CTM:People WorkLog form is the entry ID of the Person record in the CTM:People form. So there are no data issues here. In addition, if you are validating CTM:LoadPeopleWorkLog records against people records on the CTM:LoadPeople form then you need to ensure that the records on the CTM:LoadPeople form are validated without error. I suggest to log a support issue if you have further problems loading data this way we can take a look at the data in question. Thanks, Art ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Data Load Console Confusion!
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: http://ars-action-request-system.1093659.n2.nabble.com/user/SendEmail.jtp?t ype=nodenode=7583733i=0 [hidden email] || Web Site: http://www.vyomlabs.com www.vyomlabs.com Follow Vyom Labs http://twitter.com/#%21/vyomlabs http://twitter.com/#!/vyomlabs || http://www.linkedin.com/company/vyom-labs 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 4 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Data Load Console Confusion!
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=nodenode=7583733i=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 4 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
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 4 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years