Hi Srikanth,
If you are having EIE,you can create 3 or 4 instances(depends on
sources) and map the fields and can auomate the import process.
Thanks
Satya
On 8/1/07, Srikanth <[EMAIL PROTECTED]> wrote:
>
> Thanks for the information Carolyn!
> I will take a look.
>
> Thanks,
> Srikanth
>
> On Aug 1, 11:21 am, Carolyn Agabin <[EMAIL PROTECTED]> wrote:
> > Hi, Srikanth.
> >
> > You could give our product a try. It is called QuickStart Standard
> Edition
> > Datalink that we used to deploy ITSM 7.0 applications. This tool
> supports
> > the data load for the basic ITSM 7.0 foundation forms including people
> > (CTM:People). It takes the data in the form of csv files and import the
> > data into the ITSM foundation forms via the QuickStart staging
> forms. It
> > may not have everything you need, but it provides a framework for you to
> > start with and add to.
> >
> > This product is free and is available for download athttp://www.effect-
> tech.com/products2.html
> >
> > Thanks,
> > Carolyn
> > Effective Technologieshttp://www.effect-tech.com
> >
> >
> >
> > -----Original Message-----
> > From: Action Request System discussion list(ARSList)
> >
> > [mailto:[EMAIL PROTECTED] On Behalf Of Srikanth
> > Sent: Wednesday, August 01, 2007 7:04 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Import of People data into ITSM 7
> >
> > Yes, Shawn
> > We are having three different sources of data- LDAP, HRMS and Notes. I
> > am planning to extract data using SQL scripts and then merge them into
> > a single csv file.
> > We would be doing the load on daily basis.
> > i.e Update the information for the existing users if there is any
> > change
> > Create new users
> >
> > On Aug 1, 9:07 am, "Pierson, Shawn" <[EMAIL PROTECTED]> wrote:
> > > Srikanth,
> >
> > > The good thing about the staging form is that you can push to it from
> > > anywhere. Using the flat file or csv the first time will work, but I
> > > would build it in such a way that you can leverage it from Oracle,
> SAP,
> > > LDAP, or whatever source of People data you can find to pull it from
> > > also.
> >
> > > -----Original Message-----
> > > From: Action Request System discussion list(ARSList)
> >
> > > [mailto:[EMAIL PROTECTED] On Behalf Of Srikanth
> > > Sent: Wednesday, August 01, 2007 7:57 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: Re: Import of People data into ITSM 7
> >
> > > Thanks for the replies.
> >
> > > We are planning to implement Asset and CMDB for the phase one. So we
> are
> > > planning to import the support group data/permisssions at a later
> stage.
> > > At this point of time, We are just planning to automate the people
> data
> > > to be available for use with Asset and CMDB. We plan to maintain the
> > > support group and updation of permissions manually.
> >
> > > So I understand the CTM:People is the only other form, I have to look
> > > at.
> >
> > > What would be the best strategy to load the data?
> > > Here is what I am planning -
> > > 1) Get the data from the different sources and create a single flat
> file
> > > containing all the fields to be imported
> > > 2) Load the data into a staging form where all the authentication of
> the
> > > data would be done
> > > 3) Push the data from the staging form to People and CTM:People form.
> >
> > > Any suggestions/improvements to the above are welcome.
> > > All your imputs would be very valuable and helpful for me.
> >
> > > On Aug 1, 8:23 am, "Pierson, Shawn" <[EMAIL PROTECTED]> wrote:
> > > > It depends on what level of import you require. If you just want to
> > > > import all People data but don't care about users being set up and
> > > > such, then you'll only need to import to CTM:People. However, if
> you
> > > > want to set up Support Staff, you'll also need the User form, the
> > > > Support Groups form, and the Permissions form. I forgot the exact
> > > > names of the forms but you can easily find them by looking at
> > > > CTM:People and seeing what those tables point to.
> >
> > > > I built a process to automatically import and update people from
> > > > Active Directory, but it doesn't yet handle their permissions or
> > > > support groups. Our AD data is not clean enough for that yet, but
> > > > setting up an automated process to handle it is usually the best way
> > > > to go with something as dynamic as People data.
> >
> > > > Shawn Pierson
> >
> > > > -----Original Message-----
> > > > From: Action Request System discussion list(ARSList)
> >
> > > > [mailto:[EMAIL PROTECTED] On Behalf Of Srikanth
> > > > Sent: Wednesday, August 01, 2007 12:07 AM
> > > > To: [EMAIL PROTECTED]
> > > > Subject: Import of People data into ITSM 7
> >
> > > > Hi All listers,
> >
> > > > I have a question on the import of the people data into Remedy for
> > > > ITSM 7. I am pretty new to the ITSM world, So bear with me if I am
> > > > asking a very silly question.
> >
> > > > While it is clear that we need inport the base people data into
> People
> >
> > > > form, I am not very clear with all the other forms that we need to
> > > > load the data with people data. In our current system we do a load
> > > > into SHR:People form. Are there any such forms in ITSM 7 too?
> >
> > > > We are doing a fressh implemetation of ITSM 7.
> >
> > > > Please let me know if you need any additional information. Any help
> > > > would be greatly appreciated.
> >
> > > > Thanks and Regards,
> > > > Srikanth
> >
> > > >
> ______________________________________________________________________
> > > > __
> > > > _______
> > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:
> "Where
> > > > the Answers Are"
> >
> > > > Private and confidential as detailed <a
> > > > href="http://www.sug.com/disclaimers/default.htm#Mail";>here</a>. If
> > > > you cannot access hyperlink, please e-mail sender.
> >
> > > >
> ______________________________________________________________________
> > > > _____-____
> > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:
> "Where
> > > the Answers Are"- Hide quoted text -
> >
> > > > - Show quoted text -
> >
> > >
> ________________________________________________________________________
> > > _______
> > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where
> > > the Answers Are"
> >
> > > Private and confidential as detailed <a
> > > href="http://www.sug.com/disclaimers/default.htm#Mail";>here</a>. If
> you
> > cannot access hyperlink, please e-mail sender.
> >
> >
> ___________________________________________________________________________-
> > ____
> > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where
> the
> > Answers Are"- Hide quoted text -
> >
> > > - Show quoted text -
> >
> >
> ____________________________________________________________________________
> > ___
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where
> the
> > Answers Are"
> >
> >
> _______________________________________________________________________________
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where
> the Answers Are"- Hide quoted text -
> >
> > - Show quoted text -
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
> the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
