DEV Community


Discussion on: How to massively update records through a Web UI?

paulasantamaria profile image
Paula Santamaría Author

You're completely right, bulk data will always be troublesome, especially when it comes from another party.

Users don't always know that. I believe it's our job to come up with some alternate solutions that solve the problem and reduce headaches from both parties.

A long time ago I worked for a software company that was maintaining a web app that had this "update by spreadsheet" feature. I can't tell you how many times users came asking for help because the software rejected their file. And usually when we opened the file the data was completely wrong. That problem could've been solved with a standalone validator like you said, but we weren't allowed to develop new features for that project, so we had to just keep fixing excel files over and over 😥