Importing 1000 Pictures in Item table

Business Central/NAV Developers Forum
1

Hello Everyone,

I want to import 1000 of images in item table in Picture fields.The items are named same as item no. and saved in the same folder.For this i require a Process only report.

2

Welcome to DUG [:)]

You can try these suggestions
http://www.mibuso.com/forum/viewtopic.php?f=23&t=15070
http://dynamicsuser.net/forums/p/32976/173139.aspx

3

If you are going to create a processing report - it will behooooove you to make it flexible.

Just because you want to import today - doesn;t mean you will not need the ability to Export or Delete these images also.

You can beef up the report to include all 3 options.

Something like this:

Variables for Request Form
ImportItem = boolean
ExportItem = boolean
DeleteItem = boolean

OnAfterGetRecord()
InvtSetup.GET;
Item.CALCFIELDS(Picture);
IF ImportItem THEN ImportItemPicture;
IF ExportItem THEN ExportItemPicture;
IF DeleteItem THEN DeleteItemPicture;

ExportItemPicture()
IF Item.Picture.HASVALUE
THEN Item.Picture.EXPORT(‘c:\temp’+Item.“No.”+’.BMP’,FALSE);

DeleteItemPicture()
IF Item.Picture.HASVALUE THEN BEGIN
CLEAR(Item.Picture);
Item.MODIFY;
END;

ImportItemPicture()
CLEAR(Item.Picture);
IF EXISTS (InvtSetup.“Item BMP Path”+Item.“No.”+’.BMP’) THEN BEGIN
Item.Picture.IMPORT(InvtSetup.“Item BMP Path”+Item.“No.”+’.BMP’,FALSE);
Item.MODIFY;
END;

4

I had already tried this but it is not working for NAV 2013.The import func is obselete in NAV 2013.