Help on Queue - Take II

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
    - Domain Conflict Hi, Recently we have installed CRM 3.0 on a new domain since the beta was running on our existing company domain. To inegrate CRM outlook online version and to connect to the crm server, is it mandatory to have both the domains(the CRM domain and our company domain) same? Regards, George Tag: Help on Queue - Take II Tag: 64270
  - 2
    - Address Label I want to add a button to the contact and order forms which will extract the name and address fields and automaticaly insert them into a template. I would like the template to format as a label which can go directly to a specific printer (label printer). Any ideas, or has anyone done this before? Tag: Help on Queue - Take II Tag: 64261
  - 3
    - CRM Toolbar Missing.. cant add back in We have 70 of our salesmen using the outlook client. One of them is having a problem that I cant figure out. His toolbar is missing so crm doesnt work. I have tried adding it back in and it gives me this error. "An error occured loading Microsoft CRM Functionality. Try restarting Microsoft Outlook. Contact your system administrator if errors persist." this error pops up in a grey application window. Then if i click on one of the crm folders, everything except the content of the page loads up. "Page title and navigation, search boxes, etc." When it gets to trying to load the list of records it gives me this error. "An error occured loading Microsoft CRM functionality, Try restarting Outlook. Contact your system administrator if errors persist" this error has a yellow background. Please help if you cant, I am stumped. josh Tag: Help on Queue - Take II Tag: 64260
  - 4
    - Print security rols matrix Is there any way of printing a report detailing each of the privelages associated with each of the security roles set up in the MS CRM system It is a lot easier to use a report then flick between roles on the sceen Tag: Help on Queue - Take II Tag: 64257
  - 5
    - Urgent Help Workflow Error Hi Guys, Have a workflow which has been working fone for weeks. The System is due to go live today and now I'm getting the following error. I think it could be corrupt MetaData. "Error code = 80042c23.Platform evaluation engine error. Workflow could not retrieve information to perform the 'update' action. Thanks for any help Tag: Help on Queue - Take II Tag: 64255
  - 6
    - Use relationships with leads Hallo to all, i want to use, the customer relationships that we use with accounts and constacts, with leads as well. Is it possible? Thank you in advance, Vasiliki Sioti Tag: Help on Queue - Take II Tag: 64254
  - 7
    - Going offline and Contacts not showing I have the CRM client installed on my notebook, and when I go offline, everything is there, except for the Contacts. Any help would be appreciated. Tag: Help on Queue - Take II Tag: 64249
  - 8
    - Mapping Failure Hi My attempt at mapping, to allow information transfer from lead to both opportunities and companies, has failed to some degree. The mapping works for opportunities but not for companies, despite the identical process I have followed. The attribute mapping is for a picklist. Any help would be greatly appreciated. Tag: Help on Queue - Take II Tag: 64247
  - 9
    - Internal e-mail in queue (in CRM 3.0) Sorry if i am repeating it , i tried but couldnt find the answer. I can get the external e-mail in queue but not internal e-mail in CRM 3.0. Is there any work around?, i did something wrong , or this is the way , it works :0) regards / Aami Tag: Help on Queue - Take II Tag: 64243
  - 10
    - The IE closes automatically when I access the CRM site. Hi all, I installed the MS CRM 3.0 just now. I opened the IE and tried to access http://crmwebsitename. But when I inputed domain account name and password, the IE closed automatically! Why? Thanks in advance. Alan Tag: Help on Queue - Take II Tag: 64240
  - 11
    - Activities associated to a new entity I created a new entity that is child of account. Is it possible to create activities to this new entity and they appear in the account activities??? Tag: Help on Queue - Take II Tag: 64238
  - 12
    - Email Template in Campaign Activity not available We're trying to use an e-mail template in a campaign activity, but we can't find the appropriate button in the form. Does it mean that the use of a template is not directly available in a campaign activity (email type)? We're able to use a template only in we create an email activity from the "Activity" menu... Thank's Alessandra Tag: Help on Queue - Take II Tag: 64235
  - 13
    - Difference between Teams and Business Units Hi, We are trying to implement CRM 3.0.Our sales teams are divided in to four groups and we would like to restrict their record access groupwise . Each team consists of a Manager and few executives. Even though I have created teams and added the corresponding members, every one can see all the records. Do I have to create a business unit to solve this? Regards, George Tag: Help on Queue - Take II Tag: 64230
  - 14
    - Showing entities in an iFrame var navActivityHistory; navActivityHistory = document.all.navActivityHistory; if (navActivityHistory != null) { navActivityHistory.style.display = "none"; document.all.IFRAME_HistoryFrame.src="/sfa/conts/areas.aspx?oId=" + crmForm.ObjectId + "&oType=2&security=852023&tabSet=areaActivityHistory"; } else { alert("navHistory Not Found"); } The above code is used to retrieve specific information into an iFrame.Can anyone tell me what the variable "navActivityHistory" is used for?? Is it a pre-defined variable in CRM?? why r we using it in "document.all.*". And,what is tabset...can u give a brief description about this!!! Thank You Chaitanya. Tag: Help on Queue - Take II Tag: 64226
  - 15
    - Retrieving attributes of entity in an m:n relationship into an iFr How can we retrieve the attributes of an entity in an m:n relationship? for example: we are creating some products.We are creating some opportunities for an account.Now,we're associating the products to these opportunities through opportunityproducts. Now,i want to display all the products related to an opportunity in an iFrame.And,viceversa.But,as opportunityproduct is used as mediator to create this m:n relationship between products and Opportunities,we are unable to fetch the details of products/opportunities into the iFrame.Please help me in this regard. Regards, Chaitanya. Tag: Help on Queue - Take II Tag: 64225
  - 16
    - Associated View display Inactive Entity Hi All, Just want to ask, how to set Associated View of Certain Entity to display just the Active Entity. Currently I notice that in a parental relationship, the associated view display all the child entity including Active and Inactive. Is it possible to configure that associated view just display Active Child Entity? Thank you. Tag: Help on Queue - Take II Tag: 64215
  - 17
    - Error sending email from workflow I created a workflow that will send out an email when an entity is created/assigned. But the email is not sent. Checked the log in the workflow monitor, got error: Error code = 80049306. Access is denied. I checked that email is working by creating an email activity, send it to the same user as the workflow and it works fine. Why is it that it works fine when i create an email activity, but it does not work when sending from workflow? The workflow are created with a CRM user. I got other workflows e.g. to update an entity, and those works fine. Only having problem with sending email. Tag: Help on Queue - Take II Tag: 64213
  - 18
    - Upgrading 1.2 to 3.0 We Planning to upgrade CRM 1.2 to 3.0 for our clients. We are trying to create a developer environment and perform the update. My question is if we go this route how can we install 1.2 on this dev servers (Key is unique as per domain). Can we have DEV or temp key for that particular domain? If YES... HOW? On the other hand if we install a fresh copy of 3.0 what is the process of data integration from old to new DB and what kinid of information we may loose throught this route. Thanks. Tag: Help on Queue - Take II Tag: 64210
  - 19
    - ICRM Reporting of Shared Users on a client Is there a report which can be printed showing which users have been granted access to a particular client/record within ICRM? I looked at the dynamic worksheet exporting but it didn't appear to have a column which you could add for shared users on each record. Tag: Help on Queue - Take II Tag: 64208
  - 20
    - updating a custom field in Accounts from another SQL database Is there any safe way to update a custom field in the Accounts on CRM without using .Net programming or expensive software like Scribe. We need to update a flag custom field using info from another database. I know how to do it using ODBC link in Access to the CRM table, but I also know this is not recommended due to security in CRM. But we do not have any other options right now. Giving that this is not part of the default fields in CRM, and we are only updating not adding or deleting, are there really any issues to worry about. If so, is there another option. Thanks, Malcolm Tag: Help on Queue - Take II Tag: 64206
  - 21
    - Leads Customization First off I want to thank the help I've received so far, you have all been helpful. But I have yet another question! I'm working with customizing the Leads entity and I want to add the "Phone Call" icon to the top menu bar next to attachment and Send Email. I just want the icon to link to a New Activity Phone Call, so that the agents that go through their leads in the morning can easily log phone calls. I also want to add a "Completed" button to the menu of the Phone Call activity screen. What is the best way to go about this? Thanks, LJD Tag: Help on Queue - Take II Tag: 64203
  - 22
    - Include a custom entity in CRM marketing lists and campaigns It is possible to add a custom entity in CRM marketing lists and campaigns? Tag: Help on Queue - Take II Tag: 64199
  - 23
    - Import Accounts / Contacts - How to get GUIDs in CRM? I remember seeing a posting some place a couple of weeks ago regarding importing contacts into accounts using Bulk Import. The posting had a link to a page/blog that someone had written up with code to display the GUID in search results/finds. In other words, I want an import process that does not involve SQL (why have to query using SQL, isn't Advanced Find usable)? I do not care if I have to have two separate import steps (well, I do, and Microsoft has clearly failed to make this important feature usable... I guess they're trying to keep Scribe happy at the expense of us all). Anyways, if anyone know of a step by step way to get Accounts and Contacts imported without using a 3rd party tool, please let me know. If you know the link I am referring to (was just some code you had to put onto the web server of your CRM), it would be appreciated. Regards, Chuck Tag: Help on Queue - Take II Tag: 64197
  - 24
    - Change MS CRM 3.0 Install Account I have a client who has MS CRM 3.0 installed and running but it was installed using the domain administrator account. "Administrator" Is there a way to change the install so it no longer has the Administrator account as the install account? They have created another account. MSCRMInstall which was supposed to be used for the install. Also in 1.2 and 1.0 there were a few special circumstances when the install account was needed to be used. Is there any circumstances like that in MS CRM 3.0 or could I just add MSCRMInstall as an MS CRM system administrator and disable the install account. Thanks Hoss Tag: Help on Queue - Take II Tag: 64194
  - 25
    - View Other Users Details How can a user view other users to see contact details of fellow employees etc? Tag: Help on Queue - Take II Tag: 64193
