Neil McDonald's Dynamics 365 Blog

Archive for the ‘Misc’ Category

Dynamics 365 Outlook Client Not Rendering Views After September 2018 Update

leave a comment »

The 5th September 2018 Office 365 update has stopped the Dynamics 365 Outlook client from rendering views.

2018-09-10_11-59-11

This is not resolved by the ‘EnableRoamingFolderHomepages’ registry key that fixed a similar issue after the October update.

To get it working again, you’ll need to roll back to the previous update, then turn off automatic updates until it is resolved:

See the edit at the bottom for a better workaround!

Rollback the update

To roll back to the previous update, run the below from a command prompt
Read the rest of this entry »

Written by neilmcd

Sep 10, 2018 at 12:21 pm

Posted in Dynamics 365, Misc

Tagged with ,

Silverlight no longer works in Chrome 42

leave a comment »

In Google’s continuing effort to annoy me, starting with Chrome version 42, the Silverlight plugin no longer works. This is due to Google no longer supporting NPAPI plugins (see here).

To get around it until September 2015, you can use the below fix to re-enable NPAPI.

1. Type the below into the Chrome address bar and press enter: –
chrome://flags/#enable-npapi

2. Click on ‘Enable’ under ‘Enable NPAPI’

image001

3. Click on ‘Relaunch Now’ when it appears towards the bottom of the screen

image002

You’ve now got until September to re-write your Silverlight controls in a compatible technology. Good luck!

Written by neilmcd

Apr 21, 2015 at 8:52 am

Posted in Misc

Tagged with , , , ,

Chrome 37 breaks CRM 2011 and 2013 functionality

with 20 comments

Google has removed a number of APIs from Chrome 37 which is causing a lot of issues with CRM 2011 and CRM 2013. So far I’ve noticed: –

  • You can no longer add options to Option Set fields via customisation
  • Changes made to an email in a workflow are not saved when the save button is clicked
  • The ‘Upload’ button on the SharePoint list component no longer works
  • Anything using the ‘window.showModalDialog’ function no longer works as the API has been deprecated
  • Can no longer save field properties such as ‘Visible by default’
  • Export to Excel no longer works

In order to fix the problem until Microsoft issue a real fix, you can re-enable the deprecated features by following the below: – Read the rest of this entry »

Written by neilmcd

Sep 8, 2014 at 1:35 pm

Posted in CRM 2011, Misc

Tagged with , ,

Moved to WordPress

leave a comment »

Unfortunately, Posterous is closing down, so I’ve transferred my blog to WordPress.

Some of the SQL and JavaScript formatting got lost during the transfer, so I’m currently in the process of checking it all over. If you find anything not working, leave a comment and I’ll get it fixed.

Thanks!

Written by neilmcd

Feb 16, 2013 at 6:31 pm

Posted in Misc

Tagged with ,

Microsoft Community Contributor Award

with 2 comments

Mcc11_social-media_logo

Well this was a nice way to end the week!

I’ve just received an email from Microsoft informing me that I have been recognised with a Microsoft Community Contributor Award. This is awarded to people who freely contribute their time to helping others in Microsoft online communities.

I’m honoured, thank you Microsoft!

Written by neilmcd

Feb 25, 2011 at 6:43 pm

Posted in CRM 2011, Misc

Scribe Certified!

leave a comment »

Screen_shot_2011-01-01_at_21

After using Scribe for most of my CRM integrations for the last 2 years, it was about time I took the certification exams.

Although I have been using the product for some time, the training material provided was invaluable and I learnt a lot that I would never have picked up in day to day use. It’s well worth reading/watching if you use or are planning on using Scribe.

I’m pleased to say that I passed both the Server and CRM adapter exams. Not a bad start to 2011!

Written by neilmcd

Jan 1, 2011 at 8:53 pm

Posted in CRM 2011, Misc

Tagged with

CRM Timeline

leave a comment »

