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"
