|
The Advanced Data Generator comes with a very useful repository of real-life like data with the data libraries, a few sample product images and sample data in CSV files, in order to generate meaningful test-data for your database.
Data Library
When generating data for a text column or using a macro, you can use the following libraries by number:
Miscellaneous:
100
|
Countries
|
151
|
US state names
|
152
|
US state codes
|
200
|
Business names
|
Cities:
1000
|
All cities
|
1001
|
American cities
|
1031
|
Dutch cities
|
1032
|
Belgian cities
|
1033
|
French cities
|
1034
|
Spanish cities
|
1039
|
Italian cities
|
1044
|
UK cities
|
1049
|
German cities
|
1061
|
Australian cities
|
Streets:
2000
|
All street names
|
2001
|
American street names
|
2031
|
Dutch street names
|
2032
|
Belgian street names
|
2033
|
French street names
|
2034
|
Spanish street names
|
2039
|
Italian street names
|
2044
|
UK street names
|
2049
|
German street names
|
2061
|
Australian street names
|
First names:
3000
|
All first names, 30000 for male, 30001 for female
|
3001
|
American first names, 30010 for male, 30011 for female
|
3031
|
Dutch first names, 30310 for male, 30311 for female
|
3032
|
Belgian first names, 30320 for male, 30321 for female
|
3033
|
French first name,s 30330 for male, 30331 for female
|
3034
|
Spanish first names, 30340 for male, 30341 for female
|
3039
|
Italian first names, 30390 for male, 30391 for female
|
3049
|
German first names, 30490 for male, 30491 for female
|
Last names:
4000
|
All last names
|
4001
|
American last names
|
4031
|
Dutch last names
|
4032
|
Belgian last names
|
4033
|
French last names
|
4034
|
Spanish last names
|
4039
|
Italian last names
|
4049
|
German last names
|
Data Files
Besides the data library, there are data files in the 'Sample Data' folder that can be used, for example in Lookups.
The following files are available, with a description of the columns in the files
Countries.csv
CountryCode2
|
2-character alpha code for the country
|
CountryCode3
|
3-character alpha code for the country
|
TLD
|
Top level domain extension
|
DialPrefix
|
Phone dialing prefix, multiple prefixes possbible
|
TimeZone
|
Time zone for the country, can cover a range
|
CountryName (Native)
|
Country name as per native language
|
CountryName (EN)
|
English country name
|
CountryName (NL)
|
Dutch country name
|
CountryName (DE)
|
German country name
|
German districts.csv
District
|
District name
|
Form
|
Either 'rural' of 'urban'
|
State
|
State name
|
Capital
|
District capital city
|
US States.csv
Name
|
State name
|
Abbr
|
State postal abbrevation
|
Captial
|
State capital
|
Product names.csv
A file with a single column of sample product names (eg: 'CD Player', 'Cable Modem').
In addition to these csv files, there's a folder 'Product Images' in the Sample Data folder that contains, you guessed it, sample product images.
|