• My Pages
  • Comments
  • Add Link
  • Subscribe
  • Subscribe User
  • Edit (GUI)
  • Edit (Text)
  • Rename Page
  • Copy Page
  • Load Page
  • Save Page
  • Delete Page
  • Attachments
  • Check Spelling
  • Diffs
  • Info
  • Revert to this revision
  • XML
  • Render as Docbook
  • Print View
  • Raw Text
  • Delete Cache
  • Like Pages
  • Local Site Map
  • Remove Spam
  • Package Pages
  • Sync Pages

    XSD Generator

    All sourcecode and documentation provided is Copyright (C) 2006-2008 by Consultingwerk Ltd. ("CW") - http://www.consultingwerk.de and other contributors as mentioned. All Rights Reserved.

    Software is distributed on an "AS IS", WITHOUT WARRANTY OF ANY KIND, either express or implied.

    Introduction

    This tool provides a fast and easy way to create XSD files for all your database tables.

    Screenshot

    Installation

    Requirements

    • OpenEdge 10.2A

    • OpenEdge Ultra Controls (Infragistics Controls)

    Step by Step

    Unzip the files to a folder of youre choice which will be the project root for example C:\Work\Tools. Start the OpenEdge Architect with the Workspace "C:\Work" and create a new OpenEdge Project "Tools". Compile the whole "Consultingwerk" folder. Now connect your databases to the project and launch the XSDGenerator form class.

    Usage instructions

    After launching the class XSDGenerator.cls all connected databases are listed in the Combobox. With a click onto the "Display Tables" button the tool will display the tables of the selected database in the grid. The toggle button "Prefix XSD with DB-Name" let's you decide wether or not the file names of the generated XSD files will be prefixed with the database name or not.

    After you have choosen some tables from the grid and press the button "Generate XSD" the tool will display a dialog where you can choose the target directory for the XSD files. Pressing the "OK" Button will generate the files.

    Attention Dynamics users: When using the variant of the tool based on the Infragistics UltraControls please try to drag the table name column header in the group by area. We are using the group by based on the first three letters of the table name. This makes perfect use of ICFDB compliant database table names (ryc_..., gsc_...).

    Version history

    Version

    Release Date

    Comments

    1.0

    01.12.2008

    Initial release of this tool.

    Known issues

    There are currently no known issues with this tool.

    Download

    xsdgenerator.zip

    Tools/XSDGenerator (last edited 2008-12-02 11:21:08 by MikeFechner)