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 at http://www.effect-tech.com/products2.html Thanks, Carolyn Effective Technologies http://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 at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
