Null/Blank values from csv is getting IGNORED at impex in hybris

[bidyadhar_tripathy]

Hi All,

For below csv file , if the attribute value is null/blank then in generated impex it is coming as but as per our requirement null/blank should be updated at hybris end.

CSV

 7,40,0,1,,TRUE
 7,50,0,1,1340,FALSE

IMPEX

 7;40;0;1;<ignore>;TRUE - Actual
 7;40;0;1;;TRUE - Expected
 7;50;0;1;1340;FALSE

Note : Here data flows between Datahub (CSV) to Hybris (IMPEX)

[Slava · Accepted solution]

Bidyadhar,

If you're asking in the context of DataHub then you may want to read "Emptying Attribute Values After They are Set" section in https://help.hybris.com/1811/hcd/9677910439ac4268ba3d515e911279b5.html

It's true, by default empty values in the data loaded to DataHub are treated as "not provided". To empty out current values, the payload has to specifically say so. See the document.

[bidyadhar_tripathy · Accepted solution]

Thank you Slava for your response. I tried with in CSV and it is working fine.

[former_member1573]

OOTB the box blank/null values are treated as ignore only and if you have specific requirement for this then you can write your own CSVReader class where you can add your transformation logic for creating Impex.