web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Dynamics ax 2012: Data Import using EXCEl ADD In, Publish button grayed Out

(0) ShareShare
ReportReport
Posted on by 1,264

Hello Community,
I am trying to import data into a specific table in dynamics ax using excel add In.
This table contains a RefRecId. I create a query, a service, I add that service to a group and I choose the suitable service from add Data screen. Then I drag the header into the excel sheet, close the fields area, add some data, but i am not able to do a publish because the button is grayed out.
is there a step i am missing?

Here is how i proceed:

 

I make sure that the service is activated like follow:

srvsGrp.png

Also, I add this to the document data source and activate it like follow:

data-Source-document.png

 

From Excel I click on add Data, then add data and I choose my service:

 addData.png

 

in the fields section I can see the fields from my query, 

 

3731.query.png

 

Might you please helping me understand why the Publish button is grayed out?

 and how can I solve this issue?

Thank you for your help,

Kind Regards,

Jihane

*This post is locked for comments

I have the same question (0)
  • Verified answer
    ColbyGallagher Profile Picture
    3,666 on at

    You exposed your base query in document data sources (Data Source Type: Query Reference), which you can't publish through.  You need to expose your AIF service in Document Data sources (Data Source Type: Service) that you created.  

  • jihane Profile Picture
    1,264 on at

    Hello Colby,

    Thank you for your answer. Indeed that was the problem.

    I have a new issue now, is that i am not able to insert new data to AX, but i am only able to update already existing records?

    Do you have any idea about this behavior?

    Kind Regards,

    Jihane

  • Martin Dráb Profile Picture
    237,994 Most Valuable Professional on at

    jihane has a new thread for the new question (Dynamics ax 2012: Data Import using EXCEl ADD In, only update, no insertion), so please don't discuss it here. I'm marking this thread as answered.

  • jihane Profile Picture
    1,264 on at

    the link for my new question is community.dynamics.com/.../182672

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans