palewire / django-calaccess-campaign-browser

A Django app to refine, review and republish campaign finance data drawn from the California Secretary of State’s CAL-ACCESS database
http://django-calaccess-campaign-browser.californiacivicdata.org
MIT License
17 stars 12 forks source link

Loadcampaignfinanceexpenditures doesn't load CSV #194

Closed aboutaaron closed 9 years ago

aboutaaron commented 9 years ago

Hey @palewire I'm currently rewriting the load command for the expenditure model but I can't seem to get the CSV to generate. Here's the code on the expenditure-model-clean branch:

https://github.com/california-civic-data-coalition/django-calaccess-campaign-browser/blob/expenditure-model-clean/calaccess_campaign_browser/management/commands/loadcalaccesscampaignexpenditures.py

I followed what you did with load contributions command but looks like my SQL code is missing something. I don't receive any SQL syntax errors so I'm guessing it's with how I'm associating the data.

The function begins on L62. Any insight would be very helpful. Thanks dude!