CreationDirect
Contents
1. The installer places an XML Report Converter icon on your desktop To install with compressed files If you have an Operating System other than MS Windows or if you do not have user rights to install programs use this procedure to install the XML Report Converter by copying the files to a directory of your choice I 2 Use Windows Explorer to go to where you saved the downloaded XML Report Converter software Double click on XMLReportConverter zip to open the file in your zip file utility The following instructions are for WinZip a Click on Extract in the toolbar b Browse to where you want to extract your files to c Ensure that the radio button All Files is checked d Click on Extract to extract your files to your chosen directory Clearstream Banking Luxembourg June 2006 XML Report Converter User Guide Page 3 XML Report Converter 3 Starting the XML Report Converter XML Report Converter Graphical User Interface To start the XML Report Converter From the desktop 1 Double click on the XML Report Converter icon on the desktop From the Windows Start menu Windows installation only 1 Click on Start Programs XML Report Converter From the Program directory 1 Open Windows Explorer browse to C Program Files Clearstream or other directory that the software has been installed or extracted to 2 Double click on the XML Report Converter icon Automatic start with user interface If you wish to automate t2. 56 standard O e standard z 39999 Urgent_Uninstructed_Notifications UUN Urgent Uninstructed Notifications Report standard a Add Remove Convert Preferences Exit Modifying a custom report template To modify a custom report 1 Click on Preferences in the main window 2 Select the template you want to modify in the drop down list 3 The data tree will appear You can change the template and click Save as to save the new selection 4 Click on Exit to close the window Deleting a custom report template To delete a custom report template 1 Click on Preferences in the main window 2 Select the template you want to delete in the drop down list Once the template for a report type has been selected the data tree will appear Click on Delete and confirm 3 Click on Exit to close the window June 2006 Clearstream Banking Luxembourg Page 8 XML Report Converter User Guide Contact marketingf clearstream com www clearstream com Published by Clearstream Banking Luxembourg Registered address Clearstream Banking SA 42 Avenue JF Kennedy L 1855 Luxembourg Postal address Clearstream Banking L 2967 Luxembourg June 2006 Document number 6354
3. or Comma Separated Value CSV files allowing for manual calculations sorting filtering or tailor made macros XML Extensible Mark up Language is an open structured format which has been designed to deliver structured content over the web for ease of implementation and for interoperability The XML Report Converter and documentation is available on the Clearstream Banking web site under Publications amp Downloads Connectivity CreationConnect CreationDirect Customers wishing to receive the software on CD ROM can request it from Connectivity Customer Services The converter can be installed on Windows systems and several other systems The application can be launched as user interface or automatically via a command line Further information Information about the services provided by the CreationConnect channels can be found on the Clearstream Banking web site www clearstream com under Connectivity You can also contact Connectivity Customer Services as follows Luxembourg Frankfurt London Telephone 352 243 38110 49 69 211 1 15 90 44 0 20 7862 7100 Fax 352 243 638110 49 69 211 61 40 69 44 0 20 7862 7254 E mail connectluxf clearstream com connectfrankfurt dclearstream com connectlondon clearstream com Disclaimer The use of this software is bound by the provisions of the Clearstream Banking Connectivity Agreement Clearstream Banking Luxembourg June 2006 XML Report Converter User Guide Page 1 XML Rep
4. Banking Luxembourg June 2006 XML Report Converter User Guide Page 5 XML Report Converter 4 Detailed functions This section guides you through the process of transforming Clearstream XML report files to CSV or Excel files Converting an XML report file 1 After starting the XML Report Converter you can choose one or more file to convert by clicking on Add fe XML Reporting Converter Yersion 1 01 Me XI clearstream group oc XML Report Converter cE ST NT RN 99999 C4_CONF CACONF ALWAYS DELTA 1 99999 CA CONF CACONF 7 nein 99999 MT564_568 Corpor OMEN 99999 MT566_Confirmatior a Look in C1 Account 99999 99999 MT566_Corporate_ gaged ccon amp cA 99999 MT950_Cash_Balar z e 2 99999 C4_CONF CACONF ALWAYS DELTA 1043 20050804 2209074 ML 2 99999 CA CONF CACONF ALWAYS DELTA 1455 20050804 2209074 XML Recent 2 99999 MT564 568 Corporate Action Notifications CANOTIF ALWAYS DELTA 0601 200508 i E 99999 MT566_Confirmation_of_Income_Redemption_Proceeds_Report CIRPR ALWAYS DEL a e 99999 MT566 Corporate Action Confirmation CACONF ALWAYS DELTA 1455 20050804 2 Desktop I 99999 MT950 Cash Balance CASHBAL INTRADAY COMPLETE 0500 20050804 2209093 xM Dep on Res Kt gt My Network M Denans I Open Files of type XML xml eae Preferences Exit 2 Select one single file or multiple files Shift or CTRL key and click on the open but
5. DEUTSCHE BORSE clearstream croup CreationDirect XML Report Converter User Guide June 2006 CreationOnline User Manual June 2006 Document number 6354 This document is the property of Clearstream Banking S A Clearstream Banking and may not be altered without the prior express written consent of Clearstream Banking Information in this document is subject to change without notice and does not represent a commitment on the part of Clearstream Banking or any other subsidiary or affiliate of Clearstream International S A The software described in this document is supplied under a licence agreement and is subject to specific copyright protection It is illegal to copy the software on any medium except as specifically allowed in the licence agreement or copyright legislation Copyright Clearstream International S A 2006 All rights reserved Clearstream and CreationOnline are registered trademarks of Clearstream International S A Microsoft and Excel are registered trademarks of Microsoft Corporation Clearstream International S A is a Deutsche Borse Group company DEUTSCHE BORSE clearstream croup 1 XML Report Converter Introduction With the new XML Report Converter customers have the possibility to view all CreationDirect reports data with Microsoft Excel or other spreadsheet and database applications All CreationDirect reports in XML Extensible Mark up Language format can be converted into Excel XLS
6. he conversion of XML reports it is possible to launch the XML Report Converter with the user interface Your back end system can send a command line automatically and converted reports will be available without any user intervention 1 Launch a command line interface 2 From the install directory use the command java Xmx256M jar XMLReportConverter_CommandLine jar files file 1 file2 format excel csv conversion standard custom The command line requires three arguments a files is followed by a list of the file names each in quotes b format is set to excel to obtain an Excel output file or set to CSV to obtain a CSV output file c conversion is set to standard to use the standard template or set to custom to use the custom template 3 Example java Xmx256M jar XMLReportConverter CommandLine jar files report xml format csv conversion standard This command line will convert the file report xml into a CSV file using the standard template WINNT system32 cmd exe Microsoft Windows 2868 Version 5 80 2195 lt C Copyright 1985 2888 Microsoft Corp P gt java Kkmx256M jar XMLReport ingConverter_CommandLine jar files report xml format csu conversion standard June 2006 Clearstream Banking Luxembourg Page 4 XML Report Converter User Guide Starting the XML Report Converter 4 The conversion will be processed as shown below Converting file 3 of 5 Clearstream
7. mp amp Reporting frequency v amp amp Reporting mode Vv e Report generation timestamp Fh Vd e Custody Report Option subscription Hh e Period H Q amp Account i v QR Cash balance record Save as Cancel 3 You can specify what information should be shown in the converted files Excel or CSV Ensure that the tick box is deselected for any information that you do not want to be shown in the converted file 4 To navigate the data tree select the of a limb and the next level will be shown If the user selects the level will be closed again 5 Once the fields to be converted have been selected save the settings by clicking on Save as You must first define a name for the template then the system will open a window where you can specify the output directory to where the custom converted file will be saved 6 Click on Exit to close the window Clearstream Banking Luxembourg June 2006 XML Report Converter User Guide Page 7 XML Report Converter Using a custom report template To use a custom report template 1 Add an XML file to convert in the selection list and click on Standard in the Template column A drop down list with your templates will be shown gm Reporting Converter Yersion 1 01 fel Ed DEUTSCHE BORSE clearstream E75 XML Report Converter File name Report type Template csv Excel 99999 MT564_568 Corporate Action Notifica MT564 Income Pre Advice Report MT654
8. ort Converter 2 Requirements and Installation Workstation hardware specifications Resource Recommended provision Minimum provision IBM compatible PC ona 32 bit platform Pentium 4 2 4 GHz or above or PC compatible equivalent Pentium III 500 MHz or PC compatible equivalent RAM 512MB or above 64MBa Free space on hard disk 100MB5 100MBb Monitor SVGA 17 inch or above SVGA 15 inch Monitor resolution 1280 by 1024 pixels 1024 by 768 pixels Mouse Any Microsoft Windows compatible pointer device As recommended provision a This amount of RAM is required solely for the XML Report Converter If you run other applications more RAM will be needed b The XML Report Converter application requires only a small amount of hard disk space However you are strongly recommended always to keep 20 30 of the original disk space free independent of XML Report Converter in order to prevent significant performance degradation when the operating system swaps virtual memory Workstation software specifications This section lists the software required as a prerequisite to installing and using XML Report Converter It also provides appropriate installation and configuration information The following table shows the minimum and recommended software required June 2006 Page 2 Resource Recommended provision Minimum provision Software WinZip or equivalent zip file
9. ton All selected files will then be seen with a description of the report type standard conversion or the selected template the format of the file either Excel or CSV The default selection is Standard and Excel It is also possible to convert a file into Excel and CSV at the same time The file can be added a second time and the format chosen as CSV If you wish to remove one or more reports from the list select the reports and click on Remove 3 To start the conversion of the reports click on Convert The file s will be converted and saved either in the same directory as the XML file Standard conversion or the directory specified by the user Custom conversion 4 Click on Exit to close the application June 2006 Clearstream Banking Luxembourg Page 6 XML Report Converter User Guide Detailed functions Report templates After starting the XML Report Converter you can create custom report templates by clicking on Preferences Click on the drop down list to select the report type for which you want to create modify or delete a template Creating a custom report template 1 After selecting a report type click on Create 2 Atree representing all data contained in the report will appear clearstream PEYTSCHE BORSE XML Report Converter MT950 Cash Balance v fa MT 950 Cash balance report MV amp amp Report activity flag v amp amp Temporary report v amp amp XML identifier v a
10. utility None Plug ins Java 2 Runtime Environment As recommended provision 1 4 2_06 International Version Clearstream Banking Luxembourg XML Report Converter User Guide Requirements and Installation Installing XML Report Converter To install with Windows installer 1 ED Use Windows Explorer to go to where you saved the downloaded XML Report Converter software Double click on XMLReportConverter MSI Inthe Welcome dialog box click on Next to continue In the User Information dialog a Full Name Enter your first and last names b Organization Enter your company name c Specify whether the XML Report Converter is available to you or to all users who log onto your computer Click on Next to continue In the Destination Directory dialog you may choose the directory to install the XML Report Converter files The default is C Program Files Clearstream To change the installation directory click on Browse and specify a directory Click on Next to continue In the Ready to Install Application dialog you have the opportunity to go back and change any information that you have already entered Click on Next to install the XML Report Converter When the installation begins the Updating System dialog opens and shows you the progress as the files are copied Once this process is complete a dialog informs you that the XML Report Converter has been installed Click on Finish to complete the installation
Download Pdf Manuals
Related Search
CreationDirect creation direct debit creation director creation direct creation director jon creative director creative direction creative director salary creative director jobs creative direct mail campaigns creative director meaning creative director portfolio creative director jobs uk