Moving data to custom entities

I have a customer in the Financial Services industry that would like to 
upgrade to 3.0.  Part of the implementation will be creating a custom entity 
to store portfolio information (life insurance, diability, Dental, etc.). 
This data is currently stored in a SQL table from another application.  I 
would like to move this data from its current location to my customer 
entity.  Do I have to use data migration framework or the sdk to do this or 
can i just do this within SQL?
Thanks. 


0
Danielle
1/12/2006 8:19:44 PM
crm 35858 articles. 1 followers. Follow

1 Replies
560 Views

Similar Articles

[PageSpeed] 54

Ideally you would use the SDK to move the data. The DMF probably won't work for you (I'm not sure if it deals with custom entities out of the box or if you'll have to do a bunch of work to make it happen). You don't want to write directly to the database because you'll run into issues where the platform augments the data and you don't have those rules handy (they're in the platform code). Plus, if you write to the database you run a risk of supportability problems.

Mj Miller
Microsoft CRM Technical Lead

** The opinions and comments in this post are my own and in no way reflect the opinions of Microsoft or the Microsoft CRM team. This posting is not an offer of support, either immediate or ongoing, and no support is implied. Some of the information posted may include non-supported workarounds and code samples.
0
mikemill_
1/13/2006 12:44:26 AM
Reply:

Similar Artilces:

password & 01 data
Hi, I bought an oem product on e-bay & can't get the free tech. support. Any assistance appreciated. I installed 04 & money asks for a password. Beats the heck out of me. No recollection of using password before in 01. Tried all kinds of e-mails, passport, .net, etc. No go. Need assistance. Also, once in 04 how do I access my 01 data. I downloaded 04 trial of the ms site. Never could open the 01 data. Thanks in advance, John. ...

purge the discoonect mailbox after moving mailbox task failed
Hi all, Unfortunately, moving several users' mailboxes to the new exchange 2003 server failed at the first time; I ran the second time again on the different store on the new server sucessfully. but, the mailbox failed on that store has red x on it and I tried to purge and ccould do it as it already connected to the existing user? Any solution to this? Thanks. ...

Automate data labels
Is there a way in Excel 2003 to update data labels in existing Pie Charts. Everytime I run a new report I have to delete old data labels and then format my labels as needed. Typically the format I use is label value (%). Hi, I take it you have custom data labels, because the regular ones showing Value, Series Name, ... update to reflect the data range. If you have customized your data labels manually, then instead of entering data into the data labels create references to spreadsheet cells, this must be done manually. Suppose the data labels you want are in the range D1:D5 then sel...

Best way to serialize unknown data
Hi there, What is the best way to serialize unknown data? I have a class that contains a list of parameter objects. The parameter has a value which can be a simple value of a complex class, e.g. class param { object value; } When serializing, I must always have the same name for the value element. I've looked at 2 approaches: 1) Value is of type object. XmlSerializer MUST know the object's type. 2) Value is of type XmlElement. XmlSerializer doesn't care about content. Which is better? 1 is easy but has a limitation, 2 is more work. In addition, the receiver of the xml does ...

Updating a field's data to another field in same table???
I hope I make sense. What and how is the best way to update a field with data from another field from the same table? Everything from Field 1 to Field 2. Thank you in advance for any help you can provide. See: Calculated fields at: http://allenbrowne.com/casu-14.html The article describes how - and, more importantly, when - to store a field that depends on another field. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "TotallyConfused" <...

Apology for insuffient data on IE problems
I've never post to a forum before so I let my other half do it for me, and for that I am sorry. My problem started 2 days ago when IE 7 quit opening internet pages. I have a Dell laptop running windows XP Professional. I am using a verizon mifi for the internet. Intel Wireless WiFi Link 4965AGN is the wireless that cam with the laptop. IE7 was working fine, then 2 days ago it started bringing up a page saying internet explorer cannot display internet page. And this: ('Customize Your Settings' (http://go.microsoft.com/fwlink/?LinkId=74005)) is what is in the address ...

locking objects so they dont move on Pub 2000
Im trying to lock text and picture boxes so they dont move, ive done this in other programs but can i be done in Publisher 2000?? If so does anyone have any suggestions?? Thanks There is no way you can lock objects. They can be put them on the background which will keep one from inadvertently moving the objects. You can group them altogether and then create a rectangle the size of the page with no line and no fill. This will make it difficult to select the objects. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Worker&quo...

Importing data into money
I recently purchased Money to replace, hopefully, a DOS- based system I wrote myself. I have years of transactional data which I want to incorporate and which I can convert to almost any format (including any MS Office format) for import into Money. It appears this can't be done, unless I can get it into Quicken format. But if I get it into Quicken, why do I need Money? Am I missing something? If not, I have a brand new Money for sale cheap. Lew Shepley In microsoft.public.money, Lew Shepley wrote: >I recently purchased Money to replace, hopefully, a DOS- >based system...

