NAV 2018 - Picture File

(0) Share

Report

Posted on by Brian Branco

Can anyone tell me which table contains the info for pictures?

Someone mentioned that this table will contain the path to the image folder and the image wont be imported into the system.

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

Andrey Baludin 3,941 on at

Like (0)

Report

RE: NAV 2018 - Picture File

Hi!

They stored in 2000000184 Tenant Media table ("Content" BLOB field).

For Example how to get Item picture:

TenantMedia.GET(Item.Picture.Item(1)); // <- Get TenantMedia of 1st Item picture ID

TenantMedia.Calcfields(Content);

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,237 Super User 2025 Season 2 on at

Like (0)

Report

RE: NAV 2018 - Picture File

Which pictures are you referring ? are your referring to the Links where you can attach ? or Item or customer ?

Was this reply helpful? Yes No
Brian Branco 65 on at

Like (0)

Report

RE: NAV 2018 - Picture File

Items...

Basically I am trying to see if the table has the folder path and file name in fields that I can see in SQL.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,237 Super User 2025 Season 2 on at

Like (0)

Report

RE: NAV 2018 - Picture File

It is uses media type to store picture and where it stores please check this

docs.microsoft.com/.../working-with-media-on-records

docs.microsoft.com/.../media-data-type

Was this reply helpful? Yes No
Suggested answer

CDsilva 4,188 on at

Like (0)

Report

RE: NAV 2018 - Picture File

Hi,

you can refer community.dynamics.com/.../145963

community.dynamics.com/.../257070

Was this reply helpful? Yes No
Brian Branco 65 on at

Like (0)

Report

RE: NAV 2018 - Picture File

Thanks for your answer...

Forgive me, I am not a Navision programmer, I am implementing a system with a NAV developer/dealer.

They mentioned either importing a pic into a BLOB or linking to the image.

Is there a way to link to an image and not import it? I am looking for a drive/path/file name instead of in that table.

Was this reply helpful? Yes No
Suggested answer

CDsilva 4,188 on at

Like (0)

Report

RE: NAV 2018 - Picture File

You can link an image using the Link factbox

Refer this document docs.microsoft.com/.../hh879051(v=nav.70)

Was this reply helpful? Yes No
Suggested answer

Andrey Baludin 3,941 on at

Like (0)

Report

RE: NAV 2018 - Picture File

But why you don't use standard functionality?

Just open an Item card and you'll find picture factbox on the right side. Press import and you'll even see the image thumbnail.

Was this reply helpful? Yes No
Brian Branco 65 on at

Like (0)

Report

RE: NAV 2018 - Picture File

I need to know the path and file location for the image file. Its for exporting data for an existing web site.

The ERP system is being upgraded so I need to match the current file layout for the web site.

Was this reply helpful? Yes No
Suggested answer

Andrey Baludin 3,941 on at

Like (0)

Report

RE: NAV 2018 - Picture File

I wrote a post how to pass Item pictures via web service from NAV2018 to external systems. You can discuss this possibility with your developers.

community.dynamics.com/.../how-to-get-picture-from-mediaset-through-standard-apis

Was this reply helpful? Yes No