"The total length of a DataValidation list cannot exceed 255 characters" error while exporting products in Excel in Nopcommerce 3.8

Hi,

I am trying to export products onto an Excel file. But I get this error "The total length of a DataValidation list cannot exceed 255 characters".

I'm using Nopcommerce 3.8. I have read here in the forum that there's a changeset that we can download to solve this issue. Can anyone point me to the exact location and explain how to do it step by step?

Thank you.

Hi @bachbin,

Are you talking about this changeset? https://github.com/nopSolutions/nopCommerce/issues/1772

as per this topic: https://www.nopcommerce.com/boards/t/44410/excel-export-failing-in-v38.aspx

Yes, exactly...

We need to modify 2 files:

src/Libraries/Nop.Services/ExportImport/ExportManager.cs
src/Libraries/Nop.Services/ExportImport/Help/PropertyManager.cs

My website is live and I don't know where to make the changes. I have done everything online right from installation. I do not have a local copy so I'm quite lost here. Please advice.

Thank you.

bachbin wrote:


Hi @bachbin,

You will need source code to make these changes.

You may find this article helpful: http://www.strivingprogrammers.com/Difference-between-No-Source-Web-OR-Source-Code-of-nopCommerce