Category Archives: Fix that bug

Rectification of Indian Currency Symbol(Rupee) in vTiger 6.5


Hello my fellow vtiger developers & enthusiasts.

vTigress team has an exciting update for you. Today we would like to tell about a bug that some users of vTiger 6.5 are facing until now. Recently one of our clients was facing an issue with the currency symbol of Indian Rupee. The client in his present vTiger 6.5 CRM system  saw a question mark/blank area instead of the Rupee Symbol. And the aforesaid error was present across all the modules of vTiger 6.5.

As our client is based in India and his financial transactions occur in Indian currency. Thus, he wanted this issue to be fixed ASAP.

We chalked out the issue and resolved it. Actually, the issue was triggered from  vTiger’s database i.e. there was a field type mismatch for the Rupee Symbol in the database  tables that were related to the Currency fields .

With the aforesaid resolution, the client is now able to view the rupee symbol across all the modules of his present vTiger CRM.

Please refer to the screenshot attached below after the resolution.

rupee-blog-screen

For further details please email us to info@vtigress.com or Skype us at vtigress_for_vtiger

Cheers!!!
Team vTigress

Advertisements

Fix that bug – ReportsTo popup issue in User creation in vtiger 6.3


Dear vtiger enthusiasts

Life has moved on after vtiger5.4. Life for our customers also has moved on. We recently had a few migration requests to vtiger 6.3 from vtiger 5.4 and we noticed that there is this bug in the user creation process in vtiger6.3 where we are not able to select the reporting manager for the user currently in creation. This was mainly because the popup that came up in the RelatedTo window did not have the user names column to choose from. The popup shows only the Office Phone (work_phone) field and not the other fields as shown below.

before the bug fix

 

 

In the new paradigm, the columns that populate the Selection Popup are derived from the list of Summary Fields for any module.

Summary Fields are identified by having the value 1 in the summaryfield column for the field defition in vtiger_field

Only in the absense of Sumary Fields for a module, will the usage of list_fields and list_field_names arrays from the base mcodule class be called upon via the function getRelatedListFields defined in modules//models/Module.php and falls back on modules/Vtiger/models/Module.php if not declared.

In Vtiger 630, the function getRelatedListFields has been modified in Vtiger 630 and does not work due to a code variance(shown below).

The other modules which have the summaryfield attribute set in vtiger_field do not use this function for the Popup listview population.

 

There are 3 ways to get this fixed.

Code the function getRelatedListFields in modules/Users/models/Module.php

OR

Change the declaration of function getRelatedListFields in modules/Vtiger/models/Module.php to old 620 code

OR

Update the summaryfield column value to 1 for a few fields in Users module fields definitions (tabid=29) in table vtiger_field

UPDATE vtiger_field set summaryfield=1 WHERE tabid=29 AND columnname in (“first_name”, “last_name”, “title”, “department”, “reports_to_id”, “email1”);

Any of these fixes will yield the following result.

after the bug fix

 

It is still true that all businesses who need a reporting manager hierarchy within vtiger users only may need this. But it is always a good idea to have a reporting manager for any user so that while the user is disabled or deleted, the records assigned to that user may belong to his supervisor.

We have written to vtiger.com also about this. Hopefully they may add it in their next bug fixes release.

Look for more updates here!!

Enjoy

Best regards

vTigress team

Fix that bug…More menu.. less display


Dear vtiger enthusiasts,

I have always felt that I need to do something about the MORE menu display in vtiger 5.4 because once you have more modules, the display goes literally out-of-control.

‘More’ menu does not display more, it actually displays less than it should.

A client need had that right trigger which pushed me to fix this in header.tpl file

This is the screen shot of a More menu display without the fix.

before more fixing

 

Check this code and update your crm/Smaty/templates/header.tpl file.

