Andreas Mueller - 2015-07-13 22:39:37 -
In reply to message 1 from Jamie Grant
Hi Jamie,
I am happy to hear the CSV Handler is of use to you.
You should be able to use quotes by exaping them, but that would need some fiddling inside the class.
Now validation is a completely different matter and certainly not an easy one:
For the handler to know what to check we need to introduce a reference as to what field can take what value. If we did this inside the csv file the structure wouldn't be compatible anymore.
Of course you might use an extra file (same name as the csv datafile with different extension maybe) to define the necessary parameters and have the handler check for such a file. This would be of limited use though, if validation takes place at commit of a Line.
So we would need to validate on changing a field - either by sending validation parameters and code as JavaScript for the browser to complain if anything is wrong, or by ajax request (like google's autosearch) calling an extra php on the server.
Both methods imply a lot of Javascript, and to my regret that is not my strongest capability :( and would take more time than I can currently afford.
It would be a nice enhancement though and I'll put it on my list of good things to get done on a rainy day.
Regards
Andreas