Solved

Microsoft CRM: how to automatically publish articles

Posted on 2012-03-22
2
252 Views
Last Modified: 2012-04-06
See attatched. To publish I have to submit the one in draft>which goes to unapproved and only after I approve it, it goes to published. After it is published, it is searchable.

How do I made it automaically publish when the article is created? I did find a table in database called kbArticleBase where I can set both stateCode and StatusCode to 3. It does move the article to published folder but it is not searchable from workplace.

I compared the ones which I did from Draft>Upapproved>Published Vs the one I manually set the codes to 3. The difference was that the manual one didnt seem to put the template. I open the article and the entries are blank.

So if there a way set the CRM so that it automatically publish the articles without having to go through draft and unapproved folders? Is there somewhere else in the database table I see to set the flags?

Thanks
Capture.JPG
noTemplate.JPG
Template.JPG
0
Comment
Question by:itbossman
2 Comments
 
LVL 29

Accepted Solution

by:
Feridun Kadir earned 500 total points
ID: 37754936
You really shouldn't play around with values in the database tables. As you've discovered doing what looks like the right thing may not work.

I would consider using an automatic workflow that runs when an article record changes status. In the workflow, check that the status is unapproved and add a step to change the status to published.
0
 

Author Comment

by:itbossman
ID: 37817074
thanks, I have given creaters to have ability to publish their own articles. That way I dont have to work with database on the backend.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question