Legend

Newly added feature

Changed, reviewed, modified feature or code

A reported error or bug was fixed

GOLD Version 1.7.0.0 released 17th. October 2009

Create a DataBase in SQL environment module (and a new ODBC connection to match)

COMBINE multiple CONDITIONS and FUNCTIONS or CONCATENATIONS or External REPLACEMENT groups in ONE column during Data Transfers

When ALL functions used during a Data Transfer task are on the SAME source Column then DMC will apply the 1st result to 2nd function and cascade all

NEW Mass Update and QBE layout screens

UPDATE a Table - define Values to search for in Destination Table AFTER applying mapping options

Data Transfer Tab, added a button to enable the user to VISUALIZE (in another tab) and SCAN "source" & "destination" values AFTER applying mapping options (before transferring data)

UPDATE a Table - support to use ANY KEY declared in the Destination Table (mappings are scanned to find related source Columns)

STOP process button (main frame toolbar) in Viewer mode

SQL server side DEFAULT values are now supported, stored, displayed in mapping options and used when the source record value is empty during Data transfers

Main Mapping Tab - NEW screen layout (wizard type)

Mapping option window - NEW screen layout (wizard type)

Viewer window - NEW screen layout (grouping functions)

Clone to SQL - if a table using the same Name exists in DB then DMC will offer the user to drop it BEFORE starting the Cloning task

Saving a Profile - the user will be offered to REPLACE the LAST IDENTICAL Profile (if found) or ADD a new one

Cloning & Settings - DATE and TIME DETECTION (on LONG columns) during a Cloning Task (user can switch on/off-toggle and define common Column Names used to detect)

Cloning to SQL - settings allow user to define a PREFIX to use when the Column Name is a RESERVED word

Duplicate an ODBC connection

Duplicate a Profile (and all mapping options related)

Full compatibility for SQL 2008 server (DATE and TIME column types)

Detect Table Name from SQL environment script (user changed it without using the proper button or copy pasted a script)

Define the Source ORDER to be used during a Data Transfer (on multiple columns) and set ascending-descending for each

Clear all mapping options NEW button in column mapping window

Data Transfer - NEW Destination DATE and TIME DEFORMAT dropdown select box when the Destination column is a STRING typed one

Mapping options - NEW AutoInc STEP (sequence) entry field

UUID Columns in PostgreSQL version 8.4 are detected and used

NEW FUNCTIONS added during Data Transfers : FORMAT - DEFORMAT - CLIP - CLIP(LEFT) - EQUAL

Transferred Data - records are COLORED to better display between Transferred - Updated and Errors

Transferred Data Tab - FILTERS (radios) which can be applied and the SEND TO button follows the filtering (print or save a list of Data manipulation done)

External REPLACE "groups" on Search & Replace Tables are STORED WITH their Profile - user can have multiple ones and restore them when restoring the Profile

RUN a COMMAND LINE Project or Profile directly from DMC (or copy to CLIPBOARD the command line to use in your application)

DATE and TIME DEFORMATING option (dropdown listbox) when the Source column is a STRING

ICONS added to ODBC module for better visualizing different connections

Data Transfers to ACCESS Tables - support for MEMO column types

Changed Projects & Profiles PATH within DMC folders structure for future version 2

DAT Tables now allow Password Detection (and storing for second opening)

Cloning to SQL use REAL typed Columns in generated script (destination Tables) when the source Table contains some

UPDATING a Table (SQL code) to support conversion of DATE column values when used in the selected update KEY

DISABLE the Transfer data button when there are NO records in the SOURCE Table

DISABLE the "Selected Folder" button during a Clone to TPS till a new folder is selected

UPDATE a Table - if the key used as selector has multiple Columns and one of those is NOT mapped then a STOP error message will be sent before starting the process

External Replace "grouped" table - support to have a COMMA inside a search or replace column (declare them as |,|)

Export to TXD-DCTX button added in SQL environment Task

SQL environment - process is quicker as only 1 record is read from Table (and the user can read X records at will AFTER it is displayed)

Link by Name during a data Transfer links sql reserved word changed column names

New CAPITALIZE function for better "real life" processing

Clone to DAT - DBF - "re-linked" Data Transfer Task after a successful clone

Mapping Options - External Search & Replace Table allows an EMPTY Replace value

