Download the LAST version released before your expiration date from this page.

Install DMC in evaluation mode.

Open the "register application" module.

Request a new serial from Internet.

In case of a problem, contact us to receive our help and support.

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

Use these TWO "cleaners" to clean out all registry entries.

Delete the old directory where DMC was installed.

Use the installer to reinstall in the new directory.

If you open a table where there is NO Key or 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.

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 .

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) .

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 .

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 VIEW 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 using the DCTX-TXD export button and use it in your application .

In the ODBC Manager create a new Connection 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 use the Create DB button :

Click on Execute and the DB will be created for you along with a NEW ODBC connection.

Go again to the ODBC connection module and DELETE the "Master" or "Mysql" DB connection.

You have first to create an ODBC EXCEL connection (in this case it is a system DSN which you define in DMC)

1. To CREATE the Structure :

Use Clone a Table

Select ODBC

Select EXCEL

Select the Sheet to work on in the list on the right panel

Click on "Next"

Select Topspeed as Destination Driver

When you are in the mapping tab after DMC brings you there use the "Table Modification" Button (top right)

Message confirmation comes up - accept

You are now in the Creation Wizard

2. To MODIFY your Structure : CHANGE column type now - add a key if need be (better for TPS tables cloned from xls without keys) etc ...

When you are satisfied with the Structure click on the Create table button bottom right

Check the Structure of the TPS created table in the Structure TAB

The created table is in "cgf-import/destination" directory within your installation data tree

3. To TRANSFER the Data

Select Transfer data

Select ODBC

Select Excel

Select the Sheet to work on in the list on the rigth panel

Click on "Next"

Select Topspeed as Destination Driver

Select in left panel the directory "Destination" (under "cgf_import") your newly created TPS Table

Click on "Proceed"

You are again in the mapping Tab

Do your column mappings now (for example define a DATETIME or an AUTOINC etc...)

Click on "Save profile" if you need to correct or redo

Click on "Transfer " button

You will have on screen a new tab with the data Transfered to see the resulting Table.

If you do not use the UPDATE option in a transfer then DMC will simply reject all existing records and open for you a notepad log file with those rejected records which means you will only send new records.

To avoid this error log opening etc, you can simply use a record level conditional filter during the transfer :

In the mapping tab when all is linked select any column in destination right panel on which you can exercise a filter (for example a date column) double-click on it check Use Conditional Filter and then click in top on the window on "New record" and define your condition there - do not forget to check the "Use at record level" box and save.

This way when DMC hits a record where the condition is NOT met (for example date smaller than ) that record will simply be ignored .....

Check this page of online help which explains more of this feature

Now if you need to do this type of transfer regularly use the Projects and saved Profiles then use the command line feature of DMC :

Create for each access table your transfer task and when all is properly done (conditional filters etc...) save it to a profile

DMC will add it to the main TPS Project defined by default

Check this page for more help on saving profiles

When all tables are done and Profiles saved, go in the Project manager and create a New Project, name it as per your need

Then drag and drop the created profiles from main TPS to this newly created Project

You can also order them by using the Up or Down buttons if you need a defined Order of transfering data

Check this page for more help on Projects

Now you use the command line feature to "run" all the Profiles in your Project (silently or not)

In your case use a command line like x:\dmc.exe /B:1 /S:1

Where x:\ is your path to DMC executable and where /B:1 is the NUMBER of your Project created and where /S:1 is silent or /S:0 is not silent (DMC opens up and you can "see" all profiles being treated onscreen

Check this page for more help on the command line feature

You can even call this command line batch treatment from your own application ......

On _your_ machine with the normal licence you have (on clients machines you will require additional end-user licences) Try this on test tables and you will see how easy this type of data updating can become .

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.

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).

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).

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.

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.

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.

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.

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 .

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.

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.

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.

Define the Filtering condition ("record level") on ANY OTHER column which does not contain a condition or function.

Define the IF xxx THEN xxxx ELSE condition in the appropriate column.

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

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 might 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_'.