Talk:CNVC IT Committee
Welcome to the discussion ("Talk") page for the CNVC Information Technology (IT) article (document building) page on NVCwiki. This is the page you can reach by clicking on the "discussion" link at the top of the document building "article" page. This discussion (Talk) area is where we can ask and answer questions, while the "article" (document building) area can be reached by clicking on "article" above. The article area is best suited to collaboratively building documents and lists.
Contents
IT Priorities
Database combining online and CNVC office information.
- What means database ?
To me it means an industrial strength database capable of replacing Quickbooks for Payroll and other accounting needs, Excel for the various spreadsheets people have apparently created due to lack of a suitable database, and Access for the few limited non-relational freestanding databases like donor lists we apparently do have at the CNVC office and on the ASP part of cnvc.org.
- It means something like mysql ?
From what I gather, yes MySQL would be a very strong contender because it's not only a powerful database with web integration capability built-in. It's also open source and thus free for us to use and share throughout the NVC network.
- I like to differentiate between database and something named presentation layer. For me its more clear by defining database as something which contains data and presentation layer as something which allows to access the data.
Ah, so the Database is the application that stores the data, and the Presentation Layer is the Forms and Reports you use to view or edit the data. The Data itself is the information contained in the database, for example a collection of Fields that might include Name, Address and Phone. All of those Fields would be distinct sections of Data that might be used on a Donor Contact Info presentation layer Form?
- Why it means database ? For easy query ?
Yes, CNVC has an urgent need for all the Data we now have to be input only once rather than written on papers and typed into all of the different applications I listed above.
- How you like to have the access ? By web ? By "fat" client (windows/java application) ?
All of those, and probably more ways.
- Accessible by whom ?
We need to have many levels of access. Some things would be accessible to anyone on the web. Some would require registration first to give minimal security and accountability. Some would be for access by members of a group. Some for access by selected individuals. Some would be visible to one level of access and modifiable by another level of access.
- You like to split the database from the online database ? If yes, you like to import data to online database ?
That's something we'd need to decide based on security. Is it possible to have absolutely unbreakable security with online data? My guess is no, so we'd need to have only some data online yet all of it integrated somehow. Like if the online part were a subset of all CNVC data, and the part not online would be physically isolated. Maybe the online data could periodically be updated by a send-only process requiring physical access to the offline database server?
Variable levels of strong security.
- What means strong security ?
I'm no security expert, but to me it would mean as close to impossible for hackers to penetrate as can be. Hackers and spammers will probably try to gain access, so we'll need some things to be completely locked down while allowing anyone to access or even edit some things. Hopefully we could also have many different levels of security between those extremes, and the ability to have different security on individual items or entire sections.
- Not accessible by everybody ?
Absolutely not, for some items and sections.
- Only trusted verified persons ?
Some things would be best available to everyone. For example the ability to see a list (interactive map?) of trainers and NVC groups and GCCs.
- Secure connection ?
For some things, yes. Anything to do with money or private information.
Trainer contact info.
- Address data ?
Yes.
- What else ? I like to know the list of columns you like to have.....
We probably wouldn't need some of these, but could build them into the database for future or optional use: 1st Name, Last Name, Middle Name, Nickname, Password, Password reminder, Email 1, Email 2, Email 3, Birthday, Mailing address/PO Box, City, State, Country, Zip, Home address, City, State, Country, Zip, Website, Business phone (breakout country and area codes for autocompletion in subsequent phone entries for same contact record?), Home phone, Mobile phone, Free VOIP address (Skype, etc.), AIM info, IRC channel, IRC user name, maybe two fields for other contact methods, Membership status, Trainer status, Certification status, Certification date, Cert.Renewal due date, Donor status, Contribution date (expandable?),Contribution amount (expandable?), Contribution project (expandable?), Contribution currency (expandable?). Any more?
- Accessible by everybody ?
Only some fields. Probably just name, trainer status, mailing address and business phone. We'll also want a webmailer that people can use to email trainers at their preferred email address and show the sender's email address, but not reveal the destination email address. I believe CS has this built in.
Donor contact info.
- Address ?
- Payment overview ?
The Trainer and Donor contact lists could be relational so that trainers who donate could be tracked by the fundraisers without duplicating data. We probably wouldn't need some of these, but could build them into the database for future or optional use: 1st Name, Last Name, Middle Name, Nickname, Password, Password reminder, Email 1, Email 2, Email 3, Birthday, Birthday 2 (wife, etc.), Birthday 3...20, Significant date (anniversary, etc.), Significant date 2...20, Tickler dates 1...20, Notes, Mailing address/PO Box, City, State, Country, Zip, Home address, City, State, Country, Zip, Website, Business phone (breakout country and area codes for autocompletion in subsequent phone entries for same contact record?), Home phone, Mobile phone, Free VOIP address (Skype, etc.), AIM info, IRC channel, IRC user name, maybe two fields for other contact methods, Membership status, Trainer status, Certification status, Certification date, Cert.Renewal due date, Donor status, Contribution date (expandable?),Contribution amount (expandable?), Contribution project (expandable?), Contribution currency (expandable?). Any more?
Local and Regional NVC group contact info.
- Address ?
Yes.
- Contact person ?
Yes, with mailing address, business phone and email form with hidden destination address. Should be relational since this person's data is presumably already elsewhere in the database.
- Accessible by everybody ?
Yes, with interactive map if possible. Also menu for drilling down to specific group for those with slow connections or other inability to use map.
Free IT Package on CD
- I'm appreciating a possible longing for consistency and I'm anxious a strategy that involves spending money on materials and postage in order to distribute software that can be downloaded for free through the Internet seems unlikely to meet a need for economy. I am aware of certain members in our network who do not enjoy reliable Internet access, and still feel puzzled. I'd like to better understand the needs that might be met through this proposal.
I'm imagining it as an option that we could offer. Individuals might like to get a CD that comes preconfigured with everything they would need to access all that CNVC has to offer. This could save non-technical people a massive amount of time and effort getting online, or reading and writing documents. My guess is that this could be a long-term project, and one that would continually evolve. Another CD/DVD could be for local and regional groups wanting to set up their own office or online presence. Another could be for anyone who wants to use CNVC resources, like the fundraising database or online resources (so their tools and procedures would have maximum compatibility with CNVC). Overall needs: ease, mutuality, consideration, connection.
Free Computers with Pre-Installed Software
- One concern that springs to mind is that we don't have the resources available in the regions that might appreciate these that would support their distribution. (I mean, if you were to deliver 10 computers to Singapore tomorrow, I wouldn't be able to do anything with them unless you could also provide the funds that would help cover cost incurred through my shipping them out again to the people who could really use them).
Perhaps they could be shipped direct to the end user or group? Is it possible that such problems might be resolved in dailog between those providing the computers and those who'd like to receive them?
- Another thought that occurs to me is there are a couple of charities who already do this - i.e. ship used computers to people who can make use of them. Perhaps we could focus our attention more profitably on establishing a connection with them that might allow members in our network to apply for these?
Yes, and again it would be helpful if those computers had the CNVC suite of applications pre-installed and pre-configured. This would take far less work for those preparing the computers, than for those receiving them.
Online tools integrating various CNVC and other online resources.
- Is "Online tools" the synonym for online like web and accessible by others ?
Yes, that is how I would define it. This means that someone could access many resources by using their web browser. One example would be that someone could find the nearest trainer or group, and that trainer or group could update their contact information - all online without requiring any input by CNVC employees. This will reduce labor costs at CNVC, reduce errors when data is input multiple times in different places, and reduce delays due to waiting for CNVC to be open or the person who inputs particular being sick or on vacation.
Database Selection Criteria
The following database qualities are offered for consideration by the IT Committee:
- I like to differ between database and something named presentation layer. For me its more clear by defining database as something which contains data and presentation layer as something which allows to access the data.
CivicSpace Discussion
How much customization was required before the example websites on the In Action started to look and operate as they do? These sites are quite impressive, yet they may contain extensive customization. Is this customization work shared? Would we be able to find out what they did and how they did it? Is there a particular site on that page or the other "complete" list of CS sites that we'd want to emulate? Would it save us a lot of time if we could basically copy an installation that does everything we want?
"donor management" and "best practices"
Extract from CNVC IT Committee#Information Technology (IT) Needs :
5. Wiki or similar for collaborative document generation and editing, with some areas having limited read and/or write access (e.g. Board, Certified Trainers, etc.).
As some pages are related to all pages in a wiki, like Special:Recentchanges and many other "Special pages", wouldn't it be better to have separate wikis for restricted groups ? For example, the Wikimedia Foundation has a wiki for which "log in" requires approval.
Generaly speaking, considered the fact that Wikipedia seems to be one of the most efficient organisation in "donor management" — and I don't mean only money, but also time, creativity, etc... — wouldn't it meet some CNVC's goals to get closer to their team, to learn from their "best practices" ? --Dieudonné 00:24, 26 May 2006 (CEST)
- I like the idea of separate wikis as you describe it. As for getting closer to the wiki team, my impression is we've begun doing that. I'm assuming that if and as we add more content to this wiki and probably create and integrate other wikis, people with connections to the wiki team will participate. Don't you and Markus both have some connections with the wiki team? My impression is that there are several wiki teams. Is there something in particular you'd like to see by way of closeness with the wiki team(s)?
- Oops. Forgot to log in before replying, so my authorship would show on this. -JW
- Too late, we know your IP now ;-) About getting closer to wiki team(s) I imagined trying to meet some of them, but it's allready great for me feel so understood on theses subject by someone within CNVC It helps me feel confident about seeing one day NVC spreading around the world as widely as Wikipedia, and beyond... :-) --Dieudonné 23:39, 26 May 2006 (CEST)
petersrevington furniture peters denial peterbilt model truvks peterbilt logging trucks peterbilt hoods peter white guitar tabs peter wentz nude peter waterman peter verdurmen peter van vliet peter townshend peter tower peter thomas peter sorce peter smiley peter siddells peter scott peter s lemarie peter pattison chatham ma peter pan chan slash peter ordower peter o neil brechin peter north lucky bastard peter north fucking peter moleneux peter michael lee in newport ri peter mcrae bilbies peter liljeberg peter kane peter jurmain peter holmes catholic peter hegre galleries peter grybas peter griffin rebuilt peter garrett attended university at peter gabriel mp3 s peter gabriel video peter fauk peter falk preview peter emmanuel wright peter eisenman furniture peter e papierski scholarship fund peter donat photos peter cavallo peter brown born 1938 australia peter austen peter andre pied peter and the wolf worksheet peter amerman peter ackroyd pete wentz myspace layouts pete wendling pete thomson radio announcer pete shelley you know better than i know pete seegar life story pete sampras photographs pete ricketts pete pappas pete general motors ceo pete delmonico aol pete and mel petaluma ca petal newspaper ms peta events pet810 reviews pet vaccines simi valley pet urine remover homemade pet sympathy candle pet storm door pet store sanford maine pet sitter internationale pet shots pet shop birds pet services usa pet rock gary dahl pet people sex pet palaces pet pal rescue pet nanny pet name noenoe pet magpie pet health websites pet health insurence in britain uk pet grooming courses in new zealand pet friendly vacation rentals in florida pet friendly vacation rental lake george pet food sick pet essentials pet detective trained pet chinchillas pet budgies pet boarding lakefield ontario canada pet animal disposal ca pet adoption minnesota pet adoption in michigan pesty garden beetles pests on roses pesto source pestcontrol program pestartprintjob pest control services bangkok thailand pest control in haccp pest control company sold pest 1 pesach hotels pes format embroidery designs pes film peruvian green hot sauce peruvian black mint peru indiana peru in peru guide to peru national tour pictures peru fun facts peru chica perth road map golfview st yokine perth pc shops perth dating services perth booze bus locations perth amboy page ranking perth amboy community forum perter boot art perteen nude persues persuasive speech outline pollutions persson alva personnel scooter personna personals young male seeking older woman personals from corning ny personalized wheeled backpacks personalized wedding wine labels personalized swizzle sticks personalized poker sets personalized plates personalized metal welcome sign personalized matchbooks personalized leather tote bags personalized father s day gifts personalized eyeglass holder personalized day planners personalized daisy napkins personalized bride sweat and undies personalized 50th wedding gifts personalize pillowcases personality test quizzes for teens personality of twins personality needs to be center of attention personalities based off of the pet you own personalised email address