Clone to SQL when a MEMO column from source is changed to a VARCHAR

Mass Update when using EIP could result in all changed records not being saved back to File

Create from TXT code revised

Reading a TPS Table where a Column uses a PICTURE Token (ie: @PxxxxxP)

Cloning to SQL when a KEY contained Column Names surrounded by quotes , they are now deleted

Clone to SQL and the source Table did not have a Primary KEY

GOLD Version 1.6.0.8 released 29th July 2009

During Data transfers use Mapping options AND COMBINE Conditions (record level) on the same column.

Perform on a given column a Mapping Operation or Concatenation or Replacement AND also define on the same (or other) column CONDITIONS to use at record level.

All SQL Table reading is faster (pre-loading).

NEW Mapping Options during Data Transfers : Parse First Second and Last (extract WORDS from a string)

NEW Drop Down boxes (.NET styled) in ODBC connection creation and in Settings.

External "grouped replacements" table import supports DUPLICATE checking (or not) from a choice message.

Portable version creation is simplified (XML is automatically copied and stored when DMC is activated) & activation is possible with an Expired activation XML file

Changed code to fix bug in Microsoft ODBC driver when SQL server 2008 DATE or TIME column are used.

Fixed bug during Cloning & Viewing when there are MEMO columns in a DBF Table.

Fixed bug in ODBC Connection Strings when Port was at 0 (missing end semi-colon).

Fixed bug when asking a table Creation from TXT Structure File.

GOLD Version 1.6.0.7 released 11th July 2009

Reading an ASCII File would result in a GPF

GOLD Version 1.6.0.6 released 9th July 2009

FOUR Themes added to let the user select any Office 2007 look (Default - Silver - Blue and Black)

Some ODBC Access Tables WITH Illegal Column Names and Date Time Groups were not read properly

GOLD Version 1.6.0.5 released 17th June 2009

From Viewer when the user has a valid VIEWER level license he can export ALL records to CSV & XML.

ODBC Connection record fixed bug in the string "server" not being displayed

GOLD Version 1.6.0.4 released 15th June 2009

From Viewer and Clone to and Data Transfer tasks you can EXPORT the Structure to TXD and DCTX formats to import in your Clarion dictionaries.

HIDE UNHIDE Columns in the Viewer and TOGGLE formatting from LONG to DATE or TIME directly in a new module (settings are saved for next readings)

VIEWER now supports KEYLESS TPS - DBF - DAT Tables and allows you all modifications

Windev Hyper Files can now also be used as Destination Tables for all Data Transfers (and in Viewer with all options)

Viewer mode - in the main frame toolbar - a drop down box will let you dynamically change the "After Enter key action" when in EIP mode so as to ease your way of working

