[Vtigercrm-developers] date-time UI?

[socialboostdk]

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