Backoffice import is throwing null pointer exception

[Former Member]

Hi,

When I am trying to import csv file from back office , I am getting null pointer exception.

Caused by: java.lang.NullPointerException at de.hybris.platform.impex.jalo.imp.MultiThreadedImpExImportReader.setCurrentHeader(MultiThreadedImpExImportReader.java:334) ~[impexserver.jar:?] at de.hybris.platform.impex.jalo.ImpExReader.createAndSetAsCurrentHeader(ImpExReader.java:2019) ~[impexserver.jar:?] at de.hybris.platform.impex.jalo.ImpExReader.readLine(ImpExReader.java:1957) ~[impexserver.jar:?] at de.hybris.platform.impex.jalo.imp.ImpExImportReader.readLine(ImpExImportReader.java:500) ~[impexserver.jar:?] at de.hybris.platform.impex.jalo.imp.MultiThreadedImpExImportReader.readLineFromWorker(MultiThreadedImpExImportReader.java:362) ~[impexserver.jar:?]

Can anyone please suggest why exactly the header is coming as null ?

[Former Member]

Thanks Ravi .I will try this way and let you in case I face any issue.

[ravi_tavva]

Udit, you can import data into backoffice thru excel files only. Though you can export data either in excel or in csv format.

If you want to import product data into backoffice via excel file, do the following.
1. First export couple of products out of backoffice.
2. Save the file
3. Observe the header of the file
4. Modify the file accordingly
5. Finally import the modified excel file.

Hope this helps!