- Next
  - 1
    - Spellcheck & Signature How do enable spellchecking when sending out e-mails through the CRM client (via the browser)? Also, how can I insert a signature through the browser? Thanks Tag: Help on Queue - Take II Tag: 64192
  - 2
    - Outlook Client Install via VPN Hello, We need to install the CRM Outlook client to some remote users who are connected via VPN. Is this possilbe? I have read other post that seem to say there are issues because the cleint is not authenticated on the domain during the install. I could potentially have the laptops shipped to corporate, do the install and shipped back. Thanks. Tag: Help on Queue - Take II Tag: 64189
  - 3
    - Advanced Find Filter Criteria When creating a filter for Account in Advanced Find, there is no field for Classification in the dropdown list. Could this be a CRM error or am I looking over the obvious? Thanks Tag: Help on Queue - Take II Tag: 64187
  - 4
    - Workflow Rule based on picklist value I have created a new field as a picklist on the opportunity called "Type". I have a workflow rule that runs on create of opty, checks for value in type and then runs one of 3 manual sales process depending on the value chosen in type. this all worked fine until I decided to update and change the sales processes and I also exported and imported between dev and test servers. Now, the opportunity rule doesn't recognise the type field for some reason. Rule: Apply Processes when opportunity is created if Opportunity.Type = End User Project then Exec: End User Project end if ...and so on for the 3 sales process. I tried changing the rule as below and then created an opportunity in the free text field with the string "test" and it worked ok: when opportunity is created if Opportunity.topic = "test" then Exec: End User Project end if I then tried this and it just sits there waiting so doesn't recognise the type field for some reason when opportunity is created wait opportunity.Type = End User Project end wait Exec: End User Project while this one does work: when opportunity is created wait opportunity.description = "Bang head against wall" end wait Exec: End User Project considering it worked before and recognised the type field (I'm 100% sure that it did) and works with the test rules above anyone got any ideas? -- regards, Mark Tag: Help on Queue - Take II Tag: 64184
  - 5
    - Allow all tasks to be re-opened for editing. There are frequent occasions where tasks need to be updated after they have been closed: Typos, time and date changes/updates, etc. If there is security concerned then limit who can update a closed task. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=7c2a2f82-d406-48aa-aa42-c7fa2326a30e&dg=microsoft.public.crm Tag: Help on Queue - Take II Tag: 64182
  - 6
    - iFrames pulling CRM Reports For Accounts and Contacts my company wants to have the first tab displayed be read only. I have created an Overview tab and placed an iFrame in the tab for Accounts. I have tried to local reference the URL for the Account Overview rdl file but when I publish the iFrame it returns a blank. Does anyone have any suggestions? Thanks Tag: Help on Queue - Take II Tag: 64181
  - 7
    - Scribe Insight - ACT to CRM 3.0 notes/history I'm trying to get the ACT notes/history records migrated into CRM using the Scribe workbench. The out-of-box functionality ties the note/history record to the account and not the contact. I need it tied to the contact (I would think everyone would). I'm trying to use a custom formula but I'm having no luck. Has anyone been able to tie the note/history record to the contact instead of the account using Scribe? Tag: Help on Queue - Take II Tag: 64180
  - 8
    - Suggestion for Emails Microsoft should make Ctrl-Tab work in the body of an email. Since hitting tab sends focus to the next field, there is no way (that I can find) to place a tab in an email. Other programs I have seen allow the user to hit Ctrl-Tab to place a tab in the body of an email. It would be nice if this worked in CRM. Thanks Greg Tag: Help on Queue - Take II Tag: 64175
  - 9
    - enable all fields I have been using the disable property of fields in jscript to ensure that users do not enter inconsistand fields of information. Does any one know of a way to loop through all the fields on a form to enable them. I would like to attach this script to the On Save so all fields will be saved. Below is what I got so far but it does not work. code sampe ========================= var obj = new Object(); foreach(obj in crmForm.all) { obj.Disabled = false; } ================================== Tag: Help on Queue - Take II Tag: 64174
  - 10
    - HELP-The XML passed to the platform is not well-formed xml. Both my test system and my live system are experiencing this. I cannot import, export or customize anything. I know the entity (and relationships) that are causing the problem but I do not know how to reverse out of it. Can anyone help? Thanks Saira Tag: Help on Queue - Take II Tag: 64172
  - 11
    - Assign an entity to multiple Users Is it possible in CRM 3.0 to assign an entity (e.g. a contact record or account record) to multiple users of CRM ? If yes, how ? Thanks Kishore Tag: Help on Queue - Take II Tag: 64170
  - 12
    - More than 1 CRM install and single Exchange Hi all, I've done some searching and there seems to be a number of posts in this vein, but I am finding some a little confusing, or by no means clear or definitive. We have a Windows 2003 native AD, running Exchange 2003 Enterprise - A/P cluster back-end. We have just deployed a single server for an evaluation of CRM - running it on a single but well powered Dell box - CRM 3.0, SQL Standard. We have installed the email router on the A/P nodes of the Exchange cluster. 20 Clients are using a mix of the web-based interface and the Outlook add-in to access this - seems to be working fine and tracking emails in testing. We now have an additional part of the organisation wanting to go for their own evaluation of CRM - can we build an additional new CRM server (presuming the problem is we have already used our site/org name for the first one) to run this - but still link with our existing Exchange infrastructure??? Or is it better that we add the new team as a new business unit into the existing CRM deployment (as the current evaluation in place already have their own 'business unit' under the top level organisation name/site). Clearly as the reasoning behind the system is for different teams to share and publish data in the future for other teams benefit, then presumably a single CRM installation would be suitable (i.e. we can always up-size it later to additional SQL back-ends, clustered SQL, load-balanced CRM front-ends, etc. to support increase in users, data volume, fault tolerance, more 'business units') I am finding some answers a bit mixed - some people saying a single Exchange org can use the single email router to support different CRM installs, others saying there has to be a one-to-one relationship... Clearly, we don't want individual teams having to go the route of having their own Exchange org, DNS, etc. just to support a seperate CRM deployment. If we are deploying more than one business unit in the CRM deployment, do these have to largely 'share' a common schema, set of data tables, structures, etc. or do each business unit build and develop their own 'common' to only them? Any help you can give would be great - thanks in advance, Steve Tag: Help on Queue - Take II Tag: 64167
  - 13
    - Grouping results on a report (need a little help) I created a report based off of the filteredlead and filteredannotation views so that I could pull data regarding the leads and the notes regarding those leads, below is the SQL statement I use to do this SELECT dbo.FilteredLead.companyname, dbo.FilteredLead.new_productname, dbo.FilteredLead.new_clientbusinesstypename, dbo.FilteredLead.subject, dbo.FilteredAnnotation.notetext, dbo.FilteredLead.fullname, dbo.FilteredLead.description, dbo.FilteredLead.leadsourcecodename, dbo.FilteredLead.owneridname FROM dbo.FilteredAnnotation INNER JOIN dbo.FilteredLead ON dbo.FilteredAnnotation.objectid = dbo.FilteredLead.leadid WHERE (dbo.FilteredLead.leadsourcecodename = 'Quote & Bound Report') ORDER BY dbo.FilteredLead.companyname Now this statement works out pretty well and returns the data that I want with one small problem. If a lead has two or more notes associated with it the results will have the company listed twice. Looking something like below Companyname1 Note A Companyname2 Note A Companyname2 Note B Companyname2 Note C Companyname3 Note A Companyname3 Note B This isnt too huge of a deal but I would liek to have it so each company only has one heading with all the notes listed under it, like. Companyname1 Note A Companyname2 Note A Note B Note C Companyname3 Note A Note B Any ideas or help is appreciated. Tag: Help on Queue - Take II Tag: 64166
  - 14
    - Customizing the Subject entity Hi I've managed to customize "cases" - they are now called "objectives". But although the "subject" entity is listed as customizable, everything is grayed out and I can't rename it. Can anyone help? Thanks -- Mike Bristol, UK CRM user www.crmuser.blogspot.com Tag: Help on Queue - Take II Tag: 64164
  - 15
    - Axapta 3.0: Setting the linktype of DataSources at runtime Hello all, I have a button on form. It's click-EventHandler contains a line: CIRTRAStndTourOrderLine_ds.linkType(Transporteinheit.valueStr() ? 3 /* InnerJoin */ : 4 /* OuterJoin */); Where "CIRTRAStndTourOrderLine_ds" is the data source generated by MorphX (CIRTRAStndTourOrderLine) is a table. "Transporteinheit" is a StringEdit. The behaviour I would like to achieve is, that if I enter something into the StringEdit it sets the linktype to InnerJoin otherwise to OuterJoin another table. In MorphX I set the linktype to OuterJoin (as a default). The problem is, that axapta simply does not change anything. I suppose I need some kind of refresh. Yours sincerely Hot_Ice Tag: Help on Queue - Take II Tag: 64163
  - 16
    - Client Problem When I open the CRM from a client, my cpu usage grows to 60 % for the crm application. It is very slow to open it. And to use allways the precachecrm tool is really a workflow for this problem. My workstation has 1 GB ram and 3 Ghz. The CRM Server is a 1 GHz Machine with 1 GB ram. With a x64 client is crm realy fast but with my workstation 1 can wait 2 minutes before i can use crm and the cpu usage increase to 50 percent for the iexplore task. Tag: Help on Queue - Take II Tag: 64162
  - 17
    - Settings & Customization pane Hi, I'm working on CRM 3.0 and I was trying to use Outlook client when I got an error message, so I closed Outlook and turned on CRM but I lost Settings & Customization pane. I'm looking for the functionality from the "Go To" menu but it doesn't work. I'm working with administrator account. Does anybody know what the prloblem is? Thank's in advance Alessandra Tag: Help on Queue - Take II Tag: 64158
  - 18
    - Microsoft CRM Connectors blog Dear All, The following Microsoft CRM Connectors blog contains some useful information on the Microsoft CRM Connector for Microsoft Dynamics GP. This blog will also provide information on future Microsoft CRM Connectors and integration solutions such as with Microsoft Dynamics AX, or the BizTalk Adaptor for Microsoft Dynamics CRM, etc. You can also use this blog to get answers to questions on the Microsoft CRM Connectors or to provide feedback. Blog URL: http://blogs.msdn.com/microsoftcrmconnectors/default.aspx Regards, Manohar Tag: Help on Queue - Take II Tag: 64157
  - 19
    - report prefiltering does not work for custom entity Please help. I've been trying for days but can't get the reports prefiltering to work for my custom entity. I created a simple report with the CRMAF_ prefix and deploy to the CRM server. The report works fine and display all data OK. Except the pre filter does not work i.e. the "Edit Filter" button does not show. My question is: Does report prefiltering works for custom entity? I saw a lot of posts regarding this topic and tried all the suggestions i could find, but still no luck. I tried the microsoft tutorial in creating a prefilterable report base on the account entity and this works fine. When I used the same procedure to create a custom report base on a custom entity, the prefilter does not work. Tag: Help on Queue - Take II Tag: 64151
  - 20
    - User creation fails We have installed MS CRM 3.0 on a Windows Server 2003 The main problem today is that we are unable to create users in the system. We created users on the Active Directory, but when we try to add a new user to the CRM, we fill in the "Domain logon name" and when the textbox loses focus, we get the error, "An error has occurred. Please contact the System Administrator". There doesn't seem to be any other error log elsewhere. The problem is probably something related to the CRM unable to access the AD data. Can anyone give me an idea, what to do? Cheers Tag: Help on Queue - Take II Tag: 64137
  - 21
    - Searching for contacts based on fields at account level Hi, Does anyone know if you can search for a list of contacts in CRM 3.0 based on a field that is on the Account screen (entity). We have a problem where the client has put most of their customised fields at account level and now are unable to bring up a list of contacts based on those fields that are on the account screen. As a result they can also not perform mail merges etc. on contacts as all they can get is a list of accounts. Frank. Tag: Help on Queue - Take II Tag: 64129
  - 22
    - Hello We have installed MS CRM 3.0 on a Windows Server 2003 The main problem today is that we are unable to create users in the system. We created users on the Active Directory, but when we try to add a new user to the CRM, we fill in the "Domain logon name" and when the textbox loses focus, we get the error, "An error has occurred. Please contact the System Administrator". There doesn't seem to be any other error log elsewhere. The problem is probably something related to the CRM unable to access the AD data. Can anyone give me an idea, what to do? Cheers Tag: Help on Queue - Take II Tag: 64128
  - 23
    - goldmine to crm activity import hello I am trying to import activities to mscrm from goldmine... unfortunatelly there are some problems (typical). When i try to import by data migration framework it imports just 66 form 25 000 phones for account. Please i have no idea whats wrong i did mapping like it was explained in xls. here part of code (most important of mapping and inserting data ) DECLARE conthist_crsr CURSOR FOR SELECT LEFT(LTRIM(RTRIM(ISNULL(USERID, ''))) ,8) , LEFT(LTRIM(RTRIM(ISNULL(ACCOUNTNO, ''))) ,20) , LEFT(LTRIM(RTRIM(ISNULL(SRECTYPE, ''))) ,1) , LEFT(LTRIM(RTRIM(ISNULL(RECTYPE, ''))) ,10) , LTRIM(RTRIM(ISNULL(ONDATE, ''))) , LEFT(LTRIM(RTRIM(ISNULL(ONTIME, ''))) ,5) , LEFT(LTRIM(RTRIM(ISNULL(ACTVCODE, ''))) ,3) , LEFT(LTRIM(RTRIM(ISNULL(RESULTCODE, ''))) ,3) , LEFT(LTRIM(RTRIM(ISNULL(STATUS, ''))) ,2) , LEFT(LTRIM(RTRIM(ISNULL(DURATION, ''))) ,8) , LEFT(LTRIM(RTRIM(ISNULL(UNITS, ''))) ,20) , LEFT(LTRIM(RTRIM(ISNULL(REF, ''))) ,125) , LEFT(LTRIM(RTRIM(ISNULL(convert(nvarchar (500),NOTES), ''))) ,500) , LEFT(LTRIM(RTRIM(ISNULL(LINKRECID, ''))) ,15) , LEFT(LTRIM(RTRIM(ISNULL(LOPRECID, ''))) ,15) , LEFT(LTRIM(RTRIM(ISNULL(CREATEBY, ''))) ,8) , LTRIM(RTRIM(ISNULL(CREATEON, ''))) , LEFT(LTRIM(RTRIM(ISNULL(CREATEAT, ''))) ,5) , LEFT(LTRIM(RTRIM(ISNULL(LASTUSER, ''))) ,8) , LTRIM(RTRIM(ISNULL(LASTDATE, ''))) , LEFT(LTRIM(RTRIM(ISNULL(LASTTIME, ''))) ,5) , LEFT(LTRIM(RTRIM(ISNULL(RECID, ''))) ,15) FROM CBK_DC..CONTHIST OPEN conthist_crsr FETCH next FROM conthist_crsr INTO @USERID , @ACCOUNTNO , @SRECTYPE , @RECTYPE , @ONDATE , @ONTIME , @ACTVCODE , @RESULTCODE , @STATUS , @DURATION , @UNITS , @REF , @NOTES , @LINKRECID , @LOPRECID , @CREATEBY , @CREATEON , @CREATEAT , @LASTUSER , @LASTDATE , @LASTTIME , @RECID WHILE @@FETCH_STATUS = 0 BEGIN SET @counter_crsr = @counter_crsr + 1; -- print @ACCOUNTNO + ' line:'+ convert (nvarchar(15), @counter_crsr ) select @cdf_AccountId_account = accountid from cdf_mscrm..cdf_account where AccountNumber= @ACCOUNTNO select @cdf_Name_account = Name from cdf_mscrm..cdf_account where AccountNumber= @ACCOUNTNO -- print @cdf_AccountId_account + ' -> account number of cdf_account' print 'calkowita liczba wierszy przerobionych z 50 000 ->' + convert (nvarchar (10),@counter_crsr) IF @SRECTYPE = 'C' BEGIN SET @counter_activityid_phonecall = @counter_activityid_phonecall + 1; SET @counter_success = @counter_success + 1; print @counter_success SET @counter_ActivityPartyID = @counter_ActivityPartyID +1; INSERT INTO cdf_mscrm..cdf_ActivityParty ( ActivityPartyID , ActivityID -- , ActivityIdName -- , ActivityObjectTypeCode -- , PartyId , PartyIdName , PartyObjectTypeCode , ParticipationTypeMask -- , AddressUsed -- , Effort -- , ExchangeEntryId ) VALUES ( @counter_ActivityPartyID , @counter_activityid_phonecall --@cdf_AccountId_account -- , '4210' -- , @cdf_AccountId_account , 'BIURO\crm_admin' , '8' , '1' ) SET @counter_ActivityPartyID = @counter_ActivityPartyID +1; INSERT INTO cdf_mscrm..cdf_ActivityParty ( ActivityPartyID , ActivityID -- , ActivityIdName -- , ActivityObjectTypeCode -- , PartyId , PartyIdName , PartyObjectTypeCode , ParticipationTypeMask -- , AddressUsed -- , Effort -- , ExchangeEntryId ) VALUES ( @counter_ActivityPartyID , @counter_activityid_phonecall --@cdf_AccountId_account -- , '4210' , @cdf_Name_account , '1' , '2' ) SET @counter_ActivityPartyID = @counter_ActivityPartyID +1; INSERT INTO cdf_mscrm..cdf_ActivityParty ( ActivityPartyID , ActivityID -- , ActivityIdName -- , ActivityObjectTypeCode -- , PartyId , PartyIdName , PartyObjectTypeCode , ParticipationTypeMask -- , AddressUsed -- , Effort -- , ExchangeEntryId ) VALUES ( @counter_ActivityPartyID , @counter_activityid_phonecall --@cdf_AccountId_account -- , '4210' , 'BIURO\crm_admin' , '8' , '9' ) INSERT INTO cdf_mscrm..cdf_PhoneCall ( ActivityID -- , Category -- , Subcategory , RegardingObjectId -- , RegardingObjectIdName -- , RegardingObjectTypeCode , Subject , Description -- , ScheduledStart -- , ScheduledEnd -- , ScheduledDurationMinutes -- , ActualStart -- , ActualEnd -- , ActualDurationMinutes -- , OwningUser , OwningUserName -- , StateCode -- , StateCodeName -- , StatusCode -- , StatusCodeName -- , DirectionCode -- , DirectionCodeName -- , PhoneNumber -- , PriorityCode -- , PriorityCOdeName -- , IsBilled ) VALUES ( @counter_activityid_phonecall , @cdf_AccountId_account -- relacja do account -- , '1' , @REF , @NOTES , 'BIURO\crm_admin' ) END please can somebody explain to me what i do wrong?? bart Tag: Help on Queue - Take II Tag: 64125
  - 24
    - customize entities Hello, I work on a custom entitie, iand I want to know if it is possible to make reporting directly on this one? My entities includes fields address, can I use the for simple mailing? And my last question, can I use workflow on these entity? Thanks for your answers. Tag: Help on Queue - Take II Tag: 64124
  - 25
    - navigations in a webpage in an iframe hi I display a webpage in a iframe and of course, a user can navigate to other pages using links on this page. but Ä± want to save the last page's url,so that : if the user opens the form to update he/she can find the webpage that he last displayed in the iframe. how can I keep the url of the last visited page in a iframe Tag: Help on Queue - Take II Tag: 64122

Hi,

Can someone explain me and help me out about how to get the queue system
working? im not getting it...

* When i try to send a email to: support@mydomain.com <-- this didnt work
out... the email dont get on the queue to assign later on... in the email
router i have estabelish a rule for support@mydomain.com to the crm user that
have the queue...

* When i try to send a email to: support@mydomain.com; myuser@mydomain.com
<-- this works .. the mail gets in the user queue and is assigned to my
user...

* if i try send a email to support@mydomain.com ; anotheruser@mydomain.com
this doesnt works.. the email dont get in the queue and not even assigned to
the user.. he even dont enter the system...

* if i send a email to anotheruser@mydomain.com he enter the system and get
assigned (on the queue) to the user...

I mean is it possible to have a email like support@mydomain.com that could
queue emails that we could assign later?... this not seems to work out... the
email need to get assigned to myuser to enter the queue.. weird :(

ps: i tried using outlook

Top