Big problem encountered. When importing a date field mapped to a date field in Daylite, the import dialog box asks for the date format. If you fail to specify a date format, nothing gets imported. If you specify a date format, your data gets in.

When you map a date field to a custom form date field, the import dialog box does not ask for the user to specify a date format. You can map the date field to the DL custom form date field, but nothing pops up to request a date format. Consequently, when you run the import, none of the dates are imported.

Is this an oversight? I have numerous date fields in my custom forms and no way to get the dates into Daylite, short of manually adding them. I hope I'm missing something.

Thanks for any help.

Hello,

Thanks for bringing this to our attention. I can see that the date field format selector is missing. This must be an oversight and I've logged it for our engineers to address as soon as possible.

I'll try and find a work around and post back.

Thanks!
Amin

Hello!

An update on this issue. We're going to work on the fix and do our best to include it in the next update.

In the interim there is a work around, but it's a bit tricky. Basically the date string in the import file has to be in a *very* specific format. Here is an example of one saved to the database having been created through the user interface.

2008-07-22 00:00:00 -0400

So basically: year-month-day, and since your file probably doesn't have times associated you can just make it like the one above with the 0's and then the timezone offset.

If you open the import file in Excel, usually it will allow you to manipulate cell format quite extensively. It might be difficult to get it into a format that's so raw, but if anyone else has any suggestions, please post!

Thanks!
Amin

Quick update to Amin's post. The workaround works. Excel allows reformatting a 3/8/08 date to 2008-03-03 00:00:00. Save that file, then open in BBEdit or maybe TextWrangler and find/replace 00:00:00 with 00:00:00 -0500 (or whatever your time zone offset is). Then save file and import into DL. It's a chore with a lot of data but it works!