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.
}
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:
}
Hope this was useful. You may leave your comment below.
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.