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萬行，那麼什麼是孩子。