pwhiting wrote:I'm interested in comments on the following:
1. mark the last name with / / when it appears in the name* column. The last name is included when it is different than the head of household last name - should it just be included all the time?
It think it's important to be consistent.
2. each row is variable length, depending upon the number of children. We only list name1 and name2 in the column headers. We could add more column headers (name3, name4, ...) or we could go through the list once, figure out the maximum number of family members for this csv, and then create that number of column headers. I realize the second approach is more robust, but I'm trying to keep the code supporting this as simple as possible, and doing two passes through the ward list, one to figure out the maximum family size and one to print everything out seemed like more effort than it was worth.
I vote for more robust. Let's make the feature work as well as it can.
3. split the name and email into two distinct columns. Currently they are combined, it is trivial to split them. The column headers would be name1, email1, name2, email2,
This is the most important change. I strongly suggest you do it.
4. distinguish between parents and children - currently name2 contains information about the first child in single parent households.
I vote for this, too. Name2 would be blank for a single head of household. Once again, this provides consistency in output and makes the file more useful. Also, each column should have a heading: name3, name4, etc.