How NAV store Image,Media and MediaSet type data

(0) Share

Report

Posted on by Zaid Tariq

2,274

Hi,
I need some detailed info regarding how NAV store the following data type:
- Media/MediaSet

- Picture
The other question is: How and What is the best way to fetch image from existing Item/Customer?
Would be great if anyone share the blog post or something related.
Thanks

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (3)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

You can check following link

msdn.microsoft.com/.../mediaset-data-type

Was this reply helpful? Yes No
Suggested answer

CDsilva 4,188 on at

Like (0)

Report

Hi

BLOB data type is used to save images. you can refer company information table 79.

you can refer this link msdn.microsoft.com/.../dd301120.aspx

Was this reply helpful? Yes No
Verified answer

Rehan Satti 634 on at

Like (0)

Report

Hi I am also looking to fetch the Item image from existing Item. in a file or stream. So you can fetch image or file but from media datatype. not from Mediaset. Have a look at Item Table 27. There is picture field with 92 Field No. The data type is MediaSet. Media and MediaSet thess are two types which are recently introduced in Dynamics NAV. According to my R&D MediaSet is used to store multiple Media items. For example an image. If I want to store multiple images against an item. Microsoft added a filed of type MediaSet in Item table. Now you can insert multiple Media against this MediaSet.

So its kind of Group where you can insert multiple media items. as explained MSDN.

However currently Dynamics NAV allows you to store single image against an item.

According to MSDN article multiple (Images/ media) are inserted on the base of index against MediaSet.

Now issues is how to fetch media which is associated with MediaSet against an item?

The solution is you need to fetch media GUID against Mediaset on the base of index of media inserted against a MedisSet as using ITEM funcation

IF Item.GET('1900-S') THEN BEGIN
FOR Index := 1 TO Item.Picture.COUNT DO
mediaId := Item.Picture.ITEM(Index);
MESSAGE('Item retrived successfully[%1]',mediaId);
END;

But it did not returns GUID of media the result is as:

Was this reply helpful? Yes No
Verified answer

4BzSoftware 6,073 on at

Like (0)

Report

Hi Zaid Tariq,

I remember there are some blogs about news in NAV 2017, including Media and MediaSet Data Types. Hope below links are helpful for you:

community.dynamics.com/.../microsoft-dynamics-nav-2017-what-s-really-new

mohana-dynamicsnav.blogspot.com/.../changes-in-cal-behavior-of-nav2017-and.html

nav-magno.be/.../nav-2017-my-whats-new-overview

blogs.msdn.microsoft.com/.../working-with-mediaset-references-in-microsoft-dynamics-nav-2017

Was this reply helpful? Yes No
Verified answer

Zaid Tariq 2,274 on at

Like (0)

Report

Thank you everyone for your response. Actually what i was interested in how to fetch existing images from nav like in case of items it is stored in the form of MediaSet. If found nothing which can really help me to do this so finally i decided to export the MediaSet Item then then imported it to play with it. I am still looking for the best possible solutions.

Thanks

Was this reply helpful? Yes No