[Vtigercrm-developers] date-time UI?

[Uma S]

Hi,

Right now in vtiger we are using ui-type 70 for only createdtime and
modifiedtime of module and these are treated as special fields and handled
carefully.

As we need to provide back end support at many places to make ui-type 70 as
standard.

Even you trying to create uitype 70 field, should take care of dependencies
at many places.

On Wed, Jan 7, 2015 at 1:49 PM, socialboostdk <socialboostdk at gmail.com>
wrote:

> Hi again,
>
> Ok - I'll try with the external script, thank you.
>
> Just out of curiousity - why is the UI-type 70 not included as standard?
> Would that not be a good idea to include in Vtiger 6.2 (or patch or 6.1)?
>
> :)
>
> On 7 January 2015 at 09:10, Uma S <uma.s at vtiger.com> wrote:
>
>> Hi,
>>
>> From UI there is no option to create a field of type date-time, where as
>> you can achieve this through external script by creating field of uitype 70
>> (date-time) refer vtiger_field table for info.
>>
>> While importing data, map your date-time value field to this custom field
>> created to solve the issue.
>>
>> Hope so this tip might help to resolve your issue.
>>
>> With
>> Regards
>> Uma S
>> Vtiger Team
>>
>> On Tue, Jan 6, 2015 at 7:42 PM, socialboostdk <socialboostdk at gmail.com>
>> wrote:
>>
>>> Hi Uma,
>>>
>>> Thanks for your quick reply.
>>>
>>> I perhaps do not 100% understand the answer :-)
>>>
>>> I'm actually on viger 6.0, but assume this part is the same as 6.1.
>>>
>>> If I have the string "14-11-2014 12:00:20" as an example, then this is
>>> 100% identical with the default "Created Time"-format.
>>>
>>> But does this format (date+time) not exist as UI in Vtiger? Only date
>>> alone or time alone?
>>>
>>> I'm trying to import some CSV data from other system, and here they are
>>> stored as date-time, so its giving me problems. I could of course just
>>> import them as text, but then I can't really use them for anything.
>>>
>>> Is there any way round it? I suppose that one way of solving it would be
>>> to make it into two fields, ie. date and time, but that would require some
>>> additional scripting on my side (as there are several thousands of lines in
>>> the CSV).
>>>
>>> Thanks for all your input!
>>>
>>> best,
>>> Chris
>>>
>>> On 6 January 2015 at 08:31, Uma S <uma.s at vtiger.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> Now in vtiger 6.1.0 through edit fields you can create custom date
>>>> field but not date-time. We tried to reproduce this case by creating custom
>>>> date field and filling date-time value from csv file which failed. As type
>>>> of field and value that's getting filled is not matching.
>>>>
>>>> Filling date value through csv file for custom date field works fine.
>>>>
>>>> Are you creating date-time field from external script and trying to
>>>> fill value? or for date field you are trying to fill date-time value?
>>>>
>>>> On Mon, Jan 5, 2015 at 8:36 PM, socialboostdk <socialboostdk at gmail.com>
>>>> wrote:
>>>>
>>>>> Hi there,
>>>>>
>>>>> I'm trying to import a (correctly formatted) CSV, but it messes up the
>>>>> dates. Ie i've added custom field w. date, and i am trying to import the
>>>>> string: "11-09-2014 09:20:22" - but it wont work?
>>>>>
>>>>> How can I import a field w. date + time?
>>>>>
>>>>> thanks :)
>>>>>
>>>>> _______________________________________________
>>>>> http://www.vtiger.com/
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> With
>>>> Best Regards
>>>> Uma.S
>>>> Vtiger Team
>>>>
>>>> _______________________________________________
>>>> http://www.vtiger.com/
>>>>
>>>
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>>
>>
>>
>>
>> --
>> With
>> Best Regards
>> Uma.S
>> Vtiger Team
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
> _______________________________________________
> http://www.vtiger.com/
>



-- 
With
Best Regards
Uma.S
Vtiger Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150107/20a7f515/attachment.html>