SOLVED
Date + time empty after load activity (from csv)?
Hi, I have a file.csv.gz that I need to read. It has the fields date_creation and date_modify with valus if I open it in excel, but when importing in Campaign, campaing gives error satying those fields are null. Why?
**Error:** 10/27/2023 9:04:16 PM PGS-220000 PostgreSQL error: ERROR: null value in column "tsdate_creation" of relation "wkf13422281_464" violates not-null constraint DETAIL: Failing row contains (1, 10993389, 0, 0, 0, 0, GN00001, Novedades, 107671, 1, N000001, Novedades, Minorista, n
Data after loaded by load activity.
Why? Setting the fields to date or date + time gives same result.
File format config:
Edit 1: file opened in notepad:
Could it be the miliseconds causing problems?
1 Accepted Solution
Correct answer by
@god_prophet , In data loading activity > column definition of your date field, select Date format as YYYY/MM/DD
And in 'Year, Month, day:' text box > modify the symbol / into - (because in your file years month and days are separated by - and not by / )
Hi @god_prophet ,
Download the file in your local machine.
In desktop, CSV file > open with > notepad++ / notepad.
In notepad, check what is the date time format for your field and define the same in data loading activity.
Share the screenshot of the field from notepad.
Correct answer by
@god_prophet , In data loading activity > column definition of your date field, select Date format as YYYY/MM/DD
And in 'Year, Month, day:' text box > modify the symbol / into - (because in your file years month and days are separated by - and not by / )
