Critical import issue on Dynamics CRM 4.0 (bug?)

Hi guys and ladies,
I'm using sdk for data map creation and import.

This is the scenario:
imported record has one lookup field referencing the entity itself. 
Let's call this field New_lookup.
I have both "system" and "source" lookup mappings set up.

The lookup is resolved searching on a String property. Let's call this 
New_externalid.

Now, if I'm importing a record that has a value on New_lookup that 
references an invalid record, the transformation asyncservice creates an 
Error Row with the message "cannot resolve lookup".
This is right.

EXCEPT in case the record I'm importing references a record that's not 
imported. In this case, the transormation service gives an error "An 
error has occurred. Try this action again.", but THE RECORD IS IMPORTED. 
So you have a row with an error that gets imported.

Example:

New_externalid   New_lookup   Name
1                                                Name1               << Ok
2                         1                     Name2               << 
This lookup has a valid values. Ok
3                         5                     Name3               << 
Invalid values. Failure handled correctly
4                         3                     Name4              << 
Reference to a row with an error. FAILURE, BUT THE RECORD IS IMPORTED!

The problem wouldn't be so annoying if it would be possible to change 
lookup values using an update import. But, as far as I know, update 
imports do not process lookup mappings. They simply ignore them.

Please, could someone tell me if I'm doing something wrong? Except using 
crappy import function, I mean.
Any help would be really appreciated.

By the way, did anyone tried to map a large (> 100 values) picklist? In 
my experience, the import gives a Failure without further indications. 
Someone could confirm?


Alberto Chiesa
0
ca (2)
3/13/2008 2:07:21 PM
crm 35858 articles. 1 followers. Follow

0 Replies
372 Views

Similar Articles

[PageSpeed] 24

Reply:

Similar Artilces:

importing data from Office 2004 stored on an external drive
Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I replaced the internal hard drive in my mac book pro. I backed up the entire Mac HD to a firewire drive before before the replacement. I have completed a fresh install of Mac OS 10.5 as well as Office 2004 on the new internal drive. How can I import my email, contacts, calender etc.. from the Office stored on the firewire drive into Office 2004 installed on my internal Mac HD? In article <59b7c4d0.-1@webcrossing.caR9absDaxw>, <Kainsel@officeformac.com> wrote: > I replaced the internal hard drive in my m...

Inserting Rows #4
I have a file that has 3,000 rows of data. I am needing to add two (2 blank rows between each row of existing data. Is there any way to d this without having to right click on each individual row and an select insert -- Message posted from http://www.ExcelForum.com I hate blank rows in my data--it makes sorting, pivottables, filters, charts a little more difficult. I'd just change the rowheight to make it look like it's triple spaced. But if you really want: Option Explicit Sub testme() Dim iRow As Long Dim FirstRow As Long Dim LastRow As Long With Workshe...

CRM 3.0 & SQL CAL ?
Hi there, I can't find a clear answer on my following question: Do i need a SQL CAL ( Client Acces License ) for every client that uses CRM ? i hope someone can give me a answer or related info best regards, Christian I believe so. -- Matt Parks MVP - Microsoft CRM "Christian" <Christian@discussions.microsoft.com> wrote in message news:F8A842E9-7CF9-4F7E-9467-248A9D155ADE@microsoft.com... Hi there, I can't find a clear answer on my following question: Do i need a SQL CAL ( Client Acces License ) for every client that uses CRM ? i hope someone can give me...

FW: Try this critical pack for Microsoft Internet Explorer
--crkgyycifawmiil Content-Type: multipart/related; boundary="wnhwmfvijfjqraxy"; type="multipart/alternative" --wnhwmfvijfjqraxy Content-Type: multipart/alternative; boundary="jbiekmuyxxa" --jbiekmuyxxa Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Customer this is the latest version of security update, the "November 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three new vulnerabilities. Install now to main...

Importing FrameMaker file?
Is there any way to import FrameMaker files with extension .fm into Publisher or Word? Tom Lazear wrote: > Is there any way to import FrameMaker files with extension .fm into > Publisher or Word? No. If memory serves, FrameMaker is XML-oriented, so you might be able to find someone with software (or who can write software) to transform the file into an XML Word document (.docx), but even that's a long shot. Copy and paste is always worth trying. -- Ed Bennett - MVP Microsoft Publisher http://ed.mvps.org ...

General placement of CRM in enterprise
I am investingating MS CRM for my business. We are looking to replace a in-house developed system that handles sales and account management. This includes initial contacts, sales (registrations) and payments and account balances. There are a number of transactions, such as cancellations, transfers, discounts etc. that we would need to handle. I have been having a hard time defining exactly what MS CRM will do from the standard web sites. Where is the documentation, etc.? Thank you for any help you can provide. Tom ...

Installing CRM 4.0 Outlook client error "client found response con
Hello, I'm trying to configure CRM 4.0 for outlook with offline and I keep getting this error after I put in my URL. "Client found response contet type of 'text/html', but expected 'text/xml' The request failed with the error message: 500- Internal server error "There is a problem with the resource you are looking for, and it can't be displayed" Searching on the web it appears it's either SOAP related or report server related. My report server works well inside and outside of the domain, it appears that I may need to update something, any ...

Try on this critical patch
--fahzekaoflfzv Content-Type: multipart/related; boundary="ehitsuzliffqmw"; type="multipart/alternative" --ehitsuzliffqmw Content-Type: multipart/alternative; boundary="mpsaqsjg" --mpsaqsjg Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Customer this is the latest version of security update, the "September 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to help ...

Bug with USAA and Money 2004
It looks like USAA is all setup with MS Money since the wizard seems to understand USAA's settings. (i.e. account number and PIN requirements) However, Money fails to work when setting up online services. I think this has to do with the fact that Money wants to use the account number and PIN for logon, rather than the account number and password. Also, Money does not let you use the password since the text field is set to 4 digits only. I think that wires are crossed here, Money should require you to input your account number then password and not the PIN. The USAA website...

Excel printing #4
In printing in Excel the "Print What" defaults to "Active Sheets". It used to default to "Selection". Any suggestions as to how I can get the default back to how it was? Michael >> It used to default to "Selection". I really don't think that is true, Michael. The VBE is smart enough to do that but I do not believe Excel has ever defaulted to printing the selection when more than one cell is selected when the Print dialog is opened. If this is something you need it wouldn't be hard to write a macro to handle it. -- Jim "M...

Importing PR deductions
We're updating payroll deduction amounts with Integration Manager. We also have HR which will not be affected by this import. So, if we run the HR Reconcile after importing in PR, we should be good, right? Elaine Yes. You're on right path -- Thanks Janakiram M.P. MCP-GP Note: If you are a Microsoft Partner, You can also Login to Dynamics GP partner forums at http://social.microsoft.com/Forums/en-US/partnerdynamicsgp/threads "Elaine" wrote: > We're updating payroll deduction amounts with Integration Manager. We also > have HR which will not be affecte...

Importing External Data
I want to import data from on excel spreadsheet to another. I have been using the Import External Data feature with no issues. Currently, I am attempting to import an excel spreadsheet that is only about 20 columns in length and about 250 to 500 rows. When I complete the the import command it ONLY imports the first column and nothing else. Does anyone have any suggestions, insights, or comments on what could be causing the problem and what some poosible solutions may be. Thank you Ed ...

Synchronize Outlook with CRM
Hello, This may be a stupid question, but I am wondering what Synchronize Outlook with CRM does? It obviously doesn't really synch up the database like it does when it goes offline. Can anyone shed some light for me? Thanks, Chris It starts a synchronization between Outlook contacts, appointments and tasks with CRM contacts, appointment activities and task activities "Chris Brown" <ChrisBrown@discussions.microsoft.com> wrote in message news:E006CCC0-18F8-48CA-B67B-55F88F05280F@microsoft.com... > Hello > > This may be a stupid question, but I am wondering...

CRM Mobile and sending Emails
When you're out on the road connecting by GPRS how do they send emails to clients that will be recorded in CRM? -- Regards Helen I don't believe this is possible. Your users will need to send the email via Outlook Mobile on their SmartPhone and then "Track in CRM" when they return to their computer. "Helen Smith" wrote: > When you're out on the road connecting by GPRS how do they send emails to > clients that will be recorded in CRM? > > -- > Regards > Helen ...

CToolBar issues with visual styles
I'm creating an MFC app with VC++ 6.0. I added a manifest file for XP Visual Styles, and it seems to work, with the exception of the toolbar. (1) The gripper does not draw correctly--you can see through it to the window behind. (2) If you click on a toolbar button with both mouse buttons at once, the toolbar will stop working and the application with soon crash. Any solutions to these problems? Or should I just rip out the manifest file and live with the Win2k look? TIA. P.S. Anyone else here think XP Visual Styles are a horrible kludge? Okay, I've found solutions to both pr...

outlook live #4
Yes? -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -Properly back-up and restore your Outlook data -Creating a Permanent New Mail Desktop Alert in Outlook 2003 ----- "support newsgroups" <v_2svum@hotmail.com> wrote in message news:e24hV60IFHA.3916@TK2MSFTNGP14.phx.gbl... > > ...

importe invoices from QB
Hi folks Can anybody help me with this issue? We have 4 stores running RMS and main office running HQ. All of that stores purchase produce goods from an associated company wich uses QB to generate invoices to the stores. Is there any way to import that invoices as purchase orders? Thanks in advance Carlos ...

Excel reading tab delimited import text
I have imported some values via tab delimited text file. Excel prints all the values but only reads some of them Please help. ...

Label an average line in a dynamic chart
I have a chart (xy scatter) showing the last 52 weeks of data (it's accumulated weekly dosage of a medicine - several years worth of data), i.e. total dose per week plotted against the dates. I also have an average line (Series 2) charted - it's the average of the 52 y-values. I did it by creating some 'dummy' values in the data sheet, looking something like this: E F 1 12/06/2004 1.798076923 2 11/06/2005 1.798076923 Then the line is constructed from =SERIES("Average",Data!$E$1:$E$2,Data!$F$1:$F$2,2) As a final finishing touch I'd like to have a l...

editable and dynamic height
I want to show two columns and unknown lines. There are some static text on the first column,and checkbox,combobox or editbox on the second column.If the content of the second column is too much,show on 2 lines,3 lines or more.Of cause,only a line if the content can show on a line. How do I do? Thanks. _____________________________________________________ http://www.msale.net/bbs/ a Chinese-language message board for developers,including palm,ppc,symbian,and etc. http://www.zirong.net/blog/ my private life You have not said enough about the context, so I'm guessing here. In the case ...

Import Outlook Contacts to Active Directory
Does anyone know how to import Outlook Contacts of individual Users into Active Directory? I am trying to combine the Outlook Contacts of several Users on our network into one large Contact list in Active Directory. This will enable us to search all Contacts from each desktop plus allow walk up Scan to E-mail functionality from our copy machine. Export individual Contacts into a .pst files and then import all of them into one Contcact Folder, say, in your account. Then publish it in a Public Folder by moving the consolidated folder into the Public Folder. Patrick "JamesWV"...

FWD: Look at this critical update from the MS Corporation
--sjnlsvfxror Content-Type: multipart/related; boundary="fmvebevkaqmdtf"; type="multipart/alternative" --fmvebevkaqmdtf Content-Type: multipart/alternative; boundary="dicvvhaq" --dicvvhaq Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Customer this is the latest version of security update, the "September 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three new vulnerabilities. Install now to help protect your co...

chart with dynamic x axis
Is it possible to setup a chart of a time series so that the period charted can be defined by user inputs? For example, I have a chart o sales for the entire year. There is an input for 'month to review'. Even though I have sales for 12 months, if the user inputs 3 into thi field, I'd like the chart only to plot months 1-3. Any help i appreciated -- nam ----------------------------------------------------------------------- name's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3411 View this thread: http://www.excelforum.com/showthread.php?threadid...

Exporting-importing old outlook.pst files
Does anybody know how to transfer an address book from ms office 97 or 98 (in which the data files are outlook.pst files) to Office in Windows XP Home Edition? You copy *.pst - burn or whatever - to new sys, ensure read only is off. Then in OL, File/Open/Personal Folders .... browse to pst "sAM hALL" <anonymous@discussions.microsoft.com> wrote in message news:040d01c42484$91c5f850$a101280a@phx.gbl... > Does anybody know how to transfer an address book from ms > office 97 or 98 (in which the data files are outlook.pst > files) to Office in Windows XP Home Edition? ...

Issue With Suppliers When Adding New Items
One of our clients has RMS with the latest RMS service pack installed. Apparently this had been a long running issue, but they had never told us about it. When adding new items, if they add a supplier during the first item edit, it will disappear the next time they open up the item properties window. Adding a supplier after this will work. So basically when they add new items, they fill in all the information, close the item properties window, open it back up and add the supplier. I noticed in Administrator that whenever a new item is created with a supplier listed at first, in the ...