3 ms·
I watched the users of my last app cut and paste data from the application into excel, mess with the data in excel, upload the excel back to the database and as
by collyw 11y ago
I watched the users of my last app cut and paste data from the application into excel, mess with the data in excel, upload the excel back to the database and ask me what was causing the errors when the unvalidated data in excel would not go back in to the DB. It was eye opening how they accept such a crap system. I tried to change it, but it was never given high enough priority.
- bitwize 11y agoWell, then, it's your responsibility to make sure that your application can cope with data pasted in from Excel, since that's obviously a critical part of the users' workflow.
- collyw 11y agoIt was a "temporary solution". "Yes, you can built a web form with proper validation to replace it next month after you complete this URGENT feature". If it can be replaced by a web form then Excel isn't a "critical part of the workflow". Getting data into the database was the critical part of the workflow. The users actually preferred the web forms that I did manage to replace Excel sheets with (more checkboxes, and far less cut and paste). Anyway after 3 years of complaining about the same issues I realised it was time to leave.