[Vtigercrm-developers] date-time UI?

[Uma S]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150107/f92bcfb1/attachment-0001.html>