FreenetIS verze: 1.1.18
PHP verze: 5.4.45-0+deb7u4
Nahlasil: Milos Machek
Popis: Snaha o nacteni vypisu Fio banky ve formatu csv
prvni radek vypisu je:
iconv( cp1250, UTF-8, "Datum";"ID operace";"ID pokynu";"KS";"Nazev banky";"Nazev protiuctu";"Objem";"Mena";"Protiucet";"Kod banky";"Zadal";"SS";"Typ";"Poznamka";"VS";"Upresneni - objem";"Upresneni - mena";"Zprava pro prijemce"
9
Chyba se vyskytla na radku 69 souboru application/libraries/importers/Csv_Fio_Bank_Statement_File_Importer.php.
iconv( cp1250, UTF-8, "Datum";"ID operace";"ID pokynu";"KS";"Nazev banky";"Nazev protiuctu";"Objem";"Mena";"Protiucet";"Kod banky";"Zadal";"SS";"Typ";"Poznamka";"VS";"Upresneni - objem";"Upresneni - mena";"Zprava pro prijemce" "01.08.2016";"10813415524";"12201884576";"0558";"Fio banka, a.s.";"Kolarova, Stepanka";"290";"CZK";"2900177556";"2010";"";"";"Platba prevodem uvnitr banky";"";"69";"290";"CZK";"" "01.08.2016";"10813707597";"12204532558";"";"MONETA Money Bank, a.s.";" HERMANKOVA MARIE";"150";"CZK";"219169919";"0600";"";"";"Bezhotovostni prijem";" HERMANKOVA MARIE";"71";"150";"CZK";"internet" "01.08.2016";"10813874966";"12204638319";"4712";"Ceska sporitelna, a.s.";"Radova Andrea";"150";"CZK";"951600183";"0800";"";"";"Bezhotovostni prijem";"Radova Andrea";"62";"150";"CZK";"" "01.08.2016";"10813910234";"12204661357";"0138";"Ceska sporitelna, a.s.";"Beran Tomas";"290";"CZK";"1658910013";"0800";"";"";"Bezhotovostni prijem";"Beran Tomas";"31";"290";"CZK";"" "02.08.2016";"10815154379";"12207438286";"0000";"CSOB, a.s.";"NOVOTNA HANA";"290";"CZK";"110470134";"0300";"";"";"Bezhotovostni prijem";"NOVOTNA HANA";"48";"290";"CZK";"" "03.08.2016";"10815739110";"12209936976";"4712";"CSOB, a.s.";"KOSLIK VACLAV";"290";"CZK";"128227298";"0300";"";"";"Bezhotovostni prijem";"KOSLIK VACLAV";"45";"290";"CZK";"" "03.08.2016";"10815811114";"12210194163";"4712";"MONETA Money Bank, a.s.";" HAVLICEK LIBOR";"290";"CZK";"1379911574";"0600";"";"";"Bezhotovostni prijem";" HAVLICEK LIBOR";"52";"290";"CZK";"" "03.08.2016";"10815811115";"12210194164";"";"MONETA Money Bank, a.s.";" RADOMIR RIMAL";"290";"CZK";"163042897";"0600";"";"";"Bezhotovostni prijem";" RADOMIR RIMAL";"32";"290";"CZK";"" "04.08.2016";"10816137764";"12211686639";"0000";"CSOB, a.s.";"CESKA POSTA, S.P.";"300";"CZK";"160987123";"0300";"";"";"Bezhotovostni prijem";"CESKA POSTA, S.P.";"85";"300";"CZK";" posta 128203 02.08.2016 c 6031M 1 CHA E L ABARTOSOVA" "04.08.2016";"10816155962";"12211747939";"4712";"CSOB, a.s.";"MACHKOVA RADKA";"300";"CZK";"241717504";"0300";"";"";"Bezhotovostni prijem";"MACHKOVA RADKA";"10";"300";"CZK";"clensky prispevek" "05.08.2016";"10816670984";"12213937704";"";"Ceska sporitelna, a.s.";"Nemeckova Vera";"290";"CZK";"1112616023";"0800";"";"";"Bezhotovostni prijem";"Nemeckova Vera";"16";"290";"CZK";"" "05.08.2016";"10816672617";"12213945643";"";"Ceska sporitelna, a.s.";"Novotny Pavel";"300";"CZK";"2244540133";"0800";"";"";"Bezhotovostni prijem";"Novotny Pavel";"61";"300";"CZK";"" "05.08.2016";"10816674202";"12213952713";"";"Ceska sporitelna, a.s.";"Kuncova Ruzena";"290";"CZK";"734867113";"0800";"";"";"Bezhotovostni prijem";"Kuncova Ruzena";"68";"290";"CZK";"" "05.08.2016";"10816677964";"12213970952";"4712";"MONETA Money Bank, a.s.";"CHYTIL JOSEF";"300";"CZK";"150038936";"0600";"";"";"Bezhotovostni prijem";"CHYTIL JOSEF";"26";"300";"CZK";"" "05.08.2016";"10816677965";"12213970953";"";"MONETA Money Bank, a.s.";" LIBALOVA JITKA";"300";"CZK";"215195423";"0600";"";"4712";"Bezhotovostni prijem";" LIBALOVA JITKA";"77";"300";"CZK";"" "06.08.2016";"10816976379";"12215516168";"0558";"Fio banka, a.s.";"Vokal, Petr";"150";"CZK";"2300404559";"2010";"";"4712";"Platba prevodem uvnitr banky";"";"39";"150";"CZK";"" "07.08.2016";"10817259878";"12216599986";"0308";"UniCredit Bank Czech Republic and Slovakia, a.s.";"";"-65340";"CZK";"2700027000";"2700";"Pavezka, Ales";"";"Bezhotovostni platba";"JON";"10109731";"65340";"CZK";"" "08.08.2016";"10817312354";"12216810173";"4712";"CSOB, a.s.";"NEMEC JAN";"290";"CZK";"241081825";"0300";"";"";"Bezhotovostni prijem";"NEMEC JAN";"36";"290";"CZK";"internet" "08.08.2016";"10817343249";"12216927357";"4712";"Fio banka, a.s.";"Lonsky, Vaclav";"290";"CZK";"2800218699";"2010";"";"4712";"Platba prevodem uvnitr banky";"venlon";"70";"290";"CZK";"venlon" "08.08.2016";"10817369530";"12217039548";"0000";"Komercni banka a.s.";"ZELINKA OLDRICH";"300";"CZK";"51-7254650267";"0100";"";"0";"Bezhotovostni prijem";"ZELINKA OLDRICH";"41";"300";"CZK";"" "08.08.2016";"10817369531";"12217039549";"0000";"Komercni banka a.s.";"KOSINA RUDOLF";"290";"CZK";"51-7255030297";"0100";"";"0";"Bezhotovostni prijem";"KOSINA RUDOLF";"18";"290";"CZK";"" "08.08.2016";"10817407201";"12217176797";"4721";"Ceska sporitelna, a.s.";"Dedkova Ivana";"290";"CZK";"486821043";"0800";"";"";"Bezhotovostni prijem";"Dedkova Ivana";"13";"290";"CZK";"" "08.08.2016";"10817411850";"12217195966";"4712";"MONETA Money Bank, a.s.";" RADONOVA JIRINA";"290";"CZK";"1273519574";"0600";"";"";"Bezhotovostni prijem";" RADONOVA JIRINA";"14";"290";"CZK";"" "09.08.2016";"10817732852";"12218808449";"0558";"CSOB, a.s.";"HULKA VACLAV";"900";"CZK";"266817077";"0300";"";"";"Bezhotovostni prijem";"HULKA VACLAV";"83";"900";"CZK";"201468" "09.08.2016";"10817735703";"12218820385";"4712";"CSOB, a.s.";"PATACIK MIROSLAV";"290";"CZK";"195951294";"0300";"";"";"Bezhotovostni prijem";"PATACIK MIROSLAV";"73";"290";"CZK";"" "09.08.2016";"10817735724";"12218820501";"0000";"CSOB, a.s.";"HALTUCHOVA PAVLA";"300";"CZK";"196839376";"0300";"";"";"Bezhotovostni prijem";"HALTUCHOVA PAVLA";"38";"300";"CZK";"" "10.08.2016";"10818326320";"12221328592";"0000";"CSOB, a.s.";"SYKOROVA JANA";"290";"CZK";"134593040";"0300";"";"";"Bezhotovostni prijem";"SYKOROVA JANA";"1027";"290";"CZK";"" "10.08.2016";"10818437321";"12221785392";"4712";"Komercni banka a.s.";"PELCOVA DANIELA";"290";"CZK";"9257200287";"0100";"";"0";"Bezhotovostni prijem";"PELCOVA DANIELA";"76";"290";"CZK";"" "10.08.2016";"10818452485";"12221855184";"";"Ceska sporitelna, a.s.";"HRUBA ALENA";"150";"CZK";"279249013";"0800";"";"";"Bezhotovostni prijem";"HRUBA ALENA";"25";"150";"CZK";"" "10.08.2016";"10818495325";"12221991167";"4712";"Ceska sporitelna, a.s.";"LOUNKOVA JANA";"290";"CZK";"788937033";"0800";"";"";"Bezhotovostni prijem";"LOUNKOVA JANA";"12";"290";"CZK";"" "10.08.2016";"10818498026";"12222002382";"4718";"Ceska sporitelna, a.s.";"Novak Milan";"290";"CZK";"1092252153";"0800";"";"";"Bezhotovostni prijem";"Novak Milan";"67";"290";"CZK";"" "10.08.2016";"10818498815";"12222005726";"4712";"Ceska sporitelna, a.s.";"Kougl Michaela";"900";"CZK";"1200747023";"0800";"";"";"Bezhotovostni prijem";"Kougl Michaela";"17";"900";"CZK";"" "10.08.2016";"10818499559";"12222008810";"";"Ceska sporitelna, a.s.";"Bulickova Marie";"290";"CZK";"1323252063";"0800";"";"";"Bezhotovostni prijem";"Bulickova Marie";"58";"290";"CZK";"" "10.08.2016";"10818501189";"12222015572";"";"Ceska sporitelna, a.s.";"Kohout Pavel";"290";"CZK";"1663893123";"0800";"";"";"Bezhotovostni prijem";"Kohout Pavel";"49";"290";"CZK";"" "10.08.2016";"10818543110";"12222241038";"4712";"Air Bank a.s.";"Irena Radonova";"300";"CZK";"1428003012";"3030";"";"";"Bezhotovostni prijem";"Irena Radonova";"15";"300";"CZK";"" "11.08.2016";"10818930446";"12223976644";"4712";"CSOB, a.s.";"CISAR LUBOS";"290";"CZK";"100886080";"0300";"";"";"Bezhotovostni prijem";"CISAR LUBOS";"78";"290";"CZK";"" "11.08.2016";"10818974162";"12224178483";"4712";"MONETA Money Bank, a.s.";"AGD SENICE A.S.";"300";"CZK";"404406584";"0600";"";"";"Bezhotovostni prijem";"AGD SENICE A.S.";"28";"300";"CZK";"" "11.08.2016";"10819026912";"12224338737";"0308";"Komercni banka a.s.";"JANEBOVA SONA";"150";"CZK";"9252600257";"0100";"";"4712";"Bezhotovostni prijem";"JANEBOVA SONA";"33";"150";"CZK";"" )
Csv_Fio_Bank_Statement_File_Importer->check_file_data_format( )
Bank_Statement_File_Importer::import_loaded( Bank_account_Model Object
(
[belongs_to:protected] => Array
(
[0] => member
)
[has_and_belongs_to_many:protected] => Array
(
[0] => accounts
)
[has_one:protected] => Array
(
)
[has_many:protected] => Array
(
)
[load_with:protected] => Array
(
)
[object:protected] => Array
(
[id] => 1
[name] => Fio
[member_id] => 1
[account_nr] => 2500190436
[bank_nr] => 2010
[type] => 1
[settings] => {"enable_download_statements_automatically":null,"api_token":null}
[IBAN] => CZ1520100000002500190436
[SWIFT] => FIOBCZPPXXX
)
[changed:protected] => Array
(
)
[related:protected] => Array
(
)
[loaded:protected] => 1
[saved:protected] => 1
[sorting:protected] => Array
(
[id] => asc
)
[object_relations:protected] => Array
(
)
[changed_relations:protected] => Array
(
)
[object_name:protected] => bank_account
[object_plural:protected] => bank_accounts
[table_name:protected] => bank_accounts
[table_columns:protected] => Array
(
[id] => Array
(
[type] => int
[max] => 2147483647
[unsigned] =>
[sequenced] => 1
)
[name] => Array
(
[type] => string
[length] => 254
)
[member_id] => Array
(
[type] => int
[max] => 2147483647
[unsigned] =>
[null] => 1
)
[account_nr] => Array
(
[type] => string
[length] => 254
[null] => 1
)
[bank_nr] => Array
(
[type] => string
[length] => 20
[null] => 1
)
[type] => Array
(
[type] => int
[max] => 2147483647
[unsigned] =>
)
[settings] => Array
(
[type] => string
[null] => 1
)
[IBAN] => Array
(
[type] => string
[length] => 254
[null] => 1
)
[SWIFT] => Array
(
[type] => string
[length] => 254
[null] => 1
)
)
[ignored_columns:protected] =>
[primary_key:protected] => id
[primary_val:protected] => name
[foreign_key:protected] => Array
(
)
[table_names_plural:protected] => 1
[reload_on_wakeup:protected] => 1
[db:protected] => Database Object
(
[config:protected] => Array
(
[benchmark] =>
[persistent] =>
[connection] => Array
(
[type] => mysqli
[user] => freenetis
[pass] =>
[host] => localhost
[port] =>
[socket] =>
[database] => freenetis
)
[character_set] => utf8
[table_prefix] =>
[object] => 1
[cache] =>
[escape] => 1
)
[driver:protected] => Database_Mysqli_Driver Object
(
[link:protected] => mysqli Object
(
[affected_rows] => 1
[client_info] => 5.5.49
[client_version] => 50549
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 9
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.50-0+deb7u2
[server_version] => 50550
[stat] => Uptime: 8236 Threads: 1 Questions: 630589 Slow queries: 0 Opens: 337 Flush tables: 1 Open tables: 330 Queries per second avg: 76.564
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 125000
[warning_count] => 0
)
[db_config:protected] => Array
(
[benchmark] =>
[persistent] =>
[connection] => Array
(
[type] => mysqli
[user] => freenetis
[pass] =>
[host] => localhost
[port] =>
[socket] =>
[database] => freenetis
)
[character_set] => utf8
[table_prefix] =>
[object] => 1
[cache] =>
[escape] => 1
)
[statements:protected] => Array
(
)
[query_cache:protected] =>
)
[link:protected] => mysqli Object
(
[affected_rows] => -1
[client_info] => 5.5.49
[client_version] => 50549
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 9
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.50-0+deb7u2
[server_version] => 50550
[stat] => Uptime: 8236 Threads: 1 Questions: 630590 Slow queries: 0 Opens: 337 Flush tables: 1 Open tables: 330 Queries per second avg: 76.565
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 125000
[warning_count] => 0
)
[select:protected] => Array
(
)
[set:protected] => Array
(
)
[from:protected] => Array
(
)
[join:protected] => Array
(
)
[where:protected] => Array
(
)
[orderby:protected] => Array
(
)
[order:protected] => Array
(
)
[groupby:protected] => Array
(
)
[having:protected] => Array
(
)
[distinct:protected] =>
[limit:protected] =>
[offset:protected] =>
[last_query:protected] => SELECT `bank_accounts`.*
FROM (`bank_accounts`)
WHERE `bank_accounts`.`id` = '1'
ORDER BY `bank_accounts`.`id` ASC
LIMIT 0, 1
[query_history:protected] => Array
(
)
)
[db_applied:protected] => Array
(
)
[with_applied:protected] => Array
(
)
[is_in_transaction:protected] =>
[is_logger_on:protected] => Array
(
[add] =>
[update] =>
[delete] =>
)
)
, "Datum";"ID operace";"ID pokynu";"KS";"Nazev banky";"Nazev protiuctu";"Objem";"Mena";"Protiucet";"Kod banky";"Zadal";"SS";"Typ";"Poznamka";"VS";"Upresneni - objem";"Upresneni - mena";"Zprava pro prijemce"
"01.08.2016";"10813415524";"12201884576";"0558";"Fio banka, a.s.";"Kolarova, Stepanka";"290";"CZK";"2900177556";"2010";"";"";"Platba prevodem uvnitr banky";"";"69";"290";"CZK";""
"01.08.2016";"10813707597";"12204532558";"";"MONETA Money Bank, a.s.";" HERMANKOVA MARIE";"150";"CZK";"219169919";"0600";"";"";"Bezhotovostni prijem";" HERMANKOVA MARIE";"71";"150";"CZK";"internet"
"01.08.2016";"10813874966";"12204638319";"4712";"Ceska sporitelna, a.s.";"Radova Andrea";"150";"CZK";"951600183";"0800";"";"";"Bezhotovostni prijem";"Radova Andrea";"62";"150";"CZK";""
"01.08.2016";"10813910234";"12204661357";"0138";"Ceska sporitelna, a.s.";"Beran Tomas";"290";"CZK";"1658910013";"0800";"";"";"Bezhotovostni prijem";"Beran Tomas";"31";"290";"CZK";""
"02.08.2016";"10815154379";"12207438286";"0000";"CSOB, a.s.";"NOVOTNA HANA";"290";"CZK";"110470134";"0300";"";"";"Bezhotovostni prijem";"NOVOTNA HANA";"48";"290";"CZK";""
"03.08.2016";"10815739110";"12209936976";"4712";"CSOB, a.s.";"KOSLIK VACLAV";"290";"CZK";"128227298";"0300";"";"";"Bezhotovostni prijem";"KOSLIK VACLAV";"45";"290";"CZK";""
"03.08.2016";"10815811114";"12210194163";"4712";"MONETA Money Bank, a.s.";" HAVLICEK LIBOR";"290";"CZK";"1379911574";"0600";"";"";"Bezhotovostni prijem";" HAVLICEK LIBOR";"52";"290";"CZK";""
"03.08.2016";"10815811115";"12210194164";"";"MONETA Money Bank, a.s.";" RADOMIR RIMAL";"290";"CZK";"163042897";"0600";"";"";"Bezhotovostni prijem";" RADOMIR RIMAL";"32";"290";"CZK";""
"04.08.2016";"10816137764";"12211686639";"0000";"CSOB, a.s.";"CESKA POSTA, S.P.";"300";"CZK";"160987123";"0300";"";"";"Bezhotovostni prijem";"CESKA POSTA, S.P.";"85";"300";"CZK";" posta 128203 02.08.2016 c 6031M 1 CHA E L ABARTOSOVA"
"04.08.2016";"10816155962";"12211747939";"4712";"CSOB, a.s.";"MACHKOVA RADKA";"300";"CZK";"241717504";"0300";"";"";"Bezhotovostni prijem";"MACHKOVA RADKA";"10";"300";"CZK";"clensky prispevek"
"05.08.2016";"10816670984";"12213937704";"";"Ceska sporitelna, a.s.";"Nemeckova Vera";"290";"CZK";"1112616023";"0800";"";"";"Bezhotovostni prijem";"Nemeckova Vera";"16";"290";"CZK";""
"05.08.2016";"10816672617";"12213945643";"";"Ceska sporitelna, a.s.";"Novotny Pavel";"300";"CZK";"2244540133";"0800";"";"";"Bezhotovostni prijem";"Novotny Pavel";"61";"300";"CZK";""
"05.08.2016";"10816674202";"12213952713";"";"Ceska sporitelna, a.s.";"Kuncova Ruzena";"290";"CZK";"734867113";"0800";"";"";"Bezhotovostni prijem";"Kuncova Ruzena";"68";"290";"CZK";""
"05.08.2016";"10816677964";"12213970952";"4712";"MONETA Money Bank, a.s.";"CHYTIL JOSEF";"300";"CZK";"150038936";"0600";"";"";"Bezhotovostni prijem";"CHYTIL JOSEF";"26";"300";"CZK";""
"05.08.2016";"10816677965";"12213970953";"";"MONETA Money Bank, a.s.";" LIBALOVA JITKA";"300";"CZK";"215195423";"0600";"";"4712";"Bezhotovostni prijem";" LIBALOVA JITKA";"77";"300";"CZK";""
"06.08.2016";"10816976379";"12215516168";"0558";"Fio banka, a.s.";"Vokal, Petr";"150";"CZK";"2300404559";"2010";"";"4712";"Platba prevodem uvnitr banky";"";"39";"150";"CZK";""
"07.08.2016";"10817259878";"12216599986";"0308";"UniCredit Bank Czech Republic and Slovakia, a.s.";"";"-65340";"CZK";"2700027000";"2700";"Pavezka, Ales";"";"Bezhotovostni platba";"JON";"10109731";"65340";"CZK";""
"08.08.2016";"10817312354";"12216810173";"4712";"CSOB, a.s.";"NEMEC JAN";"290";"CZK";"241081825";"0300";"";"";"Bezhotovostni prijem";"NEMEC JAN";"36";"290";"CZK";"internet"
"08.08.2016";"10817343249";"12216927357";"4712";"Fio banka, a.s.";"Lonsky, Vaclav";"290";"CZK";"2800218699";"2010";"";"4712";"Platba prevodem uvnitr banky";"venlon";"70";"290";"CZK";"venlon"
"08.08.2016";"10817369530";"12217039548";"0000";"Komercni banka a.s.";"ZELINKA OLDRICH";"300";"CZK";"51-7254650267";"0100";"";"0";"Bezhotovostni prijem";"ZELINKA OLDRICH";"41";"300";"CZK";""
"08.08.2016";"10817369531";"12217039549";"0000";"Komercni banka a.s.";"KOSINA RUDOLF";"290";"CZK";"51-7255030297";"0100";"";"0";"Bezhotovostni prijem";"KOSINA RUDOLF";"18";"290";"CZK";""
"08.08.2016";"10817407201";"12217176797";"4721";"Ceska sporitelna, a.s.";"Dedkova Ivana";"290";"CZK";"486821043";"0800";"";"";"Bezhotovostni prijem";"Dedkova Ivana";"13";"290";"CZK";""
"08.08.2016";"10817411850";"12217195966";"4712";"MONETA Money Bank, a.s.";" RADONOVA JIRINA";"290";"CZK";"1273519574";"0600";"";"";"Bezhotovostni prijem";" RADONOVA JIRINA";"14";"290";"CZK";""
"09.08.2016";"10817732852";"12218808449";"0558";"CSOB, a.s.";"HULKA VACLAV";"900";"CZK";"266817077";"0300";"";"";"Bezhotovostni prijem";"HULKA VACLAV";"83";"900";"CZK";"201468"
"09.08.2016";"10817735703";"12218820385";"4712";"CSOB, a.s.";"PATACIK MIROSLAV";"290";"CZK";"195951294";"0300";"";"";"Bezhotovostni prijem";"PATACIK MIROSLAV";"73";"290";"CZK";""
"09.08.2016";"10817735724";"12218820501";"0000";"CSOB, a.s.";"HALTUCHOVA PAVLA";"300";"CZK";"196839376";"0300";"";"";"Bezhotovostni prijem";"HALTUCHOVA PAVLA";"38";"300";"CZK";""
"10.08.2016";"10818326320";"12221328592";"0000";"CSOB, a.s.";"SYKOROVA JANA";"290";"CZK";"134593040";"0300";"";"";"Bezhotovostni prijem";"SYKOROVA JANA";"1027";"290";"CZK";""
"10.08.2016";"10818437321";"12221785392";"4712";"Komercni banka a.s.";"PELCOVA DANIELA";"290";"CZK";"9257200287";"0100";"";"0";"Bezhotovostni prijem";"PELCOVA DANIELA";"76";"290";"CZK";""
"10.08.2016";"10818452485";"12221855184";"";"Ceska sporitelna, a.s.";"HRUBA ALENA";"150";"CZK";"279249013";"0800";"";"";"Bezhotovostni prijem";"HRUBA ALENA";"25";"150";"CZK";""
"10.08.2016";"10818495325";"12221991167";"4712";"Ceska sporitelna, a.s.";"LOUNKOVA JANA";"290";"CZK";"788937033";"0800";"";"";"Bezhotovostni prijem";"LOUNKOVA JANA";"12";"290";"CZK";""
"10.08.2016";"10818498026";"12222002382";"4718";"Ceska sporitelna, a.s.";"Novak Milan";"290";"CZK";"1092252153";"0800";"";"";"Bezhotovostni prijem";"Novak Milan";"67";"290";"CZK";""
"10.08.2016";"10818498815";"12222005726";"4712";"Ceska sporitelna, a.s.";"Kougl Michaela";"900";"CZK";"1200747023";"0800";"";"";"Bezhotovostni prijem";"Kougl Michaela";"17";"900";"CZK";""
"10.08.2016";"10818499559";"12222008810";"";"Ceska sporitelna, a.s.";"Bulickova Marie";"290";"CZK";"1323252063";"0800";"";"";"Bezhotovostni prijem";"Bulickova Marie";"58";"290";"CZK";""
"10.08.2016";"10818501189";"12222015572";"";"Ceska sporitelna, a.s.";"Kohout Pavel";"290";"CZK";"1663893123";"0800";"";"";"Bezhotovostni prijem";"Kohout Pavel";"49";"290";"CZK";""
"10.08.2016";"10818543110";"12222241038";"4712";"Air Bank a.s.";"Irena Radonova";"300";"CZK";"1428003012";"3030";"";"";"Bezhotovostni prijem";"Irena Radonova";"15";"300";"CZK";""
"11.08.2016";"10818930446";"12223976644";"4712";"CSOB, a.s.";"CISAR LUBOS";"290";"CZK";"100886080";"0300";"";"";"Bezhotovostni prijem";"CISAR LUBOS";"78";"290";"CZK";""
"11.08.2016";"10818974162";"12224178483";"4712";"MONETA Money Bank, a.s.";"AGD SENICE A.S.";"300";"CZK";"404406584";"0600";"";"";"Bezhotovostni prijem";"AGD SENICE A.S.";"28";"300";"CZK";""
"11.08.2016";"10819026912";"12224338737";"0308";"Komercni banka a.s.";"JANEBOVA SONA";"150";"CZK";"9252600257";"0100";"";"4712";"Bezhotovostni prijem";"JANEBOVA SONA";"33";"150";"CZK";""
, upload/Pohytestsrpen.csv, csv )Bank_Statement_File_Importer::import( Bank_account_Model Object
(
[belongs_to:protected] => Array
(
[0] => member
)
[has_and_belongs_to_many:protected] => Array
(
[0] => accounts
)
[has_one:protected] => Array
(
)
[has_many:protected] => Array
(
)
[load_with:protected] => Array
(
)
[object:protected] => Array
(
[id] => 1
[name] => Fio
[member_id] => 1
[account_nr] => 2500190436
[bank_nr] => 2010
[type] => 1
[settings] => {"enable_download_statements_automatically":null,"api_token":null}
[IBAN] => CZ1520100000002500190436
[SWIFT] => FIOBCZPPXXX
)
[changed:protected] => Array
(
)
[related:protected] => Array
(
)
[loaded:protected] => 1
[saved:protected] => 1
[sorting:protected] => Array
(
[id] => asc
)
[object_relations:protected] => Array
(
)
[changed_relations:protected] => Array
(
)
[object_name:protected] => bank_account
[object_plural:protected] => bank_accounts
[table_name:protected] => bank_accounts
[table_columns:protected] => Array
(
[id] => Array
(
[type] => int
[max] => 2147483647
[unsigned] =>
[sequenced] => 1
)
[name] => Array
(
[type] => string
[length] => 254
)
[member_id] => Array
(
[type] => int
[max] => 2147483647
[unsigned] =>
[null] => 1
)
[account_nr] => Array
(
[type] => string
[length] => 254
[null] => 1
)
[bank_nr] => Array
(
[type] => string
[length] => 20
[null] => 1
)
[type] => Array
(
[type] => int
[max] => 2147483647
[unsigned] =>
)
[settings] => Array
(
[type] => string
[null] => 1
)
[IBAN] => Array
(
[type] => string
[length] => 254
[null] => 1
)
[SWIFT] => Array
(
[type] => string
[length] => 254
[null] => 1
)
)
[ignored_columns:protected] =>
[primary_key:protected] => id
[primary_val:protected] => name
[foreign_key:protected] => Array
(
)
[table_names_plural:protected] => 1
[reload_on_wakeup:protected] => 1
[db:protected] => Database Object
(
[config:protected] => Array
(
[benchmark] =>
[persistent] =>
[connection] => Array
(
[type] => mysqli
[user] => freenetis
[pass] =>
[host] => localhost
[port] =>
[socket] =>
[database] => freenetis
)
[character_set] => utf8
[table_prefix] =>
[object] => 1
[cache] =>
[escape] => 1
)
[driver:protected] => Database_Mysqli_Driver Object
(
[link:protected] => mysqli Object
(
[affected_rows] => -1
[client_info] => 5.5.49
[client_version] => 50549
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 9
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.50-0+deb7u2
[server_version] => 50550
[stat] => Uptime: 8236 Threads: 1 Questions: 630591 Slow queries: 0 Opens: 337 Flush tables: 1 Open tables: 330 Queries per second avg: 76.565
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 125000
[warning_count] => 0
)
[db_config:protected] => Array
(
[benchmark] =>
[persistent] =>
[connection] => Array
(
[type] => mysqli
[user] => freenetis
[pass] =>
[host] => localhost
[port] =>
[socket] =>
[database] => freenetis
)
[character_set] => utf8
[table_prefix] =>
[object] => 1
[cache] =>
[escape] => 1
)
[statements:protected] => Array
(
)
[query_cache:protected] =>
)
[link:protected] => mysqli Object
(
[affected_rows] => -1
[client_info] => 5.5.49
[client_version] => 50549
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 9
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.50-0+deb7u2
[server_version] => 50550
[stat] => Uptime: 8236 Threads: 1 Questions: 630592 Slow queries: 0 Opens: 337 Flush tables: 1 Open tables: 330 Queries per second avg: 76.565
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 125000
[warning_count] => 0
)
[select:protected] => Array
(
)
[set:protected] => Array
(
)
[from:protected] => Array
(
)
[join:protected] => Array
(
)
[where:protected] => Array
(
)
[orderby:protected] => Array
(
)
[order:protected] => Array
(
)
[groupby:protected] => Array
(
)
[having:protected] => Array
(
)
[distinct:protected] =>
[limit:protected] =>
[offset:protected] =>
[last_query:protected] => SELECT `bank_accounts`.*
FROM (`bank_accounts`)
WHERE `bank_accounts`.`id` = '1'
ORDER BY `bank_accounts`.`id` ASC
LIMIT 0, 1
[query_history:protected] => Array
(
)
)
[db_applied:protected] => Array
(
)
[with_applied:protected] => Array
(
)
[is_in_transaction:protected] =>
[is_logger_on:protected] => Array
(
[add] =>
[update] =>
[delete] =>
)
)
, upload/Pohytestsrpen.csv, csv )Import_Controller->import_fio( 1, upload/Pohytestsrpen.csv )
Import_Controller->upload_bank_file( 1 )
Kohana::instance( )
call_user_func( Array
(
[0] => Kohana
[1] => instance
)
)Event::run( system.execute )
require( system/core/Bootstrap.php )