Right now, we generate our application seed data from a CSV file using a command like so
cd web
. venv/bin/activate
python manage.py parse_coop_csv directory/fixtures/chicommons_prep.xlsx\ -\ Mapping\ Sheet.csv > directory/fixtures/seed_data.yaml
However, the script doesn't process rows that include an apartment or unit number beginning with a "#" properly. For example, this row
121,Bucktown Community Organization,1658 N. Milwaukee Ave. #520,60647,Chicago,IL,"Chicago, IL 60647",USA,Social Workshop,yes,http://www.bucktown.org/,,,,,,,,,,,,,,-87.67930655,41.91146275,#ERROR!,#ERROR!,Accelerate77,SE,,,,
is getting processed but losing the "#520" when the "directory/fixtures/seed_data.yaml" is produced. We need to figure out how to keep this data.
Right now, we generate our application seed data from a CSV file using a command like so
However, the script doesn't process rows that include an apartment or unit number beginning with a "#" properly. For example, this row
121,Bucktown Community Organization,1658 N. Milwaukee Ave. #520,60647,Chicago,IL,"Chicago, IL 60647",USA,Social Workshop,yes,http://www.bucktown.org/,,,,,,,,,,,,,,-87.67930655,41.91146275,#ERROR!,#ERROR!,Accelerate77,SE,,,,
is getting processed but losing the "#520" when the "directory/fixtures/seed_data.yaml" is produced. We need to figure out how to keep this data.