Concorde Customer,Transactions & Voucher tables and links(overview)

Hi,

I'm new to the Concorde System. trying to  extract the Customers,transactions, vouchers,work ticketes.contracts and install base data from Concorde system. I need the information about tables of Customers,transactions and vouchers and joins among those tables. Please help me with etrm document as such.

Thanks in advance...

Srini

  • Hi Srini,

    The Concorde XAL/Microsoft XAL system has many versions and supports three types of databases.
    If you are not familiar to the XAL I would suggest that you get hold of a company that still holds knowledge about XAL.
    One such company could be Columbus IT(http://www.columbusglobal.com/en).

    If you would investigate yourself, go to:

    General/Periodic/Data Editing

    The following is from the SHIFT+F1 help in the console version:

     Data editing

     This menu entry is used to export and import data between sets of accounts
     in XAL and external files, provided the necessary Access rights have been
     acquired.

     Data editing is a tool which automatically generates a job on the basis of
     the given definition. Export/Import can only be used if the user has
     acquired the access code to work with XAL programming.

     The Data editing screen display is the same as the screen displayed when
     the menu entry General/Reports/Report generator is activated, with regard
     to both appearance and use. Refer also, therefore, to the section on the
     Report generator, page Go_to.

     The upper part of the screen display is used to specify the following:

     Type           This field is used to specify the table to be edited. Press
                    Alt+H to display a pick list containing all the tables in
                    the database.

     Action         This field contains a specification of the required
                    manipulation. The following options are available:

                    Export
                    Used to export the specified data to an external file of
                    the given type.

                    Imp_Import (Insert)
                    Used to import the specified fields from an external file
                    of the given type. The records which have been loaded are
                    added to the existing records in the specified table.

                    Imp_Import (Update)
                    Used to import the specified fields from an external file
                    of the given type. The records which have been loaded
                    update existing records in the specified table. Note,
                    however, that the loaded records must contain the exclusive
                    key to the current table.

                    Copy (Insert)
                    Used to copy the specified data from the requested set of
                    accounts to the current set of accounts. The records which
                    have been copied are added to existing records in the
                    specified table in the current database.
                    Copy (Update)
                    Used to copy the specified data from the given set of
                    accounts to the current set of accounts. The records which
                    have been copied update existing records in the specified
                    table. Note, however, that the copied records must contain
                    the exclusive key to the current table.

                    UPDATE
                    The specified data will be changed as requested in the
                    Expression column and thereby updated. Existing records are
                    overwritten.

                    INSERT
                    The specified data are changed as requested in the
                    Expression column and inserted in the table. This creates
                    new records in the table. Existing records remain
                    unchanged.

                    DELETE
                    The specified records are deleted from the table. It is not
                    necessary to specify any fields, since all records found
                    using the given delimitation during processing will be
                    deleted.

     Database       This field is used to specify the set of accounts to be
                    manipulated. When using Copy (Insert) and Copy (Update),
                    data will be loaded from the given set of accounts and
                    saved in the current database.

     File Type      This field contains the format of the file used for Export
                    or Import. The following options are available:

                    Comma
                    Lotus1
                    Lotus2
                    Quattro
                    Symphony10
                    Symphony11
                    Text
                    Comma delimited file 7-bit
                    Comma delimited file SAS/EIS

     Window         This field is used to specify whether a window containing
                    the status should be displayed during the editing. The
                    window contains a counter which is updated for every Xth
                    record which is handled. The parameter is specified in the
                    field just after Window.
    Individual fields in the required editing are listed below with the
    following information:

    Type           This field is used to show the type of the current
                   component. This may be a database field in the table (DB)
                   or a calculated numerical (REAL) or a text field (STR).
                   Calculated fields are assigned a value using the Expression
                   field.

    Name           This field contains the name of the current field.
                   Calculated fields must begin with '&'.

    File           This field is used to specify whether the current field
                   should be included in the editing.

    Expression     This field can be used to edit the data in a field by
                   specifying the right-hand part of an expression, i.e. by
                   setting the value of a field to a required value. The field
                   is also used to assign a value to calculated fields (REAL
                   or STR) when these are used.

    The Data editing Local menu

    The screen display has a local menu, which may be used to add all database
    fields to the list in the lower part, to export to an external file, to
    import from an external file etc:

    All fields     This menu entry is used to prepare an editing containing
                   all database fields in a table.

                   When the menu entry is activated, all database fields in the
                   chosen table are added to the list in the lower part of the
                   screen display. The user is prompted as to whether the File
                   field should be set to 'Yes' or 'No' for the lines which
                   have been inserted.

    Delete Fields  This menu entry is used to delete all lines in the
                   definition.

    Report         The menu entry is used to print out a report showing all
                   the data definitions.

    Execute        Activate the menu entry to execute the specified editing.
                   This is only possible when no errors are found in
                   Expression etc. The user will be prompted for delimitations
                   and file names etc during processing.

    Check definitionThis menu entry is used to create a trial editing for the
                   chosen table. All formulae entered in the Expression field
                   are checked. The editing cannot be executed if errors are
                   found.
     Save definitionThis menu entry is used to export the defined editing to an
                    external file. This can later be loaded in another set of
                    accounts/another installation.

     Load definitionThis menu entry is used to import the editing from an
                    external file previously created using Save definition.

    This is as close as you would get to documentation on this subject.
    Beware Data Editing has the potential to delete data in tables, so make sure to safeguard your data with backup or do the data extraction in a non-production environment.

    Best Regards

    Henrik Hansen 

  • In reply to Henrik Hansen:

    Hi Henrik Hansen,

     

    Thanks for your response,

    Actually my requirement is to extract the Customer,transactions and receipts data from Concorde DB, which is Oracle Database not from the application. For that I am looking for the back end table and joins information or any technical detail Documentation.

    Please help me.

     

    Thanks,

    Srini

  • In reply to Srini:

    Hello Srini,

    Documentation on how to extract data from the back end database has never been published.

    In 1995, a book Concorde XAL in Case was published in Danish on the internal relationship among tables in XAL, but was never updated or republished.

    Running XAL with start-up parameter -zsql will all dump all generated SQL statements in a log (txt) file named xalsql.log in %tmp%. Running e.g. XAL reports in the XAL application on the data needed may help you isolate the related SQL statements in the xalsql.log.

    You can get an overview of start-up parameters in the help file C_PARM.HLP.

    Start-up paramaters can be specified on the command line or in the INI-file CXAL.INI.

    As mentioned before, if this is an important project, I would urge your organization to team up with an IT Company that still holds working knowledge on Concorde XAL/ Microsoft XAL.

    Best Regards

    Henrik Hansen [MSFT]

Related
Recommended