Introduction

Here you will answers to some questions you may have

Installation

I need to reinstall DMC and my activation code has expired

Use the activation code you have handy (even if expired) and drop it in DMC - you will receive a 'Failure' message - DO NOT close the module, click on 'Get activation code from Internet' and you will receive a new one.

I have purchased DMC and am trying to install it after the expiration date of the activation code

After updating DMC a yellow window stays onscreen and DMC does not open

This window updates the structure of some DMC Tables : Note the name of the currently treated Table in the yellow window and if it is NOT tpsconnect.tps or maptet.tps or mapdet.tps kill the task and delete the file then restart DMC

If it is one of those 3 Tables - send it over to us by email and we will try to update the structure for you and send it back

I need to reinstall DMC on the same machine but in a different directory

Uninstall DMC from the provided link in Add - Remove programs by our Installer

Delete the old directory where DMC was installed

Delete in registry any Key under HK_CurrentUser/Software/CGF

Use the installer to reinstall in the new directory

Viewer

I used DMC to Visualize a Table and all the Viewer features are not available

If you open a table where the Primary KEY has multiple columns in it or if you open a PostGre SQL table where all columns keys are not all uppercased or lowercased then DMC cannot perform some tasks in Viewer features, so they are disabled and a special information text appears on screen

I need to filter some records (by a DATE column)

Click on QBE - select the DATE column you need to use as Filter and in Expression enter (or use the Drag & Drop facility) for example : DateCol > DEFORMAT('PlaceLower/Date/Here',@d017) AND DateCol > DEFORMAT('PlaceTop/Date/Here',@d017)

Press on TAB to verify your query and if the Icon displayed is green then simply click on 'Apply'

When you work in QBE on DATE's (or TIME's) displayed in a readable format like 01/25/2007 (or 12:25) or other formats as per your Window language settings, then you MUST use the predefined FUNCTIONS to be able to use the DATE (or TIME) in a query

I need to DELETE a range of records from a Table

Click on QBE and fill in your query to select only those records you want to delete - then use the 'DELETE' button and all those records will be deleted from the screen (do not forget to Save to File)

I have a Table with DATES (or TIME columns) stored in a LONG format and want the data exported with a proper readable Format applied

Select the Column where those DATE (or TIME) data are stored as LONG, click on 'Format' button and depending on the case enter simply as mentioned in the message box @d or @t and Save : the list will be refreshed with the proper formatting - now you can use the TOP Main Frame SendTo button (or the embedded Export to CSV) and select your Export format : the date column will be formatted properly

SQL Environment

I have several Tables in a DB and need to obtain a VIEW in my application of some filtered data, can DMC help me ?

In the Left panel select your DB with a double click to List all available Tables

In the query editor enter or build your query which can be like :

SELECT * FROM "TableName"

LEFT JOIN ON "SecondTable" WHERE TableName.SYSID = SecondTable.SYSID

Click on Execute and if the query is good then a message will popup informing you of success and a new tab will open up with all the relevant subset

Check the data and if it is what you needed click on SQL script Editor TAB to revert to the SQL Environment and you will see at the bottom left of the screen entry fields to select the format of the VIEW to create (TPS or SQL) and to define the NAME to give to this new Table

Click on Create and the relevant Table will be created for you either in cgf_import/destination directory for TPS or in the current DB for an SQL Table (in this case the table List is refreshed and you can access it immediately)

Import this table in your dictionary and use it in your application

I need to create a DataBase

In the ODBC Manager create a new Connection string to the MASTER Table (for MsSQL) or the MySQL Table etc ... using the 'sa' user (MsSQL) or the 'root' user (MySQL) with the relevant password

Connect to this DB and table from the SQL Environment and enter the hand query as such :

CREATE DATABASE

Then use the Drag & Drop facility to drop after this query ANY existing TableName (to get in the query the relevant syntax of names : quotes etc ...)

The query will now look like this :

CREATE DATABASE "TableName" (for MsSQL)

Replace TableName by the NAME of your data base to be created - keep the inserted quotes (or other) if any

The query then looks like this :

CREATE DATABASE "NewDataBaseNameHere"

Click on Execute and the DB will be created for you

Go again to the ODBC connection module and change the Master or Mysql DB Name to the newly created one : you will be able to use it in DMC

Data Transfers

I have 3 Tables and need to merge all the Data in 1 destination Table

Use Transfer data

Select the 1st source Table and your destination table, map all columns and export the data

Reopen Import & Export and again use Transfer data

Select the 2nd source table and the same destination table, map all columns and in the destination tab double-click on the PRIMARY KEY column (must be UNIQUE) and check the Update tab Is identifier box

Transfer the data : DMC will - for each source record try to find an existing one in the destination table and if it exists an UPDATE will be done otherwise an INSERT will be performed

