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

[expired user #11933]'s profile image [expired user #11933] posted 5 years ago in Import/Export Permalink

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's profile image ansgar posted 5 years ago Permalink

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

[expired user #11933]'s profile image [expired user #11933] posted 5 years ago Permalink

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's profile image ansgar posted 5 years ago Permalink

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

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