DATABASE
INFO
The
format. Databases for all KestenMedia Media Directories
(Oregon, Washington and California) are constructed and distributed
in the same manner.
How
to. Our media directory databases come to you on
a CD in "read only" format. To use a database in its most
accessible form, follow these steps: PC users: 1) Copy the database
files to your C drive. 2) In your file manager utility (e.g. Windows
Explorer) right click on the database files and click on the "properties"
option. 3) Go to the "attributes" line at the bottom of
the dialogue box and uncheck "read only." You will now
be able to use your media directory files and make changes to the
database. Mac users: Copy the database to your hard drive. You will
now be able to make changes.
Various
formats. We provide the data primarily in MS Access
2003 or MS Excel for PC customers and FileMaker Pro 6.0 for Mac
customers. Those formats seem to be the most popular. However, we
also provide the data in Dbase and comma separated formats, which
can be imported into almost any software's database.
| PC
Database is in the following
formats: |
Mac
Database is in the following
formats: |
| *.mdb |
MS
Access 2000 |
*.fm |
FileMaker
Pro 6.0 |
| *.dbf |
Dbase III
|
*.dbf |
Dbase
III |
| *.xls |
MS Excel |
*.tab |
Tab
separated text |
| *.txt |
Comma
separated text |
*.txt |
Comma
separated text |
| |
|
|
|
Database
fields. The data is provided in the following fields
in this order:
| TARGETCITY |
The
main area of circulation or broadcast. This is helpful when
the media organization's office is in a city different than
the city of circulation or broadcast. |
| DATE |
Shows “05” to confim
record has been updated for this year. |
| CONTACT |
This
is a contact name in the news department. For newspapers, it
is the editor. For radio, it is the news director. For television,
it is the assignment editor. "NA" can mean the outlet
does not support a news department or has a vacancy for the
news contact person. |
| ORGANIZATI |
Outlet
or organization name. |
| ADDRESS |
Mailing
address. |
| CITY |
City. |
| STATE |
State. |
| ZIP |
Zip
code. |
| AREAMAINPH |
Area
code and Main phone number in one field. |
| AREANEWSPH |
Area
code and News phone number in one field |
| AREACODE |
Area
code. |
| MAINPHONE |
Main
or business phone number. |
| NEWSPHONE |
Newsroom
or news staff phone number. |
| AREAMAINFAX |
Area
code and Main fax number in one field. |
| AREANEWSFAX |
Area
code and News fax number in one field. |
| FAXAREA |
Area
code for fax machines. |
| MAINFAX |
Main
fax phone number. |
| NEWSFAX |
News
fax phone number. |
| EMAIL |
Email
address. |
| TYPE |
For
sorting purposes. Newspapers are "daily," "weekly,"
"monthly" and "web." Web is for Web page
news operations. Radio is "radio." Television is
"television" or "cable." Cable is for
the community access stations. |
| EDITORIAL |
Editorial
page editor, provided for print media only. |
| FORMAT |
Radio
station format, provided for radio stations only. |
| TALKSHOW |
Local
interview opportunities at radio and television stations. |
|
