I was using Microsoft Dynamics AX excel add-in to import master data in Dynamics AX 2012 and the Publish All button was disabled after getting my excel sheet ready with data.
To publish the data using excel add-in, close the FIELD CHOSER window once you have selected all the fields you want to push to AX and then you will see Publish button enabled.
To publish the data using excel add-in, close the FIELD CHOSER window once you have selected all the fields you want to push to AX and then you will see Publish button enabled.
Dear Yasir,
ReplyDeleteI am trying to import the data from excel to ax 2012 through office addins.
I have done succesfully the export procedure, but I could not import the data.
i have done the following steps
1) created a query of the table where I wanted to import the data.
2) go to the exel and "Add Data"
3) In "Add Data", -> Add tables
4) select the table where wanted to import the data.
5) added the required field, closed the field choser
6) Added data, selected the data
7) Clicked on "Publish All".
But my publishing failed getting following error
Publishing Status
Operation State Publish Completed
Publish Start Time Thursday, October 11, 2012 5:16:10 PM
Time Taken 00:16.0
Server Name Axsupport1
Company gitl
Total Records 1
Records Published 0
Records Failed 1
Publishing Details
GODP_ExcelImportTest
Operation State Publish Completed
Publish Start Time Thursday, October 11, 2012 5:16:10 PM
Time Taken 00:16.0
Total Records 1
Records Published 0
Records Failed 1
Name Error Messages
Mayure
Document Generic document could not be created. Error details:
Plz let me know who have done this before.
Thank you in advance.
You can try enabling logging exceptions in AIF to get a meaningful error. Deactivate the service through Inbounds port form on System Organization module and then from Troubleshooting fast tab
DeleteChoose enable logging for all version of documents and then check both the boxes on this tab saying include exception in fault etc.
After you get this error in excel, go to Exceptions form or History form under Periodic -> Services and applications framework on system organization module to see the errors.
Hi Yasir,
DeleteI cant find the "System Organization" module. but i found "System Administration" module in Ax2012.
Where can i get "Troubleshooting fast tab" location?
Thank you
Regard
husna
Thank you sir, gr8 post in the sense that it really SOLVES my problem. I closed the fields bar on left and the publish button got enabled giving me tons of happiness lol
ReplyDeletethanks again
That is great :)
Deletesupreme clothing
ReplyDeletesupreme clothing
off white clothing
golden goose
off white clothing
bape hoodie
off white hoodie
stephen curry shoes
yeezy boost 350
yeezy gap hoodie