Question: using BIGTEXT variable to export a picture?

jemmy

Anyone knows how to resolve this Navision 4 question?

Scenario:
You would like to export item information about item number 70102 from
Navision to an XML document.
The information in the XMLPort should be include the following: item number,
description, picture.
Your task include the following:
1. Create an XMLPort with tags to export the item number, description, and picture from item table.
2. In the code for the picture tag, write the code to:
- Calculate the BLOB Pic field in the Item table (using CALCFIELDS function)
- Create an instream object (using CREATEINSTREAM function)
- Read the instream into the bigtext variable (using READ function)

Also in the OnInitXMLport trigger of your XMLPort, filter the Item Table to only item 70102 using a SETRANGE and FIND.

Please help since I am really confuse and stuck on these. ](*,)
I have export and got the picture is empty in the .xml....

Thanks a lot before.

Jemmy

Svensson01

Hallo Jemmy,

you must use a base64 encoder at export.
In Codeunit BizTalkXMLDomMgt are functions like AddPicture with this code.
Also you can copy the code from XMLPort 99008500 Outbound Product Catalog. There is a Tag named Picture with BigText.

regards
Svensson

jemmy

I still can't catch your idea perfectly on these...
What is base64 encoder?

Thanks for your help..