Telecommunications, Trade & Consumer Electronics News

Advanced TV Factbook

Frequently Asked Questions

General

Q: I forgot my password. What do I do?
A: Send us a message here.

Q: I'm getting a message that says, "This logon is in use." What does this mean?
A: This means someone is already logged on with the user name and password you entered. If you need additional subscriptions, please contact your sales rep. at 1-800-771-9202 or 1-202-872-9200.

Q: Why did I get logged off?
A: For security reasons, you are automatically logged off after 30 minutes of inactivity.

Q: Can I let other people at my company use my log on?
A: Yes. Just remember that only one person can be logged on at any time with your user name and password.

Q: How can I get logons for other people at my company?
A: Contact your sales rep. at 1-800-771-9202 or 1-202-872-9200 to ask about additional subscriptions.

Query Results

Q: Can I change the number of records that are displayed in the query results?
A: Yes. At the bottom of each search window is a field labeled “Records." Select any of the values in the drop-down box to change the number of records displayed in the query result.

Q: Can I sort the query results?
A: Yes. Clicking on any column heading will sort the results by that field. Clicking on the same field again will sort the list in reverse order.

Exports

Q: The Export button doesn't work.
A: The Export button is active for Premium level subscribers. For more information, please contact your sales representative at 800-771-9202 or 1-202-872-9200.

Q: When I Export my query results, which records are included in the file?
A: All records matching your query.

Q: How many times can I run and download Exports?
A: As often as you wish.

Q: If I change the value in “Records per page” on the search window, does this affect how many records will be included in my Export?
A: No. The records included in the Export are determined by your search criteria.

Data Downloads

Q: What file formats are available for the data download files?
A: All data download files are comma-separated value (CSV) text files, delivered in zip format.

Q: After I save and unzip the data download files, how can I open them?
A: Any text editor will open the files.

Q: How can I convert the data download files to Excel format?
A: (1) Launch Excel. (2) Open the data download file (.csv). (3) Save the file as an Excel Workbook.

Q: When I open a file in Excel, it removes preceding zeros from some fields (like zip code). What can be done to fix this?
A: When importing .csv files, Excel converts numbers to numeric fields. Therefore a zip code of 09456 is imported as 9456 (removing the zero). To stop this from happening, change the file into a .txt file and follow this procedure.

  1. Change the extension of the file you downloaded to .txt. One way to do this is to open the .csv file using the plain text editor that came with your computer – (examples: Notepad in Windows, TextEditor on a Mac) – and save it as a .txt file.
  2. Launch Excel.
  3. Open the .txt file in Excel. A text import wizard will begin. Follow the procedure below.
    1. Where it says "Choose the file type that best describes your data", select Delimited.
    2. Click "Next".
    3. For Delimiters, select: [x] Tab [x] Comma
    4. Click "Next".
    5. On the Data preview window, move the scroll bar to the right until you see the Zip_Code field. Click on this field to highlight it. At the top of the window where it says “Column data format”, select “Text."
    6. Click "Finish".
    7. Save the file in Excel format.

Q: When I open either the TV General Information or the TV Technical Info file in MS Excel, the data in the Account Number field looks like this -- 8.91081E+12. Why?
A: In the Factbook TV station database, the Account Number for many stations is greater than 12 digits. By default, MS Excel displays number values greater than 12 digits in cells using the scientific notation format. For example, "1231231231234" is displayed as "1.23123E+12". Even if you increase the cell width to a value greater than 12 characters, Excel will still display the number in scientific notation.

To get around this limitation, follow this procedure:

  1. Change the extension of the file you downloaded to .txt. One way to do this is to open the .csv file using the plain text editor that came with your computer – (examples: Notepad in Windows, TextEdit on a Mac) – and save it as a .txt file.
  2. Launch Excel.
  3. Open the .txt file in Excel. A text import wizard will begin. Follow the procedure below.
    1. Where it says "Choose the file type that best describes your data", select Delimited.
    2. Click "Next".
    3. For Delimiters, select [x] Tab [x] Comma
    4. Click "Next".
    5. The first field (Account_Number) will be highlighted. Change the column data format to "Text".
    6. Click "Finish".
    7. Save the file in Excel format.

Excel 2003 Record Limit

Q: When I open the Cable Programming Received Via Satellite file in Excel 2003, much of the data is missing. Why?
A: Excel 2003 has a record limit of 65,000 records and the Cable Programming Received Via Satellite file has approx. 400,000 records. Therefore, only the first 65,000 records will be imported. However, Excel 2007 can accept in excess of 1 million records.

Q: The number of records in the Cable Programming Received Via Satellite file exceeds the Excel 2003 record limit. What else can I use?
A: Excel 2007 can accept in excess of 1 million records and off-the-shelf database software like MS Access, dBase, FoxPro, FileMaker, and Paradox (to name a few) can easily work with files containing large numbers of records.