Can someone direct me to the correct process and file structure to import
Knowledge Base articles please. CRM 4.0.

are you trying to import them as attachment (on note) ? if so what
tool are you using? data migration manager?


/Aamir

Thank you.

I am trying to import unique and seperate articles to the KB. Article
template would originate in excel. Have tried to establish data map and to
use wizard. Errror message says that "source data is not in the required
format".

"Aamir Bashir" wrote:

Have you read this help on data migration manager ? The best way is to
try to migrate 1-5 records and it will be easy to track down the error
and format.


Articles in Microsoft Dynamics CRM require a subject ( A category used
in a hierarchical list to correlate and organize information. Subjects
are used in the subject tree to organize products, sales literature,
and knowledge base articles. ) and a template ( A framework for an e-
mail message, contract, or article. Templates are used to ensure
consistent layouts and content in similar types of documents. ) .

If your source system does not use a subject hierarchy, you need to
create this either by migrating a Subjects.csv file containing the
subjects, or by creating the subjects in Microsoft Dynamics CRM prior
to migrating data.
In the Navigation Pane, click Settings, click Business Management, and
then click Subjects.
For more information, on the Subjects form, click Help, and then click
Help on This Page.
If your source system does not use templates for articles, you need to
create a default template in Microsoft Dynamics CRM prior to migrating
data.
In the Navigation Pane, click Settings, click Templates, and then
click Article Templates.
For more information, on the Article Templates form, click Help, and
then click Help on This Page.

You will also need to make sure every article record that you are
migrating includes a Subject column, with a valid reference to a
subject, and a Template column, with a valid reference to a template.

Required Preparation in Source Files
Edit your article's source .csv file:

Add two new columns: Subject, Template.
For each record, in the new Subject column, enter one of the subject
values you entered in the Subject Tree.
For each record, in the new Template column, enter one of the template
values you entered in the Article Templates page.
Mapping in the Data Migration Manager
When you are mapping data using the Data Migration Wizard, map your
new columns as follows:

Subject: map to the Microsoft Dynamics CRM Subject (subjectid)
attribute.
Template: map to the Microsoft Dynamics CRM Base Template
(kbarticletemplateid) attribute.
Learn More
Resource Center

Entity Reference (Resource Center)

Related Topic


/Aamir

Thank you sir. I had added both a subject and a template as advised in set-up
and included those names in my import (.csv) file. Continue to get "source
data not in reuired format" error. Source column names are exactly the same
as CRM targets.

I really appreciate your help.

//dem

"Aamir Bashir" wrote:

The problem is in data and sometime when you make CSV , data migration
manager throw the error . To make the thing simple just import single
(1) record and see if you get the error of data format?

the place where you installed the data migration manager , you will
find data migration manager help. Please read it also while
importing.

/Aamir

I have not had success with creating data maps to import records using the
Import Tool. I have had success importing those same records when CRM
recognizes the Import file and creates the mapping automatically.

You can make this happen by using advanced find or some other grid display
of the KB articles. Add the columns to the CRM grid display that exist in
your csv file and then export to Excel. Copy and paste the header columns
from Excel into your csv file. This should ensure that the headings match
exactly and CRM should be able to autmatically create the data map.

Regards

"dem@cfo" wrote: