|
Command Line Options (DMC) |
  
|
|
Command Line Options (DMC) |
|
DMC has a command line possibility and can be used "as" a Runtime version (ONLY on YOUR machine)
ALL Runtime Engine command line Help Topics are in the relevant help file (installed along with the RT)
Command line options are :
/P:X where X is the PROFILE ID (the ID is the GREEN column figure in the project & profile module)
/B:X where X is the PROJECT ID
/S:0 or /S:1 where 0 means NOT SILENT and 1 means SILENT running
You also need to set in Settings / Setup the checkbox to Open or not the Tool at the end of a Silent process treatment
Examples :
If you need to have all the Profiles in SQL projects processed then use this command line argument
x:\dmc.exe /B:1 /S:1
(this will run all Project ID 1 Profiles SILENTLY)
If you need to have the Profile ID # 2 processed then use this command line argument
x:\dmc.exe /P:2 /S:0
(this will run Profile ID 2 Profiles NOT SILENTLY - IDE will open at the very begining and you can see all processing taking place)
where x:\ is YOUR long path to the DMC executable
To use and call DMC from your application you can use this registry key to get information of the PATH to use :
GLO:CheminProgramme = GETREG(REG_CURRENT_USER,'Software\CGF\Data Management Center','Directory Installation')
This is an example of such a call
! This gets the registry PATH and starts DMC in SILENT mode to run the profile ID '1' and wait for it to finish
! This task defined in DMC reads a txt file and concatenates fields and transfers all in a TPS table
GLO:CheminProgramme = GETREG(REG_CURRENT_USER,'Software\CGF\Data Management Center','Directory Installation')
RUN(CLIP(GLO:CheminProgramme) & '\dmc.exe /S:1 /P:1',1)
! This calls a procedure which will upload the created TPS Table to our distant server
FTPGetFile
! This calls another procedure to loop on the TPS Table and UPDATE all values
LoopMaJPays
! This is another type of call to start a procedure which will READ those values locally and export them to the site so as to show the updated values
GLO:AppelProcedure = 'ExportPaysSQL'
START(AppelTraitementInternetSQL_CGF,45000)
This example is what we use to update every day the Exchange Rates so as to enable the site to reflect current rates for all countries in our sales
When a command line process is finished then either the Interface will Open or not depending on your Settings
When the process is ended DMC will add to the cgf_import\dmc.ini file an entry value of
[DMC]
EndCommandProcess=1
you can use this in your application to read this file and "know" when it is finished treating
To retreive from the registry the location of this dmc.ini file you need to query on
HKEY_CURRENT_USER\Software\CGF\Data Management Center the Key named "Directory Data"
A log file is automatically done for all the different processes - you can find it in cgf_import sub directory under the Installation Directory - in a file called "dmclog.log" and you can open it in Notepad
This is an example of a batch on 6 profiles done from a simple Project ID Number (same TPS source Table transferred to six different SQL's DB's) :
11:30:50 --> Start Data Transfer of Profile ID : 3 [1 / 6]
11:30:50 -->
11:30:51 --> TOPSPEED Source Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS) : Open Table OK
11:30:51 --> TOPSPEED Source Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS) : Load Data OK
11:30:52 --> TOPSPEED Source Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS) : List Columns OK
11:30:52 --> MySQL Destination Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> theatrhall - cgf_clients) : Connection OK
11:30:52 --> MySQL Destination Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> theatrhall - cgf_clients) : Open Table OK
11:30:53 --> Load Complete Data : Source (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> theatrhall - cgf_clients)
11:30:53 --> Load Complete SQL Data : Destination (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> theatrhall - cgf_clients)
11:30:53 --> Start Export to SQL Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> theatrhall - cgf_clients)
11:31:16 --> Export to SQL Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> Destination : MySQL) ERROR : SQL Error:
90 - Error File System
42S22 - Unknown column 'CB_DATEEXP_TIME' in 'field list'
11:31:16 -->
11:31:16 --> MySQL Process interrupted before the end (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> Destination : MySQL)
11:31:16 -->
11:31:16 --> End Export to SQL Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> Destination : MySQL)
11:31:18 -->
11:31:18 --> Start Data Transfer of Profile ID : 10 [2 / 6]
11:31:18 -->
11:31:18 --> TOPSPEED Source Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS) : Open Table OK
11:31:18 --> TOPSPEED Source Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS) : Load Data OK
11:31:19 --> TOPSPEED Source Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS) : List Columns OK
11:31:19 --> SQL Destination Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> suitecom_cgf - cgf_clients) : Connection OK
11:31:19 --> SQL Destination Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> suitecom_cgf - cgf_clients) : Open Table OK
11:31:20 --> Load Complete Data : Source (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> suitecom_cgf - cgf_clients)
11:31:21 --> Load Complete SQL Data : Destination (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> suitecom_cgf - cgf_clients)
11:31:21 --> Start Export to SQL Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> suitecom_cgf - cgf_clients)
11:31:57 --> Export to SQL Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> Destination : SQL) 9081 Records Transfered
11:31:57 --> End Export to SQL Table (Profile : 10 [2 / 6] - PSCLIEN.TPS -> Destination : SQL)
11:31:59 -->
11:31:59 --> Start Data Transfer of Profile ID : 11 [3 / 6]
11:31:59 -->
11:31:59 --> TOPSPEED Source Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS) : Open Table OK
11:31:59 --> TOPSPEED Source Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS) : Load Data OK
11:32:00 --> TOPSPEED Source Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS) : List Columns OK
11:32:00 --> DB2 Destination Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> SUITECOM - CGF_CLIENTS) : Connection OK
11:32:00 --> DB2 Destination Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> SUITECOM - CGF_CLIENTS) : Open Table OK
11:32:01 --> Load Complete Data : Source (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> SUITECOM - CGF_CLIENTS)
11:32:02 --> Load Complete SQL Data : Destination (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> SUITECOM - CGF_CLIENTS)
11:32:02 --> Start Export to SQL Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> SUITECOM - CGF_CLIENTS)
11:32:57 --> Export to SQL Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> Destination : DB2) 9081 Records Transfered
11:32:57 --> End Export to SQL Table (Profile : 11 [3 / 6] - PSCLIEN.TPS -> Destination : DB2)
11:32:59 -->
11:32:59 --> Start Data Transfer of Profile ID : 6 [4 / 6]
11:32:59 -->
11:33:00 --> TOPSPEED Source Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS) : Open Table OK
11:33:00 --> TOPSPEED Source Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS) : Load Data OK
11:33:00 --> TOPSPEED Source Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS) : List Columns OK
11:33:00 --> MySQL Destination Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> db2727_test - cgf_clients) : Connection OK
11:33:01 --> MySQL Destination Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> db2727_test - cgf_clients) : Open Table OK
11:33:02 --> Load Complete Data : Source (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> db2727_test - cgf_clients)
11:33:02 --> Load Complete SQL Data : Destination (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> db2727_test - cgf_clients)
11:33:03 --> Start Export to SQL Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> db2727_test - cgf_clients)
11:33:40 --> Export to SQL Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> Destination : MySQL) 9081 Records Transfered
11:33:40 --> End Export to SQL Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> Destination : MySQL)
11:33:42 -->
11:33:42 --> Start Data Transfer of Profile ID : 7 [5 / 6]
11:33:42 -->
11:33:43 --> TOPSPEED Source Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS) : Open Table OK
11:33:43 --> TOPSPEED Source Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS) : Load Data OK
11:33:44 --> TOPSPEED Source Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS) : List Columns OK
11:33:44 --> Oracle Destination Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> XE - CGF_CLIENTS) : Connection OK
11:33:44 --> Oracle Destination Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> XE - CGF_CLIENTS) : Open Table OK
11:33:46 --> Load Complete Data : Source (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> XE - CGF_CLIENTS)
11:33:48 --> Load Complete SQL Data : Destination (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> XE - CGF_CLIENTS)
11:33:55 --> Start Export to SQL Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> XE - CGF_CLIENTS)
11:35:01 --> Export to SQL Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> Destination : Oracle) 9081 Records Transfered
11:35:01 --> End Export to SQL Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> Destination : Oracle)
11:35:03 -->
11:35:03 --> Start Data Transfer of Profile ID : 5 [6 / 6]
11:35:03 -->
11:35:04 --> TOPSPEED Source Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS) : Open Table OK
11:35:04 --> TOPSPEED Source Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS) : Load Data OK
11:35:05 --> TOPSPEED Source Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS) : List Columns OK
11:35:05 --> MySQL Destination Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> option_photo - cgf_clients) : Connection OK
11:35:05 --> MySQL Destination Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> option_photo - cgf_clients) : Open Table OK
11:35:07 --> Load Complete Data : Source (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> option_photo - cgf_clients)
11:35:08 --> Load Complete SQL Data : Destination (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> option_photo - cgf_clients)
11:35:14 --> Start Export to SQL Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> option_photo - cgf_clients)
11:36:12 --> Export to SQL Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> Destination : MySQL) 9081 Records Transfered
11:36:12 --> End Export to SQL Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> Destination : MySQL)
11:36:12 -->
11:36:12 --> End of all Processes
As you can see from this example any ERROR is logged and the process stops and returns automatically to the next one
When running in SILENT mode the only way to know where about the processes are is y moving the mouse OVER the SYSTEM TRAY icon : it displays the process number and details of Source and destination table Names
LICENSING : As you may need to distribute DMC to your clients so as to let them use this command line option, we have implemented this version in BOTH the Viewer and Enterprise versions.
(Version 2 of DMC offers ne special version of a small footprint engine with an installer and special licenses)
Please consult the current pricing's from our Web Site