import problem with time fields

[JD Kromkowski]

I am finding that when I import a CSV file into a table, it leaves time fields blank. Is there some special trick? I’ve recreated as follows. Set up a table with some fields including time field. Add some data, including time field data. Export to csv Delete the table data and import your csv back into the table. Time field will be blank.

[Michael]

On 15/01/2013 17:37, kromkowski wrote:
> I am finding that when I import a CSV file into a table, it leaves time
> fields blank.
>
> Is there some special trick?
>
> I've recreated as follows.
>
> Set up a table with some fields including time field.
> Add some data, including time field data.
> Export to csv
> Delete the table data and import your csv back into the table.
> Time field will be blank.

First I have heard of it. The CSV import stuff was written a long time ago, so I will have to log this and we will return to it.
Thanks for the report.

Ciao, Neil

[JD Kromkowski]

On 01/23/13 7:45 AM, Neil Robinson wrote:
> On 15/01/2013 17:37, kromkowski wrote:
>> I am finding that when I import a CSV file into a table, it leaves time
>> fields blank.
>>
>> Is there some special trick?
>>
>> I've recreated as follows.
>>
>> Set up a table with some fields including time field.
>> Add some data, including time field data.
>> Export to csv
>> Delete the table data and import your csv back into the table.
>> Time field will be blank.
>
> First I have heard of it. The CSV import stuff was written a long time ago, so I will have to log this and we will return to it.
> Thanks for the report.
>
> Ciao, Neil
>

I think it is related to the the bugs involving Modify Table and time
(and date) handling functions.

Create a table with a time field.
The default display format will be
"hh:mm:ss tt am"

Try to put in "09:30 am". No luck.

And this is exactly the problem that is happening with the CSV import.
It has nothing to do with the import, but everything to do with the how
text is handled when entered into a time field. It is and has been
messed up.

JDK

[Michael]

On 24/01/2013 17:41, kromkowski wrote:
> On 01/23/13 7:45 AM, Neil Robinson wrote:
>> On 15/01/2013 17:37, kromkowski wrote:
>>> I am finding that when I import a CSV file into a table, it leaves time
>>> fields blank.
>>>
>>> Is there some special trick?
>>>
>>> I've recreated as follows.
>>>
>>> Set up a table with some fields including time field.
>>> Add some data, including time field data.
>>> Export to csv
>>> Delete the table data and import your csv back into the table.
>>> Time field will be blank.
>>
>> First I have heard of it. The CSV import stuff was written a long time ago, so I will have to log this and we will return to it.
>> Thanks for the report.
>>
>> Ciao, Neil
>>
>
> I think it is related to the the bugs involving Modify Table and time
> (and date) handling functions.
>
> Create a table with a time field.
> The default display format will be
> "hh:mm:ss tt am"
>
> Try to put in "09:30 am". No luck.
>
> And this is exactly the problem that is happening with the CSV import.
> It has nothing to do with the import, but everything to do with the how
> text is handled when entered into a time field. It is and has been
> messed up.

Hmmm. This may have been fixed in the changes I recently made then to resolve other issues. You are talking about the CSV import
inside of Personal, as opposed to directly using the library I assume. It is very possible that these issues were all fixed by
changes to the way Personal uses the default data and field data now.

Ciao, Neil

[Author]

Posts