How can i export my Item pictures

rouxbox
rouxbox Member Posts: 8
edited 2008-04-19 in NAV/Navision Classic Client
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

Comments

  • rvduuren
    rvduuren Member Posts: 92
    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..
    Met vriendelijke groet, best regards,

    Rvduuren

Categories