Date field data uploaded does not populate via CSV

8 years 1 week 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.

Please Log in to join the conversation.

8 years 1 week ago #206511 by jciconsult
I am afraid that I can't help you.

Please Log in to join the conversation.

8 years 1 week 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

Please Log in to join the conversation.

8 years 1 week 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.

Please Log in to join the conversation.

8 years 1 week 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.

Please Log in to join the conversation.

Moderators: beatnantjciconsultwolvertonkrileon
Time to create page: 0.424 seconds

Facebook Twitter LinkedIn