Tag Archives: tip

Magento, Re-init config values of admin module

Assuming that you want to re initialize the configuration values of a module, the fastest way is to manually remove entries from  table “core_config_data

here i want to remove all saved values for module “price” (be careful if there are other modules that uses the same name) :

delete from core_config_data where path like "price/%";

Extjs, Add tooltip to grid row

The purpose of this tutorial is how to add tooltips for row grids, you can you this when the row is a text field for example.

first of all we need to tell Extjs that row need to be rendered by a custom function, on the column Model add renderer attribute :


{
  id : 'motivation',
  header : 'motivation',
  width: 200,
  dataIndex : 'motivation',
  renderer:addTooltip,

then add the addTooltip function :


function addTooltip(value, metadata, record, rowIndex, colIndex, store){
    metadata.attr = 'ext:qtip="' + value + '"';
    return value;
}

SVN, Ignoring Mac Os hidden files

working with a Mac with SVN can be fastidious especially when you have dozen of .DS_Store ..
So you have to look for the subversion config file on the server at the section global-ignores and add this pattern :

global-ignores = *.o *.lo *.la #*# .*.rej *.rej .*~ *~ .#* .DS_Store .AppleDouble ._*

Or if you don’t have enough permission to do this use the svn propedit svn:ignore command

svn propedit svn:ignore files

files is the directory where we want to ignore file, you will be prompt with the default editor to add the pattern of files .. and there it is !

MySQL, Truncated result with GROUP_CONCAT function.

MySQL function group_concat is a powerful tool to concat strings using a custom sperator :

 

GROUP_CONCAT([DISTINCT] expr [,expr ...]
[ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC] [,col ...]]
[SEPARATOR str_val])

But sometimes the execution result may be truncated because of mysql default setting, so in this case “group_concat_max_len” haveto be changed to a bigger value

SET [GLOBAL | SESSION] group_concat_max_len = val;