Skip Navigation
Federal Election Commission, United States of America (logo). Link to FEC Home Page
Federal Election Commission
Search

 

HOME / E-FILING HELP / DOWNLOAD IMPORT FORMATS

Importing Data Into FECFile

(Individuals and Organizations, Schedules A, B, and H4, only)

The FECFile import feature allows users to import the following data sets into the software:

-Individuals and organizations (IND/ORG)

-Schedule A transactions (SA)

-Schedule B transactions (SB)

-Schedule H4 transactions (H4)

To successfully import a data set, the data set must be formatted properly into an "import format"-- an ASCII character (28) delimited text file.

Contained on this page you will find a link to download the FECFile Import Format and the ASCII 28 data converter tool, followed by step-by-step instructions on how to import your data sets.

Download FECFile Import Format and Data Converter:

NOTE: One of the files extracted from the zipped download is the Data Converter. Usage of this tool will be explained in the next section.

Converting data from your Import Format into the ASCII 28 delimited text file.

NOTE: FECFile requires a special delimiter to separate data fields in your Import Format. The following steps will convert your csv text file into an ASCII 28 delimited file.
 

Importing your ASCII 28 delimited text file into FECFile.

NOTE: The procedures for importing individuals and organizations differ a bit from importing Schedules. Both instructions follow below.

Importing Schedules (A, B, and H4):

NOTE: All transactions dates must fall within the selected report’s coverage date range.

NOTE: Remember your import file will have the extension (*.fs).

NOTE: If your file has duplicate individual or organization entries the “Merge” window will appear. The Merge feature is discussed in more detail in the FECFile User Manual. In short, this tool allows you to merge two like records into one. You can merge the entire record or individual fields. Left mouse click the Merge button and the Left record will be added.

NOTES: Status logging shows you the following:

-Import results

-Number of transactions imported

-Any errors that occurred during the import process

Any transaction that failed the import process must be fixed in the MSExcel .csv file, re-converted to the ASCII .fs file, and re-imported. You must also delete any transactions that were previously imported, as they will create duplicates when re-imported.

Note/Tip: If you find that you have imported large data sets that contain many errors, you may find that it is easier to close down FECFile without saving your import and starting over the import process (once you have corrected the data in the csv file).

Importing Individuals and Organizations:

NOTE: Remember your import file will have the extension (*.fs).

NOTE: The “Continue” button in the Merge window allows you to skip a particular record and move to the next without the merge occurring.

Note/Tip: If you find that you have imported large data sets that contain many errors, you may find that it is easier to close down FECFile without saving your import and starting over the import process (once you have corrected the data in the csv file).

If you have questions regarding importing, please call the FEC Electronic Filing Office at (202) 694-1642 opt# 2.

Page Modified October 4, 2011