GenerateData - Free online test data generator GenerateData -免费在线测试数据发生器
Posted on November 26, 2008 at 5:43 am发布于2008年11月26号在上午05时43分
If you write programs that have SQL or MS Access databases on the backend, then there has probably come a point where you needed to generate some test data in order to test out your program.如果您写的程序了SQL或MS Access数据库的后端，然后有可能已经走过了点，您需要产生一些测试数据，以测试你的程序。
I’ve actually needed test data when writing Excel macros because unless you use a real set of large test data, you simple won’t be able to anticipate all problems that can possibly arise.我已经实际需要的测试数据时，写的Excel宏，因为除非你使用一个真正的一套大型的测试数据，您简单的将无法预见的所有问题，都不可能出现。 If you’re a coder, you know how important it is to test as many inputs as possible.如果你是一个编码，你知道是多么重要考验许多投入越好。
GenerateData GenerateData is an online service that you can use to generate random data for populating databases, spreadsheets, etc. You can generate data for all kinds of fields including names, phone numbers, email addresses, cities, states, counties, dates, street addresses, lorem ipsum text, number ranges, alphanumeric strings, auto-increment, and more.是一个在线服务，您可以使用随机生成的数据填充数据库，电子表格，等等，您可以生成数据的各种领域，包括姓名，电话号码，电子邮件地址，城市，州，县，日期，街道地址， lorem本身的文字，数字的范围，数字串，自动增量，等等。
To start generating test data, click on the Generator tab and starting typing in field names and then choosing the field type.开始产生的测试数据，按一下发电机标签，并开始输入栏位名称，然后选择外地类型。 On some fields, you will have options you can set and others will not.在某些领域，您将选择您可以设置和其他不会。
You can choose to generate the data in several formats, including HTML, Excel, XML, CSV, or SQL.你可以选择生成的几个数据格式，包括HTML ， Excel中， XML的格式，或SQL 。 You can also pick which country you want the data to resemble: US, UK, Netherlands, or Canada.您也可以挑选哪一个国家想要的数据相似：美国，英国，荷兰，加拿大。
Type in the number of results you want and then click Generate .型结果的数量要然后单击生成。 You can also click the Rows button if you want to add more columns to your table.您也可以按一下按钮行如果你想添加更多列的表。 Note that the online generator from their website only allows you to generate 200 rows of data.请注意，从网上发电机自己的网站上不仅可以让你产生200行的数据。
If you want more, you either have to download the full Data Generator script by click on the Download tab and installing on your web server or you have to donate $20, which will get you a username to login into the site and generate data sets of up to 5,000 rows.如果您想要更多的，你要么必须下载完整的数据生成器脚本的点击下载标签，并安装在您的Web服务器或者您已捐赠20美元，这将让你的用户名登录到该网站并生成数据集的5000行。
The script is free and pretty easy to install if you know a little SQL and understand how to setup a web server.该脚本是免费的，而且很容易安装，如果你知道一点SQL和了解如何设置一个Web服务器。 This is obviously for people who know what they are doing.这显然是人们谁知道他们在做什么。 If you just need a lot of test data and can’t install it yourself, then just donate $20 and you’ll be able to generate larger datasets.如果你只是需要大量的测试数据，不能安装它自己，就捐出20元，您将能够产生更大的数据集。
However, unless you need to generate thousands and thousands of rows, 200 should be good enough.然而，除非您需要产生数以千计的行， 200应该不够好。 If not, you can keep generating 200 rows of data, download the file and then combine them to get to the desired number of rows.如果没有，您可以随时生成200个数据行，下载文件，然后把他们可以获得理想的列数。
If you do end up donating, you will also have the option of saving your forms, so that you can quickly regenerate datasets without having to re-type everything.如果你最终捐出，你也可以选择节省您的形式，这样您可以快速恢复数据，而不必重新输入一切。
Overall, it’sa great service for anyone who has to generate a lot of test data for programs they may be writing.总的来说，这是一个伟大的服务，任何人谁也产生了很多的测试数据的程序，他们可以书面形式。 Enjoy!享受！
» Filed Under »文章属于 Cool Websites酷网站
 Save this page 保存该网页 |  Stir it up on Mixx 它搅动了Mixx | |
 Add to Reddit 添加到Reddit |  Stumble this page 失败此页 |
Related Posts 有关职位
- Excel Tutorial - How to make a simple graph or chart in Excel Excel的教程-如何使一个简单的图形或图表在E xcel
- How to setup free dynamic DNS for remote access to your PC如何设置免费动态DNS ，用于远程访问您的PC
- Beat Writer’s Block With A Domain Name Generator垮掉作家的阻滞域名发生器
- How to hide tabs, cells, columns, and formulas in Excel如何隐藏标签，细胞，列和公式在Excel
- Combine or merge multiple text files using TXTCollector联合或合并多个文本文件使用TXTCollector
What a joke.真是一个笑话。
My real tests with pgsql are all with more than one million rows, anything less is for kids.我真正的测试pgsql都超过100万行，那么什么是孩子。