Can I have 2 customer ID's roll up into 1 invoice
We have a customer that buys 2 different lines of our product. Currently we are using 1 customer ID and putting both lines of product on the same order & invoice. For reporting purposes, we need to be able to divide the different lines into separate divisions. We still need to input both lines of product on 1 order/invoice. Any thoughts? -- Phil Camp Director of Information Hopkinsville Milling Company What kind of reporting are you talking about Phil? There are a number of ways of classifying product that will enable segregation on reports. Frank Hamelly MCP-GP, MCT East Co...

Id months inlcuded in data set for text string
Hi, I am having some trouble coming up with a way to create a text string that ids the months included into a custom data set. My structure is as follows: Jan Feb Mar Apr ---> Dec 1 3 In the example above the data set contains Jan & Mar. I want to create a title that lists the months used. ex. Months Included: Jan, Mar Any thoughts as best way to elminate spaces and get what I am looking for? Thanks in advance, Greg I assume your 1 and 3 values are in cells a2 and c2 In A3 enter...........(You may have to insert a row) =IF(A2="","",...

Why isn't data that is automatically generated in my form showing up in table?
Ok, I've been messing with this problem all day (for those of you who have been following me, I'm so sorry!). But I think I finally figured out the root of my problem. I have created a form that allows users to enter in an employee's clock number using a combo box and it automatically generates the employee's name in a text box next to it by pulling information from the Employee Data table. This data shows up fine in the form view and the datasheet view. However, when I open the table up that this data is being saved to (Weekly Data), the data that has been automatically...

Extracting data from multiple rows
I have a list of 40 records in one column, each record about 20 rows long, with different data, but with the same field headings (100, 245, 260, etc.) that looks something like this: 100 Joe Smith 245 Book of home repair 260 Simon and Shuster 440 Language tape 500 Audio File 655 Audiobook 856 Bibliographic record URL 994 Location designation 100 Mary Jones 245 Cooking light 260 Random House etc. If I only want to view certain fields, like 100 and 245, how can I extract that data from all the records and create a new table with that information? Like this: 100 Joe Smith 245 Book of home repa...

cancel event if data change
Hi there, I have a main form with a sub-form and code at the before update event on the date field under the main form, I would like to bypass/cancel the before update event if the user change the date after entry. I mean that when the user enter the date (new record), the before update event wil be executed. If the user change the date (immediately or after record saved), I would lite to bypass/cancel the before update event. Hope this clear for you. Appreciate for your expert comments. Thanks in advance! On Nov 29, 8:06 am, Andy <A...@discussions.microsoft.com> wrote: > Hi th...

