On Fri, Mar 03, 2006 at 08:32:03PM -0800, Tony Fenleish wrote: > What type of database are you running?
oracle > > > ----- Original Message ----- > From: "Peter Whiting" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Friday, March 03, 2006 4:10 PM > Subject: [Ldsoss] ward list export > > > | We'd like to add the option to export the ward list from the unit > | website either as a csv file or as vcards. > | > | Issues/questions: > | > | 1. Most of the text is stored in caps. We plan on just leaving > | it as-is for simplicity. If someone wants to propose a clean, > | simple, safe way to decapitalize in TCL, feel free to send it my > | way. > | > | 2. For the csv export, what should each row look like? > | > | a) name, email, phone, addr (one row for every member of the ward) - > this > | is the easiest to do but might not be as useful. > | b) family, head of household, head of household email, phone, addr > | (one row for each family) - this is about as easy to do as the above. > | c) family, head of household, head of household email, spouse, spouse > email, > | phone, addr (one row for each family) > | d) everything above, plus one large field containing all of the > children's > | names, and emails > | e) similar to above, but each child would get their own pair of columns > | (name and email) making each row vary in the number of columns - this > | would imply that the children are going to be at the end of the > record. > | > | Sorry we can't do unique phone numbers per person - it isn't supported > in > the > | current database. > | > | 3. Similar questions for vcard... > | > | pete > | > | _______________________________________________ > | Ldsoss mailing list > | [email protected] > | http://lists.ldsoss.org/mailman/listinfo/ldsoss > | > | > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > _______________________________________________ > Ldsoss mailing list > [email protected] > http://lists.ldsoss.org/mailman/listinfo/ldsoss _______________________________________________ Ldsoss mailing list [email protected] http://lists.ldsoss.org/mailman/listinfo/ldsoss
