Dynamics Community Forum Thread Details

Export pictures from Microsoft Dynamics NAV 2009

hi,

I know that does not solve the problem but I'll give you some links and examples

BLOB Fields

If you are using NAV BLOB Fields; by default the Compressed property is <Yes>, which means the value is zipped and not usable externally; Change this property to No and the value will be the binary of a normal bitmap format (provided that is whats stored there) which you can extract and display externally.

Some samples & links

NAV export samples:

//EXPORT

// export blobs as bmp files

CALCFIELDS(Picture);

IF Picture.HASVALUE THEN BEGIN

PictureFileName := FormatFileName(FilePath,Item."No.");

Picture.EXPORT(PictureFileName,FALSE);

END;

//STREAM

tem.GET('1000');

item.CALCFIELDS(Picture);

IF item.Picture.HASVALUE THEN

BEGIN

Item.PICTURE.CREATEINSTREAM(InStrm);

DOWNLOADINTOSTREAM(InStrm, 'Save image', 'E:\', '*.bmp', '');

END;

Form 346 ...

IF Picture.HASVALUE THEN

Picture.EXPORT('*.BMP',TRUE);

CODE\ENCODE64

Use Encode\Decode 64 functions to convert a BLOB to Base64

ex: Codeunit 99008516 - BizTalk XML DOM Management

Function 'GetPicture' converts a Base64 encoded DOM node to binary and imports it into a BLOB.

Function 'AddPicture' converts a BLOB to Base64 encoding and adds it to an XML doc...

You can use Encode\Decode 64 functions on sql server stored procedures, views, sql scripts

Basically, a BLOB field in NAV contains a byte-array, so the challenge is how to read or write this byte-array and use it in the conversion methods. In .Net we can use Stream objects to work with byte-arrays.

.NET Base64 encoding\decoding

To convert a Base64 string to binary data, we can use the "Convert.FromBase64String" method. It accepts a string as input parameter and returns a converted byte-array.

To convert binary data to a Base64 string, we can use the "Convert.ToBase64String" method. It accepts a byte-array and returns a Base64 encoded string.

To exchange binary data in a web service, it is common use to convert the binary data to Base64 encoding. The .Net Framework has built-in support for Base64 converting with the System.Convert class.

Good link this:

www.kauffmann.nl/.../binary-data-with-nav-web-service

How to import and export BLOB fields using Dataports in Navision

support.microsoft.com/.../874348

Quick Links

Leaderboard