- Data Migration Manager and Attachments in CRM 4.0
- Posted by GIJimmyj on January 23rd, 2008
We are using the Data Migration Manager to import data into CRM 4.0 from
another system. All of our data seems to be migrating fine except for
attachments. The note is important and the attachment appears to be there,
but the size of the attachment is 0 kb, and We have followed all the steps in
the help files including:
1)We put all the notes/attachments into a Notes.csv file with a column
specifying
the entity, a column that contains the unique (entity) id, and a column with
the
filename.
2)We moved all of the attachments to a sub-folder named 'Attachments' within
the
folder that is holding the Notes.csv file.
3)We have mapped the 'Regarding' field (in CRM) to the entity id column.
After the migration completes, we can see the attachments when we open up an
entity, but the size is not there and the files can't be opened. When we
look in
the database, the filenames are there but there is nothing in the
DocumentBody column.
There are no errors during the migration.
Has anyone had a similar issue or any suggestions?
- Posted by Aamir on January 24th, 2008
Hi,
It happened to me but i made additional column .
Well i am not regular blogger but you can see some screen shots.
http://danishmscrm.blogspot.com/2008...hments-to.html
--
Aamir
http://danishmscrm.blogspot.com/
- Posted by Tushar Bhatia(tusharb@microsoft.com) on January 24th, 2008
Hello Jimmy
You need to map the column in the Notes.Csv file which contains the
filenames of the attachments to the "Document (documentbody)" Column of the
Note entity. Are you doing this?
Thanks
Tushar
"GIJimmyj" wrote:
- Posted by GIJimmyj on January 31st, 2008
Thanks SO much for the post. This was exactly the issue. We had the filename
mapped to the "Filename" field rather than the "Document" field. We created a
second column with the filename and mapped to "Document" and all was smooth
after that. Amazing that this is not documented in the help files, or
anywhere as far as i can tell.
"Tushar Bhatia(tusharb@microsoft.com)" wrote:
- Posted by Tushar Bhatia(tusharb@microsoft.com) on March 16th, 2008
My recent blog post elaborates how to migrate attachments in detail. The blog
is located at:-
http://blogs.msdn.com/crm/archive/20...n-manager.aspx
"GIJimmyj" wrote: