Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Jeane Meade]

Hi All,

We are looking to link images with our item cards so we can use them on the Assembly Order report.  Is there a required image format – .jpg, .bmp or .png? 

What are the consequences to our NAV 2015 database size?  The images are stored on our data server right now

I found a link on creating a report to do a mass update, but our image names do not exactly match the product names at this time.  We have spaces in our item names – B1 S, but the image name uses an underscore in place of the space –  B1_S.  Currently all the images are in a high-res .tif format, so I believe we would need to convert them first anyway and can rename at that time.

Thanks for the help.

——————————
Jeane Meade
IT/DBM
Sheldons’, Inc.
Antigo WI
——————————

[Ian Ray]

Pictures are inserted into the “picture” column of the item table (Item.Picture). I use jpegs and they are stored as BLOB at the same size they were when uploaded. The default behavior is to store them compressed in Table 27 Item – 92 Picture. This can be changed to uncompressed without any sort of solution provider license or anything as it is just changing one variable. Uncompressed would potentially make rendering very slow on the client when the picture is loaded. Compressed is fairly fast, most images I have stored are ~200k.

——————————
Ian Ray
Cypress Grove
http://www.cypressgrovecheese.com
Arcata CA
————————————————————————-

[Jeane Meade]

Thank you Ian, that is the info I was looking for.

——————————
Jeane Meade
IT/DBM
Sheldons’, Inc.
Antigo WI
————————————————————————-

[Franz Kalchmair]

pictures are saved in a blob field in the database. 

for performance purposes best you convert the images first to jpg format, then import them to the database, set property Compressed to yes.

——————————
Franz Kalchmair
Dynamics NAV Engineer and Consultant
Microsoft MVP
Vienna
————————————————————————-