Navigation:  Introduction >

Logs

Previous pageReturn to chapter overviewNext page

You have in the Import & Export WIZARD a Trace LOG checkbox which enables you to have a complete LOG file created by DMC for all tasks.

 

These logs are all in a special directory under 'cgf_import\logs' and you can access then directly from DMC in the Documents Task from the Navigation Panel

 

These logs can be very helpful for you to understand why a task is not completed

 

These logs can also be emailed to us to ask our help in a task not completing properly

 

These logs are also regularly offered to be deleted from your HD : a message will open up when you open DMC the first time on the 1st of each month and offer to delete them

 

These logs are also - IF they exist - used in our built in emailing feature IF the application crashes in a task when you reopen it

 

email_log

 

By clicking on the eMail button you will be taken automatically to a module pre filled with all the necessary data (EXCEPT YOUR EMAIL ADDRESS IF UNDER DEMO)

If you are in this situation please fill in your email and send us the email with the log zipped and attached

 

You just have to check the log file sent - it is displayed for you in Note Pad - check if you want to delete any information's from it before you send it to us for analysis on your problem

 

email_send_log

 

Of course you can also chose NOT to send the log by email - this feature will help us (and you at the same time) to better the tool by understanding any eventual problem you encountered

 

You also have the possibility to ask DMC to generate TRANSFER logs from the MAPPING TAB

 

Remember that such logs can be VERY important in size if you transfer a large amount of data - we recommend doing a first transfer on say 100 records and to log this one preferable

 


 

This is an example PROCESS LOG created (from a Restore Profile on a Transfer from ACCESS to a TPS Table) :

 

10:34:50 --> Start a New Task

10:34:50 --> Restore a saved Profile

10:34:53 --> GLO:SelectedProfile <> 0

10:34:53 --> Load Profile

10:34:53 --> Define Type of Task => (SQL Type - SQL Type Dest - Driver Dest) =  -  -

10:34:53 --> ?GLO:Driver

10:34:53 --> Load Profile Step 1

10:34:53 --> Select SQL

10:34:53 --> Load Profile Step 2 SQL

10:34:53 --> Define Type of Task => (SQL Type - SQL Type Dest - Driver Dest) = Access -  -

10:34:53 --> Define Type of Task => (SQL Type - SQL Type Dest - Driver Dest) = Access -  -

10:34:53 --> Define Type of Task => (SQL Type - SQL Type Dest - Driver Dest) = Access -  -

10:34:53 --> ?GLO:DriverDest

10:34:53 --> Load Profile Step 1 Destination

10:34:53 --> Define Type of Task => (SQL Type - SQL Type Dest - Driver Dest) = Access -  - TOPSPEED

10:34:53 --> Run

10:34:53 --> Init Run

10:34:53 --> Define Type of Transfer

10:34:53 --> Define Type of Task => (SQL Type - SQL Type Dest - Driver Dest) = Access -  - TOPSPEED

10:34:53 --> SQL Query Source

10:34:53 --> SQL Query Source - Table Name => products

10:34:53 --> SQL Query Source : Start Process

10:34:53 --> SQL Query Source : DO SelectSQL

10:34:53 --> Select SQL

10:34:53 --> SQL Query Source : DO SQLCountRecsS

10:34:53 --> SQL Count Records Source

10:34:53 --> SQL Count Records Source - Connection => dirtbike

10:34:53 --> SQL Count Records Source - Connected

10:34:53 --> SQL Count Records Source - Query => select * from products

10:34:53 --> SQL Count Records Source - Prepared

10:34:53 --> SQL Count Records Source - Create Temp Q

10:34:53 --> SQL Count Records Source - Disconnect

10:34:53 --> Init Class for SQL

10:34:53 --> Init Class for SQL => Access

10:34:53 --> SQL Count Records Source - Get Number of records SQL code on Table => products

10:34:53 --> SQL Count Records Source - Number of records in Table => 577

10:34:53 --> SQL Count Records Source - SQLTableName => products

10:34:53 --> SQL Count Records Source - END

10:34:53 --> SQL Query Source - SQLTableName => products

10:34:53 --> SQL Query Source : Connect => dirtbike

10:34:53 --> SQL Query Source : Connected

10:34:53 --> SQL Query Source : Prepare Query => select * from products

10:34:53 --> SQL Query Source : Prepared

10:34:53 --> SQL Query Source : Access : dFileSource.Clone WITH KEYS => products

10:34:53 --> SQL Query Source : BLOBS => 25

10:34:53 --> SQL Query Source : BLOBS - Create Qs

10:34:53 --> SQL Query Source : DO ReadKeys

10:34:53 --> DMC.Read Keys

10:34:53 --> DMC.Read Keys DLib code : Primary Column ID Name KeyName : (+CATALOGID) (PRIMARYKEY)

10:34:53 --> DMC.Read Keys  Primary Column ID Name KeyName : (1) (CATALOGID) (PRIMARYKEY)

10:34:53 --> SQL Query Source : Primary Column ID Name KeyName : (CATALOGID) (PRIMARYKEY)

10:34:53 --> SQL Query Source : dQueSource is Completed

10:34:53 --> SQL Query Source - Reset Table Name and Owner => products - dirtbike

10:34:53 --> SQL Query Source : (Not Generate Data and Not EXCEL) DO FillSQLSourceQ

10:34:53 --> Fill SQL Source Q

