Dataport with picture

Vineeth.R

Hai Friends,

I wanted to export and import data from Employee table which has picture also, into an Excel file(CSV). When I export it saves the picture as '*' in Excel file and when i import back into employee table it does not give me the picture.how to solve this???


thanks and Regards
Vineeth

garak

the picture is stored into a BLOB field. Dataports can't import blobs.
To import a blob use the same source like in "Item Picture" form.

Regards

Stef-B

Picture export to csv File??
CSV Files cant hold binary data.
see http://en.wikipedia.org/wiki/Comma-separated_values

Vineeth.R

hi

thats y how can i export and import a picture file from navision to a text or esv file and import back using dataport?

regards

Stef-B wrote:

Picture export to csv File??
CSV Files cant hold binary data.
see http://en.wikipedia.org/wiki/Comma-separated_values

garak

you can't export Binary Objects per Daqtaport :!:
To export / import Data, use the same function line in "Item Picture" Card.

Export Data to csv and store BLOBS (your Pictures) in the same folder with Syntax YourFolder:\PIC_ItemXYZ.bmp

REGARDS

Vineeth.R

hi garak

i also had the same idea of storing picture to some folder and saving the path in the excel file, but i was trying if there is any other easy method. it seems these isn't any ...

To export / import Data, use the same function line in "Item Picture" Card.

i didnt understand what u meant here... please explain..

thanks

garak wrote:

you can't export Binary Objects per Daqtaport :!:
To export / import Data, use the same function line in "Item Picture" Card.

Export Data to csv and store BLOBS (your Pictures) in the same folder with Syntax YourFolder:\PIC_ItemXYZ.bmp

REGARDS

Savatage

Vineeth.R wrote:

To export / import Data, use the same function line in "Item Picture" Card.

On the item picture card there is a button to import/export. If you look at the code you'll see how it's done.

or you can search the forum for:
"PICTURE EXPORT HASVALUE"