Carl, Thanks for the detailed description of the process. Managed to figure most of it, but pointer to how to troubleshoot will definitely be useful as I am at the moment stuck with the Load step In Progress and nothing else happening (using BMC People template). Checked the arcarte.log file on the server and it reported the job as started and completed with no errors within a couple of seconds, but the step still sits in the In Progress status and there appears no way to move it forward. Same with the job directory where it did not report any errors.
Regards Jiri -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: 09 October 2012 16:12 To: arslist@ARSLIST.ORG Subject: Re: Data Management Tool in version 8 replaced by Atrium Integrator Hi, the documentation is now on the BMC wiki (docs.bmc.com). To be honest it is not that straight forward to understand as it is all over the place in terms of structure. A couple of points: - You need to specify a UNC based directory for the tool to be able to do the conversion on the spreadsheets. This cannot use "localhost" in the path and must be in the UNC format. Can be a pain to setup on Windows. Sharing a directory and giving permissions is the easiest I have found to get working. You can then use something along the lines of "\\win-atmsk2nqp0b\c\DataLoad\" - set from Application Administration > Foundation > Advanced Options > System Configuration Settings - System Settings. Ensure the correct permissions for writing to this directory as the tool will create directories and files on the fly. - Spreadsheet Management (Data Management). Here you can download the spreadsheets for population, as well as upload completed spreadsheets for use in the Jobs. You "Copy to New" the spreadsheets from the normal space (BMC Template) to a user space (Users Data), which then becomes selectable in the Jobs Load Activity setup. I suggest you do this one spreadsheet at a time until you are familiar with setting up and configuring jobs. Try not to overwrite the BMC Templates .... You can update the "Copied" spreadsheets when making changes (Users Data), updates will then be re-selectable in the Job steps. - Jobs Console. There are 2 parts to setting up a job to load in data. You first create a job (basic information), then you associate a pre-defined activity (Template) to that job (Steps > Create Using BMC Templates > Select the Template). When you associate a pre-defined template (all the Data Loads are BMC Templates pre-defined) you can then open the Load activity and either select the uploaded spreadsheet (as in the point above - lives in the Users Data) or directly load a spreadsheet into the attachment field. Once this is done (saved), you save the job and set the status to "Built". This will then allow you to run the job (enable the run options) and view the status of the various activities. - There is a couple of places errors will be pushed to. Data Load errors will generate a zip file with the issues encountered (usually Excel data conversions i.e. numbers need to be stored as text, not numbers) and will be found when you open the Load Step in the job. Other errors such as validation, etc can be seen from the Error Management link (Data Management Job Console > Other Functions > Error Management). That should get you started, the Wiki has any troubleshooting steps or additional information for setup and execution. Cheers Carl http://www.missingpiecessoftware.com/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jiri Pospisil Sent: 08 October 2012 12:20 To: arslist@ARSLIST.ORG Subject: Data Management Tool in version 8 replaced by Atrium Integrator Hi all, It appears that in version 8 the data management tool has been replaced by the Atrium Integrator. I am trying to find any documentation on how to use it for foundation data load or updates, but so far with not much luck. Hop it is just me. Can anybody point me in the right direction, i.e. documentation describing how to use the Atrium Integrator to run the pre-defined transformations for loading foundation data. Thanks Jiri Pospisil A copy of the LCH.Clearnet e-mail disclaimer can be found at: www.lchclearnet.com/disclaimer/email LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, London EC3N 1EA. Recognised as a Clearing House under the Financial Services & Markets Act 2000. Reg in England No.25932. LCH.Clearnet SA, Siège Social, 18 rue du Quatre Septembre, 75002 Paris, Chambre de Compensation conformément au Code Monétaire et Financier. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"