Post#5: Excel Addin – Issues of minimum fields

Excel addin is a wonderful tool really it is. It is quick to import, even shows errors neatly. Its really good for shared tables, non shared however becomes a chore if you have a lot of entities to deal with.

However that is not the issue i want to talk about today. I had to update the title table in AX which is HcmTitle this is used to store job title/designation information in HR. It is a simple table as simple as they come in base AX, it just has one field. Yes just one. Ha no need of getting technical team to create a job i guess i can use excel addin to import right ?

Wrong.

The issue is excel addin at least with  AX 2012 R3 CU8 requires a minimum of 2 columns to work !!! Yes you heard that right folks, but don’t take my word for it see for yourselves. If you try you will get the following error:

excel_addin_title

Well how to get around this issue if you really want to use excel addin ? Well just give excel addin what it wants…create a new column, use excel addin to import the records and the just delete the extra column. Who needs to trouble our already overworked poor ax technical consultant.

Happy Daxing…

 

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s