Importing Item Images for Navision 3.7

A._B._Computer_Systems

We have a customer who will require to import images for some items. The BMP images are very big. We see in the downloads a tool called IFacto ImageVision v2 but it's for NAV 4.0.

Also, any downloads available for 3.7 to store these images in a separate directory and not in the Navision DB?

Regards,
Ed

nunomaia

You can insert in Item table a field where image file is located and very time you open item picture card, it will load image from file instead of blob field.

Savatage

We have all our pictures saved in a seperate NETWORK drive we labeled it P:\BMP for pictures and each pic is the same as the item #.

When you go into an item if the pic exists it pop's it up for viewing (happens instantly - don't even notice it)

Form 346 (Item Picture)

OnAfterGetRecord()
SETRANGE("No.");
IF EXISTS ('P:\BMP\'+"No."+'.BMP')
THEN
Picture.IMPORT('P:\BMP\'+"No."+'.BMP',FALSE);
CALCFIELDS(Picture);

The thing I did notice is that if you are in a picture and a small change is made to that item the picture IS SAVED in the blob. so to get around this I added to the item Table

OnModify()
CLEAR(Picture);

& on the OnValidate too just to be sure it never actually gets saved into the database.