ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> T for Thumbnail
http://www.istechforum.com/YaBB.pl?num=1231179608

Message started by shadowcaster on 01/05/09 at 11:20:08

Title: T for Thumbnail
Post by shadowcaster on 01/05/09 at 11:20:08

Id like to start using thumbnails on workorders and other places

whats the best way to get started

what graphics format is best

what size shoild the thumbnail be ?

looks like i will need to generate 3-4000 of them from my cad system  I think I can automate the generation part

what is the best place to store them ??

TIA

John


Title: Re:  T for Thumbnail
Post by deburr on 01/07/09 at 10:27:47

Not sure what other types work, but JPG's do. Best size probably depends on the size of the window you display it in. I have expanded the display size on the RTM's (in the header section) to be about 2.5 inches square. By rearranging the RTM you could come up with any size you want, so you may want to play with that first. There are two available frames in the graphic traveler. I don't know if anyone has ever been able to get thumbnails to work in the routings section. I keep the thumbnails in the same mapped drive with a global path as my linked documents to keep things simple. It would be nice if there could be separate default paths between the thumbnails and links.


Title: Re:  T for Thumbnail
Post by PROBES on 04/10/09 at 09:46:22

Mr. Deburr,
  I can report that I have not been able to get thumbnails [or any graphics for that matter] to link within my routings. I really wish I could because my everything is so bland without photos. They say "A picture speaks a thousand words", and whoever "they" are that said that, are absolutely right.
  My goal is to get a routing setup with little or no words - mainly photos, complete with segregated sequences to more closely resemble an instruction book.
  Its so annoying to have to write, "Insert the wire with the red insulated end into connector position #5, which is the 5th one from the left if you are holding the unit with the large end facing up and the arrow pointing to the right." A photo embedded in the routing would be sooooo much simpler, plus, I can just take the photos as I go though and build my sample units.... 2 birds with one stone...
-Mike



Evo-Erp 9-27-07 update, build 11/08/07

Title: Re:  T for Thumbnail
Post by skyywalker on 04/10/09 at 15:15:19

That's a really good idea, Probes.  About 3 years ago I visited a company who had converted all their work instruction binders to marked up pictures with captions and it decreased their production mistakes across the board ESPECIALLY with new employees.  If it could be done in Evo with routings that would indeed be '...2 birds...'

Title: Re:  T for Thumbnail
Post by Lynn_Pantic on 04/10/09 at 17:07:11

It can but you need to enable Evo Links (which is an Evo only option that enables linking files to any data entity in the system including routing operations) in SD-Q System Manager rather than using Item Links which is available in both Classic and Evo but is limited to linking to part numbers.

Title: Re:  T for Thumbnail
Post by PROBES on 04/20/09 at 08:59:59

Thanks Lynn. FYI we just installed the 12/21/08 update over the weekend [I like the changes, too numerous to mention] and I took some time to try to get this functioning. We now have Evo Links enabled through SD-Q, and I entered a .jpg link using the Evo Links button through IN-B. It all seems very straightforward, however it seems to be lacking the area that explains exactly which routing sequence it should be linking too, unless I'm missing something. Using the old Item Links it would ask you which routing sequence to link [allthough it would never save for me], and I can't seem to find the equivalent using Evo-Links. I can verify the link path is correct because I get a preview, and oddly enough when I print using the default ENWOC3.RTM file it links the thumbnail at the top of the form, but doesn't actually embed it within the routing sequence. I'm soooooo close... :-? -Mike

Title: Re:  T for Thumbnail
Post by NovaZyg on 04/20/09 at 09:57:32

Thanks,

 You just found a loop hole I missed.  You can use Inventory Inquiry (IN-A) and click on routing to add the Link to that part and that routing,  That works great, or you can create a WO and then in IN-A drill to WO then Drill to Routings and add a link to that WO for that Routing seq..  BUT  Routing Links should copy when WO's are created, and I have not done that yet. I will...



Title: Re:  T for Thumbnail
Post by PROBES on 04/20/09 at 11:08:47

Hmmm... :-[
IMHO, logical places to enter image links for routings would be:

RO-A. - Select or enter a sequence #, have an entry somewhere along the standard flow that allows you to do a quick file name entry, checkbox for 'global link path', and 'T' or 'L', [thumb or link]. I write my routings in a very systematic way, trying to do a very detailed step-by-step instruction set and would make sense to me for the link entry to be here, so as I'm writing my initial master routing I can easily keep things in check and not lose my place instead of having to enter all the instructions, then go back to a separate data entry sheet to link all my files. On that note, I write all my sequences in intervals of 10, and would appreciate if I happen to rename sequence 30 to sequence 40 that the link intelligently follow along...

WO-A. Why? - In the event you have to make a one time change to a routing that has already been converted to 'F'. Similar to the interface of WO-K-A.. wait, scratch that, WO-K-A is horrible.. but you get my drift. It might also be prudent to have it block change requests to 'R' work orders since they should already be 'Live and in production".

IN-A. Why? - It's probably the default starting place for most folks when they are looking for general information. At the least this could be a link to the same screen used in one of the above suggestions of not a separate entry form.

Oh, and BTW, while I understand what you suggested in your last post, it is still not properly printing on the default ENWOC3.RTM. Using IN-A to drill to the routing seems to be on the right path because it informs me I'm editing the link for P35-1206  -  40 [item # and sequence #]. At this stage my preview also displays correct. I'm linking a jpg file, its tagged as 'traveler', 'thumbnail' and 'parent'. Its also set up using our global path. >:(

Oh, and on a possibly unrelated note, since the update to 12/21/08, none of my .pdf files link with the travelers when they print. I have to manually open the link through IN-A and print.  :'( This seems like some simple problem I've overlooked which is adding to my frustration. Happy Monday!  ;D And as always, I appreciate the help and input of my fellow forum users. We are such a diverse crowd with many backgrounds and specialties whom all seek a unified solution to our database problems.
-Mike

Title: Re:  T for Thumbnail
Post by NovaZyg on 04/20/09 at 12:43:32

The reason I suggested IN-A to get to the routing is that there is no T7ROA at this time. and Only the T7 programs can get to the Links. We are working on doing more and more T7 stuff, and perfecting the ones we already have, but it is a long slow process.


Title: Re:  T for Thumbnail
Post by NovaZyg on 04/20/09 at 16:04:17

I just looked at the RTM for WOC and "T"unmbnail is not an option in routings. It only woks for The Parent WO, or the BOM components.

I did just however, add the ability to print them as Links. Thumbs would be something custom.

Title: Re:  T for Thumbnail
Post by shadowcaster on 05/06/13 at 14:27:43

Are we there yet ?

I have generated my thumbnails   ended up with 4700 + PNG images.

found a program to auto crop the images  XnView   (did all 4700 in about 3 Minuets.)

linked them to the part numbers.

And I have them printing on the work order.

I'd like to use them now to do more.

Is there a list of forms that have image links ?

I'd really like a graphical pick slip with images for each item that I could use when I have new people doing the picking.

A catalog would also be nice.

is this something I could do with Access or some ODBC program ?


Title: Re:  T for Thumbnail
Post by David Waldmann on 05/10/13 at 10:06:12


shadowcaster wrote:
Is there a list of forms that have image links ?

I don't know if there is a list, but as far as I know, Quotes, Acks, Pick Tickets, Packing Slips, Invoices, Travelers and POs all do.


shadowcaster wrote:
I'd really like a graphical pick slip with images for each item that I could use when I have new people doing the picking.

No problem. They are there (make sure you have the latest RTM (copy from RTX).


shadowcaster wrote:
A catalog would also be nice.
is this something I could do with Access or some ODBC program ?


If you are on the latest Update (April 2013) Links and Notes are now accessible by ODBC so Access, Excel, Crystal et al can be used.

Title: Re:  T for Thumbnail
Post by shadowcaster on 06/04/13 at 07:38:29

I did not have the latest pickslip RTX  so that was an issue.
so if yours dont print get the new RTX/RTM



Title: Re:  T for Thumbnail
Post by shadowcaster on 07/07/13 at 08:08:40

I just finished maxing out my thumbnails.

I now have a thumbnail for every item, there are about 5,000 real thumbs and 15,000 that all point to a generic no image thumbnail. (camera with a No symbol over it)
This makes it so much easier to add a thumb to an existing item as each one has all the settings I only need to update the file name the link points to.

Also the reports all print with the same vertical spacing because it always prints a thumb for every item.

Title: Re:  T for Thumbnail
Post by shadowcaster on 08/14/13 at 09:05:01

Thumbnail update.
I now have over 7000 thumbs !

Some are generic   like steel flat,  steel round, steel tube, and the no photo icon
and are used on hundreds/thousands of items (thanks wintask for doing the updates)
the rest I either made from CAD or coped from the web.

size matters

Batch mode Xnview is a great for processing your thumbnails from cropping to sizing and more.

And its free

Just re-sized all my thumbs and I'm getting much better printing with way less black boxes.
took about 1/2 hr to resize all 7000 images.

looks like a 300 pixel width or height is a safer number. Wish I knew what was ideal.

If you get black boxes don't just look at the ones that are black look at the one printed before the black box.  I found that sometimes a large one would print but mess up the following thumbs even if they are small.

Already caught a few bom errors because the thumbs stick out like sore thumbs when you have a wrong item on a bom !

Everyone in the shop is loving the new pick slips and WO boms with the added visual information.

Quotes look great as well as acknowledgements and po's.

Still have some items that need thumbs but already seeing fantastic results.

Title: Re:  T for Thumbnail
Post by David Waldmann on 08/14/13 at 09:15:21

Congrats. I've thought about putting thumbs on Sales related docs but am just not sure I want to do that. We already have the images (we generally only print them on Travelers) so it would just be a matter of updating the links and modifying the forms. A relatively simple task.

Title: Re:  T for Thumbnail
Post by shadowcaster on 08/16/13 at 13:03:01

Spice up your life.

Photos on everything !

Title: Re:  T for Thumbnail
Post by shadowcaster on 11/18/13 at 10:25:58

Now if we could just have thumbnails come up on the screens as part of the normal operation w/o having to click the icon.

IN-A,  IN-B,  Bom editing maybe. Or is that available with the T7 screens already ?


Title: Re:  T for Thumbnail
Post by shadowcaster on 11/22/13 at 22:12:02

Seems like the new JAVA BOM edit and BOM availability and screens would be a nice place to add thumbnails on screen.


Title: Re:  T for Thumbnail
Post by Lynn_Pantic on 11/24/13 at 10:15:46

BOM Availability has it.  Links are listed on the lower left and a double click opens it.

Title: Re:  T for Thumbnail
Post by shadowcaster on 11/24/13 at 22:04:01

I was thinking more of an automatic on screen display of the thumbnails in EVO.

Title: Re:  T for Thumbnail
Post by PROBES on 12/02/13 at 09:24:35

Shadowcaster - any chance you can print an example of one of your WO Boms / travelers with the thumbnails / photos linked and post for us to see? I've abandoned creating travelers with EVO and just started using CAD software to implement my photo routings, however I'd much rather have everything tied together in the database instead of using 2 separate data sources.

Thanks, Mike

Title: Re:  T for Thumbnail
Post by shadowcaster on 12/02/13 at 11:54:11

Sure I can do that.

Ill make up a PDF or 2

Title: Re:  T for Thumbnail
Post by shadowcaster on 12/02/13 at 13:18:19

Here are some working examples of DBA shop documents and orders
with thumbnails turned on

http://www.waddingtonelectronics.com/DBA/default.html

everyone's situation is different but this works for me

the print book example is what we send to the shop for CNC work.
If someone needs a large format drawing (Electrical or assembly) I do those manually or the guy that needs them can print them when he needs it in some cases.
99 % dont need that in my case. Some of the guys will print the word doc page they need as a large format D or E and the prints come out fine so I dont have to get involved.

I do a copylink from autocad for the manufacturing drawings and paste them into a word document as vector files not bit maps.

I like word as a container because you can stick just about any kind of data in it and the cad files print cleanly from there.

The word files are linked to print with Travelers and sometimes with a PO or RFQ if it needs a drawing to go with the order.

I turned off thumbs for components on travelers because we had them on the pick lists and it was redundant but we still use them on the header/parent item.

Title: Re:  T for Thumbnail
Post by PROBES on 12/05/13 at 15:00:10

They look nice, thanks for the information.
We never tried using the pick lists since our BOM component lists are generally under 8 components and most items are not packed loose, however I see how having a small snapshot of the items would be beneficial for the pickers assembling the BOM kits.
We tried linking some thumbs to our BOMs but I was never happy with the results.

What I do now is make instruction sheets in CAD that allow me to quickly insert text and large photos to make a booklet that accompanies the shop traveler. Generally they are around 10 pages long and try to keep the text brief and the photos to a minimum.
"K.I.S.S." is always in my mind.

What I would like to see is a way for us to link photos of any size directly to the routing sequences on a shop traveler, so we can not only explain what needs to be performed but have large graphic examples available as well. In a manufacturing environment like ours it would be very helpful. Maybe their is a way to do it and I'm just unfamiliar with the coding required?

Essentially I'd like a Shop Traveler Routing format like:
Operation #1 [Title]
Text of what to do + other pertinent information
Photo(s) of what to perform

Operation #2 [Title]
Text of what to do + other pertinent information
Photo(s) of what to perform

Operation #3 [Title]
Text of what to do + other pertinent information
Photo(s) of what to perform

Printer ink is cheap - production mistakes are not :)
Here is a couple of photos of a current shop traveler along with one of the pages we use for assembly.
It's not shown, but sequence #80 is for the testing and matches page 8. My employees know #10 = 1, #20 = 2, etc...
-Mike

http://i.imgur.com/uL1ssGW.jpg
http://i.imgur.com/sZQqUUc.jpg


Title: Re:  T for Thumbnail
Post by shadowcaster on 12/07/13 at 14:58:45

Are you using evo links.

I dont have that on.

I may have had it on before so I'm wondering if I turn it on again will it duplicate all my links ?


Title: Re:  T for Thumbnail
Post by shadowcaster on 01/17/14 at 08:06:09

so who wants this or something like it ?


http://www.waddingtonelectronics.com/DBA/dba_screen.png

Title: Re:  T for Thumbnail
Post by shadowcaster on 03/03/14 at 12:49:14

Had a little milestone today.

Printed an exploded 3 level BOM with thumbs to a 144 page PDF  

0.0 black boxes    ;D

Make sure your thumbs don't exceed 300 in either direction and they will work.


ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.