New Design

Recent Post

Tuesday, August 25, 2015
no image

MySQL phpmyadmin - show BLOB to a viewable format

When using phpmyadmin to list out the records from a table, it will display a link for download a bin file if the field format is defined in BLOB.

If you want to display the content directly, you can using the convert function as below:

SELECT CONVERT('field_name' USING utf8) FROM table;
Thursday, May 7, 2015
no image

Drupal - Custom template file field output

Typically, to control the output of your field you'd just print out all your fields in your template files by doing precisely what you have up there:
<?php print render($content['your_field_name']); ?>
You can have as much html in your template file in addition to these rendered fields and then style them with css! So you can have
<div id="some_field_grouping">
  <?php print render($content['field_1']); ?>
  <?php print render($content['field_2']); ?>
And then theme this with css using any of the ids and classes you get and whatever the fields themselves render.
If you really need to modify the field's output more precisely and the standard output from print render doesn't work for you, you could certainly look into the field structure itself and grab the individual field parts you need. I'd only do this if you absolutely need to...
To start peering into the exact structure of the fields, I'd
  • Install and enable the devel module... You can just enable the 'Devel' module that comes with it for this purpose
  • In your template file, put a
    <?php dsm($content['your_field']); ?> 
    statement somewhere. That function is only available if you have the devel module enabled, and it will print out the field array for you to inspect in detail. Here is an example of the dsm output: enter image description here
  • Once you can look into the structure of that array, you can take any pieces of the field you need, if you don't want to render it in the default way.
So, you can do something like getting only the uri of your image...
<img src="<?php print $content['field_image'][0]['#item']['uri']; ?>" >

Thursday, March 27, 2014
no image

MSCRM - What is the difference between Owner and Owning user?

In CRM 2011, the entity has 3 fields: 
  • Owner, 
  • Owning Team, and 
  • Owning User

Owner of an entity record can be a user or a team. 
Owner is the system user who owns the entity record.
If Owner = User, then Owning User = Same User and Owning Team = null
If Owner = Team, then Owning User = null and Owning Team = Same Team

You can display Owner on the form, but not the other two. Those work behind the scenes. We should be only concerned with the Owner field.

From : Source
Monday, December 2, 2013
no image

MSCRM - Error : ActivityFeeds.Plugins: ActivityFeeds.Plugins.ActivityClose

After adding a plugin and published, every time I try to add a new Account and get a failure. The error message like :
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: An error occurred. Contact a system administrator or refer to the Microsoft Dynamics CRM SDK troubleshooting guide.Detail:
<OrganizationServiceFault xmlns:i="" xmlns="">
  <ErrorDetails xmlns:d2p1="">
      <d2p1:value xmlns:d4p1="" i:type="d4p1:string">0</d2p1:value>
  <Message>An error occurred. Contact a system administrator or refer to the Microsoft Dynamics CRM SDK troubleshooting guide.</Message>
  <InnerFault i:nil="true" />

[ActivityFeeds.Plugins: ActivityFeeds.Plugins.ActivityClose]
[666ee08c-a126-e311-8e0c-0050569aa3d9: ActivityFeeds.Plugins.ActivityClose: Create of  any Entity]


There is an solution from Here on the problem, and the detail is:

The error code -2147220891 can be converted to the hexadecimal version using Windows Calculator. To do this open calculator and change the mode to Programmer. Then paste the number -2147220891. Then press the negative button to make the number negative. Finally change the value to hexadecimal by changing the mode from DEC to HEX. You will get FFFFFFFF80040265 which is 0x80040265. You can then search using a search engine and find that the error means: Error Message: Object reference not set to an instance of an object. This error is very generic and does not help much at this point.
It could be that the Activity Feeds solution is not configured correctly. I believe the best way to continue troubleshooting this problem would be to open a support request with Dynamics CRM Support. Once that is open the support engineer will be able to collect tracing from the CRM Online server deployment. Tracing is needed to get a better idea of what failed when the Activity Feeds solution executed. The tracing will need to be collected when you reproduce the error so be prepared to reproduce the issue when the engineer is ready to collect the traces.
Alternatively you could try to disable the Activity Feeds solution for the account entity. This blog covers enabling an entity for Activity Feeds, but I would assume that it has some step to disable as well.
"...To disable Activity Feeds for an Entity, you will need to click to choose an Entity from Post Configuration grid and click Delete. Publish the change to take it effect."
Finally,  after disabled the the ActivityFeeds.Plugins from solution, CRM came back working.
Tuesday, October 22, 2013
Thursday, October 17, 2013
no image

MSCRM - Microsoft Dynamics CRM 2011: Field Formats

The field data types and formats are rather limited in MS CRM. As a programmer, I'm accustomed to having my cake and eating it too. One of the unfortunately frustrating aspects of using a solution framework is needing to work outside the borders. Things the framework handles natively, are inherently easy to do and a great time saver. Once you move out of that box, it can get dodgy. 

Breaking News
Quick Message
Press Esc to close
Copyright © 2013 Technology KB All Right Reserved