How to export import images or pictures from a table field by X++ code in Microsoft Dynamics AX 2012.

How to export / import a picture or image from a table field by X++ code in Microsoft Dynamics AX 2012.


Applied on: Dynamics AX 2012 R3 CU9.
Prerequisite: Basic Dynamics AX 2012 programming knowledge.
Target audience: AX programmers.Assumption: You are familiar with Dynamics AX 2012.


Below X++ job will explain you how to export an image or picture from Dynamics AX 2012 table. It's a simple piece of code but sometimes we spent hours to get the code how to export picture or image. I have posted here just to make it handy.

static void exportImageFromTable(Args _args)

{

    bindata             bin = new bindata();

    str                 content;

    container           image;

    RetailImages        retailImages;

    FilePath            filepath;

   

   

    select retailImages where retailImages.PictureId == 8045;

   

    filepath = strFmt('C:\\Users\\Administrator\\AppData\\Local\\Temp\\images\\PictureID_%1.jpg', retailImages.PictureId);

    image = retailImages.picture;

    bin.setData(image);

   

    // Create the base64 encoded string

    // content = bin.base64Encode();

    // info(content);

   

    // Save it to the file system as a jpg, png or tif format

    AifUtil::saveBase64ToFile(@filepath, content);

   

}


In addition I am share the code how to import or insert a picture or image in Dynamics AX 2012 using X++ code.

Here is the job:

static void InsertImageToTableField(Args _args)

{

   

    Bindata         binData = new BinData();

    FilePath        path;

    RetailImages    retailImages;

    str             imageID;

   

    path = "C:\\Users\\Administrator\\AppData\\Local\\Temp\\Images\\PictureID_8046.jpg"; // file location

   

    binData.loadFile(path);

   

    select retailImages where retailImages.PictureId == 1111;

   

    if (!retailImages)

    {

        retailImages.picture    = binData.getData();

        retailImages.PictureId  = 1111;

        retailImages.doInsert();

    }

   

}


Hope this was useful. You may leave your comment below.

Microsoft Dynamics AX 2012 Database Entity Relationship Diagrams

Hello,

After a long time I got a chance to write here.
I was surfing internet and came out with a very useful link http://www.microsoft.com/dynamics/ax/erd/ax2012r2/ which tells about Microsoft Dynamics AX 2012 Database Entity Relationship Diagrams.

This link can answers your questions like:
How to know Microsoft Dynamics AX 2012 table relations?
In Microsoft dynamics AX 2012 how to know tables per module?
In Microsoft dynamics AX 2012 how to know parent child relationship for tables?

You can explore the content by Module.
This link is very useful for AX developers as well as functional people who are interested to know about Microsoft dynamics AX 2012 table relationship.


You may leave your comments below.