Home Search Tags Members

Home » Kartris ASP.NET Ecommerce Software » Data Tool » Data export doesn't output Hebrew letters

Data export doesn't output Hebrew letters

Posted By Booker Mon 26 Jan 2015
Add to Favorites0

Data export doesn't output Hebrew letters

Topic View Topic View Topic Options Topic Options
Author Message
Booker
Posted Mon 26 Jan 2015
Supreme Being

Supreme Being - (1,879 reputation)Supreme Being - (1,879 reputation)Supreme Being - (1,879 reputation)Supreme Being - (1,879 reputation)Supreme Being - (1,879 reputation)Supreme Being - (1,879 reputation)Supreme Being - (1,879 reputation)Supreme Being - (1,879 reputation)Supreme Being - (1,879 reputation)

Group: Forum Members
Last Active: Tue 27 Jan 2015
Posts: 3, Visits: 24
Hello all,

I have many products named in Hebrew, when I export into spreadsheet each letter becomes a "?"like this ????? ?? ????????? ????
Is there any setting to fix that?
Tags
Post Information
bpaluch
Posted Tue 5 May 2015
Supreme Being

Supreme Being - (40,046 reputation)Supreme Being - (40,046 reputation)Supreme Being - (40,046 reputation)Supreme Being - (40,046 reputation)Supreme Being - (40,046 reputation)Supreme Being - (40,046 reputation)Supreme Being - (40,046 reputation)Supreme Being - (40,046 reputation)Supreme Being - (40,046 reputation)

Group: Forum Members
Last Active: Thu 23 Jul 2020
Posts: 70, Visits: 175
Thanks, Paul, for helping me find my way with this one.

In Kartris.vb, WriteToCSV function, change the line with the ASCII encoding

Dim data() As Byte = System.Text.ASCIIEncoding.ASCII.GetBytes(strData.ToString)

to this

Dim data() As Byte = System.Text.UTF8Encoding.UTF8.GetBytes(strData.ToString)

When exporting, choose SAVE, then open the file in notepad. You will see the HEbrew chars.

(If you open in Excel, it will be messed up)
Post Information
Paul
Posted Tue 5 May 2015
große Käse

große Käse - (449,456 reputation)große Käse - (449,456 reputation)große Käse - (449,456 reputation)große Käse - (449,456 reputation)große Käse - (449,456 reputation)große Käse - (449,456 reputation)große Käse - (449,456 reputation)große Käse - (449,456 reputation)große Käse - (449,456 reputation)

Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806, Visits: 2,737
Can you try changing the content type line to this

        Current.Response.AddHeader("Content-Type", "application/Excel; charset=utf-8")
This sets the header on the file, with the charset there it may be that Excel understands better how to open this directly.

--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.

If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
Post Information

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top

Powered By InstantForum.NET 2012-1 © 2024
Execution: 0.047. 11 queries. Compression Enabled.