<span style="font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 13px; font-style: inherit; line-height: 1.6em;"><TABLE border=0 cellspacing=0 cellpadding=0 width=100% class="hdrTabBg"></span></pre>
<tr>
 {if $MODULE_NAME eq 'Home'}
 50px" class='tabSelected' align = "center"><a href="index.php?module=Home&action=index"><img style="width: 16px; height: 16px;" alt="" src="{$IMAGEPATH}Home.PNG" border="0" /></a>
 {else}
 50px" class='tabUnSelected' align = "center"><a href="index.php?module=Home&action=index&parenttab=My Home Page"><img style="width: 16px; height: 16px;" alt="" src="{$IMAGEPATH}Home.PNG" border="0" /></a>
 {/if}
 <td nowrap>
 <table border=0 cellspacing=0 cellpadding=0>
 <tr>
 <img src="{'spacer.gif'|@vtiger_imageurl:$THEME}" width=2px height=28px align="right">
 {assign var="count" value=1}
 {foreach key=maintabs item=detail from=$MENUSTRUCTURE}
 {if $maintabs eq 'top'}
 {foreach key=number item = name from = $detail}
 {assign var="modulename" value=$name[1]|@getTranslatedString:$name[0]}
 {assign var="modulelabel" value=$name[0]}
 {if $modulelabel ne $MODULE_NAME}
 <td class="tabUnSelected" align="center" nowrap><a href="index.php?module={$name[0]}&action=index">{$modulename}</a></td>
 <img src="{'spacer.gif'|@vtiger_imageurl:$THEME}">
 {else}
 <td class="tabSelected" align="center" nowrap><a href="index.php?module={$name[0]}&action=index">{$modulename}</a></td>
 <img src="{'spacer.gif'|@vtiger_imageurl:$THEME}">
 {/if}
 {/foreach}
 {/if}
 {/foreach}
 {foreach key=maintabs item=detail from=$MENUSTRUCTURE}
 {if $maintabs eq 'more' && $detail != null}
 allMenu');" onmouseover="fnvshobjMore(this,'allMenu','{$ANNOUNCEMENT}');"nowrap><a href="javascript:;">{$APP.LBL_MORE}<img style="padding-left: 5px;" alt="" src="{'menuDnArrow.gif'|@vtiger_imageurl:$THEME}" border="0" /></a>
 <img src="{'spacer.gif'|@vtiger_imageurl:$THEME}">
 {/if}
 {/foreach}
 10px" nowrap>
 {if $CNT eq 1}
<select id="qccombo" style="width: <span class=;">110px" onclick="QCreate(this);"></select>
 <option value="none">{$APP.LBL_QUICK_CREATE}...</option>
 {foreach item=detail from=$QCMODULE}
 <option value="{$detail.1}">{$APP.NEW}&nbsp;{$detail.0}</option>
 {/foreach}
 </select>
 {else}
<select id="qccombo" style="width: <span class=;">110px" onchange="QCreate(this);"></select>
 <option value="none">{$APP.LBL_QUICK_CREATE}...</option>
 {foreach item=detail from=$QCMODULE}
 <option value="{$detail.1}">{$APP.NEW}&nbsp;{$detail.0}</option>
 {/foreach}
 </select>
 {/if}
 </td>
 </tr>
 </table>
 </td>
 10px" nowrap >
 </td>
 </tr>
 </TABLE>
<pre>
 

 

Now take a look at this screen, This is after the code fix.

after more fixing

Note: The image is intentionally blurred.

 

Feel free to contact us at info@vtigress.com if you need to get this implemented for your CRM instance.

Happy More displaying...

best regards

vTigress team

Fix for workflows:: Vtiger deficiency


Dear vtiger users,
I have been waiting for so many days now to write an article under the ‘FIX THAT BUG’ category.
Here it is.
In vtiger modules, workflows do not like attachment or file type fields. The error message is also a bit cryptic and leaves the user, kind of confused. To solve a client’s need to build a workflow for a module that had a file type field, I started to check how it could be overcome without breaking any vtiger principles.
I did that and I succeeded.

You need to replace this old code with the new code.
Both code snippets given here for your reference.

Enjoy!!

As always, you can mail info@vtigress.com for more help in implementation.

include/events/VTWSEntityType.inc has to be updated around line 171
REPLACE OLD CODE


case 'currency':
 $et->type = 'Number';
 $et->format = 'Decimal';
 break;
default:
 print_r($type);
 throw new Exception($type["name"]." is not supported yet.");
 

WITH NEW CODE LINES



