Here are the sample data files for the files FEC will convert to pipe delimited text format at the end of this month. The compressed file contains sample files for CN, CM, WEB* and CCL. cn12_sample.txt cm12_sample.txt webk12_sample.txt webl12_sample.txt webl12all_sample.txt ccl12_sample.txt file_formats_cm_cn_webk_webl_weball_ccl_20120615.xlsx The FEC will convert five more FTP files to pipe delimited text files and produce a new linkage file. We will also change the file extension from .dta to .txt on all the weekly FTP files (INDIV, PAS2, OTH, CM, CN, WEBK, WEBL and WEBALL) We will place the newly converted files in the appropriate 2-year period folder on the FTP server. We have changed some of the data elements and their order in the Candidate Master (CN) file and the PAC Financial Summaries (WEBK) file. Please review these changes. We have not changed the data elements or the order of the data elements in the other files: Committee Master (CM), Candidate Financial Summaries - Current Candidates (WEBL) and Candidate Financial Summaries - All Candidates (WEBALL). Once we start producing the files in the new format we will no longer produce the files in the old format. The last update for the current format will be 07/22/2012. The update on Sunday 07/29/2012 will be in the new format. The FTP files to be converted are: Existing Files CMxx (Committee Master) CN (Candidate Master) WEBK (PAC Financial Summaries) WEBL (Candidate Financial Summaries - Current Candidates) WEBALL (Candidate Financial Summaries - All Candidates) New File CCLxx (Candidate Committee Linkage) The candidate committee linkage file will help you associate candidates with their campaign committees (principle and other authorized) and joint fundraising committee
Posted by Stephen Salfeety on July 20, 2012 at 10:05 AM EDT #
Posted by Paul on July 20, 2012 at 10:29 AM EDT #