Has anyone experienced Dates not importing correctly. I've tried this both with the typical import set/transform map and the new spiffy way to import in Dublin with the Excel template that is offered. What happens is this:
I have my original excel file. 7 columns. After everything in imported on the 'review' page, the date is in the field and looks great. See screen shot:(Please ignore the error, that is for another field that has 1 errant value.
The date field shows up correctly. As soon as I hit the 'Complete Import', it finalizes, and on the table...every date field is blank. Our system is setup with YYYY-MM-dd, that field is strictly a date field, with no time. I've attempted to go into transform map, and change the date format there, I've tried changing the format on the original excel file I'm using to import the data.
I've looked in the error logs and there are errors for pretty much every record on the date format with something similar to:
com.glide.db.impex.transformer.TransformCoercionException: Unable to format 2020-12-11 using format string yyyy-MM-dd hh:mm:ss for field u_next_review_date
or
com.glide.db.impex.transformer.TransformCoercionException: Unable to format 2020-12-11 using format string yyyy-MM-dd for field u_next_review_date
I've tried a few things I've found on the community, like changing the date format on the transform map, but so far nothing is working? Any suggestions? Thanks.
You're importing a date into a date/time field. In your transform map, go to the u_next_review_date field mapping. There should be a field on the left side of the form called 'Date Format'. Click on the lightbulb next to it. You should see a list of date formats. Choose the one that matches your data (ie YYYY-MM-DD). Reprocess the import set and transform. That should take care of your problem.
Failing that, you can just hardcode the fix by adding a time onto your string. Check source script and use something like this:
var date = source.u_next_review_date.toString();
answer = date + "00:00:00";
You're importing a date into a date/time field. In your transform map, go to the u_next_review_date field mapping. There should be a field on the left side of the form called 'Date Format'. Click on the lightbulb next to it. You should see a list of date formats. Choose the one that matches your data (ie YYYY-MM-DD). Reprocess the import set and transform. That should take care of your problem.
Failing that, you can just hardcode the fix by adding a time onto your string. Check source script and use something like this:
var date = source.u_next_review_date.toString();
answer = date + "00:00:00";