case 'currency':
 $et->type = 'Number';
 $et->format = 'Decimal';
 break;
case 'file':
 break;
default:
 print_r($type);
 throw new Exception($type["name"]." is not supported yet.");
 

Reports Improved


Hi all

When I was perfecting the reports code which I shared in my previous post, it struck to me that for a complete reports experience, pagination and search capabilities were the least a user would ask for.

So, now, I have connected the reports output to a jQUery DataTable for better pagination and search capabilities.

Here are the files again

http://rapidshare.com/share/24DE532FC214B4B3BFA1E23DAA02BB7C

and a related screen shot..

reports-update
Happy reports DZining!!

Don’t forget to watch this space for ChartDZiner on which I have been spending sleepless weeks now!!!
Keep reading….

Best regards
S.T.Prasad

vtiger Installation Guide for Invoice Quick Import Plugin


Dear vtiger Subscribers,

Here is the user manual for our quick import plugin for Invoice module of vtiger.

Vtiger CRM by default does not have the import and export option for inventory records. Hence the vTigress team started out by making a tool for importing and exporting inventory records. As a byproduct of this, we were able to create what are called quick import plug-ins for Sales order, Purchase order, Quotes and Invoice module on vtiger.

Presenting the Invoice order quick import plug in for vtiger5.4 that imports the mandatory fields and handles error records also.

Features

  • Works with vtiger CRM5.4
  • INV Import is a quick import for Invoice order records
  • vtiger5.4 compatible
  • Module manager installable
  • Simple import of all records with the click of a button
  • Error handling of bad imports

 INV (invoice order) Quick Import installation

  • Go to the vtiger instance and login with the specified credentials.
vtiger installation manual

vtiger admin page

  • The home page is as shown below. Go to CRM settings in the right corner and click on module manage.
vtiger installation guide

vtiger instance page

  • Now go click on custom module and then click on Import new.
vtiger installation guide

Settings Page

  • Click on choose file and import an Invoice zip file from the Computer and click on import.

    vtiger installation manual

    Import a Zip file

  • Now accept the license and click on yes.

    Import a Zip file

    Import a Zip file

  • Now go back to home page and click on “More” and choose “Invoice order” from the list. Now it redirects to screen below. Then you will see a “INV Import” button available for importing INV records.
Verify the INV Import Plugin

Verify the INV Import Plugin

Import the Invoice order records from the excel file

  • As shown in the picture click on ‘INV Import’ button and import an excel file with Invoice order module records which contains only mandatory fields.
Choose an excel file.

Choose an excel file.

  • Conform the import of the excel file.
vtiger installation guide

Conform the import

  • When it is a good file the results will be as shown below. All records are fine without any errors.
Verify the recorded Imports

Verify the recorded Imports

  • This screen shows a bad import file with an error, which is not approved in the CRM hence colored in red.

    Check the error records.

    Check the error records.

  • Now refresh the page and see all the correct imports are imported on the screen.

    Refresh the page

    Refresh the page

To download this guide, please use this link-Invoice Quick Import User Guide

vtiger Import/Export Feature For Inventory Modules..(Contd..)


Almost got the import to work except for a few glitches here and there.

Tried to make the GUI as simple and as neat as possible so that it mainly copies the default vtiger look and feel.

Here, the searched records as well as the selected records can be exported.

Currently the Export works by copying master records in the first sheet of the excel file and the item details in the second sheet.

Some code and exceptions caught, help files updated and we should be done to release it to the buyers.

——————————————————————————————–

Have always wondered why did vtiger not give the Import Export feature for Inventory modules.

Seemed very logical to be able to import and export sales records with item details and records ids neatly put in excel like looking sheets.

Recently had an inquiry for the same who asked only for Sales Order module.

Was not able to focus on anything else till I cracked it.

Now, after 4 days, I got the Import and export to work… though I started with sales order, now I am able to import and export records using all inventory modules Sales Order, Purchase Order, Quotes and Invoice.

 

Will soon make it available as an installable zip file for buyers in our website http://www.vtigress.com

Inquiries  welcome!!

Mail to info@vtigress.com

Happy Importing/Exporting……