When you leave a field empty in a csv file and use the merge mode the importer does nothing with that field. This behaviour is in most cases what we want. It allows to change only some of the fields. But in some cases you want to set a field to null. That is not possible.
One very bad example is where a default value is set for a field but you want it to be null for this record. You are not able to create this kind of record with the csv importer.
I want to suggest to allow a special syntax to set a field to null. Like "@@@" or such.
Environment
None
Activity
Show:
Thomas Bayen June 24, 2015 at 3:05 PM
Haha! That is already solved. I should RTFM before writing here...
For the records: You can write "(null)" to set a null value.
Major
When you leave a field empty in a csv file and use the merge mode the importer does nothing with that field. This behaviour is in most cases what we want. It allows to change only some of the fields. But in some cases you want to set a field to null. That is not possible.
One very bad example is where a default value is set for a field but you want it to be null for this record. You are not able to create this kind of record with the csv importer.
I want to suggest to allow a special syntax to set a field to null. Like "@@@" or such.