How can i export my Item pictures

rouxbox

i have 2 navision databases. i want to export the items from database A including the picture blobs and use them (import) in database B. Using dataports its really easy to export the items but i get an error exporting the picture Blobs. any suggestions

rvduuren

Hello,

You can try exporting the pictures as blob <Item."No.">.bmp into a specific directory and then import them into database B.

You can use a simple report (export database A):

Item - OnAfterGetRecord()
Item.CALCFIELDS(Picture);
IF Item.Picture.HASVALUE then BEGIN
  Item.Picture.EXPORT('/<dir>/'+Item."No."+'.bmp',false);
END;

And import database B:

FileRec.SETRANGE(Path,'<dir>');
FileRec.SETRANGE("Is a File",TRUE);
if FileRec.FIND('-') then 
  repeat
    if ItemRec.GET(DELCHR(FileRec.Name,'=','.bmp')) then begin
      ItemRec.Picture.IMPORT('/<dir>/'+FileRec."Name",false);
      ItemRec.modify;
    end;  
  until FileRec.NEXT=0;

Let me know if this is what you mean..