Kevin, I am having the same issue for one of my clients. BMC is about to release a new data loader called BMC Data Management. It's a set of workflow in combination with excel sheets to perform the initial load of foundation data. It looks quite nice. From the new "Data Load Console" you control all the foundation data elements. Even their new tool do not support a regular data load. I am now looking into to combine the new BMC Data Management module with BMC AIE. Where the BMC AIE perform a regular load in the Data Management module. Personally I would have expected this "interface" to be part of the solution. There is alternatives out there. Take a look at Effective Technologies www.effect-tech.com/product2.html They got a really nice and effective solution. All the best Terje Terje Moglestue Mogle Consulting Ltd Office +44 1344 621060 Mobile +44 7740 90 9985 Fax +44 870 134 7023 Email [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
________________________________ From: Action Request System discussion list(ARSList) on behalf of Jo Pottinger Sent: Wed 11/28/07 10:38 AM To: [email protected] Subject: Re: BMC Foundation Data Loader ** Hi Kevin, You're correct in that the Foundation Data Loader is really only intended for the initial loading of data, so therefore will not update existing records in the way you want. However, there was a utility that could be purchased for use with ITSP which does what you're after. Obviously, this is not going to be any use for you, but I understand that BMC are currently working on an equivalent utility for ITSM, which should do exactly what you need. I'm not aware of timescales, but I very much doubt it's going to be available in time to help you with your current task. Cheers....Jo ----- Original Message ---- From: Kevin Shaffer <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, 28 November, 2007 8:15:31 AM Subject: BMC Foundation Data Loader ** Has anyone successfully used the BMC Foundation Data Loader that was release around 10/31? I have a couple of questions. I am hoping I am missing something but it appears it will only create new records. Can someone confirm if that is true or not. We have about 200,000 records in our People form and I have a list of about 2000 users that need to have their support groups and permissions updated. I was hoping to use this tool to meet this need. I am able to get the tool to create new records but cant figure out how to update exisiting records, even if I supply the person id. Assuming I screwed something up and you can update records, I dont understand what the link is between the tabs, so on the 03 CTM-PeoplePermissionGroups tab it has 3 columns, Permission Group, License Type and Template Name. How does it know to put that permission to the user JDOE. I dont understand what the identifier is. Any help would be appreciated Thanks Kevin Shaffer __20060125_______________________This posting was submitted with HTML in it___ ________________________________ Yahoo! Answers - Get better answers from someone who knows. Try it now <http://uk.answers.yahoo.com/;_ylc=X3oDMTEydmViNG02BF9TAzIxMTQ3MTcxOTAEc2VjA21haWwEc2xrA3RhZ2xpbmU> . __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
