Import Action won't let me import decimals

Hi! About to lose my hair here. Whenever I try to import decimals from a CSV, the importing fails and I get this error message on the "failed_import_rows" table: "The payout field must be an integer. " In my database, the payout is set to decimal(11,5) and I tried setting it to nullable and not nullable. Things I've tried: - Casting the state - Filament built-in casting with numeric() - Removing all validation - Building the resource from scratch. Nothing works. - Filament and league/csv are up to date. - Laravel log shows no errors - Console shows: 2024-03-18 18:23:00 Filament\Notifications\DatabaseNotification .............................. RUNNING 2024-03-18 18:23:00 Filament\Notifications\DatabaseNotification ......................... 17.29ms DONE - The value in the CSV is ,6.5, not ,"6.5", If I change the value to 6, everything works as expected. Am I missing something?
3 Replies
christmex
christmex6mo ago
if the value is not decimal, let say just the number like,1,2 or 3? its still error?
ParchiX
ParchiX6mo ago
No, if it is an integer everything works as it should.
christmex
christmex6mo ago
sorry, i missed this "If I change the value to 6, everything works as expected. "
Want results from more Discord servers?
Add your server