Navigation:  Import & Export > Import - Export Data

 

 

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

 

The utility 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 STREAM and FLUSH in code on all the non SQL transfers to speed things up.

 

When you click on "Import", if the destination Table is not empty then you will be prompted to do it or not (be very CAREFULL 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

 

CAREFUL : Those files are overwritten at each new Transfer working on the same Destination table

 

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

---