Product Import Wizard : Expression : FUNCTION LEN does not exist

Product Import Wizard : Expression : FUNCTION LEN does not exist

Avatar image
May 11, 2016
Davide wrote
I'm trying to get from the excel file the file name except .jpg portion of it.
SUBSCRING('123-456.jpg', 1, LEN('123-456.jpg') - 4)
But the execution result is FUNCTION LEN does not exist.
Does that need to be added to the StoreManager SQL library?

Thanks,
Reply
3 Answers
Avatar image
May 11, 2016
Davide wrote
* SUBSTRING('test string', 1, LEN('test string') - 4)
Avatar image
May 12, 2016
Alexandra Kold agent wrote
Thank you for contacting us and your question.

Actually, we don't work with custom application like https://msdn.microsoft.com/en-us/library/ms190329.aspx , we use MySQL which doesn't support LEN() function .

We recommend for testing launch the following query in Custom SQL section of Store Manager - SELECT SUBSTRING('test string', LENGTH('test string') - 4) AS test .

I would like to share with you the following online document - http://dev.mysql.com/doc/refman/5.7/en/string-functions.html - it could be useful in such case.

If you need any assistance - let us know.

Sincerely, eMagicOne team
May 18, 2016
System wrote
Hello,

We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com

Maybe we are waiting for some information from your side? In this case please get back to us.

In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.

If you do not reply us back, the ticket will be automatically closed within 24 hours.

With kind regards,

The eMagicOne Administration Team