Jump to content
We've recently updated our Privacy Statement, available here ×

Csv adapter encoding problem


vbence

Recommended Posts

 

I have an excel file, I saved is as csv. It mades a csv with ANSI character encoding. I want to use this csv, as a csv data adapter. I tried to create a data adapter with the jaspersoft studio wizard, i changed the encoding to windows-1252 (and tried much other).  It was useless. You can see it on the picture below. When I changed the encoding with notepad++ from ANSI to UTF8 it worked, but i need without manual changing.

 

Windows 1252 because of this stackoverflow question:

 

What is ANSI format? ANSI encoding is a slightly generic term used to refer to the standard code page on a system, usually Windows. It is more properly referred to as Windows-1252 

adapterWizard.png.2f19416b1a7162de51b92e6373ca62d8.png

notepadpict(1).png.70fbce06b25c77e7c0b3fdd9728af2cd.png

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Posted Images

I realized that, maybe the problem : ő,Ő,í,Í,Ű,ű in the csv header row (maybe hungarian character coding). So if i don't have the same characters in the header row, the csv useful content is shown well, correct (when I choose windows-1252).  

But i need that characters in the header (It's business requirements).

It is a bug?

Please help me.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...