Data migration issues

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Crm
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Search records occurring on Saturday Hi, I have a request to return all records this year with a date falling on a Saturday. Does anyone know how to do that using Advanced Find, or otherwise? How to select all dates in a period of time that fall on a particular day of the week! Thanks, Mo Tag: Data migration issues Tag: 83732
  - 2
    - How do we close an invoice in version 3.0? In version 1.2 we had an Action on the toolbar to close the invoice. Now we have nothing. I tried customizing the form and adding the statecode, but that field is Read-only and so it didn't help. We mass-print all of our invoices and need them to be closed (not deleted) once they are paid. HELP! Thanks, Karla Tag: Data migration issues Tag: 83729
  - 3
    - Populate fields in forms with data from CRM 3.0? Hi all. Is it possible to gather data from CRM 3.0 ("Accounts" in our case) and use it to populate a drop down field in a SharePoint form? We're running MOSS 2007 Enterprise so BDC is an option if need be. I haven't checked out the downloadable web parts for CRM connectivity yet but as far as I can tell they're not for this kind of functionality. Tag: Data migration issues Tag: 83726
  - 4
    - Email Time Out Errors receiving this error from CRM only. Could not deliver the message in the time limit specified. Please retry or contact your administrator. <folders.com #4.4.7> Need some help please. Tag: Data migration issues Tag: 83725
  - 5
    - Reporting Services Export to MS Word Option I recently learned that there's an ISV plug in to SRS that allows for an Export to Word option. But I've had more than 5 clients asking if this option is in the works for a future update/version. Does anyone have any info regarding this? Tag: Data migration issues Tag: 83720
  - 6
    - BlackJack compatiability with CRM Mobile 3.0 Is anyone running CRM Mobile on a BlackJack? The BlackJack runs Windows Mobile 5.0, but only has a 2.3â?? screen. Microsoft's minimum requirement is a 3.5" screen. http://download.microsoft.com/download/d/a/6/da6e13a1-256c-4ba9-a301-4d059147a2c0/dynamics_crm_3.0_mobile.pdf Iâ??m not sure if this will be a stumbling block. Thanks for reading. Tag: Data migration issues Tag: 83718
  - 7
    - moving reports server(old server decommisioned). Hi- We have CRM3.0 running on a server and have the database on a separate server and the reports were installed on a third server. Unfortunately the reports server was decommisioned before the reports could be migrated to a new reports server. I now need to setup the reporting again(effectively from scratch) but cannot fund the info on how to do this. Can someone point me in the right direction, do I need to run crm setup on the crm or reports server again? After that I know I need to setup the delegation etc but am stumped on how to actually install the reports on the new report server. Have read kb's re moving server but unfortunately don't have access to the old one anymore. TIA. Jez. Tag: Data migration issues Tag: 83717
  - 8
    - Tab order I am in version 3.0 of CRM. One of the user defined fields that I have is a pick list that opens a calendar drop down. When the user selects a date from the calendar, the tab order goes back to the first field. However, if the user writes the date in (without using the picklist) the tab order goes to the next feild as it should. Any thoughts on this? Thanks Tag: Data migration issues Tag: 83710
  - 9
    - Reports I have created a user within CRM 3.0 and added them to the roles Sales Manager and Marketting Manager When they click on the Reports option within Workspace, no reports are displayed. As a sysadmin they display for me. Where have I gone wrong ??? Thanks Tag: Data migration issues Tag: 83709
  - 10
    - Error On Report Hello, We had created a report in visual studio and imported in MS CRM. This has worked fine for a while. Now when we run this report we get the following error: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for data set 'Contraste_Europe_MSCRM'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors I noticed one thing, when we run this report with a user with domain admin rights, the report works. When we run this report as a normal domain user, we get the error. I enabled remote errors in the webconfig file on the sql server, but i receive no more info. has anyone an idea what could be wrong. thank you in advance Tag: Data migration issues Tag: 83708
  - 11
    - Multiple CRM organizations Hello, We are a microsoft partner and currently setting our first steps in the CRM environment. We are situated in a building with multiple small organizations and we are searching for a solution to host CRM for all these organizations on one server. I received a CRM 3 SBE edition to test with and installed it in a test environment. The problem here is that I see no way how to add multiple organizations in CRM. Can somebody please explain to me what is exactly possible in a situation like this and how it can be fixed? Best regards Ruben Tag: Data migration issues Tag: 83707
  - 12
    - CRM performing slowly Hello All, we have a CRM3.0 installed, but the users are complaining about bad performance. I have the following questions: - how/where do I see what is the version of CRM installed on the server? - how/where do I see what is the version of CRM installed on the client? - where do I download the latest version? - the client installation is "destroying" the Outlook, and sometimes our VPN connection, and in the worst cases we were in need to re-install the machine - any help? - how would I troubleshoot My-CRM-Is-Slow issues? Our CRM server is installed with SQL 2005 server. Thanks in advance! Tag: Data migration issues Tag: 83701
  - 13
    - Workflowrule start Just to get something clear: When exactly does an OnCreate workflowrule start monitoring the record? Is that upon clicking for example 'New incident' (rule starts looking but if form is closed without saving the rule is deleted again?) or is that (seems more logical to me) after the very first 'Save'/'Save&cose' (thus actually creating the record). Tag: Data migration issues Tag: 83694
  - 14
    - Workflow Manager CRM 3 How can I install the workflow manager on a PC to manage my CRM server over the network ? Thanks in advance Tag: Data migration issues Tag: 83693
  - 15
    - Import of Data Hi Guys Is their a way that when data has been improted into contacts in CRM, a tick box is automatically selected on the contacts screen. E.g Have a checkbox called 'Cross' which needs to be ticked when the data has been inserted for all new imported contact records. Thanks in advance Tag: Data migration issues Tag: 83692
  - 16
    - Sync Service Calendar with Exchange I would like to Sync our service calendar with our exchange server, our engineers have windows mobile devices and will receive appointments on those wirelessly from the exchange server. They don't necessarily have to sync their laptops everyday then. How can I do this? Tag: Data migration issues Tag: 83690
  - 17
    - Elapsed time tracking for cases Hello, I am trying to convince MSCRM to calculate an elapsed time value from the create date/time of a case through to either the current date/time (for non-closed cases) or the resolved date/time (for closed cases). Complicating this is the need to be able to stop the timer incrementing when the case is put on hold, and outside of our support hours (9am-5pm). For example, if a case is created at 4:50pm and resolved at 09:10 am the next day only 20 mins will show on the elapsed time counter. We need this for SLA tracking and calculation, and the elapsed time value needs to be displayed on the case form itself. Any suggestion will be gratefully received. Thanks Tag: Data migration issues Tag: 83689
  - 18
    - Outlook 2007 client problem I have one install were Outlook won't open links from crm. When I click view regarding in Outlook screen flashes, but nothing happens. On task manager I see that IEXPLORER.EXE starts and closes. Webclient works just fine. What could close internet explorer automatically when I try to open links from Outlook. Tag: Data migration issues Tag: 83682
  - 19
    - Disabling secton in a tab I am working in Microsoft CRM 3.0, I want to disable or invisible some sections. Thanks in Advance -- Jaber Tag: Data migration issues Tag: 83678
  - 20
    - Disabling Sections in a tab. C -- Jaber Tag: Data migration issues Tag: 83676
  - 21
    - Disable Tabs I am working on CRM 3.0 and I want to disable or invisible a tab. Is there anyone can able to help me. Thanks in Advance. -- Jaber Tag: Data migration issues Tag: 83671
  - 22
    - Problem with asssociated view There are few columns that I have added up in the associated view for a customized entity but it did not showing the value for some columns, where as it is showing the value for same columns in the other view. Need help badly Thanks in Advance -- Jaber Tag: Data migration issues Tag: 83665
  - 23
    - Reporting on Responses to Campaign Activities I am trying to find a way to use a Campaign Performance report to run the following report with the following conditions: How many new contacts were created as a response of them filling out a form in several monthly journals (campaign activities, in CRM terms). Forms have codes to help track the issues. No sale process is involved. Basically, I would like to include a sub-report in the Response channel section (Journal1, Journal2, Journal3) that will group new contacts created as their response to a particular activity (Journal1 January 2007). Adding a customizable filter (Pick your activities...) will help. Am I on the right track? Any comments and ideas will be appreciated. Tag: Data migration issues Tag: 83660
  - 24
    - Reporting on Responses to Campaign Activities I am trying to find a way to use a Marketing module in general and Campaign Performance report in particular to run a report with the following conditions: How many new contacts were created as a response of them filling out a form in several monthly journals (campaign activities, in CRM terms)? The goal is to measure the effectiveness of different ads. Forms have codes to help track the issues. No sale process is involved; just need the count of new contacts. Some customizations were made to the campaign response entity to include the appropriate response channel and code. Responses point to the activity corresponding to the month of the publication. Basically, I would like to include a sub-report in the Response channel section (Journal1, Journal2, Journal3) that will group new contacts created as their response to a particular activity (Journal1 January 2007). Adding a customizable filter (Pick your activities...) will help. Am I on the right track? Any comments and ideas will be appreciated. Am I on the right track? Any comments and ideas will be appreciated. Tag: Data migration issues Tag: 83659
  - 25
    - Error message in the Event Log I get this error message on the CRM 3.0 server. Everything seems to be Ok as far as application is concerned. Does anyone know what it means? Any reasons to worry about? Thanks in advance! ------------------- The description for Event ID ( 1000 ) in Source ( c:\windows\system32\inetsrv\w3wp.exe ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: w3wp.exe, 6.0.3790.3959, 45d6968e, crmobjectmodel.dll, 3.0.5300.1555, 45e0019f, 0, 001c79f7. Tag: Data migration issues Tag: 83658
- Next
  - 1
    - Mail merge template not saving settings I have created a mail merge template for our labels. I have marked the option to always print the country as well as re-mapped a couple fields. I applied these to all the address blocks. When I re-use this template, those settings are gone and I can only update the first label to add country and re-map as there is now no "update all labels" when using a template. I do not want to have to have the users enter the type of label, margins, font size, mapppings etc. Why is CRM overriding these settings? Tag: Data migration issues Tag: 83652
  - 2
    - isDirty attribute hello everyone, I'm working with crm 3.0 and got the following issue. I have some fields that are disabled for the user, but are showing data calculated from other fields. When I save the form I enable them, otherwise they would not be saved. That works fine when the user uses the Save & Close button. But when the user click on the Save button and he hasn't made any changes, the disabled fields become enabled. I've been trying to workaround this problem, but with no result. I tried to use the OnLoad event to disable the fields everytime, but when the Save button is clicked the OnLoad event doesn't trigger. I tried to modify a fields value and return it back to its original value to get that field isDirty attribute to true, but that didn't work either. Is there a way to set a field's isDirty attribute to True programmaticaly? Any help will be appreciated. Thanks Eduardo Tag: Data migration issues Tag: 83643
  - 3
    - CRM, Outlook and Cookies My office is currently running a CRM 3.0 Professional install and I have successfuly installed the CRM client for Outlook on a CSR's system, but when I open Outlook I am getting the following error: "Your Web browser options are currently set to disable cookies. Microsoft CRM requires cookies to use the Web client. To enable cookies, see the online Help for your browser" On this users system I have enabled all cookies in their IE properties and the CRM server is listed in their Local Intranet zone. At this point, IE is set to the lowest possible settings and Outlook is still throwing this error out at me. I have two systems that the CRM client is currently working successfuly on and I can find no difference between their browser settings and this problem install before lowering it's security levels. I'm unsure as to what the next steps should be for troubleshooting this issue. Any help? David Bracht Sr. Network Administrator Business Integration Group www.bigcenter.com Tag: Data migration issues Tag: 83637
  - 4
    - Email to Case Email->Description Formatting Ok, interesting problem here. I have written a Workflow that creates a service request from an email that is sent into the Q. THis is working great. One big problem is the formatting of the text of the message if the email has been sent formatted in HTML. When I send this to the description field in the Service Request, I get all the HTML formatting and the email is difficult to read. My preference would be to keep this formatting, but the description box is not html enables. That leaves me with getting just the plain text out of this and sending it. Does anyone know the method of converting this email info to plain text. Tag: Data migration issues Tag: 83633
  - 5
    - Sync Issues - outlook 2007 Ok, I've seen other people run into this, but it seems no-one has an answer to it: Symptoms: Your "Sync Issues" starts getting clogged with entries named "Synchronization Log" and with an error description "Error synchronizing message...". It happens whenever somebody else starts creating appointments and and uses the "track in crm". You get it every time your outlook tries to sync. with the Exchange server; on my laptop, around 2 mails/minute. You also get a copy of the calendar entry in the "Local Failures", virtually doubleing the number of entries. Last time i reviewed my Sync Issues folders, I had more than 100.000+ emails, causing Outlook to perform slowly (problem with large PST files). I'm using: - Outlook 2007 - Exchange 2003 - MS CRM 3.0 How to reproduce: Create calendar entry in your outlook 2007. When entry is open, click "track in CRM" and "Set regarding". After first exchange synchronization, the sync issues starts popping up in other peoples mails. -- Best regards, Lars FlÃ¸e Nielsen Solution Architect Tag: Data migration issues Tag: 83632
  - 6
    - Multiple price lists per quote When quoting, it would be helpful to be able to access all price lists for a customer, outside of their default list. This is particularly useful for short-term promotions, and would eliminate the need to create multiple versions of the same product across many lists. Ex: add new existing product, select from default list or click to the change price list, select product. Does anyone know if this function exists now, and I'm just missing it? Tag: Data migration issues Tag: 83630
  - 7
    - Error When Promoting Emails Any ideas what can cause this error: An error occurred promoting this item to Microsoft CRM. The Microsoft CRM server could not be contacted or the user has insufficient permissions to perform this action. Do you want to send the email? If you click yes, the email will be sent out, but no corresponding activity will be created in Microsoft CRM Users have appropriate permissions. Tag: Data migration issues Tag: 83629
  - 8
    - Change "Account" to "Company" in Navigation pane Ok, what am I missing here. We don't want to call companies "Accounts". So I went and changed the "Account" Entity "Name" field to "Company" (and the corresponding plural name to "Companies". However, in the navigation pane, it still shows up as "Accounts". What am I doing wrong? Do I need to edit the site map for this? Thanks, Elie Wildman. Tag: Data migration issues Tag: 83625
  - 9
    - HIPAA Standards Hello, Does Microsoft Dynamics CRM support HIPAA Standards for electronic transactions ? Take care, Dave Tag: Data migration issues Tag: 83624
  - 10
    - Email Tracking We're having problems with inbound email not tracking in CRM. I've verified out setup based on the implementation guide (install location, server side rule, users set to accept all unsolicited emails, etc...) and inbound emails don't get tracked in CRM. We have tracking tokens off. When I log into the CRM mailbox, the majority (99%) of the emails forwarded end up in unresolved. Anyone else having problems with inbound email tracking? Anyone actually have inbound email tracking working? Tag: Data migration issues Tag: 83622
  - 11
    - Quick Campaign Notes do not list in the contact directly Hi, I have no glue if I do make something wrong or this is by design: When I make notes to a contact within a quickcampaign this note is not in the history and it is also not in the main notes of the contact. IMHO notes to a contact of anything should be found in the main notes, no matter where the come from. (Is there a filter or something I could change - if it is that way) best regards Antonio Tag: Data migration issues Tag: 83620
  - 12
    - Email Templates and Outlook When creating an email from CRM Outlook client, is there anywhere to access the email templates that are in CRM? It seems that email templates are only available if you use the web client. If this is true, has anyone been able to design or update the email form in Outlook to pull/merge CRM data? Thanks, James Tag: Data migration issues Tag: 83618
  - 13
    - Is it possible to add further contacts to the quick campaign after Hy, Why is it not possible to add more contacts to the quick campaign after it started. Do I make something wrong? Antonio Tag: Data migration issues Tag: 83617
  - 14
    - Outlook client error Does anyone know how to resolve this issue. Since today I am receiveing the following error (only one client experiences this problem all others work fine): Event Type: Error Event Source: MSCRMAddin Event Category: None Event ID: 5974 Date: 12-6-2007 Time: 10:51:19 User: N/A Computer: ISG-IBMR51 Description: There was an error setting or clearing the cookie used in identifying Microsoft CRM clients. Microsoft CRM folder home pages may render incorrectly inside the view pane. Check Internet Explorer cookie settings and restart Microsoft Outlook. HR=0x80072ee2. Context=. Function=CAddin::HrActivateAddin. Line=477. Thanks, Kind Regards, Ryan. Tag: Data migration issues Tag: 83614
  - 15
    - Setting Security on CRM Price-Lists I want to set security constraints so that each sales person is able to see/handle only certain price-lists and not all price-lists. The same also, I want that the each sales person be able to see/handle only certain products and not all products. Can I do the above 2 requirements? If yes, then how? If no, then is there a workaround for it and how? Thanks Tag: Data migration issues Tag: 83608
  - 16
    - Custom entity and e-mail Hi, For a design process I made an custom entity with a relationship with account. When I select the activity e-mail, the designprocess and CRM user are automatically selected. But I also want the account to be selected automatically, just like in service requests and opportunities. How can I accomplish this? Regards, Jan Tag: Data migration issues Tag: 83606
  - 17
    - Changing Requirement Levels when a Regarding entity is selected Hi there, I was wondering if it is possible to change a field from a business recommended to a Business Required mode when a custom entity is selected on the Regarding lookup field. Lebo Tag: Data migration issues Tag: 83603
  - 18
    - Changing Requirement Levels when a Regarding entity is selected Hi there, I was wondering if it is possible to change a field from a business recommended to a Business Required mode when a custom entity is selected on the Regarding lookup field. Lebo Tag: Data migration issues Tag: 83602
  - 19
    - Email template with images How to add images in an email template. I tried to use SharePoint Designer to design my email template and copied the entire design and paste it to MS CRM email template editor, but the images does not appear. Any help is very much appreciated. Tag: Data migration issues Tag: 83596
  - 20
    - Campaign NO Response listing The Quick Campaign - Campaign Response view lists items that have been promoted with a response. However, is there a way to list quick campaign sent items that have no responses yet so you can follow up on them? Tag: Data migration issues Tag: 83588
  - 21
    - CRM 3.0 Print Quote Feature using Word/Excel We are currently using Experlogix to configure modular equipment that we manufacture. As a result, we would like to be able to have the "Print Quote" export to multiple options such as Word, Excel or PDF (current choice though since we don't want to license all users for the writer we prefer the latter mentioned). Our needs are to be able to edit the quote before creating a PDF. We also need to add information... Is there a configuration that will let us select which option we would like to create the quote to? Is there an easy way to accomplish this? Tag: Data migration issues Tag: 83586
  - 22
    - Outlook / Web Permissions Issue ??? Hi all, we are having a few problems with users who have Outlook client for CRM 3 installed but also use the Web interface. The problem is that the permissions seem to get confused. Eg Buttons missing/menu items from the web client. In many cases it seems if the user logs in via the web first, everything works OK, but if they later launch ouitlook, it removes some functionality from the web client. Eg - the ability to create/save new products. Can anybody offer any help here ? Ian Tag: Data migration issues Tag: 83581
  - 23
    - MS Outlook toolbar does not have CRM toolbar installed I have a user running on a XPSP2 machine with Outlook 2K3 with CRM 3 installed. The CRM install is for online only. Recently, the ability to 'track in CRM' has not been functioning. After looking at the laptop myself, the CRM toolbar is enabled however nothing in CRM is functioning. It will highlight as you move the cursor over the different buttons but nothing responds. All updates have been installed and there is only one patch for CRM installed, KB913270. I've checked Event Viewer and do not see any errors. I have also tried disabling and then enabling the tool bar again with no change. Has anyone had this problem or seen this before? Tag: Data migration issues Tag: 83580
  - 24
    - Design question - millions of records pushed against 'product'? A general design question - I'm working with a web search/aggregator company that generates millions of chargeable click events/month - say between $.10 and $1.00 per click, i.e., non-trivial valua. Each click is generated by a customer ad campaign that is defined in CRM. (Btw, I'm new to Dynamics CRM - but have worked with multiple other CRM platforms.) At present, in the last architecture we took these into a 'warehouse' and then built extracts on a monthly basis to take to Dynamics for invoicing - a very manual process. One idea going forward (with Dynamics CRM in the picture) is to take this click stream and map it back directly to the campaign (or 'product' in CRM) on a regular basis. This would allow direct access to campaign/product performance and much easier invoicing - and also future BI potential as well... 1) Any scalability problems with pushing millions of records/month into Dynamics accounting/CRM? This could easily be over 10M records/month 2) Any other thoughts, e.g., how the heck does one actually go about customizing 'product' into a much richer animal integrated with Dynamics acctg? -- Okay, probably out of scope for this question! :) Cheers - p Tag: Data migration issues Tag: 83579
  - 25
    - "SQL Server is not ready" error messages After doing a few customisations and disabling and re-enabling a couple of users, the server keeps crashing (everyday) after logging several sql errors. These are : ID : 18456 Login Failed for user 'NT AUTHORITY\NETWORK SERVICE' ID : 17187 SQL Server is not ready to accept new client connections... ID : 18452 The user is associated with a trusted SQL Server connection Any ideas what could have generated these messages? Tag: Data migration issues Tag: 83576

Hi there

having issuses when migrating from a csv to crm via the bulk import

Line 552
Char 1
Error expected token ']' found name
value [@source=Zulty-->s<--']

code 0

url http://crm/tools/bulkimport/importfieldmap.aspx

Do you want to contimue running scripts on this page

Re: Data migration issues by George

George
Thu Jun 14 00:09:41 CDT 2007

Hi frank,

looks like your data include something like Zulty's. Try to add an extra
quote in the source, i.e. Zulty''s.

Hope it helps
--
George Doubinski
CRM Certified Professional - Developer

"frank" <frank@discussions.microsoft.com> wrote in message
news:B47926F8-DA21-4845-9875-4CA0F03EFEC6@microsoft.com...
> Hi there
>
> having issuses when migrating from a csv to crm via the bulk import
>
> Line 552
> Char 1
> Error expected token ']' found name
> value [@source=Zulty-->s<--']
>
> code 0
>
> url http://crm/tools/bulkimport/importfieldmap.aspx
>
> Do you want to contimue running scripts on this page

Re: Data migration issues by frank

frank
Mon Jun 18 21:53:00 CDT 2007

yeah im getting mutiple so its a nightmare
thanks mate

"George Doubinski" wrote:

> Hi frank,
>
> looks like your data include something like Zulty's. Try to add an extra
> quote in the source, i.e. Zulty''s.
>
> Hope it helps
> --
> George Doubinski
> CRM Certified Professional - Developer
>
>
> "frank" <frank@discussions.microsoft.com> wrote in message
> news:B47926F8-DA21-4845-9875-4CA0F03EFEC6@microsoft.com...
> > Hi there
> >
> > having issuses when migrating from a csv to crm via the bulk import
> >
> > Line 552
> > Char 1
> > Error expected token ']' found name
> > value [@source=Zulty-->s<--']
> >
> > code 0
> >
> > url http://crm/tools/bulkimport/importfieldmap.aspx
> >
> > Do you want to contimue running scripts on this page
>
>
>