TABLE FILE CAR
BY COUNTRY NOPRINT
HEADING
"whatever you like"
END

	Frank
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7

quote:

Originally posted by edadhc:
So, it looks like you basically want to create a DM Log report within your own HTML page.

Under the hood, DM Log report gets generated by using POST request to send data to the server to be processed in some way, which then sends the response back with the log information through CMRPT1 (see below for more information on this). You can capture what’s actually going on through HTI scripts. HTI scripts are files used by playback and the recorded sequence - you can think of them something similar to traces.

Once we have the playback script, we can create the actual URL that is being used by POST. Then finally, you can create that link inside your HTML document.

To get started, open up web console.
1. From the top menu, go to My Console  Preferences. Under Preferences, change “Show Web Console reports in the following format” to HTML. Click Update.
2. Then run your DM flow.
3. After your flow completes, open up your DM Log from the Web Console. Workspace  Configuration/Monitor  In the left pane menu, Logs and Traces  Right-click DataMigrator Logs and Statistics  View  View Report  Double-click the appropriate log under the Log column. You should now see the Log report.
4. Open up a separate browser window. From web console’s top menu go to Workspace  Scalability. From the left pane menu, right-click on Scalability  New  Recording. You can leave the script directory and name as is, test0001 and rec0001 respectively. Click Start.
5. Now that the recording is on, go back to your DM Log and refresh the Log page. Don’t hit F5, instead, right-click on Log content page and from the drop-down menu, click Refresh.
6. Then go back to the Recording of HTI Script File page, click Stop.
7. From left navigation pane, right-click test0001 and refresh  rec0001 should appear, double-click rec0001
8. In the HTI requests, you should see the POST action that was used to generate the DM Log report. Double-click on POST.
9. You should see something like the following:
BEGIN
HOST = localhost
PORT = 8117
REQUEST_METHOD = POST
URI = /webconsole
XCONTENT = {
IBIS_pageid=78
IBIX_action={
Show Log
}
IBIS_etlRptName=CMRPT1
IBIS_page=IMPCTTABLE
CGIP_type=ETLREP
CGIX_cmd=ETLSchedulerLog
CGIX_PID=20110331141507_b43871e3
CGIX_option=nodflt
CGIX_deferr=y
IBIS_output=grid
Flow_Name=dmhr_fl
CGIX_title=Log
IBIS_client=BINDOWS
CHARSET=UTF-8
}
COMMENT = Show Log
END

10. Now all you need to do is tie all these values to the end of the URL after the quotation mark using POST method like so,
11. http://localhost:8117/webconso...INDOWS&CHARSET=UTF-8
(Remember to substitute spaces with %20)