How to perform a mass import of all your new products Item Pictures using Dynamics NAV 2013 R2

How to perform a mass import of all your new products Item Pictures using Dynamics NAV 2013 R2

IF THIS POST IS USEFUL AND HELPED YOU KINDLY LIKE AND SHARE THIS PAGE SO OTHERS CAN FIND IT, THANK YOU. NOTE: Click on image for a clearer view.

Ever wondered how to perform a mass import of all your new products Item Pictures using Dynamics NAV 2013 R2?It’s really quite once you know how ;). It took me a while but I got their eventually. Firstly you will need a new Report, I called mine “Import Item Pictures” with a dataitem pointing to Table 27 “Item”:

These are the local variables for the dataitem:

The code will first try find the picture using the file name which should match the Item No. So if your Item No is LS-150 the file name must be “LS-150.jpg”. I created a directory under “C:\Pictures\” and stored all my Item Pictures in there. The picture is translated into a BLOB using the File Management Codeunit. Then the temporary file is deleted and the Item Table modified.

And when you open your Item Card it will now have a picture. Voila!


Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: