Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Excel addin error - Cannot have 0 columns

Posted on by 130

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Excel addin error - Cannot have 0 columns

    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.

  • Jefry Then Profile Picture
    Jefry Then 1,980 on at
    Re: Excel addin error - Cannot have 0 columns

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Excel addin error - Cannot have 0 columns

    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

  • Suggested answer
    Weaveriski Profile Picture
    Weaveriski 23,616 on at
    Re: Excel addin error - Cannot have 0 columns

    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.

  • Re: Excel addin error - Cannot have 0 columns

    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans