How do you save blobs (Employee pictures) to a package or similar?

Business Central/NAV User Forum
1

NAV 2013 R2

The database will be remigrated to, but I want to be able to put back the employees pictures from the current NAV Company.

How do I save blob fields?

Cheers

Dave K

2

You need to export BLOB field using XMLPort and Import…

3

Thanks, but I get * in the xml instead of data.

Is there a trick to this (do I need to do some stuff in a code unit rather than just running the xml port from the object designer)?

Thanks

Dave K

4

We use the export function from a report.

like this:

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

http://msdn.microsoft.com/en-us/library/dd338648.aspx

5

& obviously the Import function to bring then into NAV

http://msdn.microsoft.com/en-us/library/dd354940.aspx