Lauren Carlson over at Software Advice, has created a great interactive timeline showing the growth of CRM software over the last 3 decades. It’s very interesting to see how much has changed over the last 30 years and I can’t wait to see what happens in the next 30! Keep an eye on it, as it will be updated over time.

Written by neilmcd

Nov 23, 2010 at 9:00 am

Posted in Misc

Internet Explorer 9 – First Impressions

with 2 comments

I’ve just downloaded and installed the public beta of the next version of Internet Explorer, IE9 and wanted to share my first impressions.

Once installed, the first noticeable difference is how minimal the interface has become. The address bar and tabs section seem to take up roughly 66% less screen space, since the address bar, search box and tabs are now all located on the same row. As I usually have a lot of pages open, I didn’t think I’d like the repositioning of the tabs, but it really hasn’t caused me any problems.

Screen_shot_2010-09-16_at_14

The next thing I noticed is the speed. It really flies. Microsoft have added GPU acceleration to IE9, so a lot of image rendering is now performed by your graphics card rather than your CPU.

Another great new feature, is the ability to add web shortcuts to your taskbar. You just drag the favicon from the address bar to your taskbar to create a shortcut. This is great if you want quick access to applications such as your email and it really feels like you’re launching an app rather than a browser.

Screen_shot_2010-09-16_at_16

Read the rest of this entry »

Written by neilmcd

Sep 16, 2010 at 4:00 pm

Posted in Misc

Tagged with

Checking SQL table sizes

leave a comment »

Sqlsize

I wanted a way to find which tables were using the most storage in my SQL databases. The stored procedure sp_spaceused will show this data for a single table, but I wanted to view every table at once. The below SQL query will run against any SQL 2005 database and show you it’s table sizes in descending order. As expected, the ActivityMimeAttachment table in my CRM database was pretty huge!


SELECT sys.schemas.[name] AS [Schema],
sys.tables.name AS [Table],
COALESCE([Row Count].[Count], 0) AS [Rows],COALESCE(8192 * [Data Pages].[Count],0) AS [Data Bytes],
COALESCE(8192 * [Index Pages].[Count],0) AS [Index Bytes]
FROM sys.tables
INNER JOIN sys.schemas ON sys.schemas.schema_id = sys.tables.schema_id
LEFT OUTER JOIN (SELECT object_id,SUM(rows) AS [Count]
FROM sys.partitions
WHERE index_id < 2
GROUP BY object_id) AS [Row Count] ON [Row Count].object_id = sys.tables.object_id
LEFT OUTER JOIN (SELECT sys.indexes.object_id,SUM(CASE WHEN a.type <> 1
THEN a.used_pages
WHEN p.index_id < 2
THEN a.data_pages
ELSE 0 END) AS [Count]
FROM sys.indexes
INNER JOIN sys.partitions AS p ON p.object_id = sys.indexes.object_id
AND p.index_id = sys.indexes.index_id
INNER JOIN sys.allocation_units AS a ON a.container_id = p.partition_id
GROUP BY sys.indexes.object_id) AS [Data Pages] ON [Data Pages].object_id = sys.tables.object_id
LEFT OUTER JOIN (SELECT sys.indexes.object_id,SUM(a.used_pages - CASE
WHEN a.type <> 1
THEN a.used_pages
WHEN p.index_id < 2
THEN a.data_pages
ELSE 0 END) AS [Count]
FROM sys.indexes
INNER JOIN sys.partitions AS p ON p.object_id = sys.indexes.object_id
AND p.index_id = sys.indexes.index_id
INNER JOIN sys.allocation_units AS a ON a.container_id = p.partition_id
GROUP BY sys.indexes.object_id) AS [Index Pages] ON [Index Pages].object_id = sys.tables.object_id
ORDER BY [Data Bytes] desc

Written by neilmcd

Jul 19, 2010 at 6:07 pm

Posted in Misc

Tagged with