During a Cloning task (non SQL's) you will be asked in WHICH FOLDER (works also on LAN) to create the New Table (this folder setting will be kept in memory during the current session only)

Viewer the HIDDEN columns in CSV & XML & all Predefined Exports : Hide a column and it will NOT be exported

Changed during Cloning a Table task : after the data is transferred DMC will automatically open the selected Destination folder for you.

Transfer to SQL DateTime Columns "link by name" => either STRING() or DATE & TIME (unused cols. are hidden).

Fixed bug during Cloning when there are BLOB columns : the size was not be set properly and displaying was giving problems

Fixed bug during Cloning when there are BLOB columns : the size was not be set properly and displaying was giving problems

Several small bugs in cloning to SQL

GOLD Version 1.6.0.3 released 5th May 2009

Added Feature : External Replacement table during Transfer in Mapping Options (allows multiple "grouped" Search & Replace values for replacement within a column) with Uppercase option

Added Feature to Password protect the ODBC module (in settings under 'DMC')

Added in Mass Update and in Data Transfer the possibility to CAPITALIZE data

In Mass Update changed the layout and added descriptive texts to help users

In QBE added buttons to check the validity of a query and changed the layout (step1 - step2 - step3)

Added in Mass Update and QBE automatic replacement of "Expression" in all functions with column name worked on

In QBE added descriptive texts to help the users while building queries

In Mass Update and QBE added automatic popup message to save the query created

Added after a CSV or XLM export from Viewer a button to open the destination folder for the user to 'take' the created file and use it

Added the Expiry Date of Maintainance Plan in main screen after license text

Fixed bug in Mass Update and QBE on tables with GROUPS

Fixed a bug in Extension module where the drop down would not let user select a value - replaced with entry EIP field

Fixed a bug in Oracle & FireBird cloning (key's)

GOLD Version 1.6.0.2 released 13th. April 2009

Changed array fields naming convention - array[1],array[2] etc...

Added feature for DMC to run several instances at the same time (Viewer in one and Transfer in another etc ....) all temp tables are timestamped

Added a setting to delete or not all temp tables when closing DMC

Added feature in Create from TXT File to create DBF or DAT tables also (plus TPS)

Added feature in Create from TXT to allow preprocessing and DMC will check Column types etc depending on the Driver used (Merci Vido)

Added feature in Create from TXT : now several "Executions" are possible to rectify if need be or create several variants of the table to test

Added feature to allow ODBC Access (and other SQL's) table reading & cloning when it contains illegal column or key names (like accentuated letters)

Added feature of automatic deletion of all old temp tables (after 3 days) used by DMC

Added feature in Create from TXT for preprocessing checks on Key Name LENGTH (DBF)

Entirely rewritten Mass Update and QBE Tabs to display properly when the OS did not have Themes turned ON

Added feature to support schemas in Oracle

Added feature of complete HyperFile tables support in all SOURCE tasks without using an external Wizard (rewrite of our library)

Added feature when an Access Table contains EMPTY Memo Names

Added feature to check TPS Total record SIZE when exceeding 15 k limitation - with automatic CHANGES applied by DMC to overcome this situation

Added in Navigation Panel a link to web site page on "HowTo" do's - Step by Step explanations

Added feature in main Wizard to display or not (from a new setting) ballooned tips with RIGHT CLICK possibility to open up directly web site HowTo page

Added setting to display or not those balloon tips in Main Wizard

Added feature of Main Frame resizing to default size - this will automatically resize and re center the screen)

All windows now have their OWN CLOSE button : careful : a learning curve might be necessary as the main frame top left button always closes DMC itself

Added feature for Evaluation users to test the Portable Version

Added setting to display balloon tips or not in all DMC

Added balloon tips throughout DMC with the use of a new class

Added NEW FEATURE of complete Themes support in DMC - define your own Themes and define ALL colors (with automatic restart after applying)

Redesigned the Registration module

Changed all the Create from TXT task which now opens up the TXT in DMC and allows for copy pasting - "live" modifications and several Tables created with different Drivers from the same script

Changed the main Wizard to now use Radio buttons and mainly all tasks are separated in 'types'

Changed ODBC "Test connection" button code to speed up the process

Changed the minimum Main Frame window size to avoid problems

Changed the Portable version module display

Redesigned the Settings module

Changed license activation success message and added an automatic restart of DMC

Added a Close button in the mapping tab to end a task without any transfer

Added TimeStamping for all temp BLOB Tables

Fixed a SendTo bug when exporting to Office 2007 Excel

Fixed bug in Creation Wizard when using "Open existing" where the wrong directory was used

Fixed a bug when Transferring with BLOBS would crash if the size was at 0

Fixed a bug in Viewer when exporting to CSV

Fixed bug in SQL environment when using MySQL version 4

Fixed bug in Viewer on a DAT Table with missing keyFile to launch an automatic rebuilding of that Key

Fixed a bug in Portable version creation and synching

Fixed a bug when cloning to Oracle and Firebird on UNIQUE KEYS

Fixed a bug in Structure tab when loading a table

GOLD Version 1.6.0.1 released 11th. March 2009

Added support of Multi Columned Primary KEYS in the Viewer (user can also update columns within the KEY)

Added support of Multi Columned Primary KEYS during data Transfers (select the FIRST column of the KEY and define it as an update column - DMC does the rest for you)

Support for full Drag & Drop in main module from Windows Explorer to open a Table

Use existing instance of DMC when asking for a table reading from Windows Explorer (if no process is running in the existing instance)

Added full support for MySQL version 4

Created a full clean-up utility (available on our web site on the download page) to help reinstall DMC

Support in Viewer to be able to read only the FIRST "X" or "Y" LAST records and also between record "Z" and record "T"

Added profile ID column in Project & profile module to better use the command line option

Added "end of process" .ini file writing in DMC to allow you to "drive" DMC from your application when using command line options.

Added default mapping option of generating a GUID()

Added default mapping option of generating a Replicate (capesoft) GUID

Added Visual Indicators on all entry fields for better user interface usage.

Added support for all existing CHAR SETS in Settings/Setup module to allow DMC to read and display properly all "foreign" characters (Greek - Chinese - Hebrew etc...)

Added support of MEMO columns in DBF Tables

Added a setting to define the LENGTH of String to use when displaying a MEMO column in the Viewer

Added setting to turn SQL Tracing AND ODBC Tracing On/Off when transferring data

Added an automatic BUILD KEY's after a Clarion DAT file Viewer update (column values modifications)

Added a protection in Viewer (updating a Table) : if DMC cannot locate the record changed then a LOOP on the Table is done and if again the record is not "found" then it BREAKS out of the updating.(generally this means the KEY needs rebuilding)

Added support to add to Most Recent Used list any DROPPED table in DMC to read it.

Changed HyperFile way of working : now all is "in" DMC as for other Tables and Viewing - Cloning and Transferring data are as easy as can be

Added support to check for Illegal Column Names (mainly for HyperFile) : if a Key or Column contains accentuated characters it is then still possible to View or Clone and transfer the Data.

Added in the Wizard a "locator" search entry field to make locating your tables easier.

Added support for Tables containing BLOBS (when Table total size is bigger then 2GB) : now the temp Tables are split in 250 MB chunks and this highly accelerates all readings.

Added support to store the Source and Destination Directories in the Wizard (no more looking for your "special" directories all over the machine or lan) : select them and automatically come back to them.

Support for full Drag & Drop of Activation XML file under Vista.

Removed all screen flickering (caused by balloon tips)

Changed all Icons.

Modified SOURCE and DESTINATION directories handling : now they are stored in memory and offered as default for the next read - when using either Viewer or data transfers.

Added in Viewer a message stop when modifications are done in a Table and the user closes the module without saving to File.

Changed in new Installations : default to read only first 50 records during a Transfer.

Changed directory for Temp BLOB tables from cgf_import to Windows temp directory (USB portable and small partitions).

Changed in Transfers : when no Updating is done, DMC will not read the Destination data (when the setting "read only 50 first records" is used).

Added support while Cloning to SQL in Oracle for all INDEXS to be created.

Fixed Clone to SQL (Access) missing end ')'.

Fixed After a data Transfer the SendTo button did not hold all data.

Fixed Clone to SQL (PostGre SQL) created KEYS where not seen and displayed on screen.

Fixed bug during Cloning to SQL : only the first 50 records were transferred (if the setting was used).

Fixed bug when reading only "X" records in the Viewer (SQL tables).

Fixed bug when reading DBF tables on KEYS (length of string container was too small)

Fixed bug when a Clarion DAT Table was used as destination.

Fixed another bug in DBF Tables KEY reading.

Fixed a bug in Table Creation Wizard : changing a Column Name which was in a KEY and was not automatically changed in the Key.

Fixed bug in Clone to SQL on MEMO columns bigger then 8000

Fixed bug when displaying BLOB columns in SQL Tables.

Fixed bug in Viewer Locate and Next functions.

Fixed bug in Clone to Clarion DAT (on STRING columns)

Fixed bug in Clone to DBF on Column Names bigger then 12 characters.

Fixed bug in MsSQL Tables where all KEYS where not read properly (same problem fixed while cloning to SQL Anywhere)

Fixed bug accessing Excel Tables (connections could not work properly)

Fixed bug in Viewer when sorting by Multiple Columned KEYS

Fixed bug in Mass Update and QBE where the "Load" button did not appear on screen.

Fixed bug in Clone - Transfer to ASCII on STRING length bigger then 255 characters.

GOLD Version 1.6.0.0 released 1st January 2009

We rebuilt the Installer - Updater and DMC itself to enable the tool to better comply with Windows standards of Limited Accounts.

When trying to run DMC under an XP limited user account (non admin) it would not run at all.

GOLD Version 1.5.0.7 released 19th December 2008

Data Transfer and Cloning from CSV - added the possibility to define the FORMAT of a TEXT DATE or TIME column so as to export properly in TPS - DBF or DAT tables.

When reading an EXCEL Table there where problems in cloning and transferring the data.

GOLD Version 1.5.0.6 released 26th November 2008

Viewer - after a QBE - added the possibility to Save the subset of the query to the Table (careful : all the other records will be deleted).

When reading an ASCII Table a GPF would occur when the wrong type was selected.

GOLD Version 1.5.0.5 released 5th November 2008

To support HyperFile, we had to create a new independent executable just for the Wizard and we added a new Setup - Settings parameter to let you define if you need working on those Files (to open either or Wizards).

In all Table reading we increased the number of columns from 999 to 9999 as it could result in column names being badly reported and GPF's during a cloning process.

GOLD Version 1.5.0.4 released 30th October 2008

Added support of Windev HyperFile as SOURCE format through ODBC (careful : BLOB columns cannot be updated in the Viewer as they are external files) - QBE Clone To .... are supported

Added in Mapping Options an IF THEN ELSE possibility

Added in Mapping Options an INLIST Condition Type to use with a LIST of up to 25 Values

To support HyperFile, we had to create a new independent executable just for the Wizard so as to access those Tables so now all this side is completely outside the tool and can be called as often as necessary without causing errors.

In the Viewer when a table is not fully compliant with DMC standards (Multi Columned PK or no PK) opened up all Viewer features but disconnected the Save to File only.

Many "logging lines" in code have been added to help you (and us) - in case of problems - to better trace all the tasks done by DMC.

In a TPS Table when the PREFIX was embedded in the structure the Key's were not properly assigned to Columns

Truncating a SQL Anywhere table was not working

GOLD Version 1.5.0.3 released 23rd October 2008

Added in Operations during a Transfer : LEFT - RIGHT and SUBSTRING portion extraction

Portable Version creation and synching (missing files)

GOLD Version 1.5.0.2 released 17th October 2008

Support of SQL Anywhere cloning

Real Edit In Place in the Viewer (with a calendar popup for all DATES)

Viewer : format a LONG to a DATE or a TIME column and export the data as is directly

Viewer : after doing a QBE on any Table you can now DELETE all the records of the resulting subset with a New DELETE button

Viewer - Embedded BLOB Viewer with predefined types for Images - RTF - HTML - XML - PDF - VIDEO - SWF - DOC and XLS documents

Complete LOG file creation by DMC (tasks and transfers)

eMailing client to send us automatically the LOGS in case of a crash - this enables us to trace eventual errors in DMC or to show you why a process cannot be completed

In the Mapping OPTIONS added the possibility to perform an OPERATION on two columns (+ - * /)

In SQL Cloning we have added a BUTTON to rename the TABLE (instead of the old entry field)

In SQL Cloning we have added a BUTTON to SEARCH & REPLACE text in the script (for example if you want to replace all 'ClientName' with 'Client_Name'

When doing a Clone to xx the Destination Table is CLEANED from any illegal Names like ColName=N(12.2) and changed to ColName

Full support in PostGre SQL of Mixed cased Schemas and table names and Columns or keys

Full support by hand creation of SQL Structures for GUID type columns without having to use functions for displaying purposes

Full support of GUID columns in Random Data Generator

Added SQL DRIVER selection for MySQL (to let you use either 3.51 or the new 5.1 driver)

Added SQL KEY support in the cloning process (some Key's were not created properly in PostGre SQL mainly)

Added SQL KEY support in the cloning process (some Key's were not created properly in PostGre SQL mainly)

Added DECIMAL separator and number of decimals to be used in Settings

In the Mapping TAB a column "T" will show if Data is truncated while being transferred

In the Mapping TAB when columns are linked - the number of unlinked columns is displayed in the Status Bar rightmost part

When doing a Clone to TPS the Destination Table is directly created if no illegal column names are found otherwise you are taken to the Creation Wizard Screen to let you check and modify the Structure

Several small bugs in the application (mainly in ASCII transfers and in DATE TIME support)

GOLD Version 1.5.0.0 released 8th August 2008

UPDATE any SQL Table with the proper mapping option

Full support of SQL BLOB columns - these can be transferred even if the size is over 65k

In ODBC creation and edition of a form,  we added a list of Drivers installed on your machine for you to choose from to help Oracle - PostGreSQL and SQL Anywhere users

Added full support of UNIQUEIDENTIFIER (GUID) columns in Pervasive and Ms SQL (and in generating random Data when the Table contains such columns)

Added full support of Clone to Pervasive Tables

Added full support of Clone to Access Tables

All windows are now compliant with LCD screens and also any language (Chinese etc ...)

Added in SQL environment two buttons : EMPTY & DROP (the selected table)

This version also brings the first of coming features : SQL Table synchronization and backups using profiles and the command line (more to come)

The ODBC connection string Display Name is now an open field for you to change if need be

When transferring Data and when you had selected to only read the First 50 records - you could not transfer records

When only one ODBC connection string was built you could no 'see' it in destination

Generating random data from SQL environment would hang

In SQL environment several DB - Table selections one after the other could crash the tool

Version 1.4.0.2 released 3rd July 2008

UPDATE any non SQL Table with the proper mapping option

Command line (Runtime version of DMC) arguments are accepted to run single or Batch processes

Profiles are now 'linked' to Projects which allows you to group them by your preferred themes

When restoring a profile the process windows are replaced by a Queue treatment (speed)

When transferring Data and when you had selected to only read the First 50 records - you could not transfer more then 50 records

Version 1.4.0.1 released 23rd June 2008

SQL Environment - work on any Data Base : - Query Builder Single or Multi Table - Export to TPS or SQL subsets - Viewer direct access - Generate Random Data etc ...

Clone to DAT - DBF (DBase - Clipper and FoxPro)

User option to display or not a Sum Up display screen of the Main Wizard (with canceling possibility)

Direct access in Viewer to the last 25 Most Recently Used Tables (all formats)

All Data Management screens redesigned to accommodate more space (better visibility)

Data Management Task WIZARD - define step by step your task (change source and / or destination settings without loosing pace)

Create ODBC WIZARD

User option de read only first 50 records before reaching the Mapping tab

Define the Color of all List Box records

List of all SQL Key's in Structure Tab - Structures stored in Clipboard

In Mapping tab : List by ... processes changed to working on Queue's (speed)

Processing of Columns to define if DATETIME's are present also changed to working on a Queue (speed)

Clone to SQL - constraints where not always properly created

Removed the empty column in column list when creating a Key in 'Create with Wizard'

Version 1.3.0.1 released 26 May 2008

Portable Version : Any multi copy licensed user can create one or several (depending on his license) copies of DMC on USB - Memory Cards etc.....

The ODBC Connection string window has been entirely redrawn and when CREATING a new one, wizard type messages are now displayed in sequence to help you in this process

When in the Viewer and you want to Export to CSV or XML a message of confirmation is opened for you.

When reading a TPS table with arrays (dimensioned columns) and when a column was OVER another one, you received an error message - corrected.

Version 1.2.0.3 released 19 May 2008

VIEWER : Refresh TPS Multi Table Table List (if you added a table trough another application while the Viewer is opened)

VIEWER : Use a new button to BUILD all KEY's of the viewed table (TPS & DAT)

Store your encrypted TPS Passwords automatically by using a new checkbox in the PWD Message (it will be used automatically at next table opening)

During all processes - no more dynamic Table creation in TPS format - this accelerates the result display

Version 1.2.0.2 released 14 May 2008

VIEWER : A new technique is used to load the Data : the main screen opens up in around 2 seconds with the first 500 records displayed

VIEWER : When reading a TPS Multi Table a List of tables is displayed to switch directly between them

VIEWER : When reading a DAT - TPS or Ms SQL or MySQL table you can add and delete records

VIEWER : Locator Search (full text) on the selected column or all columns

VIEWER : Mass Updating of the table via a powerful Expression & Condition Builder (store queries for future use)

VIEWER : QBE on the table via a powerful Query Builder (store for future use)

Export what you have on screen after a QBE or a mass Update (WITHOUT having to save to File) to various predefined Formats plus XML and CSV directly from DMC Viewer

VIEWER : After a QBE or a Mass Update before saving to File, you can reset all data to its original state with a button

Full support of TPS Multi Tables

When reading a TPS Multi Table a List of tables is displayed both for Source or Destination to let you chose from them the table to read

When saving a Profile and Multi Tables are used, all will be stored and when you restore it, all will be done automatically for you (Table Name, Password etc...)

Full support of array fields even while generating data and cloning to SQL (Column[4] will generate Column (in case of a Key) + Column_2 + Column_3 + Column_4)

Change the SQL table Name when Cloning to SQL in the script editor window

You can now use ODBC with Trusted Connection against an Ms SQL server (empty login and empty pwd)

A new technique is used for translating the IDE - switch language's on the fly

The installer now offers to link or not DBF - DAT and/or TPS Tables with DMC

In the messages displayed you can now use the "Enter" and "Escape" keys to accept or refuse it

When all the columns were not mapped for a transfer, some of them could be not transferred at all

Version 1.2.0.1 released 1st. April 2008

You can use a simple Double-Click on any DAT - DBF or TPS file to view it in DMC (column sorting - key sorting etc...)

Export from any structure to ASCII (CSV & TXT) format

Generate Random Data for test tables from DMC for any structure

Use Multiple Record Level conditional mappings combined with the Column Level ones

New conditional options in mappings : Replace - Starts with - Ends with - Empty & Not Empty

All the ASCII reading has been rewritten to speed up the process

The process used in DMC is now displayed in the main frame toolbar

XML export now opens immediately a Tab in DMC with your File displayed (no longer necessary to wait for IE to open the file)

The Data Tab showing your Source and Destination data now can be sorted with column headers

The Viewer mode in DMC is now full screen

Version 1.1.0.7 released 6th. March 2008

You can now use DMC to UPDATE (by record number) any NON ODBC Table and not only to INSERT records.

When a Clone to TPS process is done, a structure file will be created for you to be able to switch to Creation Wizard mode and modify your TPS table

When in an ODBC record a list of all available DSN's is displayed and a Double-Click will fill in automatically the record for you

Activation codes can be requested directly on Internet

The test ODBC button now returns a "Success" message along with the type of server you are connected to (and does no longer send an error when no Table is in the DB)

The main frame is resizable to any dimension and all windows fit in a resolution of 800x600

All buttons have been resized and some Icons removed to allow for a better UI integrity in some small screen resolutions

The Creation Wizard now let's you create multiple columned keys

The installer and updater now is fully Vista compatible and you will be able to install the program under Program Files and the data under Program Data (or change the directories of course)

The full installer can be used as an updater .... although we do not recommend it

The "Link by Name" process was creating wrong mappings - corrected and DATETIME icons added

The Clone to TPS was not creating properly certain keys

Version 1.1.0.6 released 14th. February 2008

When a BLOB is found in source Table it is stored in full BINARY to a temp TPS table and is transferred from there to your destination table

When an XLS sheet is source then if a REAL is found an NO decimals it is converted (clone to TPS) in a LONG

when an XLS sheet is source then the Clone to TPS or SQL table name is now without the trailing $ sign

Version 1.1.0.5 released 21st. January 2008

DMC allows you to Visualize ANY Table and to limit the number of records to be displayed.

DMC displays for you all the transferred data directly in a List Box for you to Visualize.

DMC supports SQL Anywhere both as source and destination and for cloning purposes. New Feature : "Horizontalize" your data : Transfer x RECORD values in x COLUMNS in ONE RECORD.

While doing a "Link by Name" mapping DMC will automatically map DATE & TIME columns of a DATETIME GROUP.

SQL & XLS reading of tables did not return proper information's.

Version 1.1.0.4 (bug fix) released 15th. Jan 2008

When in Creation Wizard a KEY was defined as NODUPE then it would be created as DUP

Version 1.1.0.3 released 14th. Jan 2008

Clone to SQL - select ANY source table (DAT-DBF-TPS-CSV) and create an exact cloned SQL Structure

Create from TXT File - use a TXT File containing a VALID TPS structure to create the table

Creation Wizard to create a new TPS or SQL Table - Use a Wizard to manually define a new TPS or SQL Table

support of FireBird InterBase SQL

Expiry date of your maintenance Plan in the "About Screen"

Right click support in ODBC connection module

"Link By Name" mapping now takes care of DATE fields in SQL destinations

TOPSPEED password is only asked if the table requires one

when SQL DATETIME was NULL

when Oracle or Pervasive where used in ODBC connection string (driver not saved properly)

in ODBC when a table Name had a space in it

UNIQUE KEY's were badly showing in mapping Tab

in record level conditional rules

when reading some DBF Tables with MEMO columns

when Oracle or PostGre SQL where destination, some columns were not well read

when an error occurred while reading a table, DMC would GPF without any error message.

Version 1.1.0.2 released 8th. Dec 2007

Added feature of Cancel Processing on all data transfers

Changed Main Frame to resizable and made inner screens compatible with 1024x768 resolution

Transfer to XLS bug fix

Version 1.1.0.1 released 4th. Dec 2007

Added support of XML files as DESTINATION and as  Source Raw Data as is export also

Added feature to Clone to TPS from any source Table - All the data contained in the source Table can be transferred after mappings are done

Added feature of editing the Structure of both Source and Destination Tables : You can even use this txt file to add it in your dictionary if need be (with a small modification)

Added an extra Tab (Assign Q) which opens up after Transfer is done showing all columns used and the respective values found for the last scanned record

Added DBF overred Field support : if a field placed over another one is larger then the 'root' field size is dynamically changed

Added for Basic - CSV files a parser to replace any illegal character in column names

Added for Basic - CSV files a process to adapt automatically to the biggest length of field found in the file (a one pass process)

Added feature that both Source and Destination tables are automatically cloned to TPS - this let's you access an empty TPS table as a copy of your tables

Added feature for empty passwords in ODBC connections

GROUPS with DATE & TIME fields are better visibly shown when found (icons) and all unusable (depending on driver) columns are placed at the bottom of the mapping list

GROUPS with DATE & TIME fields are now automatically prohibited from being used in ODBC driver destination mappings

When a KEY has ascending or descending defined an different icon will reflect it for better understanding

When during any non ODBC Transfer of Data, errors occur, they will be logged to a txt file which will popup automatically at the end of the process

If Opening or Reading a Source or Destination File is impossible an error message will popup and the process will be stopped

Corrected bug when not using a Port in ODBC connection

Small bug fixes ...

Version 1.0.0.9 released 14th. Nov 2007

Added support of DBF files as SOURCE and DESTINATION (read the docs for detailed explanation regarding directories)

Added feature to SendTo XLS-CSV-PDF-HTML-DOC and email or FTP or print those generated files when in the DATA tab (source data only) or the Mapping tab

Added a fully automatic DAT 2 TPS cloning possibility : now you can select a DAT File and have the tool clone it for you to a non existent TPS Table with all keys

Added an extra process to find in Source and Destination mappings if any STRING(8) 's are there with a DATETIME GROUP over it (mapping prohibited of course on those)

Small bug fixes ...

Version 1.0.0.8 released 7th. Nov 2007

Added support of SQL Pervasive SQL files as SOURCE and DESTINATION

New Installer Vista UAC compliant : under VISTA with UAC turned ON you HAVE to use this tool as ADMINISTRATOR (for ODBC connection reasons) and you can install anywhere now

Bug fix in ODBC Connection record when Access or Excel where used

Bug fix in ODBC Connection when using the Test Button : now you can use this feature as many times as you wish

Bug fix when dropping the activation file under Vista (executable path problem)

Version 1.0.0.7 released 3rd. Nov 2007

Added support of SQL PostGreSQL files as SOURCE and DESTINATION

Changed the numbering of columns when a DATETIME was found

Bug fix in Exports when aggregate was used

Version 1.0.0.6 released 2nd. Nov 2007

Added support of SQL Oracle files as SOURCE and DESTINATION

Bug fix in Exports ODBC / TPS / XLS (when ODBC and DATETIME as source then some fields were not transferred)

Version 1.0.0.5 released 30th. Oct 2007

Added support of SQL DB2 files as SOURCE and DESTINATION

in ODBC SQL (Keys not being properly retrieved)

Version 1.0.0.4 released 28th. Oct 2007

Fixed bug in export to ODBC (logfile error)

Version 1.0.0.3 released 26th. Oct 2007

Added support of Clarion DAT files as SOURCE and DESTINATION

Added Licence and Maintenance Plan registration at the same time

Version 1.0.0.2 released 20th. Oct 2007

Added Spanish language

Added Skype support

in SV List boxes headers not being translated

in some Buttons and Action Message not being Translated

FIRST Version 1.0.0.1 released 17th October 2007