Developer forum

Forum » Integration » Excel Import where field value including 'Enter line'

Excel Import where field value including 'Enter line'

E-mail notifications
Dynamicweb Employee
Thet Nong Phu
Reply
Posted on 13/09/2021 07:01:45

Dear Sir,

Currently, we are open up the integration module to customer for running the price import job where they accidently put the 'Enter line' in ProductID. Data imported with /n and this cause the issue in database. Other than control from excel, any way can control from our side? Can we use trim function in integration? Please advise.

Thanks,

Phu


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 14/09/2021 09:11:27
Reply

Hi Phu,
you can implement the custom TableScript class that can do any stuff with the source row data before it gets to the destination provider.
You can read more about it here.
BR, Dmitrij

 

You must be logged in to post in the forum