Creating Random / Fake Data

[Uncle Gizmo]

Bruce McPherson is always creating some excellent ideas. I like the look of this one, although I haven't tried it out yet! Will post back when I know more about it.

Random and fake test data in Sheets with Google Apps Script - Desktop Liberation

ramblings.mcpher.com

 

[The_Doc_Man]

The U.S. Navy had a commercial product for ORACLE and SQL Server databases (and presumably would have worked for any ODBC-enabled DB) that could generate randomized data. Made testing easy because of the scripts it could run that would interact cleanly with the back-end DB. But every now and then one of our DBAs would forget having used it and we would get some of the damnedest names, most of which had entirely too many consonants. Names like PBRZEWSKI and DOSTOYEVSKI and such. (Obviously had a selection of foreign-sounding names for random selection.) Then of course the system would have to be cleaned because of "leakage" of test data into a production system.