Jumat, 29 November 2013

Import Data from Excel Office add-in to Dynamics AX2012

Hi, ...
dah lama ya ta jumpa...

Tiba-tiba sudah AX2012 lagi :( ...
Kali ini i want to share a simple way and... of course a simple sample how to import data from Excel Office add-in to Dynamics AX2012.

I take a sample from my machine
Sebelumnya Ms.Office saya adalah versi 2007. lalu saya install Office Add-in dan hasilnya prerequisite AX12 tidak menemukan adanya Ms.Office 2007... well thats is weird. Then i go check to the internet and found that i have to upgrade my MS.Office 2007 to SP1,...so i updgrade la... but ... its still doesnt work... its more weird rite? ... OK,.. next ... i am very mad, ta' tanggung2 aku upgrade aja sampe SP3.. dan itu teman ku juga menyarankan seperti itu. n the Result is ... The Prerequisite can read my MS.Office :).

after you installed the Office Add-in,... u must go to AX2012-System Administration-Periodic-Compile into .NET Framework CIL, ... wait(its quite long) until the proces is done. and give an information like this.
why we must generate the .NET CIL? .. coz if u r not u will got an error like this "Document Generic document could not be created. Error details:" this is error will appear when u import data to AX2012. but for some reason in technically... i dont know ...heheheh

Ok now open ur Excel and find the Dynamics AX menu ...(found it? ... god boy!)
Click new blank document, go up to the menu then click Add-data-> Add table

Here,... i have create a VetSpeciestable for my sample..u can choice ur tables off course.
click OK.
and this is the view of my Worksheet of VetSPeciesTable.
Click Menu 'Fields' to hide the navigator of table
then u can put ur record at the couloms.

click Publish at the up Menu,...
then u will get information from the Excel about the result.