10:34:53 --> Fill SQL Source Q (VIEWER) : BLOBS so CREATE DMCBLOB

10:34:53 --> Fill SQL Source Q (VIEWER)

10:34:53 --> Fill SQL Source Q (Clone or Transfer and ReadOnlyFirst 50 Recs)

10:34:53 --> Fill SQL Source Q (Clone or Transfer and ReadOnlyFirst 50 Recs - BLOBS => DO ReadSQLDataWBlob)

10:34:53 --> Read SQL Data With Blob

10:34:53 --> Read SQL Data With Blob => BLOBS = 25

10:34:53 --> Read SQL Data With Blob - Reset Table Name and Owner => products - dirtbike

10:34:54 --> SQL Query Source : dSQLSource.DisConnect

10:34:54 --> SQL Query Source - (Fill DummyQ)

10:34:54 --> SQL Query Source - (GLO:ReadSrcOnly = 0 OR GLO:SQLType = Excel) => DO SQL_StepOne

10:34:54 --> SQL Step One

10:34:54 --> SQL Step One (Generate or Transfer) => DO CreateDFDTable

10:34:54 --> Create Table Main

10:34:54 --> Create Table Main : ID = 1

10:34:54 --> Create Table Main : ID = 1 Goto Creation

10:34:54 --> SQL Step One => DO ModifierStructure

10:34:54 --> SQL Step One => DO DO EcrireStructureStartSource

10:34:54 --> SQL Step One => DO DO EcrireStructureODBC

10:34:55 --> SQL Step One - General => DO BuildNewList

10:34:55 --> Build ListBox Format

10:34:55 --> Build ListBox Format - Decimal Sep. => .

10:34:55 --> Build ListBox Format - Nb. Decimals => 4

10:34:55 --> SQL Step One - General => oQ2SQL.Kill

10:34:55 --> SQL Query Source - END

10:34:55 --> Run : Goto run step one (not MT or MT and restore profile)

10:34:55 --> Run Step One

10:34:55 -->

10:34:55 --> TPS Query Destination

10:34:55 --> TPS Query Destination - Table Name => L:\Data\eBusines\PIECES.TPS

10:34:55 --> TPS Query Destination - TOPSPEED Check if it is a Multi-Table

10:34:55 --> TPS Query Destination - Normal and NOT a Multi-Table or Load Profile

10:34:55 --> TPS Read Destination Table

10:34:55 --> TPS Read Destination Table - Init

10:34:55 --> TPS Read Destination Table - DAT or TOPSPEED

10:34:55 --> TPS Read Destination Table - Restore and Normal Table and NO PWD

10:34:55 --> TPS Read Destination Table - Goto FillTPSDestinationQ

10:34:55 --> Fill TPS Destination Q

10:34:55 --> Fill TPS Destination Q - Init all

10:34:55 --> Fill TPS Destination Q - MEMO or BLOBS or ARRAYS => 0 | 0

10:34:55 --> Fill TPS Destination Q - NO Memos and NO Blobs and NO Arrays - Create Q

10:34:55 --> Fill TPS Destination Q - Create DISPLAY Q

10:34:55 --> Fill TPS Destination Q - End of Q creation

10:34:55 --> Fill TPS Destination Q - Goto FillTPSDestQ

10:34:55 --> Fill TPS Destination Q

10:34:55 --> Fill TPS Destination Q - Reset Table NAME => L:\Data\eBusines\PIECES.TPS

10:34:55 --> Fill TPS Destination Q - OPEN Table

10:34:55 --> Fill TPS Destination Q - SET Table

10:34:55 --> Fill TPS Destination Q - END

10:34:55 --> TPS Read Destination Table - Goto Build ListBox Format

10:34:55 --> Build ListBox Format Destination

10:34:55 --> TPS Read Destination Table - Goto Create Temp TPS Structure Tables

10:34:55 --> Create Table Main

10:34:55 --> Create Table Main : ID = 2

10:34:55 --> Create Table Main - File to Create => L:\CGF\Compta\cgf_import\Dfd_D_Data.tps

10:34:55 --> Create Table Main : ID = 2 Goto Creation

10:34:57 --> TPS Read Destination Table - Reset Browse From File

10:34:57 --> TPS Read Destination Table - CLOSE Table

10:34:57 --> TPS Query Destination - END

10:34:57 --> Run Step One : DO Run Step Next

10:34:57 --> Run Step Next

10:34:57 --> Run Step Next - Continue

10:34:57 --> Run Step Next - General Case

10:34:57 --> Run Step Next - (General Case) Goto FillSLColNameQ

10:34:57 --> Fill Source ColName Q

10:34:57 --> Run Step Next - (General Case NOT Viewer)

10:34:57 --> Run Step Next - Continue Loading = 2 AND Clone2SQL = 0)

10:34:57 --> Load Profile Step 2

10:34:57 --> Load Saved Mappings

10:34:57 --> Define Type of Task => (SQL Type - SQL Type Dest - Driver Dest) = Access -  - TOPSPEED

10:34:57 --> Load Profile - END

10:34:57 --> Run Step Next (ReadSrcOnly = 0 OR (ReadSrcOnly = 1 AND GenerateData = 1) OR (ReadSrcOnly = 1 AND Driver = ASCII))

10:34:57 --> Run Step Next - END

10:34:57 --> Run Step One - END

10:34:57 --> Run - Display LOG File

10:34:57 --> Run - END

10:34:57 -->