Data Import/Export Framework Walkthrough: Installation

Microsoft provided an extension to Microsoft Dynamics AX that smooth’s the import / export process. Without this framework, importing data to some specific tables implied using X++.

I will try to publish a series of posts about Dynamics AX Data Import/Export Framework, covering:

  1. Installation
  2. Architecture
  3. Importing data to an out of the box target entity
  4. Importing to a custom target entity

Installation Step by Step

1 – First you must download the extension package from informationsource, unzipt it and execute setup.

2 – The installation process is split into 3 main components :

  • A component must be installed on a server running MS SQL Integration Services.
  • A component must be installed on a server running AOT.
  • A component must be installed on a workstation having the Dynamics AX client

Since I’m running all the services on a single box in a virtual machine, I have selected all components.

Install

In first step of the wizard, the installer will check if you have the minimal requirements.

Capture4

Designate a user account to run the Data Import/Export Framework service. Enter the user account of AOS service.

Capture5

Press Next.

3 – The components are now installed, now the model files must be imported into Dynamics AX

Import the Model file from a command line using AXUTIL. The modal file is located inside the folder of the client component.

Note that there is a matching folder in “C:\Program Files\ Microsoft Dynamics AX 2012 Data Import Export Framework Client Component” for each supported version of Dynamics AX.

  • AX 2012 -> Folder 2012.
  • AX 2012 Feature Pack ->  Folder 2012 FP.
  • AX 2012 R2 -> Folder 2012 R2.

For Dynamics AX 2012 R2 execute : axutil import /file: “C:\Program Files\ Microsoft Dynamics AX 2012 Data Import Export Framework Client Component \2012 R2\model\DataImportExportFramework.axmodel”

Capture7

Capture8

4 – Restart the AOS service

Capture6

5 –  Open the Dynamics AX Client, and a screen should popup to you. Select “Compile and synchronize” option. The next step is to do a full CIL compile.

Capture9

This step should take a few minutes to complete.A info log is displayed at the end.

Capture10

6 – Restart the AOS Service

Capture6

7 – Open Dynamics AX client, now the Dynamics AX Navigation pane should have the option of Data Import/Export Framework.

Capture11

Stay tuned for next posts

Advertisements

17 thoughts on “Data Import/Export Framework Walkthrough: Installation

  1. Having an issue when importing the model-file to AX 2012 FP. with CU4.

    Error: One or more conflicting model elementes already extists in an installed model.

    Conflicting model: Extensions .
    \Macros: 1
    \Menus: 1
    \Security\Process Cycles: 1

    Do you know if the framework is competible on AX FP CU4. Else I’m running on av WS 2008 R2 Ent Sp1 environment with SQL 2008 R2 SP1. All components on same box.
    I don’t know what elements is in conflict, but I’ve seen all elements from the extensions model is in layer fpk, at least from mentioned elements.

    Else I wonder about the model file in the server folder. Can I try and install this one instead? I have only tried to install the model-file from the client-folder, as specified from guide. But they look identical. Since I’m running all components on same box, should I instead try to install the server model file?

    And is there any additional steps I should do before installing the model-file. Like setting up the service.

    If you have any knowledge about any of this I would really appreciate it.

    Thor

  2. Hello Nuno, thank you for this blog. I am having difficulties seeing the Data Import/Framework in the AX Client.
    Running through your steps I get an error when attempting to import the model. In the command line I enter
    axutil import /file: “C:\Program Files\Microsoft Dynamics AX 2012 Data Import Export Framework Client Component\2012\Model\DataImportExportFramework.axmodel”

    and the output I am getting is
    ERROR: The C:\Program Files\Microsoft Dynamics AX 2012 Data Import Export Framework Client Component\2012\Model\DataImportExportFramework.axmodel command or command line switch is unkown or undetected

    Would you happen to have any advice with this?
    We are running just the 2012 version and I have installed the previous components as per your instructions although I was having challenges with the GACUTIL for the AOS install which I believe we got around.
    Thank you,

      • Thank you Nuno, very helpful.
        We are running two instances of AX on the development server. Can you point me to where to configure the axutil so that it can be applied to the other instance? I see when the command line runs it indicates which instance it is applying the change to.

      • using the config option

        from help

        /config[[:aosinstance]:name]
        Specifies an Application Object Server (AOS) configuration to use to
        determine the model store database and server name. The default for AOS
        instance is the name of the "01" AOS instance on the local computer. The
        default for name is the name of the current configuration on the specified
        instance. This parameter cannot be used with the /db or /s parameters. If
        no parameters are supplied, /config is used by default.
        Example: axutil export /model:Test /config:DynamicsAx1:CoreDevelopment

      • Thank you for this guide and assisting with my challenges. It ultimately worked after using the /s: /db: and -conflict:push commands.

      • Hi Nuno,
        Apparently we are having challenges with compiling now. I see the results for point 7 of your walkthrough (Framework in AX client) however I get errors when trying to open any of the forms which I think goes back to the errors from compiling:
        I see 6 errors when compiling. The Compiler output error description was the same for each error being: “CIL generation: Object reference not set to an instance of an object”
        Path = \XppIL
        Method/Property name = XppIL
        Now I’ve researched a bit on other blogs but I can’t seem to fix this.
        Here is what I’ve pulled from AOT log:
        Finished pass 1 at 4/26/2013 9:00:03 AM

        Error when loading the method. Type: CustomerTransaction_CustSettlementLine, Method: new
        System.NullReferenceException: Object reference not set to an instance of an object.
        at Microsoft.Dynamics.Ax.Xpp.ILGenerator.BuildConstructor(TypeBuilder typeBuilder, XmlNode methodNode)
        at Microsoft.Dynamics.Ax.Xpp.ILGenerator.BuildMethod(TypeBuilder typeBuilder, XmlNode methodNode)
        at Microsoft.Dynamics.Ax.Xpp.ILGenerator.LoadMethods(XmlNode classNode, TypeBuilder typeBuilder)
        at Microsoft.Dynamics.Ax.Xpp.ILGenerator.GenerateXppModule()

        Error when loading the method. Type: CustomerTransaction_CustSettlement, Method: new
        System.NullReferenceException: Object reference not set to an instance of an object.
        at Microsoft.Dynamics.Ax.Xpp.ILGenerator.BuildConstructor(TypeBuilder typeBuilder, XmlNode

        …… MORE that I left out …….

        The CIL generator found errors and could not save the new assembly.
        Errors: 6
        Warnings: 0

        I also see when trying to open the Data import export framework > Setup > Data import export framework paramaters the following error:
        Cannot select a record in Shared folder (DMFParameters).
        The SQL database has issued an error. Looking at the DB I see that this table does not exist although I’m likely missing something.

        Would you be able to recommend anything for these compile errors? I feel so close to finishing setup.
        Thank you,

  3. HI Nuno Maia,

    I perfectly installed with your giudence, but i need the same configuration for the another instane in the same server.is it possible?

    if possible how to import the model into another instance through axutil.Please clarify .

    Thanks In advance

  4. Pingback: Data Import/Export Framework Walkthrough: Installation | Personal Knowledge Base

  5. Im facing similar issue but “push” option doesn’t work
    Here Im faceing the conflict :
    C:\Users\User2>axutil import /file:”c:\DataImportExportFramework.axmode
    l”
    AXUtil 6.0 – Microsoft Dynamics AX Admin Utility (6.0.1108.6482)
    (c) Copyright, Microsoft Corporation, 2011. All rights reserved.

    The AXUtil command was started in the mode: import.
    Working against model store AX-TESTSQL/Database_Test.
    ERROR: One or more conflicting model elements already exists in an
    installed model.
    ERROR: Model(s) could not be imported.
    ERROR: The import has been aborted and rolled back.
    Conflicting model: Extensions (Microsoft Corporation).
    \Macros: 1
    \Menus: 1
    \Security\Process Cycles: 1

    And her when I try “push”:

    C:\Users\User2>axutil import /file:”c:\DataImportExportFramework /confl
    ict:push”
    AXUtil 6.0 – Microsoft Dynamics AX Admin Utility (6.0.1108.6482)
    (c) Copyright, Microsoft Corporation, 2011. All rights reserved.

    The AXUtil command was started in the mode: import.
    Working against model store AX-TESTSQL/Database_Test.
    ERROR: The given path’s format is not supported.
    ERROR: The given path’s format is not supported.

    Thanks for any Ideas

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s