How to insert NULL value into the database with csv import or bulkedit?

Questions › How to insert NULL value into the database with csv import or bulkedit?

Alexander Toth asked 5 years ago

Hello,
I’ve a column with the option $col[“isnull”] = true;
In default edit mode this works fine, if I put 0 in the dialog box the NULL value is inserted into the database.
But unfortunately this not works in bulkedit mode and with the csv import function. With the csv import function the value 0 is inserted into the database (I also tried to put NULL in the csv, but the result is that in the database is written the text NULL and not the NULL value)
In bulkedit instead if I put 0, this is totally ignored a there are no changes.
There is any solution or workaround? Thanks

5 Answers

-1 Vote Up Vote Down

Abu Ghufran Staff answered 5 years ago

Both issues are resolved and updated files emailed to you.

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework

0 Vote Up Vote Down

Alexander Toth answered 5 years ago

Hello Abu,
I tested your fix, it works well for bulkedit but not for csv import.
The fields with isnull options are recognized correctly but there is some problem with the insert query
I checked the mysql log and the query is like:

INSERT INTO test (field1,field2,field3) VALUES (”,’10’,’2019-02-10′)

When it should be

INSERT INTO test (field1,field2,field3) VALUES (null,’10’,’2019-02-10′)

Thanks

0 Vote Up Vote Down

Abu Ghufran Staff answered 5 years ago

Make sure you update step3.php in lib/inc/import. I verified it before sending. Please confirm.

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework

0 Vote Up Vote Down

Alexander Toth answered 5 years ago

Yes, I confirm that the file is updated.

0 Vote Up Vote Down