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...
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 EditingThe 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 thefollowing 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 databasefields to the list in the lower part, to export to an external file, toimport 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.
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.
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.
Henrik Hansen [MSFT]