Errors in the cells of the csv file

This site is best viewed in a modern browser with JavaScript enabled.

JorgeLuis

When exporting in CSV, I get errors in the cells of the csv file:

The data is in text mode, including the amounts. For the amounts I have an assignment in the form (number_format (({base}), 2, ',', '.'). "". {Symbol})

I solved it by modifying line 110 of the ReportCsv.php file

of
$this->text. = "= \" ". $ output." \ ",";

to
$this->text. = "\" ". $ output." \ ",";

Attached images

peterdeed

Really sorry.. somehow i didnt see this!!!! I will see if i can put this in the code

JorgeLuis

peterdeed Thanks for your answer. Actually, what I wanted to know is if the change I made was correct.

peterdeed

Hi Jorge ... it looks ok .. i think its fine.

JorgeLuis

peterdeed I'm not a programmer, I compared that code with the one I have from version 4.4 and the result was what I needed. Although if you look at the images, the title of the second column should be Año. It seems that it does not recognize special characters.

peterdeed

Ok Jorge, ive had problems with excel generally and special characters, Im sure I need to research the correct character set... I'll try to find the problem when i get some time, unless someone else has any ideas.

JorgeLuis

peterdeed
The funny thing is that in version 4.4 and 4.6 I do not have that problem with special characters. Either in remote server as in local server. In the configuration of projects of the two versions it is in UTF8. That's what I have for version 6.

JorgeLuis

Hi @peterdeed I think I solved the problem with the special characters in the column titles when exporting to CSV. I have commented on two lines of code in the ReportCsv.php file. Tell me if this change is correct or not.:

    public function formatColumnHeader(&$column_item)
    {

    if (!$this->showColumnHeader($column_item)) {
        return;
    }

    $padstring = $column_item->deriveAttribute("column_title", $column_item->query_name);
    $padstring = str_replace("_", " ", $padstring);
    ///$padstring = ucwords(strtolower($padstring));                           /// Cambiado - Anulado
    ///$padstring = ReporticoLang::translate($padstring);                      /// Cambiado - Anulado

    $this->text .= '"' . $padstring . '"' . ",";
}

public function formatColumn(&$column_item)
{
    if (!$this->showColumnHeader($column_item)) {
        return;
    }

    $padstring = &$column_item->column_value;
    // Dont allow HTML values in CSV output
    if (preg_match("/^<.*>/", $padstring)) {
        $padstring = "";
    }

    // Replace Line Feeds with spaces
    $specchars = array("\r\n", "\n", "\r");
    $output = str_replace($specchars, " ", $padstring);

    // Handle double quotes by changing " to ""
    $output = str_replace("\"", "\"\"", $output);
    $this->text .= "\"" . $output . "\","; /// Cambio "=\"" por "\""

}

peterdeed

Hi Jorge .. that is a great find, glad you found that, do you know if the problem is the ucwords function or the translate function...
.. or both? i will investigate what they do

Peter

JorgeLuis

peterdeed I have only acted under the trial and error system. I do not know what those functions do. Sorry.

peterdeed

no problem I was just wondering if you could comment out just one of them to see which one works and which one doesn't.
Don't worry if you don't get a chance

JorgeLuis

I'm sorry @peterdeed, I did not understand you. I have tried to leave the active ucwords function, and that is when the error occurs with the special characters. Apparently, that function changes the first letter to uppercase.

Hope that helps.

peterdeed

Thanks that gives me a clue.. there might be a multi languageversion of ucwords which capitalised the labels.. I'm sure a web search will help me find the answer !