Skip to content

"American Heart Association" data is wrong in NetFile #107

@tdooner

Description

@tdooner

This is a note to debug later, I think it is a bug in Netfile. In the original Excel file downloaded (SFO, 2018; Filing ID = 171799001), some of the columns for the American Heart Association on Form 497 are mixed up:

For example, see how the "Bal_Name" is in the "Dist_No" column:

image

This is the origin of our error:

"COULD NOT FIND BALLOT MEASURE: "City & County of San Francisco"
Add it to the Oakland Candidates spreadsheet
Debug: {"Filer_ID"=>"489164", "Filer_NamL"=>"American Heart Association", "Measure_Number"=>nil, "Bal_Name"=>"City & County of San Francisc
o", "Sup_Opp_Cd"=>"Unknown", "Total_Amount"=>nil}"

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions