How to pass space or empty string to ImpEx?

Question

I'm working with Hybris and I have to write an ImpEx and pass empty string and space there. I would like to do something like this:

INSERT_UPDATE attr1[unique=true]; attr2
              "someString1"      ; ""
              "someString2"      ; " "

But the problem is that both "" and " " are recognized as null. I checked that database is able to save empty Strings (MySQL is used). And the problem is somewhere in ImpExReader. How can I pass empty space and empty string via impex? Is it possible? Hybris v5.7 is used

Many thanks

score 1 · Answer 1 · answered Aug 19 '18 at 15:16

1

After some investigating it turned out that ImpExReader in Hybris replaces empty strings with null and there isn't any way to pass empty string or blank string via impEx. The point is that some databases cannot hold null value and empty values are used instead. Hybris supports many databases so thats way this approach of replacing blank strings is used

answered Aug 19 '18 at 15:16

Roman P

51
7

Your description of the results of your own investigation gives the perfect answer. Upvoted. – reichhart Mar 11 '20 at 08:13

score 0 · Answer 2 · answered Jun 19 '18 at 07:49

0

Have a look here: https://hybrismart.com/2016/10/30/mastering-hybris-impex-recipes-and-secrets/

I haven't tried it but if it doesn't work then you could go with processing the last saved item and doing it in beanshell.

answered Jun 19 '18 at 07:49

Dario Pedol

2,070
14
24

How to pass space or empty string to ImpEx?

2 Answers2