Date and Time field

[npolite]

Hello,


We are running Sugar 5.0.0.g. Our customers would like to see on our cases a resolution date and time field. Currently when I create the date field, that is all that is displayed with no option to allow time. Has this been implemented in a newer version? If not does anyone know what files I need to modify to get this to work?

Thanks,
Nick

[npolite]

Can anyone help out?

Thx

[mikesolomon]

Have a look at http://www.sugarcrm.com/forums/showt...light=datetime

Either create the field in module builder or edit vardefs to add it

[npolite]

Thanks for the help. I'm having problems locating which vardefs to modify for the Cases. What I have is a resolution_date_c field which I have created. But when I grep for it no vardefs.php are returned.The Casevardefs that are returned are in the cache so won't they get overwritten?

grep -R resolution_date_c *
cache/modules/Home/Casevardefs.php: 'resolution_date_c' =>
cache/modules/Home/Casevardefs.php: 'name' => 'resolution_date_c',
cache/modules/Home/Casevardefs.php: 'id' => 'Casesresolution_date_c',
cache/modules/ModuleBuilder/Casevardefs.php: 'resolution_date_c' =>
cache/modules/ModuleBuilder/Casevardefs.php: 'name' => 'resolution_date_c',
cache/modules/ModuleBuilder/Casevardefs.php: 'id' => 'Casesresolution_date_c',
cache/modules/Cases/Casevardefs.php: 'resolution_date_c' =>
cache/modules/Cases/Casevardefs.php: 'name' => 'resolution_date_c',
cache/modules/Cases/Casevardefs.php: 'id' => 'Casesresolution_date_c',
cache/modules/Cases/DetailView.tpl:{if $fields.resolution_date_c.acl > 0}
cache/modules/Cases/DetailView.tpl:{$fields.resolution_date_c.value}
cache/modules/Cases/form_SideQuickCreate_Cases.tpl:addToValidate('form _SideQuickCreate_Cases', 'resolution_date_c', 'date', false,'{/literal}{sugar_translate label='LBL_RESOLUTION_DATE' module='Cases'}{literal}' );
cache/smarty/templates_c/%%D8^D8F^D8F13C84%%DetailView.tpl.php:<?php if ($this->_tpl_vars['fields']['resolution_date_c']['acl'] > 0): ?>
cache/smarty/templates_c/%%D8^D8F^D8F13C84%%DetailView.tpl.php:<?php echo $this->_tpl_vars['fields']['resolution_date_c']['value']; ?>
cache/smarty/templates_c/%%96^961^961E3BE0%%form_SideQuickCreate_Cases.tpl. php:addToValidate(\'form_SideQuickCreate_Cases\', \'resolution_date_c\', \'date\', false,\''; echo smarty_function_sugar_translate(array('label' => 'LBL_RESOLUTION_DATE','module' => 'Cases'), $this); echo '\' );
cache/smarty/templates_c/%%8F^8FF^8FF5FFF2%%EditView.tpl.php:<?php if ($this->_tpl_vars['fields']['resolution_date_c']['acl'] > 1 || ( $this->_tpl_vars['showDetailData'] && $this->_tpl_vars['fields']['resolution_date_c']['acl'] > 0 )): ?>
cache/smarty/templates_c/%%8F^8FF^8FF5FFF2%%EditView.tpl.php:<td valign="top" id='resolution_date_c_label' width='12.5%' class="dataLabel" NOWRAP>
cache/smarty/templates_c/%%8F^8FF^8FF5FFF2%%EditView.tpl.php:<?php if ($this->_tpl_vars['fields']['resolution_date_c']['acl'] > 1): echo smarty_function_counter(array('name' => 'panelFieldCount'), $this);?>
cache/smarty/templates_c/%%8F^8FF^8FF5FFF2%%EditView.tpl.php:<?php $this->assign('date_value', $this->_tpl_vars['fields']['resolution_date_c']['value']); ?>
cache/smarty/templates_c/%%8F^8FF^8FF5FFF2%%EditView.tpl.php:<input autocomplete="off" type="text" name="<?php echo $this->_tpl_vars['fields']['resolution_date_c']['name']; ?>
cache/smarty/templates_c/%%8F^8FF^8FF5FFF2%%EditView.tpl.php:" id="<?php echo $this->_tpl_vars['fields']['resolution_date_c']['name']; ?>
cache/smarty/templates_c/%%8F^8FF^8FF5FFF2%%EditView.tpl.php:" id="<?php echo $this->_tpl_vars['fields']['resolution_date_c']['name']; ?>
cache/smarty/templates_c/%%8F^8FF^8FF5FFF2%%EditView.tpl.php:inputField : "<?php echo $this->_tpl_vars['fields']['resolution_date_c']['name']; ?>
cache/smarty/templates_c/%%8F^8FF^8FF5FFF2%%EditView.tpl.php:button : "<?php echo $this->_tpl_vars['fields']['resolution_date_c']['name']; ?>
cache/smarty/templates_c/%%8F^8FF^8FF5FFF2%%EditView.tpl.php:<?php echo $this->_tpl_vars['fields']['resolution_date_c']['value']; ?>
cache/smarty/templates_c/%%8F^8FF^8FF5FFF2%%EditView.tpl.php:addToValidate( \'EditView\', \'resolution_date_c\', \'date\', false,\''; echo smarty_function_sugar_translate(array('label' => 'LBL_RESOLUTION_DATE','module' => 'Cases'), $this); echo '\' );
custom/modules/Cases/metadata/editviewdefs.php: 'name' => 'resolution_date_c',
custom/modules/Cases/metadata/detailviewdefs.php.suback.php: 'name' => 'resolution_date_c',
custom/modules/Cases/metadata/editviewdefs.php.suback.php: 'name' => 'resolution_date_c',
custom/modules/Cases/metadata/detailviewdefs.php: 'name' => 'resolution_date_c',
custom/portal/modules/Cases/metadata/editviewdefs.php: 'field' => 'resolution_date_c',
custom/working/modules/Cases/metadata/editviewdefs.php: 'name' => 'resolution_date_c',
custom/working/portal/modules/Cases/metadata/editviewdefs.php: 'field' => 'resolution_date_c',
custom/history/modules/Cases/metadata/detailviewdefs.php_1229979276: 'name' => 'resolution_date_c',

[mikesolomon]

I would delete the custom field u have created and directly add it cases vardefs
or better add it by the extension method in custom/extension/modules/cases/vardefs

[npolite]

Thanks for the help Mike but there is no custom/extension/modules folder underneath /sugarcrm/htdocs/sugarcrm/custom. The closest I can find is sugarcrm-5.0.0/htdocs/sugarcrm/custom/Extension/application/Ext

[eggsurplus]

Mike means custom\Extension\modules\Cases\Ext\Vardefs

Just create any php file you want like npolite.php in that folder and create your custom field there. Do a quick repair/rebuild afterwards (maybe twice to be safe) to ensure that the changes propagate through.

npolite.php:

 <?php
 
$dictionary['Case']['fields']['my_date_field'] = array (
    'name' => 'my_date_field',
........................................., etc
);
 
?>