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?
Solved! Go to Solution.
Views
Replies
Total Likes
@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 / )
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
hi. @ParthaSarathy , please, check edit 1 in original question.
Views
Replies
Total Likes
@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 / )
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies