Hi, I'm trying to import employees using the excel addin. DirPartyTable will publish fine, as does HcmWorker. But hwen I try to publish HcmEmployemnt, I get an error "Cannot have 0 columns".
Does anyone know what this error means please, and how I can publish this table?
Thanks
*This post is locked for comments
Send an email to helpdesk@globesoftware.com.au and request a free trial of Atlas. Atlas can report from AX and upload into AX without leaving Excel. Customers, Vendors, Items/Products - whatever you need.
[View:http://www.youtube.com/user/Atlas4Dynamics] has several movies, one showing a customer upload.
Hi Alex, I've read your blog post and try to follow your instructions. However I still face this issue when trying to publish ForecastSales table. I'm uploading Demand Forecast.
At first, excel add-in raise 2 errors that is surrogate key are needed for ForecastSales table and PurchLine table. To resolve this, I've added surrogate key for ForecastSales table with ExpandID and RecID while for PurchLine I've added InventTransID and RecID for PurchLine.
After add those 2 surrogate keys, I add a field "DummyField" in DimensionAttributeValueSet and create a surrogate key for this table. I use DummyField and RecID as my replacement key.
Then, I managed to retrieve data from AX but when I try to publish, it still raises an error cannot have 0 columns. Any idea how to solve this? Many thanks Alex.
Jefry
Hi mikeeboy and Tim!
Please take a look at the solution I found to 'Cannot have 0 columns' issue here: ax2012exceldataimport.blogspot.com/.../dynamics-ax-2012-excel-add-in-issues.html
In essence this error means that one and more tables participating in the resulting data set have NO columns. In order to resolve it you will have to identify those tables by using Relations node on table level and then add at least one field (fictitious field) to these tables. After that you can publish data into the main table.
Please let me know if you have any comments and/or questions
Best Regards,
/Alex
Unfortunately Microsofts stance is that the tool is not for data migration, there is a beta migration tool that has been released, you can find it here.
dynamicsuser.net/.../default.aspx
In the meantime the Excel add-in should only be used for simple single table processes, and on large data this will be slow.
The caveat to this is I have not had hands on with the add-on, it is just me picking up all of the various discussions on the issues with it.
I got this error try to add an inventory journal line. No solution found yet.
The Excel add-in Is not AX 2012's best feature!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156