import pictures NAV2017 by sql

kanika · 2018-01-18

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 · 2018-01-19

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 · 2018-01-18

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

kanika · 2018-01-18

Then... how I can yo do it?

Juhl · 2018-01-19

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 · 2018-01-19

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

kanika · 2018-01-19

And how can I export them?

Juhl · 2018-01-19

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

kanika · 2018-02-07

Thank you very much for the help!!

import pictures NAV2017 by sql

Best Answer

Answers

Categories