Repeat this type of process on the 3rd source table

Your destination table will contain all relevant records from the 3 source Tables

I have a Price List of a supplier (XLS) and need to update my Table (any Format except ASCII)

Open Import & Export and use Transfer Data

Select the suppliers table (XLS or any other format) as source table and your existing destination table, map all columns and in the destination tab double-click on the PRIMARY KEY column (must be UNIQUE) and check the Update tab Is identifier box

Transfer the data : DMC will - for each source record try to find an existing one in the destination table and if it exists an UPDATE will be done in your existing table otherwise an INSERT will be performed (new records in your suppliers Table)

I have some data in different Tables and need to Transfer specific columns of each in the same destination Table

Use Transfer data

Select the 1st source Table and your destination table, map only the relevant columns (for example ID NAME and ADDRESS) and export the data

Reopen Import & Export and again use Transfer data

Select the 2nd source table and the same destination table, map again only the relevant columns (for example ID PHONE and FAX) and in the destination tab double-click on the PRIMARY KEY column (must be UNIQUE) and check the Update tab Is identifier box

Transfer the data : DMC will - for each source record try to find an existing one in the destination table and if it exists an UPDATE will be done otherwise an INSERT will be performed

Your destination table will contain all relevant records from the different source Tables and columns will be all sequenced (ID NAME ADDRESS PHONE and FAX)

Is it possible to Filter the Source Data when Transferring it

Use Transfer data

Select the source Table and your destination table, map only the relevant columns (for example ID NAME and ADDRESS)

If for example you do not want to Transfer RECORDS where the NAME column contains 'JONES' the double-click in the destination list on the NAME column and at the bottom check the 'Use Condition' box

Then from the screen top buttons use the 'New' button to add a CONDITION

Check the 'Use at record level' to avoid transferring all the record

In the conditions select 'Contains' and in the entry field enter JONES

Save and transfer the data : any record where the column NAME contains JONES will NOT be transfered

Can I map multiple source columns to a single column in destination Table

You can concatenate TWO columns at a time in DMC today during a Transfer
You might then need to repeat this transfer using the UPDATE facility and again the concatenate option

I have a Table with DATES and need to Export it to ASCII format with proper Date formatting

Use Transfer data

Select your source Table and select ASCII as destination driver - define the proper settings of the Table you want
Click on Finish and when in the Mapping TAB click on 'Link by Name'

In the destination list double-click on the DATE column and check the 'Use Date Time' - check also the 'Use date' and finally select in the drop down list the source column containing the date value

Transfer your data

You can also perform the same type of Transfer directly from the Viewer as described here in that Chapter

I have an ACCESS DB with tables and I cannot Transfer the Data - I get an error on 'Opening Table'

Generally this indicates that the ACCESS DB is locked to an 'application' and cannot be read

Try to open the database directly from Access and you should see an 'application' window when it opens - if you cannot access the tables directly from here it means DMC will also not be able to read the tables

Try to get a copy of the DB without the application

I need to transfer data in a Table with Identity column : how do I tell DMC to start at the last available record ID

When you are in the mapping Tab double-click in the destination List on this column and check AutoInc

Enter in the relevant field the FIRST number you want DMC to use as Identity - save and transfer the data

I want to UPPER (or LOWER) case a Column during a Transfer

In the mapping tab double-click in the destination List on the column you want to perform this 'Operation' on and in the 'More' tab check 'Operation' and select UPPER or LOWER

Save and transfer the data

I want to add some Text BEFORE (or AFTER) a column value during a Transfer

In the mapping tab double-click in the destination List on the column you want to perform this 'Operation' on and in the 'More' tab check 'Operation' and select Concatenate BEF. or Concatenate AFT.

Enter in the relevant field the STRING value you want added BEFORE or AFTER the column source value SEPARATED by a space

Save and transfer the data

I have a TPS Table that I want to convert to MySQL and DMC defines it correctly in SQL, but when I ODBC import the Table in a dictionary all decimals are STRINGS

This special case comes from the ODBC driver you use on your machine

Please update the driver at least to 3.51 if not the latest 5.1 version

Portable Version

I am trying to test the Portable version on my computer and it does not load

You can only use DMC portable on ANOTHER computer then the one where it is installed

General

When I clone to SQL a column named SYSID is created as DMC_SYSID, why is this ?

In SQL some words are reserved for SQL language and for example SYSID is one of them

You can either delete this word from the Reserved Words list under Settings (careful you migth not remember deleting it and one day have problems)

You can also IF you are sure all is well in the SQL you are using change the Column Name in the script offered by DMC during the Cloning process and delete the 'DMC_'

DMC is corrupting TPS tables when they get cloned : a column is missing

Please check your source table : generally this comes from illegal column NAMES such as "subfolder" or ?VAT or any other .....

Rename the column in your dictionary and try again