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=node&node=7583733&i=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 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_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
