yes, i'm a lame and lazy PHP coder, otherwise, i'd code something myself...but i need something fast.
i use Navicat right now for a mysql GUI and i love it, EXCEPT, i'm having one problem with the XLS import function. basically, you cannot set it so that blank XLS cells DO NOT overwrite any existing database info during an Update.
let me explain:
i run an XLS import, choose the nice "Update/Append" option, which allows me to set a primary key and have Updates run on existing entries (matching this key), otherwise have them added. however, the problem is that sometimes i have blank cells in my XLS sheet for fields where data actually exists in the database and i don't want to overwrite with blanks. the import, during an Update, will still choose to update the record with blank cells and overwrite my actual data. i'd like an importer that could allow me to run this "Update/Append" function but choose to have it ignore blank XLS cells when doing the update.
does that make sense? 5 emails to Navicat support apparently concluded in this not being possible.
anyone know a good piece of software i can just buy that will do the trick? i see a load of them but don't know what's good.
