Export CSV - błąd - OLD Forum of Users and Developers of Epesi BIM

Export CSV - błąd

eltonik

Witam, przy exporcie CSV pojawia się błąd:

Type: E_NOTICE (8)
Message: fputcsv(): enclosure must be a single character
File: /var/www/epesi/modules/Utils/RecordBrowser/CsvExport.php
Line=154
error backtrace:
[PHP core called function]
    function called: handle_epesi_error(8, "fputcsv(): enclosure must be a single character", "/var/www/epesi/modules/Utils/RecordBrowser/CsvExport.php", 154, Array (???, Array (#31), Array (#34), Array (#20), "
", "&quot;", "1"))

File: /var/www/epesi/modules/Utils/RecordBrowser/CsvExport.php
    line 154
    function called: fputcsv(???, Array (#34), ",", "&quot;")

File: /var/www/epesi/modules/Utils/RecordBrowser/CsvExport.php
    line 92
    function called: to_handle(???)

File: /var/www/epesi/modules/Utils/RecordBrowser/csv_export.php
    line 39
    function called: to_output()

eltonik

Może jakiś dostęp RW jest potrzebny poza katalogiem ./DATA?

nnader

W 'administrator->CommonData' dla 'Systesm->csv_export_params' zmień wartość 'text_space_separator' na podwójny cudzysłów (") i zapisz.

eltonik

Tak jest, błąd występuje od samego początku
\

nnader

Spróbuje przedytować tak czy inaczej, wpisz " i zapisz. Wygląda na to, że masz jednak "

eltonik

OK, działa, szkoda ze wsześniej nie napisałeś o "

nnader

Pisałem wcześniej, żebyś wszedł do common data i zapisał ten parametr.

eltonik

Niestety nie pomaga ? po zmianie na " i później po ponownej edycji jest "
Napisałem że działa i nie sprawdziłem exportowanego pliku

nnader

Rzeczywiście, jest błąd przy eksporcie który nie conwertuje kod ascii na znak. Wprowadziłem zmiany na githubie i wypuścimy poprawkę do tego w nastepnym revision. W międzyczasie proszę poprawić te dwie linie https://github.com/Telaxus/EPESI/commit/ae76d0e54399d0de0f9e8219b695a86373021088
czyli w modules/Utils/RecordBrowser/CsvExport.php na linii 154 należy wprowadzić

        fputcsv($f, $cols, $this->field_separator, chr($this->text_space_separator));

i na linii 224

        fputcsv($f, $rec, $this->field_separator, chr($this->text_space_separator));

Dziękujemy za znalezienie bugu!

eltonik

na chwile obecną po poprawkach export wygląda wygląda tak:

Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto
Record ID	Created on	Created by	Edited on	Edited by	Title	Description	Date	Time	Duration	Employees	Status	Priority	Permission	Customers	Recurrence type	Recurrence end	Recurrence hash	TekLab	Related	Visit producer	AndroidRaport	Geppetto

ilość wierszy odpowiada ilości exportowanych rekordów

nnader

Czy modyfikowałeś CsvExport.php poza tymi zmianiami, albo w Utils/RecordBrowser?

eltonik

nic nie robiłem, taki był od samego początku w paczce. pociagne jeszcze z githuba i zobacze

eltonik

OK, pobrałem z githuba CsvExport.php i jest OK, sprawdzcie paczkę na SF

nnader

Pliki są takie same na SF i na githubie. Zakładam, że pobrałeś z mastera. SF jest kopią z tagu v1.8.2.2. Tak, na masterze wrzuciłem już poprawkę. Wygląda na to że zamiast wkleić

 fputcsv($f, $rec, $this->field_separator, chr($this->text_space_separator));

na linii 224 wpisałeś

fputcsv($f, $cols, $this->field_separator, chr($this->text_space_separator));

pisałem wyżej, że to ma iśc tylko na linii 154.
To by tłumaczyło dlaczego pojawiały Ci się nazwy kolumn ?

dongordon

Mi również pojawia się błąd przy próbie eksportu do CSV mimo zainstalowanej najnowszej wersji:

Type: E_USER_ERROR (256)
Message: Invalid CommonData::get_array() request: System/csv_export_params
File: /epesi/modules/Utils/CommonData/CommonDataCommon_0.php
Line=253 error backtrace: [PHP core called function] function called: handle_epesi_error(256, "Invalid CommonData::get_array() request: System/csv_export_params", "/epesi/modules/Utils/CommonData/CommonDataCommon_0.php", 253, Array ("System/csv_export_params", "value", false, false, Array (#1), false))
File: /epesi/modules/Utils/CommonData/CommonDataCommon_0.php line 253 function called: trigger_error("Invalid CommonData::get_array() request: System/csv_export_params", 256)
File: /epesi/modules/Utils/RecordBrowser/CsvExport.php line 36 function called: get_array("System/csv_export_params")
File: /epesi/modules/Utils/RecordBrowser/csv_export.php line 31 function called: __construct("company", Object (Utils_RecordBrowser_Crits), Array ("DESC"), "1")

eltonik

Witaj.

pobierz z github pliki CsvExport i csv_export i wgraj do odpowiedniego katalogu
Sprawdź:
common data - ustawienie parametrów
sprawdz poprawkę nnader

dongordon

Zrobione
Zrobione (chociaż wszystko było identycznie)
Nie widzę w Common Data tego o czym pisał nnader. Poniżej to co mam.

nnader

Wejdź do panelu admina, wybierz 'run php command', i wpisz ten kod

        Utils_CommonDataCommon::new_array('System',[],false,true);
        Utils_CommonDataCommon::new_array('System/csv_export_params', [
            'charset'               => 'UTF-8',
            'field_separator'      => ',',
            'decimal_separator'    => '.',
            'end_line_type'        => 'UNIX',
            'text_space_indicator' => 1,
            'text_space_separator' => '"'
        ],
            true,
            false
        );

czy na pewno masz zainstalowany ostatni revision?

dongordon

Dzięki nnader, teraz działa. Moja wersja: 1.8.2 rev20170830

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge