Export to CSV NULL turn to \N but when importing from CSV \N turn to text "\N" instead of NULL

harishashim posted 1 week ago in Import/Export

As per the title. Is this a bug?

I have to change all \N to NULL in the csv file to successfully import that CSV with the proper NULL value

ansgar posted 1 week ago

What did you enter (or left) in the "NULL value" text field of the export dialog?

harishashim posted 1 week ago

Must be \N since the output exported is \N

Thanks. That is a useful tips for exporting.

But IMHO more on topic is about importing. And I did not see any NULL related option in the CSV import dialog.

ansgar posted 1 week ago

String values of "NULL" should be imported as NULL value.

Please login to leave a reply, or register at first.