de.hybris.platform.impex.jalo.ImpExException: unexpected char # after cell end at 1 in line 235 : '"#% impex.includeExternalData(ImpExManager.class.getResourceAsStream

[Former Member]

Hi All,

am trying to give the path of an impex that is present under customized core extension in essential_data impex file of my customised core extension like below:

 "#% impex.includeExternalData(ImpExManager.class.getResourceAsStream(""/impex/import/country/xyz/usergroups.impex""), ""utf-8"", 0, 0 );";
 "#% impex.includeExternalData(ImpExManager.class.getResourceAsStream(""/impex/import/country/xyz/catalogs.impex""), ""utf-8"", 0, 0 );";
 "#% impex.includeExternalData(ImpExManager.class.getResourceAsStream(""/impex/import/country/xyz/catalog_sync.impex""), ""utf-8"", 0, 0 );";

its throwing the below exception in console logs

 de.hybris.platform.impex.jalo.ImpExException: unexpected char # after cell end at 1 in line 235 : '"#% impex.includeExternalData(ImpExManager.class.getResourceAsStream(""/impex/import/country/xyz/usergroups.impex""), ""utf-8"", 0, 0 );";'

[andyfletcher · Accepted solution]

I suspect it is something as simple as an unclosed quote in your file before the lines that you have shown here.

E.g. if I run this impex I get the same error as you

 INSERT_UPDATE Product;"
 "#% impex.includeExternalData(ImpExManager.class.getResourceAsStream(""/impex/import/country/xyz/usergroups.impex""), ""utf-8"", 0, 0 );"

[Former Member · Accepted solution]

Many thanks for the solution.

[andyfletcher · Accepted solution]

No worries. Please go ahead and accept the solution if it worked for you.