Hi Gerard,
I have detailed two methods. The second might be the easiest. Method 1. Invoke DP with the /EOI switch and pipe its output to the Windows Clipboard clip.exe The /EI switch is used as the magic switch to web enable DP. The /EI switch causes the specified transaction log to be executed.. The transaction log can contain various processing instructions including running a report. The interesting this with this is that when using the /EI switch the output of a report which would normally go to the screen now goes to STDOUT (this requires DP 2.6Y) , which then means it is available to any program that can use data from STDIN, eg piped into CLIP.EXE Here is an example: <<<<<TLOG.TXT<<<<<<<< #R: =2= <<<<<<<<<<<<>>>>>>>>> Now the command line: DP.EXE MYAPP.STR /EI-TLOG.TXT | CLIP.EXE Would run the the first DP report (the TLOG #R: command uses the Built-In Short report as 1, and the first user report is number 2, ) If this report is a Screen report then it will be output to STDOUT The Pipe symbol "|" causes the STDOUT from a command to be redirected to the next command, ie CLIP.EXE DP exits. Clip.exe places the reports content into the Windows Clipboard You cannot directly input parameters into the report as with the /EI switch there is no interaction with the user. If you need to have report parameters, which you would normally enter by the keyboard than you need to bring that in via a reports parameter panel, and then provide the data in the T-Log, the report then needs to look at the reports parameter table. Alternatively if you are running DP interactively and you could create a report which loads the parameters into a panel, selects the report you want to run creates a T-Log,. You would run the report, exit DP, then use a batch file to run DP with the T-LOG, and then re-enter DP in the normal mode eg <<<< START.BAT >>>>>> @echo off :NORMAL dp.exe myapp.str REM if the file tlog.txt exists then use it to start an /EI invocation of DP, if not then user just wants to exit IF EXISTS tlog.txt GOTO EISTART GOTO END :EISTART dp.exe myapp.str /ei-log.txt REM Get rid of the temporary T-log so it doesn't get repeated DEL tlog.txt REM Re-enter DP normally GOTO NORMAL :END <<<<<<<<<>>>>>>>>>>>> METHOD 2 Poll an output folder for a specific file and then send it to CLIP.EXE You could use ><<<<<<< POLL.BAT<<<>><<<>< @echo off ECHO Polling for DPREPORT.TXT to send to Windows Clipboard... ECHO CTRL-C to terminate :Start IF EXIST dpreport.txt GOTO ClipIt SLEEP 10 GOTO Start :ClipIt CLIP.EXE < dpreport.txt Echo Report copied to clipboard.. SLEEP 10 DEL dpreport.txt GOTO Start <<<<<<<<<<<<<>>>>>>>>>>>>>>>>> I am not sure if the SLEEP command is a standard External program in Windows, or whether I have added it. You can get it from Microsoft as part of the Server 2003 Resource Kit http://www.microsoft.com/downloads/details.aspx?FamilyID=9d467a69-57ff-4ae7- 96ee-b18c4790cffd <http://www.microsoft.com/downloads/details.aspx?FamilyID=9d467a69-57ff-4ae7 -96ee-b18c4790cffd&DisplayLang=en> &DisplayLang=en You would need to run this batch file from the folder where your DP reports are being output, you might want to create a special temp folder for this purpose. Run the POLL.BAT and minimise it, until you need to stop it, by either closing the command window or CTRL-C to temrminate it I hope this helps Regards Brian _____ From: [email protected] [mailto:[email protected]] On Behalf Of Gerard van Loenhout Sent: Thursday, 10 June 2010 5:47 PM To: [email protected] Subject: Re: [Dataperf] Export to Windows clipboard Michael, that's still not an export to the clipboard... Gerard 2010/6/9 Michael Iannantuoni <[email protected]> Hi Gerard, The only thing that occurs to (others may know other/better ways of doing this) would be to use DPSpool and output the report to a pdf "printer" - Adobe Acrobat if you have it or a freeby like pdf999. The simply attach the pdf file to your email. Michael On 09/06/2010 15:30, Gerard van Loenhout wrote: Michael (and Brian), I know that one. I use it a lot, but I want to paste a whole report into a Windows application. I make several quotations per day in a (small) DP panel. I just fill in a couple of fields with specific data. The main part of my quotations is standard (appr. two pages if printed) and rolls out in a report, mixed with the new data from the panel. This report I woud like to paste by control+v in my email. Now I have to go to the exported text file and select all text first. It would be a lot handier if the export of the report is on the Windows clipboard. So, how would I do this directly from DP with clip.exe for instance? G 2010/6/9 Michael Iannantuoni <[email protected]> Hi Gerard, If you are running Tame, you can copy a selection to the Windows clipboard and also paste into a field from it. Michael Iannantuoni On 09/06/2010 09:35, Gerard van Loenhout wrote: Hello all, I posted a request about export to the Windows clipboard about a year ago and since no one really reacted I guess I'm the only one who wants to use this. Still, if ever there is going to be a new DP version, I would love this feature in it. Instead of sending a report to a printer, a file or the shell (DOS) clipboard I woul like to send a report to the Windows clipboard. Here's a link about the subject: http://www.frontiernet.net/~fys/clipbrd.htm <http://www.frontiernet.net/%7Efys/clipbrd.htm> Regards Gerard van Loenhout _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
