Data Management > Import

This is the final stage of your work : define the settings for your Data Transfer

DMC will tell you how many records are found in your Source Table and you will be able to define the following :

Nb. of Records to Import : if you change this from the full value to say 50 then ONLY the FIRST 50 records will be imported

1st. Record & Last record : if you change these two figures then only the selected records starting from 1st. and ending at Last will be imported

Do NOT change Nb of Records if you change 1st and Last of course ....

We have included a LOGOUT and COMMIT in code on all the non SQL transfers to speed things up.

When you click on "Transfer Data", if the destination Table is not empty then you will be prompted to "Empty Table" or not (be very CAREFUL to duplicate errors if you do not empty the table)

The Destination table will be created and placed in the "destination" subdirectory of "cgf_import" for you to use it from there - you can access those files directly like this

If you select XML as Destination then the File will be created for you in the 'Destination' directory like this

You also have at all times the possibility from here to save all your work in a Profile to be able to use it again at a later date ....

After doing any non ODBC transfer IF any errors occurred during this process, a popup window with an error log file will open automatically and let you examine and see what went wrong

You can stop the Data processing at any time with the relevant button

You can of course do as many transfers as you wish without closing the mapping window ( selective record levels or different trial outs - remember that the "empty table" is here to help you add or not new records also)

After a transfer is done the Tab "Transferred Data' will open up for you to immediately see the destination table....

You have a checkbox on the left "Log Transfers" which allows you to create a TXT file in cgf_import subdir named dmclog.log - you can also use this to see all in DebugView from Microsoft

On some Excel Tables, we have noticed that in a NUMERIC column sometimes some values where stored as TEXT (this is shown in Excel 2007 when moving mouse over such a column a small Icon pops up to inform us of this situation)

In this case DMC will of course read the value of the column as : EMPTY and return a 0

To overcome this situation simply export directly from Excel to CSV and then use this CSV File to Transfer your data to whatever destination Table you need

THIS TASK IS RUNTIME ENGINE COMPLIANT

If you need to perform this task on your clients machines , then SAVE it as a Profile when all is defined and use the Runtime Engine to run it from your application

The different settings on source - destination Folders (even Table Names) plus some ODBC settings like User Name and Password can be changed dynamically from your application to meet your requirements