UTF uncode in Spreadsheet CSV

0
Hello Dear Friends .
First of all I would like to commend once again the Expenser Manager component and give my support to you at work engaged to assist us in the topics of this Forum .

I have a small problem that I think is easy solution for you . I hope you can guide me ...

When I click export files in CSV and open it in excel , data ( sources ) are all misconfigured what seems to be a coding error which defaults to me that I am in Brazil should be UTF -8.

Attached is spreadsheet download from the mistakes ...

I await your response .
Responses (6)
  • Accepted Answer

    Thursday, May 19 2016, 07:28 PM - #Permalink
    0
    SandroAlvarez wrote:

    I Try send a CSV archive but this message appear.... "The file export_2016_05_19.csv, which you are attempting to upload is in an unsupported format." Follow same archive in zip format...
    The reply is currently minimized Show
  • Accepted Answer

    Joan Vilà
    Joan Vilà
    Offline
    Friday, May 20 2016, 08:10 AM - #Permalink
    0
    Hello Sandro,

    As I don't have your characters I would ask you to do a test for me.

    Are you exporting the items from the frontend or from the backend?

    If you are doing it from the frontend, could you please replace this line of code located in (components/com_finances/controller.php line 340:


    header("Content-Type: text/csv");


    with this one:


    header("content-type:application/csv;charset=UTF-8");


    Then, you can try to export it again and see if it works.

    Thank you,
    Joan
    The reply is currently minimized Show
  • Accepted Answer

    Friday, May 20 2016, 02:12 PM - #Permalink
    0
    Good Morning.

    Thanks for answering. I did what you said , changing the command and the file specified line and not getting success ...

    I understand that you do not know about bad English language is evident in the words that these characters are not part of them ... so I'm marking them for you to see who really have a problem here. This print screen I did after making the corrections that you said above.

    I really do not have the knowledge to solve this and need to file download comply with the data that was entered in the front end . Do you have any solutions?
    The reply is currently minimized Show
  • Accepted Answer

    Friday, May 20 2016, 02:14 PM - #Permalink
    0
    I understand that you do not know about bad Portuguese Brazilian language
    The reply is currently minimized Show
  • Accepted Answer

    Friday, May 20 2016, 02:28 PM - #Permalink
    0
    Follow change in controller.php line:340
    The reply is currently minimized Show
  • Accepted Answer

    Friday, May 20 2016, 03:30 PM - #Permalink
    0
    Hi Sandro,

    when I open the CSV file you sent, I can see all characers correctly..

    which makes me think.. could it be an issue with the program you are opening the file with?
    can you change the encoding of what the program (excel, I guess) shows you?
    The reply is currently minimized Show
Your Reply