Dynamics Search Engine

Tuesday, February 21, 2012

In Microsoft Dynamics AX 2012 during data import using Excel Add-Ins you may experience an exception or error

In Microsoft Dynamics AX 2012 during data import using Excel Add-Ins you may experience an exception like: “You must include at least two items in any list used for updating data.”

Applied on:
Microsoft Dynamics AX 2012 CU2.

Assumption:
This article is for those who has at least basic data flow and navigation
knowledge.

About this article:
This article may answers your question like-
• In Microsoft Dynamics AX 2012 how to handle exception during data import or data conversion?
• In Microsoft Dynamics AX 2012 how to copy master data from one environment to another environment and handle exception or error?
• In Microsoft Dynamics AX 2012 what are the new feature to export / import data?

Exception:

Resolution:
During data import using Excel Add-ins tool you need to select table(s). Once the table(s) is selected, by default system will select field(s) from table which is mandatory or part of primary index. If you have more than two fields like this then you will not face this exception or error. If there is one field which is mandatory or part of primary index in your table then system will select that field and put in the excel sheet and manually you need to select one more field along with this. In the above error screen if you see the red marked area where one more field to be added to get out of this exception.
Hope this is useful.

4 comments:

  1. Thank Rajesh. You are brilliant. However, I am still having troubles on import customer transaction balance. First it sais that I needed to increase max Buffer size which I did. Then when I click "Publish Data", I got an error message from excel.
    LedgerJournalTrans.createList Line=4, Pos=4, Xpath=/LedgerJournalTrans/LedgerJournalTrans[1] Method AxdBase.getDimensionId must be overridden.

    LedgerJournalTrans.createList Line=4, Pos=4, Xpath=/LedgerJournalTrans/LedgerJournalTrans[1] Document Generic document could not be created. Error details: Method AxdBase.getDimensionId must be overridden.

    What this means?

    ReplyDelete
  2. Rajesh,

    It's been over 4 years since this was posted, but I don't understand what you mean by if there is one field you need to manually select another field. If you see this can you please help me out.

    Thanks

    ReplyDelete
  3. Scott,
    Let’s consider the scenario where you have a table T with 4 fields (field1, field2, field3 & field4). Field1 is set to mandatory = yes. Now you are using this table to import or update data using Excel Add-Ins. As soon as you select the table, system considers field1 to the spread sheet by default and that is the only field. In such a situation you should get the error shown above. How to ignore this error? You need to add one more field from table T to your spread sheet manually e.g. field2 or field3 or field4. This was a bug back in 2012 but I don't know the current situation whether this bug has been addressed or not.
    Thanks,
    Rajesh

    ReplyDelete
    Replies
    1. Thank you Rajesh, that was helpful and what i needed.

      Delete