Documents & Filing Forms
Note: This also applies to Fom 3–Q - Comprehensive Quarterly Financial and Operating Report
Viewer - Instructions and Download Before downloading the Viewer Application, please print and read this page of instructions! You will save yourself a lot of time by referring to this page first, before contacting FERC with problem issues. Most problems will involve Internet communication issues which are addressed below. Of course, we make mistakes - and need to fix things on the server or with the software, so we do not mind emails, questions, and suggestions.
Downloading and Viewing the Form 1 Database
The public version of the Form 1 database is available for partial or complete download to client sites and may be viewed with the Form 1 Database Viewer. The Database Viewer will permit the selection, viewing and printing of individual or all Form 1 annual submissions for 1994 through the last filing year and quarterly (3Q) filings submitted for the first quarter 2004 and on.
The resulting Form 1 Database downloaded to the local client may be manipulated for specific reporting or analysis needs using Microsoft Visual Foxpro 6.0 (VFP 6.0) or commercially available reporting software such as Crystal Reports or others that support the VFP 6.0 database container structure. Learn how to connect to a Visual FoxPro Database through Microsoft Access to access the Form 1 database.
Depending on your browser, you can either download the installation file, or run the installation from within your browser. In any event, the downloaded file is named Form1v.exe and can be considered the Installation Disk for the Viewer Application. You must execute this file to install the Viewer Application. Follow the instructions given during the installation process. It will be easier for us to help you with problems if you use the default directory/folder names for the software. The default for the viewer is C:\F1viewer. The software should be installed on the workstation. The database may be installed on a network for multiple user access.
Once the application is installed on the client PC, it is accessed through the Start\Programs\FERC Applications menu. There are two sub-items under this heading named Form 1 Data Download and Form 1 Data Viewer. You must first use the Form 1 Data Download application to obtain the database. Within the download application, you should select the companies you are interested in and the filing year. (You select multiple companies by highlighting them on the displayed list. To highlight multiple companies, use the standard Windows selection technique of ctrl key/left mouse click.) You have a checkbox option of selecting all respondents (Form 1 Filers) for a particular filing year.
The download process may take a few minutes, depending on your connection speed and the number of companies requested. When requesting one or more companies, the server extracts the requested companies from our database and creates a small database with just the requested companies. This database is compressed, sent via Internet to your PC, and decompressed. All this takes some time. So, give it a few minutes before you think something is wrong.
The more companies you select, the longer it will take to get the data. If you want many companies, it may be quicker to download the entire database for the year instead of selecting individual companies.
When you use the Viewer, click on Company Selected to obtain a drop down list of companies downloaded to your PC. Then, select the company you wish to view.
The downloaded information is not cumulative. When you download a new selection, the previously downloaded data is replaced by the new download. (Of course, you can always copy or download it to another directory if you wish to retain it.)
As an alternative, you can download a compressed (zipped) copy of the database for particular years. If you want the most current information, you might visit this site just to check the dates on the files. When the date changes, we have probably added more respondents, or made other corrections to the database. If you have problems with this, contact your computer support personnel.
You should not experience much trouble downloading and installing the Viewer application on your workstation. However, the component of the viewer that provides the Listing of Available Companies - and downloads the database may not work properly with your workstation or network configuration. In the event that you cannot download data, it is suggested that you download the entire database for the specific year you desire. The downloaded file should be unzipped into the appropriate folder. Then, start the Viewer and use Options/Change DB Location to point to the database folder.
Download Problems - Potential Solutions
The Form 1 Viewer uses HTTP (to get the list of companies) and FTP Receive (to download the selected database data) and notify you of availability of updated Viewer software. These common Internet Communication Protocols may be blocked by your Internet Firewall for security reasons. This will require intervention by your computer or network support personnel. To assist in diagnosing this problem, we make available an Internet Communications Test Application – which you can download and run on your workstation just as you did the Form 1 Viewer. Please see a description of this application below under Forms Communications Test Application. Note that your workstation only needs to pass the HTTP send/receive and FTP Receive tests. FTP Send is not necessary for proper operation of the Form 1 Viewer.
The easiest and most effective solution is to ask your Firewall Administrator to install a rule in the Firewall permitting HTTP Send/Receive and FTP Receive from IP 18.104.22.168. This presents a minimal or non-existent security risk since all communication requests are issued by the Client (your workstation). The FERC Forms Server does not “push” unsolicited information to your workstation.
Privileged Treatment of Data
Last, but not least, some companies have selected certain parts of their Form 1 Submission for Privileged Treatment. These parts are not available for public distribution pending a decision by the Commission. There will be a very light blue hyphen (-) pattern in the fields where the data would appear if not privileged. So, if you come across this, the application is not broken, but rather the data was redacted for these fields.
Problem Reporting and Assistance
If you have any problems with downloading or using the viewer application, please send an email describing the problem to firstname.lastname@example.org . In order to help in diagnosing a problem, please attach the file F1view.log to your email. The Viewer Application writes little notes on how it is feeling about life on your PC to this log file. If you don’t attach it, we will send you a reply email asking for it. So, it just saves time for all of us if you do it first off. This file is found in the c:\F1viewer folder. If you see two files called F1view,and can’t determine which is the log file, attach and forward the smaller of the two files.