I did ours by hand. I had the customers in a spreadsheet, by address and speed. Then I had to go through the addresses to make sure that they were correct. Some of our customers bill to an address that is not their home address, so I had to change it. Then I sorted by Zip and went through with the PDF of the census tract, by hand and populated the census tract.
The CSV looked even more complicated. Most of my users are in Quickbooks and although we also have an Access database for our technical info, there were new fields to add. Wasn't sure how to add these new fields and make sure it was right. Martha Huizenga DC Access, LLC 202-546-5898 */Friendly, Local, Affordable, Internet!/**/ Connecting the Capitol Hill Community /* David E. Smith wrote: > Randy Cosby wrote: > >> Did you guys end up creating a CSV file to upload, or do it by hand, by >> tract? >> > > I ended up doing the CSV thing. I had to correlate our billing system, > our in-house IP management system, and two spreadsheets, to get all > their requested data (and I'm still not confident it's 100% accurate in > every detail, but it was the best I could do). > > Ended up being a lot easier to just add a little "spit out a CSV" code > at the end, than to try to enter seventy-some-odd numbers into those > great big tables. > > David Smith > MVN.net > > > -------------------------------------------------------------------------------- > WISPA Wants You! Join today! > http://signup.wispa.org/ > -------------------------------------------------------------------------------- > > WISPA Wireless List: [email protected] > > Subscribe/Unsubscribe: > http://lists.wispa.org/mailman/listinfo/wireless > > Archives: http://lists.wispa.org/pipermail/wireless/ > > -------------------------------------------------------------------------------- WISPA Wants You! Join today! http://signup.wispa.org/ -------------------------------------------------------------------------------- WISPA Wireless List: [email protected] Subscribe/Unsubscribe: http://lists.wispa.org/mailman/listinfo/wireless Archives: http://lists.wispa.org/pipermail/wireless/
