August 21st, 2013, 09:13 AM
I have to disagree with you. When you have a known set of values, constraining the user's input to those values is much better than asking the computer to guess on the back end. Is it not possible that two different, legitimate company names could differ by less than the margin that user error can warp one of them?
Originally Posted by paulh1983
Having converted a number of spreadsheet/free-form/flat-file "databases" into applications backed by a real RDBMS, I have to say that anything one can do to encourage consistent user input is a huge plus. Obviously it's not possible to check or constrain every field, but it's fallacy to suggest that the whole notion should be thrown out because it only partially mitigates the problem.
August 21st, 2013, 09:17 AM
He has users who make mistakes. That's his problem. he's decided that his solution involves forcing the users to choose an excel drop-down rather than the CSV they already use, massively increasing the complexity of his system and only causing him more headaches. Nevertheless, he's ignoring this and pushing forward with his "let's introduce a closed-format proprietary spreadsheet software into the mix" plan.
HEY! YOU! Read the New User Guide and Forum Rules
"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin
"The greatest tragedy of this changing society is that people who never knew what it was like before will simply assume that this is the way things are supposed to be." -2600 Magazine, Fall 2002
Think we're being rude? Maybe you asked a bad question
or you're a Help Vampire.
Trying to argue intelligently? Please read this.
August 21st, 2013, 09:47 AM
I'm not a fan of proprietary formats or tools, but having the computer silently alter a user's uploaded data based on guesswork is *not* a better idea than finding a way (any way) to constrain the user's input to correct values in the first place, IMHO.
Originally Posted by ManiacDan
Picking the right way forward toward building such an interface is really requires more knowledge of the larger scenario. Are the users employees of a company, where a standard spreadsheet software or custom client could be deployed? Or are they private individuals, who cannot be expected to own a specific software? Are the CSV files generated by hand, or automation? If the former, in what program are the users working right now?
Excel is by no means a necessary or even recommended way of solving this problem, but it's hard to guess what else might be available here.
August 21st, 2013, 10:09 AM
i still don't know why user would enter the wrong company? I dont even know why i would be importing data about another company? I should only be interested in MY company in which case a login scenario would rectify the "invalid company name" scenario.
Maybe you need to tell us what happens in that particular part of the system.