Export job image as jpg unattended

mickboland · Post by **mickboland** » Wed Sep 21, 2005 6:16 am

I use the cmd:

dsdesign.exe /H=%Host% /U=%User% /P=%Password% /SaveAsBmp=%BackupDir%\%DsxDate%\%%.bmp %Project%

to export the job image to a jpg. This issue i have is that it is interactive ie: dialogs pop up it a warning occurs etc..

Is ther any way to export the image of a job unattended?

chulett · Post by **chulett** » Wed Sep 21, 2005 7:15 am

Kim Duke has put together a bat file that does basically that. You'll find it here on his website, under the 'Scripts' section.

mickboland · Post by **mickboland** » Wed Sep 21, 2005 5:23 pm

he uses the same cmd - but it is not unattended the function returns message boxes

chulett · Post by **chulett** » Wed Sep 21, 2005 5:31 pm

Not sure what you mean - it executes as a batch and I've used it to dump jpegs of all jobs in a project... all unattended.

Some commands recognize the fact they are running under batch control and disable or default the user prompts that you would get running the same command from the command line. Assuming that is what's going on in this case.

aartlett · Post by **aartlett** » Wed Sep 21, 2005 5:32 pm

I thought that'd save as a bmp not jpeg? I use a bmp2jpg program to convert to jpg and then sed the html from Kim's utilities converting bmp to jpg (and add a few other goodies).

We now store all our doco in the jobs and an annotation file that is shown in the HTML.

I've never had any popups from the command though.

chulett · Post by **chulett** » Wed Sep 21, 2005 5:33 pm

Yes, true... bitmap image.

aartlett · Post by **aartlett** » Wed Sep 21, 2005 6:03 pm

I posted the method I used to run Ken's HTML in response to a poll on doco importance (http://dsxchange.com/viewtopic.php?t=88876)

This shows how to do the BMP JPEG stuff and all. Much less space used.

kduke · Post by **kduke** » Wed Sep 21, 2005 7:10 pm

The name is Kim not Ken. It should work unattended. SaveAsBmp.bat is the batch file.

The line from this batch file is:

Code: Select all

%Designer% /H=%Host% /U=%User% /P=%Password% /SaveAsBmp=%BackupDir%%DsxDate%\%%i.bmp %Project% %%i

Where %%i is the job name. This uses dsjob.exe to get a list of jobs to feed this line.

I have had a lot of problems with this lately. This hangs when done from Visual Basic. I also get an error when using the dsjob.exe from 7.5 versus 7.5.1A. Weird stuff.

The above command would cause problems in Ds7.1 as well. You had to hit return about every other job. Still runs fairly fast.

I also posted a similar batch file to generate the HTML from Designer. It should do a whole project as well. I like Tony Curcio's HTML much better. It has more and better information. I think the one in my product DwNav is better still. It has row counts and few more things like usage analysis reports.

aartlett · Post by **aartlett** » Wed Sep 21, 2005 7:23 pm

kduke wrote:The name is Kim not Ken.

Sorry Kim. Can I get away woth blaming key shift or inattention on the keyboard?

We are using the utilities in a 7.1 environment without any hassles. The only change I had to make was to drop the DSJOB from the bat script as we don't have it (we use UNIX) and create the list of jobs to extract on the UNIX box and export them down.

I wonder if that's why we aren't getting the same issues with stops?

kduke · Post by **kduke** » Wed Sep 21, 2005 11:21 pm

The stops are in the Designer. By that point dsjob is done. Others have had that problem. It maybe XP. You can get the dsjob.exe off the CD.