- Data Import - Contacts - Parent Customer Reference Lookup
- Posted by ANeal on March 25th, 2008
I've finally got the DMM installed and accessing CRM Live instance. However,
when I go to load contacts and reference Parent Customer to link to Accounts
already loaded in the CRM I keep getting an error that the lookup reference
cannot be found.
I've tried various formats:
"account, {GUID}"
"account","{GUID}"
"actual account name, {GUID}
{GUID}
account name
Anyone know the correct format?
- Posted by Kamal on March 25th, 2008
it needs to be "account, {GUID}"
for example:
FirstName,LastName,ParentCustomer
Kamal,Hitari,"account,{BB51BC3D-98EB-DC11-9C73-0002B3C73EB0}"
For more, follow this link:
http://forums.microsoft.com/Dynamics...6322&SiteID=27
--
Kamal Hitari
MBSS, MCNPS, MCTS
2B.net Ltd
http://kamalhitari.blogspot.com
ANeal wrote:
- Posted by ANeal on March 25th, 2008
Kamal - I've tried that and again I tried again this morning but that format
does not work. Please see error code below:
Column Heading Column Value Error Code Description More Information
Parent
Customer account {5F67282E-DDF2-DC11-B259-0018FE332CC6}"" -2147220653 The
lookup reference could not be resolved.
FirstName LastName Parent Customer Realtor
Matt Walsh "account,{5F67282E-DDF2-DC11-B259-0018FE332CC6}"
I'm not sure if the "account,{GUID}" then pushes it to another column?
Also, I've changed account's display name to be Real Estate Company but I
don't think that affects anything.
"Kamal" wrote:
- Posted by Kamal on March 26th, 2008
ANeal wrote:
Email me the csv file, it could be an extra or missing comma that
shifting the columns across the left or right.. csv file is a pain.
trust me.
Alsom have you got access to the database?
Are you able to get any details on the guid you are using?
SELECT * FROM FilteredAccount
WHERE accountid = '5F67282E-DDF2-DC11-B259-0018FE332CC6'
you could be using the wrong guid, it's just something else to check on
as the way i showed you is the only way to do it and tried it many time,
it worked fine for me.
--
Kamal Hitari
MBSS, MCNPS, MCTS
2B.net Ltd
http://kamalhitari.blogspot.com
- Posted by Kamal on March 26th, 2008
Email me the csv file, it could be an extra or missing comma that
shifting the columns across the left or right.. csv file is a pain.
trust me.
Alsom have you got access to the database?
Are you able to get any details on the guid you are using?
SELECT * FROM FilteredAccount
WHERE accountid = '5F67282E-DDF2-DC11-B259-0018FE332CC6'
you could be using the wrong guid, it's just something else to check on
as the way i showed you is the only way to do it and tried it many time,
it worked fine for me.
--
Kamal Hitari
MBSS, MCNPS, MCTS
2B.net Ltd
http://kamalhitari.blogspot.com
ANeal wrote:
- Posted by Andrej Torbica on June 19th, 2008
I've noticed same problem while importing Invoice Product. I even reduced the
number of CSV "fields" for import hoping for bigger chance for success. In
either case, it results with error.
As you mentioned, I checked access to database and existance od GUID in
Invoice table. So far, nothing. Any hint?
Any movement on "ANeal" case?
Tnx, Andrej
"Kamal" wrote:
