import pictures NAV2017 by sql

kanika

Hi experts!! NAV2017

I imported the item pictures by sql from other base with NAV2017 too

I see, in sql, this fields haves information but i don´t see anything in NAV Client and I don't know wy??

thanks for the attention

Juhl

I wouldnt do i by SQL, as Media tables contains other pictures not related to items. And Items is actually using MediaSet, and not Media, so the reference in Picture fields is referencing a MediaSet, that again multiple Media's. So an Item can actually have multiple pictures in 2017.

I would proberbly export all pictures to filsystem and import again.
https://docs.microsoft.com/en-us/dynamics-nav/importfile-function--mediaset-

Juhl

The field only have and GUID reference to the media table.
No pictures in standard Item table anymore.

kanika

Then... how I can yo do it?

Juhl

I wouldnt do i by SQL, as Media tables contains other pictures not related to items. And Items is actually using MediaSet, and not Media, so the reference in Picture fields is referencing a MediaSet, that again multiple Media's. So an Item can actually have multiple pictures in 2017.

I would proberbly export all pictures to filsystem and import again.
https://docs.microsoft.com/en-us/dynamics-nav/importfile-function--mediaset-

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

kanika

And how can I export them?

Juhl

Look at MS documentation, i put a link for import :-)
Google is your friend.

kanika

Thank you very much for the help!!