Nuxeo CSV Importer update document, change existing integer to null

LaraGranite_ — Fri, 16 Nov 2018 17:13:29 GMT

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",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?

Re: Nuxeo CSV Importer update document, change existing integer to null

Florent_Guillau — Fri, 16 Nov 2018 19:05:50 GMT

Unfortunately it is currently not possible to import null values.

Re: Nuxeo CSV Importer update document, change existing integer to null

LaraGranite_ — Fri, 16 Nov 2018 19:11:25 GMT

Thanks, Florent. That was my fear.

topic Re: Nuxeo CSV Importer update document, change existing integer to null in Nuxeo Forum

Nuxeo CSV Importer update document, change existing integer to null

Re: Nuxeo CSV Importer update document, change existing integer to null

Re: Nuxeo CSV Importer update document, change existing integer to null