RE: What's the proper lookup fieldformat for importing products by CS
CS
Tue Mar 18 02:05:00 CDT 2008
Hello Ray,
I am having the same problem
I have been tring just with a few products and the necessary valueshere is
the file i am using
Productname,ID,currenciy,unit,unitg,decimal
CRMprod1,CRM-CA-PRO,"transactioncurrencies,{F425745A-67EF-DC11-9FB3-00104BD27F1C}","uomschedule,{7C1BA26A-47FD-DB11-A8E4-00104BD27F1C}","uom,{7D1BA26A-47FD-DB11-A8E4-00104BD27F1C}",2
I had no success with this, up to now.
the format looks to be working fine with account a contacts
meaning if you try to use this to import a contact and link it to an account
it is working:
lastname,firstname,parentcustomer
cs,cs,"account,{GUID}"
Hope we find a solution for this
personally I could just creat my own import tool but it is not what the
customers a looking forward to when they see the import option in CRM 4
BR
Claudio
"Ray Flowers" wrote:
> I tried using both the Import feature in Data Management as well as the
> Dynamic Data Migration Manager to get a csv product list imported into CRM
> 4.0 and I keep running into issues with the Unit and Unit Group lookup
> fields. I have tried using the GUID as well as the name for each lookup
> record and I get a â??The source data is not in the required formatâ?? error. I
> also read a post somewhere about formatting the values in that field like
> this â??[Account Entity],[GUID]â??. When I do that I get the message â??An error
> has occurred. Try this action again. If the problem continues, check the
> Microsoft Dynamics community for solutionsâ?¦. â??. I was wondering if anyone
> could shed some light on the proper format to use for the lookup field
> values. Thanks.