Nuxeo CSV Importer update document, change existing integer to null

I am doing a bulk update using nuxeo csv-import.

The documents have existing data in an integer field.

I'd like to force the integer fields to have a null value. To be clear, this means the value in my:integerField will need to change from “12345” to ““. I've tried:

“name”,“type”,“my:integerField”

“MyDoc”,“MyType”,

“MyDoc”,“MyType”,

“MyDoc”,“MyType”,null

“MyDoc”,“MyType”,NULL

“MyDoc”,“MyType”,“null”

“MyDoc”,“MyType”,“NULL”

“MyDoc”,“MyType”,\N

“MyDoc”,“MyType”,“\N”

“MyDoc”,“MyType”,“”

“MyDoc”,“MyType”,''

“MyDoc”,“MyType”,“NULL

“MyDoc”,“MyType”,“{@code null}”

“MyDoc”,“MyType”,{@code null}

etc etc.

I'm using Nuxeo 8.10 with postgresql.

Any suggestions?

0 votes

1 answers

75 views

ANSWER



Unfortunately it is currently not possible to import null values.

0 votes



Thanks, Florent. That was my fear.

In case anyone else comes across this: I was able to use curl instead.

$ curl -d '{"entity-type": "document","properties":{"my:integerField":null}}' -H 'Content-Type:application/json' -X PUT -i -u Administrator:Administrator http://localhost:8080/nuxeo/api/v1/path/to/document

11/16/2018