I need to find the actual data for the knowledge base but when I open the SQL
server database and look at the KBarticlebase table about a third of the data
I need is there. The articleXML table holds some of the data in XML tags but
most of the entries here say <Longtext> . Does CRM store the rest in an XML
file or am I overlooking them? Thanks

RE: data structure of knowledge base by TraceySaling

TraceySaling
Tue Oct 05 08:19:03 CDT 2004

Can anyone assist me on this? I need to pull information from our CRM
knowledge base to our website but I don't think that the SDK will work. Our
CRM server resided behind a firewall and is inaccessible from outside of the
network. Any help would be appreciated, thanks.


"Tracey Saling" wrote:

> I need to find the actual data for the knowledge base but when I open the SQL
> server database and look at the KBarticlebase table about a third of the data
> I need is there. The articleXML table holds some of the data in XML tags but
> most of the entries here say <Longtext> . Does CRM store the rest in an XML
> file or am I overlooking them? Thanks

Re: data structure of knowledge base by John

John
Tue Oct 05 23:43:19 CDT 2004

all the text should be accessible as you can see in the schema here

http://msdn.microsoft.com/library/en-us/CrmSdk/htm/Schema/kbarticle.xml

you could have code run on the crm web server side that extracts the needed
data in xml format and stores it in a location your internet side web can
access..?

--
John O'Donnell
Microsoft CRM MVP
http://www.microsoft.com/BusinessSolutions/Community/CRMFaqLanding.aspx


"Tracey Saling" <TraceySaling@discussions.microsoft.com> wrote in message
news:600F711B-7C8F-4EA9-96CB-22264F0D1CA9@microsoft.com...
> Can anyone assist me on this? I need to pull information from our CRM
> knowledge base to our website but I don't think that the SDK will work.
Our
> CRM server resided behind a firewall and is inaccessible from outside of
the
> network. Any help would be appreciated, thanks.
>
>
> "Tracey Saling" wrote:
>
> > I need to find the actual data for the knowledge base but when I open
the SQL
> > server database and look at the KBarticlebase table about a third of the
data
> > I need is there. The articleXML table holds some of the data in XML tags
but
> > most of the entries here say <Longtext> . Does CRM store the rest in an
XML
> > file or am I overlooking them? Thanks