search

calpaterson / csvbase

a simple website for sharing table data - with an API
https://csvbase.com
GNU Affero General Public License v3.0
376 stars 13 forks source link

Float type guessing too eager and raising exceptions for non-float data #144

Open calpaterson opened 1 month ago

calpaterson commented 1 month ago

Description

Steps to reproduce

  1. Insert the sample file below as a new table

Expected result

Table created

Actual result

500 error

Additional details

"acct_ccy","acct_id","bal_aftr_bookg","bal_aftr_bookg_nmrc","bookg_amt","bookg_amt_nmrc","bookg_cdt_dbt_ind","bookg_dt_tm_cet","bookg_dt_tm_gmt","booking_id","card_poi_id","cdtr_schme_id","ctpty_acct_ccy","ctpty_acct_id_bban","ctpty_acct_id_iban","ctpty_adr_line1","ctpty_adr_line2","ctpty_agt_bic","ctpty_ctry","ctpty_nm","dtld_tx_tp","end_to_end_id","ntry_seq_nb","rmt_inf_ustrd1","rmt_inf_ustrd2","tx_acct_svcr_ref","tx_tp","year_month"
"EUR","NL05YEPP5829166052",2342.93,234292,7.93,793,"CRDT","2024-10-12 00:02:53","2024-10-12 00:02:53","2f452a06-0cb8-4e9a-bc47-07c9bcad6451",,,"EUR","378.91.55.762","NL12FAKE3789155762","Marijnsingel 899
3740 AL Jistrum",,"JGuIJWpXuR","NL","Toyota",4111,"be894619-54e7-4067-a7e9-c3989bc02fb2",497,"Vehicle service charge",,"3f496859-d65c-4ad2-a253-ca6ffc0a4379",,202410