Date field data uploaded does not populate via CSV

5 years 9 months ago #206509 by salazar.ea
All the tools checked out green. So, I'm wondering what could be the issue. My file's header fields and respective data didn't change.
5 years 9 months ago #206511 by jciconsult
I am afraid that I can't help you.
5 years 9 months ago #206534 by salazar.ea
I found the issue. There was a space in the "firstname" field and the comma separator for that field in some of the entries.

The problem with the date upload still persists however. I've tried just straight text "12012014" using the (mm-dd-yyyy) format, I've tried "/" and "-", but still no upload. Are there any settings in CB Configuration that could be adjusted? I have the date format to display as both mm/dd/yyyy and mm-dd-yyyy, but no change.

Erick
5 years 9 months ago #206535 by jciconsult
The key is always to force strings to be delimited with quotes.
CB does NOT determine how dates are processed. It is an QL thing. Make SURE that the csv file that you submit to CBJUICE has every non-numeric field enclosed in quotes.
5 years 9 months ago #206536 by salazar.ea
I did an export of the recently uploaded users, and the format was different this time. The date came back as "yyyy-mm-dd". I changed that string on my csv file, and that solved the problem.

The dates are now populated correctly.
Moderators: beatnantjciconsultwolvertonkrileon
Time to create page: 0.164 seconds
Facebook Twitter Google LinkedIn