Picture in item card

seyhock

Dear all,

We are thinking of putting picture in item card.

But some said it is not a good idea because of space/memory problems.

Wonder anyone of you encounter any issue?

I also notice that picture function only accept bmp file, how can I change it to jpg file with smaller file size.

Thx.

Dave_Cintron

To figure out how much space it will take, just do the math. If you have a 30KB .bmp file, and you store 10,000 of them, this is only 300MB of space, not too much in today's measures.

Navision will store any picture, but will only display .bmps, and it will not support any visual OCX control. If you want to display a .jpg you would have to go to unusual measures, like exporting the image and invoking a screen through a command prompt. At least that's the battle I've had to fight.

kine

There is one performance problem - each BLOB field on SQL option leads to extra call which calculate size of the blob, and this is performance problem mainly on lists. It means that when you do List on Items, for each line the size will be calculated, and this is VERY time consuming operation...

garak

Kine's right. So, take a look to that post an my answers.
There you can also see the sql statement.

http://www.mibuso.com/forum/viewtopic.p ... light=blob

Regards

Savatage

you caould also put a link to the pic or if they are in another directory you can call for the pic onafterget record to show without savfing it in nav.

http://www.mibuso.com/forum/viewtopic.php?t=23593

in the dowload section there are jpg viewers
http://www.mibuso.com/forum/viewtopic.php?t=3430
http://www.mibuso.com/forum/viewtopic.php?t=10844

KYDutchie

Hi

If you really want to store your pictures in the database, I would suggest create a new table, for example: Item Picture, and give it the same key as the item table ("No.") and only store the pictures in that new table.
Then only read this table when you need the picture displayed.
Also, put a delete statement in the OnDelete trigger of the Item table to delete the corresponding record in this new table, this to ensure that the picture gets deleted when you delete the item. This method will not impact performance as bad.

Regards,

Willy

senna

I would like to find out exactly what the correct bitmap sizing should be if you have a picture attached to an item in Navision. I have an issue at the moment where the picture needs downsizing quite significantly to show a true reflection of the image (that is unless you maximise the image) has any got any specific knowledge on this?

thanks in advance

Savatage

http://www.mibuso.com/dlinfo.asp?FileID=91

also scroll down the page for more related downloads

Dave_Cintron

The bottom line is Navision displays the bitmap the same as HTML, at 72dpi. That's your size guideline.

senna

thanks for the replies - the bitmap software works a treat and i think the best approach is to use an add on to re-format the pictures.