to import vendor through excel in ax 2012

(0) Share

Report

Posted on by CU02060633-1

371

want to import the vendor through excel in a 2012 and the company is "INMF" code to import through is excel..

the fields are :- ACCOUNT NUM, NAME ALIAS, VENDOR NAME, VENDOR GROUP, CURRENCY, COUNTRY, STATE ZIPCODE,STREET,ADDRESS, CITY, EMAIL CELL PHONE, PHONE, SITE ID, PAYMENT, TERM, TIN NO,

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Prashant Singh 8,802 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear Vinay,

Please correct the tag. It should AX 2012 .

atinkerersnotebook.com/.../using-excel-to-import-customers-and-vendors-in-dynamics-ax-2012

Please follow above link. It will help you to do so.

Also you can import vendor through dmf.

Regards,

Prashant Kumar

Was this reply helpful? Yes No
CU02060633-1 371 on at

Like
a
(0)

Report
Copy link

Link copied!

@Prashant Kumar...thanx for the reply want to o with the help of the X++ code

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Vinay Tak,

Here is the code similar to your solution! Please try this.

static void InsertRecords(Args _args) { SysExcelApplication application; SysExcelWorkbooks workbooks; SysExcelWorkbook workbook; SysExcelWorksheets worksheets; SysExcelWorksheet worksheet; SysExcelCells cells; COMVariantType type; Name name; FileName filename; int row =1; int i=0; VendTable vendTableLoc; AccountNum accountNum; str VendGroup; Dialog dialog; DialogField dialogField; ; application = SysExcelApplication::construct(); workbooks = application.workbooks(); dialog = new Dialog("FileOpen"); dialogfield = dialog.addField(extendedTypeStr(Filenameopen), "File Name"); dialog.run(); if (dialog.run()) { filename = (dialogfield.value()); } try { workbooks.open(filename); } catch (Exception::Error) { throw error("File cannot be opened."); } workbook = workbooks.item(1); worksheets = workbook.worksheets(); worksheet = worksheets.itemFromNum(1); cells = worksheet.cells(); do { ttsBegin; row++; accountNum = cells.item(row, 1).value().bStr(); VendGroup = cells.item(row, 2).value().bStr();
vendTableLoc = VendTable::find(accountNum,true);

vendTableLoc.VendGroup = VendGroup; vendTableLoc.insert(); ttsCommit; i++; type = cells.item(row+1, 1).value().variantType(); } while (type != COMVariantType::VT_EMPTY); application.quit(); info("Done"); info(strFmt("%1", i)); }

Thanks

Suresh

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,286 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Vinay Tak,

You don't need to write x++ code, use DMF to import vendors shafeaa.blogspot.co.nz/.../import-vendors-using-data-import.html

Use standard functionality instead of custom solution you need to write, test and mintain.

Was this reply helpful? Yes No
Suggested answer

Faisal Fareed 10,796 User Group Leader on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Vinay,

Though there can be many ways to import an entity (e.g. Customer) in AX 2012 however, based on the list of fields you want to import data for I found best-written article here [View:http://ax2012xppdataimport.blogspot.com.au/2013/02/microsoft-dynamics-ax-2012-xpp.html:750:50] which explains each and every field related to customer e.g. postal address, electronic address etc.

Above approach is best if you still want to write code to import otherwise Data import export framework is there for you to do all job.

Was this reply helpful? Yes No
Naman Jaju 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you please explain this code?

Was this reply helpful? Yes No