csv exporting & importing: date & time fields

[vsawri]

1) is there a way to make it so that when i export date and time fields into csv, i get what i see in the fabrik table instead of what's in mysql ? mysql seems to have a different timezone so all my date time data when exported to csv is set to +6hrs from CST. i want the export to be in CST.

2) and is there a way to import csv back without losing the time portion of a date time field ?

thx.

[vsawri]

another issue i have

3) when i use the 'Always return todays date' it outputs date & time with +6hrs offset from CST also? is there anyway to localize all of this ?

[cheesegrits]

1) At the moment, no. We always store datetime in the database in GMT, and apply the server TZ offset when rendering. So the assumption on CSV import / export is that all times are in GMT. This might be an option we can add to the import/export at some point, but at the moment ... it's GMT.

2) I wasn't aware we were losing the time portion. I'll take a look. Out of interest, what are your form and table date formats set to on your date element?

3) When you say "it outputs", do you mean that's what is in the raw table, or that's what we are showing when rendering a table or form?

-- hugh

[vsawri]

1) k, thx.

2) k, thx, and date elements set to %Y-%m-%d for form (cause it has that time selector), date elements %Y-%m-%d %H:%M for table.

3) its what the rendered form and table is showing.

thx for the assistance hugh

also, i'm using latest svn .

-sawri

	SVN SVN (short for Sub Version) is the source code control system we use to manage the Fabrik code with. The SVN will always contain bug fixes and new features which have been added since the last ZIP in the downloads area was built. We allow public access to our SVN repository, so users always have access to the latest and greatest version. Click the link next to this popup to go to a page which describes how to access our SVN repository.

[cheesegrits]

For 3), I seem to recall some discussion of the wy's and wherefore's of this recently.

For now, I suggest you just create you own eval'ed default using date() or gmdate() as appropriate, so you get whatever result you are wanting.

-- hugh

[vsawri]

k, thanks hugh.


just in case someone ran into this same issue, and needed a quick fix, here's how i ended up doing it. with the following javascript set run onload.

it updates the datetime element 'fab_WorkSchedule___ludate'

dn = new Date();

dnmon = (dn.getMonth() + 1);
if (dnmon < 10) {
    dnmon = '0' + dnmon;}

dnmin = dn.getMinutes();
if (dnmin < 10) {
    dnmin = '0' + dnmin;}

xdn = dn.getFullYear()+'-'+dnmon+'-'+dn.getDate()+' '+dn.getHours()+':'+dnmin;

$('fab_WorkSchedule___ludate_cal').value = xdn;