Shop Order printing (jobs) with drawings attached

Yahoo Archive
1
We are printing drawings from crystal reports using TIF files created from Solidworks. The report is a re written Job traveller using only ODBC, this gives flexibility when printing specific ranges or selections of numbers.

The image is printed on the back of the page on every job, as 99% of our job cards are 1 page long this works very well.

I have created an OLE object in the First Group footer and in the formula for the graphic location it reads
IF ISNULL({@TifLocation}) THEN "\\SERVERNAME\EPICOR\CRDROTATED\NOPIC.TIF" ELSE {@TifLocation}

The {@tiflocation} reads
replace({XFileRef.XFileName},"crd","crdrotated")

We have 2 folders crd and crdrotated the images are saved in landscape and a program runs every day that copies new drawings and rotates them to portrait into a new folder, the revision attachemnt points at the inital landscape folder for easy screen viewing.

The NOPIC.TIF is an empty tif file that prints a blank page for any part that doesn't have a drawing attachment against the part revision

If there is an attachment but no physical file on the server crystal still prints a blank second page so job cards do not get mixed up for double sided printing.

We then print all the job cards through APM to different printers depending on their destination.

Its not perfect but works extremely well.

Mark
Teagle Machinery Ltd


--- In vantage@yahoogroups.com, "Paul Millsaps" wrote:
>
> We are re-visiting the issue of printing our shop jobs and automatically attaching the autocad drawing to each shop order. We know Crystal Reports will definitely not embed DWG files, but are looking at either PDF files or JPG files. Has anyone done this, or researched it? It appears a couple of years ago at least that PDF files will not work either, but I was hoping someone else found a better solution.
>
2
We are re-visiting the issue of printing our shop jobs and automatically attaching the autocad drawing to each shop order. We know Crystal Reports will definitely not embed DWG files, but are looking at either PDF files or JPG files. Has anyone done this, or researched it? It appears a couple of years ago at least that PDF files will not work either, but I was hoping someone else found a better solution.
3
Doing it through crystal reports will be a giant pain.

You can create dynamic image location placeholders in the report, but as of yet I can't seem to find a way to suppress the placeholder if no image exists.

If you do want to do that, you just insert the image (I'd recommend creating a super small one since its going to show if your dynamic link doesn't exist), then open Format Graphic and use a formula for the image location pointing to a UNC path.

It will look like:

"\\Server\Shared Files\Traveler Attachments\Images\" + {JobAsmbl.PartNum} + ".png"

You'll have to hard code each image to be a unique name. I've kicked around the idea of creating a user defined table and filling it with the part numbers and a number for the number of images available for that part. Then conditionally suppress any that are less than the user defined table field but have never gotten around to trying.

Also looking at trying to use APM/APM+ module to attach relevant prints/pictures when a traveler is printed.

--- In vantage@yahoogroups.com, "Paul Millsaps" wrote:
>
> We are re-visiting the issue of printing our shop jobs and automatically attaching the autocad drawing to each shop order. We know Crystal Reports will definitely not embed DWG files, but are looking at either PDF files or JPG files. Has anyone done this, or researched it? It appears a couple of years ago at least that PDF files will not work either, but I was hoping someone else found a better solution.
>
4
We use a software called planet press watch to do this

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of justincalbraze
Sent: Monday, January 07, 2013 12:59 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Shop Order printing (jobs) with drawings attached



Doing it through crystal reports will be a giant pain.

You can create dynamic image location placeholders in the report, but as of yet I can't seem to find a way to suppress the placeholder if no image exists.

If you do want to do that, you just insert the image (I'd recommend creating a super small one since its going to show if your dynamic link doesn't exist), then open Format Graphic and use a formula for the image location pointing to a UNC path.

It will look like:

"\\Server\Shared Files\Traveler Attachments\Images\" + {JobAsmbl.PartNum} + ".png"

You'll have to hard code each image to be a unique name. I've kicked around the idea of creating a user defined table and filling it with the part numbers and a number for the number of images available for that part. Then conditionally suppress any that are less than the user defined table field but have never gotten around to trying.

Also looking at trying to use APM/APM+ module to attach relevant prints/pictures when a traveler is printed.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Paul Millsaps" wrote:
>
> We are re-visiting the issue of printing our shop jobs and automatically attaching the autocad drawing to each shop order. We know Crystal Reports will definitely not embed DWG files, but are looking at either PDF files or JPG files. Has anyone done this, or researched it? It appears a couple of years ago at least that PDF files will not work either, but I was hoping someone else found a better solution.
>



[Non-text portions of this message have been removed]