pulling data from one workbook to other one and back
Hi All, On the sheet A I created the form is to be completed by a few people Always after completing the form data are transfered to the sheet B i the same workbook (database.xls). Then the A sheet is saved as a ne workbook (new1, new2 etc) in the different directory. What I like to have is connection between the new workbook (new1, new etc) and sheet B. New1, new2 etc are current value (text) from F3 in and column B in B sheet. Is it possible to create a macro or somethin to enable following. When I click on ex. B2 (=new1) in B sheet it caus automatically openning of the appropriate file (n...

Moving Average based on criteria
Dear all, Can somebody please help - i have a query about 'averages'. I have an excel 2000 worksheet with the following array formula: - =AVERAGE(IF((((MONTH(A6:A500)>MONTH(AU7))*(YEAR(A6:A500)=YEAR(AU7)))* ((MONTH(A6:A500)<MONTH(AV7))*(YEAR(A6:A500)=YEAR(AV7))))*((Z6:Z500)=AS7)* ((H6:H500)=AO8)*((AA6:AA500)=AT7),AB6:AB500,"")) where the values to look up are: A6:A500 - dates i.e. 01/01/2001 AU7 - is a cell where i state my 'from' date AV7 - is a cell where i state my 'to' date AS7 - is a cell where i state if 'closed' ...

The tab key moves from A to L all of a sudden, how do I fix it please
Our secretary is bothered by the fact that her tab key advances from A to L all of a sudden. It just made that change today. How can we fix it so it goes jus to the next column instead all the way to L. Many thanks.........Peter Double check these settings. Tools->Options->Transition Microsoft Excel Menus should be selected, and the 3 tick boxe (Transition navigation keys, etc) should all be unticked. I think that should fix your problem. Hope it helps. -Bo -- Message posted from http://www.ExcelForum.com AAAAAAAAAAAAAAHHHHHHHHHHHH......I appreciate you very much, it worked. ...

Sales Order Customization
Hello. I have a pretty complex need of a custom sales order screen. I intend to develop a Web Application for Sales Order with a Single form to enter Header as well as Products. I can Add this Web Application to the ISV Tab and I can generate a CRM Order from my WebApp using CRM SDK. Couple of Questions: 1. When the User Clicks on the New Order Button or Picks up an existing Order, Is there a way to Default the Tab to my Custom Tab instead of the CRM Information Tab? 2. How can i remove mandatory field constraints like Price List in Sales Order? Is it possible? 3. Is it Possible to Embed ...

Extract data fm cell
Hi...I have a cell that contains a first and last name [Bill Gates]. I need to extract the first and last into two cells [Bill] [Gates]. I'm stuck, I'm guessing the Left, Right or Mid function is involved but I'm not smart enough to figure it out... Help is greatly appreciated! Have a great Friday, steve If you want to use formulas, you could use something like: =LEFT(A1,SEARCH(" ",A1)-1) (for the first name) and =MID(A1,SEARCH(" ",A1)+1,LEN(A1)) for the second name. If you have a whole column of names to fix, you may want to insert a column to the ri...

Data Analysis
I recently updated to 2003 and when I did my data analysis capabilities disappeared. How do I get that back? If you don't find the Analysis Toolpak Add-in in Tools>Add-ins, you may have neglected to install all components during the update. If the second case, do a "Change" in Control Panel>Add/remove and install the components needed to "run from my computer". Gord Dibben Excel MVP On Tue, 5 Apr 2005 09:51:10 -0700, Dunamaswoman <Dunamaswoman@discussions.microsoft.com> wrote: >I recently updated to 2003 and when I did my data analysis capabilities...

"Move to folder" doesn't show folder labels
Outlook 2007, Windows 7: The "move to folder" command only shows the icons, not the folder labels/titles. I have to guess which folder might correspond to the subfolder I want to move an e-mail to. How do I get the labels/titles to appear? I've used Outlook for 6 years -- including OUTLOOK 2007 SINCE 'O7 and never had this problem until I migrated to Windows 7. Help!! Thanks. "Teragram7" <Teragram7@discussions.microsoft.com> wrote in message news:ED0276B0-703E-4269-96DC-D4327743EA17@microsoft.com... > Outlook 2007, Windows 7: The "...

Data collection Form Edit
We have a form which will be used almost daily, for data collection, based on a query. During the test we found a typo in one of the field labels where a brief description is included. Is there some way to edit the form? (recreating it with all the custom lables is just too long a task). Another issue on this topic, every time the form is sent, the messge reverts to the default "Please fill out the form and retunr it to me". Can this default message be changed? Nothing in the help functions. Any advice, or deirection to a learning resource will be appreciated. Thanks is adva...

Error on Crystal Report when using custom field
When I run one of the canned crystal reports (like Case Summary) and try to use one of my custom built fields, I always get this error: Error in formula This field name is not known.. File a4c34756b Is there something obvious I'm missing? All I'm doing to add the fields is to go to Deployment Manager and adding a schema field. Am I supposed to sync that with a crystal db or something like that? Thanks for anyone who can help. ...

How can I move my filtering settings to a new installation?
Dear friends: How can I move my filtering settings (Outlook XP) to a new installation (Outlook 2003) in a newer machine? Which settings files should I copy from the older machine to the new one? Thanks Juan I. Cahis Santiago de Chile (South America) Note: Please forgive me for my bad English, I am trying to improve it! Hi Juan, By the filtering system do you mean the junk email list in Outlook. In Otlook click on tools>options> junk email options and you can export the files to the desktp and then import them back into Outlook. Sharath "Juan I. Cahis" <jiclbchSINBASU...

Append data if a duplicate found
Hi one and all Want to do a look for duplicate and if yes then append data. Example Column 1 Column 2 1234 product1 1234 product 2 1234 product 3 i would like it find where column 1 contains a duplicate then if yes append the data or copy it into column 2, and 3 and 4 Column 1 Column 2 Column 3 Column 4 1234 product1 product 2 product 3 1234 product 2 1234 product 3 Possible? Thanks If possible also to mark in column 5 as a dup like this Column 1 Column 2 Column 3 Column 4 Column 5 1234 ...

How do I shrink an xlsx file after cutting a big data worksheet?
I deleted an Excel 2007 worksheet that contained lots of data (approx. 40% of initial spreadsheet size). It resaved to the disk at its previous disk size. What do you do to save the file in its new, smaller size, i.e. compress it? I'm new to Excel 2007, previously using Excel XP, so I figure there is some option to check/uncheck to make this work. I just haven't found it yet. Thanks for the pointers. If you deleted a worksheet itself the file size will be smaller. If you simply cut or cleared the contents of a worksheet then Excel thinks those cleared cells are still bein...