Here’s a handy little script for web developers / QA specialists who need to generate human-related data for use in testing software. This program lets you rapidly build custom test data including names, phone numbers, email addresses, states, provinces and random text of varying size. You may download the information as an excel spreadsheet or view it as HTML. And (naturally), it’s free.
I wrote this program for generating sample submissions for my Form Tools script. Very useful indeed!
Thanks for spotting that, tokobayashi. Good grief – bloody register globals.
I’ve updated the zipfile.
Very nice indeed.
Excellent tool !
I have found a few really small issues.. you may want to correct:
1) in XML export, there is missing a “\n” after the first root entry,
2) Excel export: it should be optional to have column headings included.
3) CSV: it should be possible to have a parameter included, if the values should be quoted
always, quoted when needed, or not at all.
4) not sure if it makes sense.. but maybe there should be an option about how many
rows to start with.
5) if possible: make is possible to save the settings (row layouts), so that they can be recalled later.
Your excellent script replaces commercial software that costs a lot. Awesome work !
Might I suggest adding YAML as an output option.
briliant program but would be even better if you could set it up to have correlation in cluded cheers
I am trying to set up the following generator for a fundraiser for our fire department.
I want to start with a pool of 64 NHL players names.
Then randomly choose 6 players from the pool to create a team.
I would create 100 teams approx. and seal each team in an envelope and sell them.
I would like to create a database of these teams for tracking and to keep stats as the playoffs progress.
Do you have any idea if a program like this exists?
I would be willing to pay for this program if available.
Thanks! I don’t know of anything that would work for you… I think you’ll probably need a custom script written for that purpose. Sorry I couldn’t be more help. :-)
Thank you very much indeed for such a wonderful program. I am an (ageing) software student and this evening I am having to type sample data into a database to test it. Your program has saved me a sleepless night!! Wonderful.
Not used it yet, but the idea is great.
One suggestion though.. I would be great it the user can supply the SQL code of the table structure (instead of having to specify it). This would make things much simpler. For example I have a table with 35 columns, it’ll take a while to add them all, would be much better to just supply the structure in standard SQL and get test data!!
That’s a great idea, Stuart. I’ll definitely give it some thought.
I’m maybe a couple of weeks away from finishing generatedata.com – a site just for this script, including a save mechanism. But I’ll definitely try and get this into a later version.
This is a perfect tool! I’m sure I will use it!
Your other tools are also great!
Thanks for sharing!
Hi where can I change the Max number of rows to be returned?
Thank you for the tool.
I use also this tool in http://www.yandataellan.com. You can generate up to 10.000 rows of data in several file formats (CSV, Excel, SQL, JSON, HTML, and XML) and for free!. Take a look…
Is it possible to download Standalone instead of web interface?
Hi Muthu, no, I’m afraid the downloadable script is still web-based: you’ll need to have MySQL and PHP installed to install it.
Great site and donated to help out; but also to be able to save my data set. Wish that it would have taken me back to my data set after donating, as I had 50 columns set up and didn’t realize they would reset during the donating process. =(
Hi James – I am sorry about that! I’ll log this as a bug: I can totally imagine that being a real nuisance, especially with larger data sets like yours.
But thanks very much for the donation & I hope it comes in handy.
This service should run on SAAS business model.
Very much required in most firms.
Donation is just a peanut for what it is serving.