![]() ![]() I then took and added new rows, which gave me three records within the table, of the Excel worksheet. Now moving forward, I will only have the key field Mode of Delivery as it is required, and then Description field. Here I've added a few fields, just to give you an idea. Here we can add and remove fields, using the Field Chooser, on the ribbon. Also notice the fact, that the process created a new worksheet, in this workbook, just for our DlvMode AX table. Once we select to Add tables, then we can select the DlvMode table, and actually use the Filter field at the bottom, so we only see that table to select. Now moving forward from here, lets go and add the DlvMode table, by clicking on the add data, then add table. We see, that we have the ability to override here, and point to what AOS instance we want to connect too, as well as within that what company entity. (Server specific information, blanked out on purpose.) So to get started, lets click on the Connection button, from the ribbon, and make sure we are in the company account and instance we care about. This data, lives in the DlvMode table within the Microsoft Dynamics AX AOT. I'm going to assume this is already in place, and lets say, for the sake of keeping this simple, that I need to add some Delivery Mode data. To help show this process, I have created the following walk through that shoudl give an idea of what it takes to work with the new Dynamics AX Add-in for Excel, and get data into Microsoft Dynamics AX 2012 using this new, and great tool!įirst, you have to launch Microsoft Office Excel 2010, and of course have the Excel Add-in installed. Let me say, this new process is very fast, and is designed so that a developer or architect is really not needed to import a lot of data, into AX. Now, with Microsoft Dynamics AX 2012, and the new Excel Add-in for Microsoft Dynamics AX, scripts are a thing of the past. The older Excel Import, honestly was very slow and if you had any records of any size, then you just really would rather create X++ scripts to import data. With the release of Microsoft Dynamics AX 2012, this no longer exists! For some, I'm sure this will be a little shock, however this is a good thing. You can see this, in the Microsoft Dynamics AX 2009 menu system, here.: One such topic, is the old Microsoft Excel Export / Import Wizard for Microsoft Dynamics AX. This is out-of-the-box ability, that replaces a lot of older ways for doing things. With the release of Microsoft Dynamics AX 2012, the lines between the Rich Client, the Portal as well as Microsoft Office are going to be blurred. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |