Excel addin error - Cannot have 0 columns

(0) Share

Report

Posted on by mikeeboy

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

All responses (5)

Answers (0)

Sort by

Tim Schofield on at

Like (0)

Report
Copy link

Link copied!

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!
Suggested answer

Weaveriski 23,620 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.
Community Member on at

Like (0)

Report
Copy link

Link copied!

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
Jefry Then 1,982 on at

Like (0)

Report
Copy link

Link copied!

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
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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.