Expand my Community achievements bar.

SOLVED

Date + time empty after load activity (from csv)?

Avatar

Level 5

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


ogonzalesdiaz_0-1698439566818.png

Data after loaded by load activity.

ogonzalesdiaz_1-1698439693756.png

Why? Setting the fields to date or date + time gives same result.


File format config: 

ogonzalesdiaz_0-1698444282296.png

 

 

ogonzalesdiaz_1-1698444306310.png

 




Edit 1: file opened in notepad: 

Could it be the miliseconds causing problems?

ogonzalesdiaz_0-1698617206665.png

 



 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@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 / )

View solution in original post

3 Replies

Avatar

Community Advisor

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.

Avatar

Correct answer by
Community Advisor

@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 / )