Microsoft Dynamics AX (Archived)

Import or update default dimension from CSV (Comma Delimited) file with X++

(0) Share

Report

Posted on by Community Member

Hi ,

How do I insert new customer or update dimensions or import default dimensions?

I need job.

plz suggest me

thanks

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

DavidGunawan 1,381 on at

Like (0)

Report

Hi Shub,

To import data to AX 2012, there is out of the box function that you can use. Please look into data import export framework. You can refer link below for more details.

ax.help.dynamics.com/.../walkthrough-import-data-from-a-csv-data-source-dixf-dmf

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi David,

Thanks for reply.. i need X++ code related that topic.

Was this reply helpful? Yes No
Suggested answer

startax 1,845 on at

Like (0)

Report

@Shub

howtoax.com/import-customer-form-csv-in-ax-2012-using-x-with-address-and-contact-information

howtoax.com/how-to-update-customer-and-vendor-dimension-in-ax-2012-from-csv-using-x

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Dinkar,

For customer dimension code not working ..showing Error "Financial dimension value does not exist" have any idea about this .

plz suggest me

thanks

Was this reply helpful? Yes No
startax 1,845 on at

Like (0)

Report

@shub

can you share your code and csv screenshot ??

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Dinkar,

static void CustomerDimension(Args _args)

{

CommaTextIO csvFile;

container readCon;

counter icount;

Dialog dialog;

DialogField dfFileName;

FileName fileName;

Struct struct;

DimensionDefault DimensionDefault;

CustAccount custAccount;//For vendor declare VendAccount

CustTable custTable; //Declared VendTable here

container ledgerDimension;

int i;

#File

// create dialog for file selection

dialog = new Dialog("Select file to upload");

dfFileName = dialog.addField(extendedTypeStr("FilenameOpen"));

dialog.filenameLookupFilter(["All files", #AllFiles]);

if (dialog.run())

{

csvFile = new CommaTextIo(dfFileName.value(), 'r');

csvFile.inFieldDelimiter(',');

readCon = csvFile.read();

ttsBegin;

while(csvFile.status() == IO_Status::OK)

{

readCon = csvFile.read();

if(readCon)

{

icount++;

custAccount = conPeek(readCon,1);

custTable = CustTable::find(custAccount,true);

struct = new Struct();

struct.add('BusinessUnit',conPeek(readCon,2)); //(DimensionName,Value)

struct.add('CostCenter', conPeek(readCon,3));

struct.add('Department', conPeek(readCon,4));

ledgerDimension = conNull();

ledgerDimension += struct.fields();

for (i = 1; i <= struct.fields(); i++)

{

ledgerDimension += struct.fieldName(i);

ledgerDimension += struct.valueIndex(i);

}

DimensionDefault = AxdDimensionUtil::getDimensionAttributeValueSetId(ledgerDimension);

custTable.DefaultDimension = DimensionDefault;

custTable.update();

}

}

ttsCommit;

}

}

CSV file formet

Cust Account BusinessUnit CostCenter Department

DE-004 003 010 024

Was this reply helpful? Yes No
Suggested answer

startax 1,845 on at

Like (0)

Report

@shub

your code is looks fine i run the following code and it works

static void SST_CustomerDimension(Args _args)

{

CommaTextIO csvFile;

container readCon;

counter icount;

Dialog dialog;

DialogField dfFileName;

FileName fileName;

Struct struct;

DimensionDefault DimensionDefault;

CustAccount custAccount;//For vendor declare VendAccount

CustTable custTable; //Declared VendTable here

container ledgerDimension;

int i;

icount++;

custAccount = "US-001";//conPeek(readCon,1);

custTable = CustTable::find(custAccount,true);

struct = new Struct();

struct.add('BusinessUnit',"003");//conPeek(readCon,2)); //(DimensionName,Value)

struct.add('CostCenter', "010");//conPeek(readCon,3));

struct.add('Department', "024");//conPeek(readCon,4));

ledgerDimension = conNull();

ledgerDimension += struct.fields();

for (i = 1; i <= struct.fields(); i++)

{

ledgerDimension += struct.fieldName(i);

ledgerDimension += struct.valueIndex(i);

}

DimensionDefault = AxdDimensionUtil::getDimensionAttributeValueSetId(ledgerDimension);

custTable.DefaultDimension = DimensionDefault;

custTable.update();

}

try to give single hard coded value as per given in this code. it will work

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi dinkar ,

When i use same code update Dimension for csv file is not working ..why this happening plzz Suggest

Thanks

Was this reply helpful? Yes No
Verified answer

startax 1,845 on at

Like (0)

Report

@shub

static void LeadProductCategory2(Args _args)

{

CommaTextIO csvFile;

container readCon;

counter icount;

Dialog dialog;

DialogField dialogField;

FileName fileName;

Struct struct;

DimensionDefault DimensionDefault;

CustAccount custAccount;//For vendor declare VendAccount

CustTable custTable; //Declared VendTable here

container ledgerDimension;

CommaIo commaIO;

int i;

#File

#file

dialog = new Dialog ("Select File");

dialogField = dialog.addField(extendedTypeStr(FilenameOpen));

dialog.filenameLookupFilter(["All Files",#Allfiles]);

if (dialog.run())

{

fileName = dialogField.value();

}

commaIO = new CommaIo(filename,'r');

if (commaIO)

{

ttsBegin;

while (commaIO.status() == IO_Status::ok)

{

readCon = commaIO.read();

if (readCon)

{

icount++;

custAccount = conPeek(readCon,1);

custTable = CustTable::find(custAccount,true);

struct = new Struct();

struct.add('BusinessUnit',conPeek(readCon,2)); //(DimensionName,Value)

struct.add('CostCenter',conPeek(readCon,3));

struct.add('Department',conPeek(readCon,4));

ledgerDimension = conNull();

ledgerDimension += struct.fields();

for (i = 1; i <= struct.fields(); i++)

{

ledgerDimension += struct.fieldName(i);

ledgerDimension += struct.valueIndex(i);

}

DimensionDefault = AxdDimensionUtil::getDimensionAttributeValueSetId(ledgerDimension);

custTable.DefaultDimension = DimensionDefault;

custTable.update();

}

}

ttsCommit;

}

}

Use this code and put (custaccount,'003,'010,024) in your csv i am not using header in csv so remove header in csv. In csv if you not put (') before 0 then you get error. if your value is starting with 0 ex. 003 then it will be consider as 3 in csv .

Was this reply helpful? Yes No