Meta tags:
description= Posts about Programming written by William Buell;
Headings (most frequently used words):
blog, cloud, william, buell, the, category, on, stats, zoho, and, open, source, ubuntu, archive, for, programming, daily, posts, twitter, calendar, my, links, pages, categories, tag, blogroll, interesting, line, publications, google, plus, flickr, photos, meta, speedy, support, reply, from, poetry, computing, electronic, storage, of, student, records, firefox, browser, hijacked, movement, creating, storing, passwords, blows, me, away, popular, fiction, 2nd, attempt, multiple, local, sites, apache2,
Text of the page (most frequently used words):
the (277), and (179), that (96), you (94), for (61), with (55), www (53), have (51), zoho (51), from (37), not (37), can (36), this (35), var (35), but (33), which (31), would (30), are (28), was (28), some (27), http (26), then (26), com (25), php (24), williambuell (24), proj1 (24), know (23), what (23), #records (23), your (22), data (22), sheet (22), any (20), school (20), ubuntu (19), like (19), all (19), will (19), rows (19), did (18), privacy (17), about (17), want (17), make (17), folder (17), there (17), programming (16), html (16), test (16), should (16), desktop (16), now (15), other (15), report (14), create (14), free (14), security (14), file (14), code (14), need (14), spreadsheet (14), tutorial (13), mysql (13), software (13), first (13), only (13), one (13), above (13), access (13), org (13), blog (12), google (12), work (12), local (12), when (12), could (12), sudo (11), chown (11), where (11), out (11), also (11), time (11), irc (10), use (10), posted (10), comment (10), localhost (10), support (10), here (10), into (10), same (10), address (10), copy (10), people (10), children (10), paste (10), target (10), linux (9), education (9), apache (9), leave (9), see (9), each (9), issue (9), they (9), them (9), found (9), their (9), gnu (9), has (9), problem (9), state (9), student (9), regarding (9), information (9), cell (9), spreadsheets (9), our (9), account (8), more (8), source (8), cloud (8), government (8), pages (8), very (8), get (8), book (8), how (8), browser (8), able (8), last (8), certain (8), email (8), password (8), 2010 (8), oss (8), link (8), column (8), row (8), william (7), buell (7), line (7), educational (7), technology (7), wubi (7), new (7), links (7), head (7), question (7), because (7), following (7), project (7), command (7), beginner (7), change (7), might (7), let (7), simply (7), next (7), several (7), name (7), may (7), application (7), open (7), share (7), excel (7), size (7), wordpress (6), malware (6), history (6), law (6), facebook (6), internet (6), stuff (6), tags (6), just (6), step (6), dont (6), understand (6), why (6), sure (6), since (6), folders (6), say (6), user (6), automatically (6), files (6), two (6), numbers (6), firefox (6), than (6), tried (6), sent (6), problems (6), schools (6), 000 (6), electronic (6), services (6), over (6), meg (6), noticed (6), date (6), sub (6), error (6), formula (6), sign (5), online (5), passwords (5), microsoft (5), simple (5), through (5), including (5), session (5), sense (5), look (5), second (5), rights (5), correct (5), home (5), does (5), most (5), different (5), page (5), thanks (5), client (5), help (5), were (5), made (5), read (5), anyone (5), automated (5), who (5), bazaar (5), between (5), better (5), health (5), federal (5), click (5), storage (5), harmful (5), consequences (5), issues (5), upload (5), stamp (5), end (5), offset (5), https (5), perhaps (5), large (5), limit (5), already (4), document (4), place (4), polychem (4), poetry (4), install (4), clipperz (4), blogging (4), avira (4), antivirus (4), philosophy (4), literature (4), company (4), store (4), windows (4), district (4), daily (4), 2009 (4), pick (4), zip (4), something (4), hard (4), directory (4), without (4), default (4), post (4), right (4), bryan (4), gives (4), navigate (4), gui (4), once (4), mkdir (4), try (4), channel (4), whenever (4), terminal (4), correctly (4), proper (4), apache2 (4), within (4), search (4), both (4), whether (4), notice (4), upon (4), version (4), come (4), field (4), record (4), these (4), take (4), having (4), far (4), had (4), based (4), using (4), america (4), add (4), child (4), every (4), cathedral (4), delicious (4), laws (4), below (4), public (4), such (4), general (4), macro (4), day (4), documents (4), age (4), names (4), view (3), content (3), log (3), entries (3), review (3), twitter (3), nature (3), verizon (3), teaching (3), religion (3), paltalk (3), blackberry (3), art (3), antivir (3), shell (3), memorable (3), medicine (3), finds (3), high (3), computer (3), american (3), posts (3), answers (3), started (3), basic (3), downloaded (3), exercises (3), great (3), called (3), path (3), saying (3), well (3), enough (3), words (3), aha (3), act (3), yeah (3), everything (3), told (3), away (3), back (3), too (3), think (3), root (3), changes (3), year (3), old (3), total (3), key (3), concept (3), works (3), system (3), follow (3), example (3), yes (3), lamp (3), cannot (3), trying (3), external (3), excellent (3), projects (3), installed (3), remote (3), detailed (3), sort (3), asked (3), wanted (3), business (3), creating (3), trick (3), realize (3), until (3), word (3), added (3), database (3), saved (3), hours (3), really (3), become (3), visual (3), kind (3), forum (3), exercise (3), always (3), his (3), december (3), koontz (3), steel (3), process (3), program (3), etc (3), generator (3), gig (3), notes (3), less (3), world (3), face (3), apps (3), before (3), download (3), drive (3), per (3), idea (3), browsers (3), sometimes (3), chrome (3), while (3), few (3), malwarebytes (3), enter (3), safe (3), decided (3), available (3), find (3), study (3), been (3), least (3), states (3), curious (3), learn (3), york (3), safeguards (3), officials (3), necessary (3), however (3), systems (3), often (3), htm (3), personal (3), boces (3), computing (3), governments (3), facility (3), vba (3), instability (3), increase (3), corruption (3), much (3), larger (3), created (3), private (3), applications (3), ability (3), october (3), way (3), pasting (3), scenario (3), missing (3), bottom (3), reached (3), columns (3), hyther (3), blogs (3), supports (3), sharing (3), protected (3), export (3), upto (3), subscribed (2), subscribe (2), rss (2), photos (2), flickr (2), function (2), widget (2), stats (2), monthly (2), interesting (2), wifi (2), war (2), sprint (2), south (2), seaport (2), poem (2), parenting (2), military (2), linkedin (2), librivox (2), happiness (2), gimp (2), freedom (2), ethernet (2), backup (2), writing (2), uncategorized (2), theology (2), talk (2), spirituality (2), short (2), science (2), psychology (2), politics (2), nyc (2), movies (2), life (2), forums (2), ethics (2), essay (2), dialogue (2), bookstore (2), category (2), grade (2), amity (2), holy (2), consulting (2), chat (2), contact (2), info (2), policy (2), procedure (2), older (2), multiplenamehost (2), questions (2), straight (2), hand (2), posting (2), anything (2), develop (2), else (2), addresses (2), quite (2), makes (2), sufficient (2), looks (2), current (2), going (2), yep (2), type (2), comes (2), paths (2), making (2), ownership (2), cant (2), give (2), unless (2), mean (2), cheat (2), require (2), permissions (2), matter (2), those (2), needed (2), whatismyip (2), turns (2), put (2), debian (2), administration (2), articles (2), 412 (2), multiple (2), sites (2), answer (2), clear (2), required (2), under (2), says (2), raw (2), person (2), week (2), someone (2), purposes (2), doing (2), allow (2), steps (2), cloned (2), went (2), entered (2), actually (2), saw (2), prefixed (2), table (2), submit (2), phpmyadmin (2), signed (2), sink (2), executing (2), original (2), run (2), possible (2), progress (2), foxpro (2), finally (2), best (2), feedback (2), gave (2), developing (2), shall (2), invoke (2), machine (2), keep (2), attempt (2), novel (2), fiction (2), middle (2), real (2), danielle (2), wondering (2), many (2), novels (2), sentence (2), three (2), close (2), blows (2), its (2), took (2), message (2), yahoo (2), aim (2), hundreds (2), updates (2), afford (2), server (2), long (2), strong (2), technique (2), encrypted (2), random (2), prayer (2), veni1vidi0viki66 (2), even (2), letter (2), january (2), unesco (2), result (2), opinion (2), please (2), promote (2), usage (2), never (2), cooperation (2), organization (2), movement (2), care (2), design (2), believe (2), imagine (2), write (2), good (2), explorer (2), hijack (2), various (2), billbuell (2), rebooted (2), scanners (2), running (2), down (2), searched (2), similar (2), quickly (2), visit (2), hijacked (2), epic (2), compromised (2), protections (2), reports (2), social (2), safety (2), doctors (2), provided (2), reasonable (2), requires (2), interest (2), ferpa (2), must (2), gov (2), protect (2), against (2), potentially (2), present (2), serious (2), september (2), control (2), activity (2), center (2), being (2), nys (2), secure (2), legally (2), owned (2), archives (2), request (2), ensure (2), archival (2), facilities (2), event (2), attempted (2), formulas (2), corrupted (2), normal (2), 2000 (2), logged (2), group (2), invite (2), course (2), cells (2), enev (2), enableevents (2), exit (2), worksheet_change (2), byval (2), range (2), rem (2), tab (2), worksheet (2), places (2), adding (2), deal (2), particular (2), proprietary (2), unix (2), became (2), drinking (2), die (2), light (2), breaks (2), sun (2), shines (2), docs (2), embedding (2), parsed (2), easy (2), farm (2), birth (2), sheets (2), minor (2), small (2), uploaded (2), manually (2), additional (2), 10000 (2), began (2), experiment (2), others (2), number (2), million (2), performance (2), zohosheet (2), assist (2), fine (2), editor (2), import (2), mentioned (2), a10010 (2), a10009 (2), a10006 (2), ref (2), behavior (2), thank (2), collapse, bar, manage, subscriptions, site, reader, comments, xfn, valid, xhtml, meta, createelement, getelementsbytagname, async, src, socialstatistics, min, parentnode, insertbefore, script, plus, publications, spreading, via, charles, beard, democratic, jeffersonian, democracy, stories, narrative, cronon, kim, ventures, blogroll, wisdom, street, soundcloud, socrates, skype, shortstory, sartre, rushdie, rumi, plato, philokalia, armor, morality, michael, moore, maimonides, kung, koan, islam, homework, gnome, gimptricks, frankl, firewall, faith, existentialism, evolution, euthyphro, compassion, christianity, capitalism, camus, bible, anti, virus, tag, youtube, yola, adapter, website, vocabulary, dsl, television, telephone, soul, slang, shorts, story, sexual, orientation, scribus, scams, romance, reminders, 166, recipe, pynchon, pwp, purchases, poets, 119, photoshop, photography, pants, labrets, networking, netflix, mathematics, mandarin, limb, mp3, journalism, jobs, investment, indies, identity, theft, humor, guns, grammar, wave, firewalls, 384, etymology, entertainment, economics, ecology, mail, dreams, cpap, costco, comedy, clothing, census, catholic, bush, bollywood, biology, belts, bands, ayn, rand, anthropology, categories, racebrook, orange, 6th, junior, senior, john, college, corp, trinity, monastery, transfiguration, university, haven, almy, dept, northeastern, wallpaper, market, forge, aluminum, stone, webster, revisited, guttman, institute, elderplan, porter, diamond, factory, outlets, karebac, lot, chit, biography, handbook, golden, rules, administrative, assistantance, 937, reads, posterous, profile, halloween, pics, feb, august, 2026, calendar, tweets, readgreatbooks, reilly, reality, getting, techie, types, pulling, teeth, series, moron, btw, ebook, 1979, 1980s, cobol, rpg, background, interested, buying, tomorrow, publisher, leads, cookie, sessions, germain, starts, hint, move, somewhere, specific, url, correspond, launching, entier, rather, inside, telling, asking, basically, loads, bunch, explicit, configs, brain, wont, mess, locally, honkey, dory, wnat, guys, suggested, owning, doesnt, admin, creat, own, whatever, nothing, changing, hints, truly, lost, though, sounds, fussing, talking, along, except, seems, honor, proj2, suppose, tutorials, shouldn, likely, ifconfig, mentions, indicate, reach, clues, ipconfig, internal, set, websites, illustrate, technically, savvy, thought, complex, separate, unnecessary, leaves, important, front, soon, dawned, copied, pressed, bingo, sql, tell, recognize, concepts, showed, inserted, somehow, testwww, grief, rapid, pay, paperback, bathroom, subway, reason, sick, tired, years, bondage, micr0, oft, products, worse, dropped, supported, product, figure, choice, whats, tons, documentation, patient, valuable, guidance, follows, text, sorted, achieve, goals, remains, mind, unchanges, honoring, defeat, purpose, transparently, moving, location, 1st, typing, given, myself, withing, note, convenience, 2nd, steele, opened, dean, tick, tock, turner, miracle, males, genre, mostly, women, audience, happen, tally, frequency, counts, encode, representing, abstract, fear, envy, rage, jealousy, lust, sadness, death, pattern, emerge, programmatic, popular, speed, elegance, reasonably, priced, experimenting, installs, top, pure, 280, gateway, amazing, multi, platform, instant, icq, msn, konverse, lands, kubuntu, dozens, specialty, rooms, around, yet, smoother, annoying, spare, ruin, felt, succeed, installing, primitive, unfriendly, friendly, lots, interfaces, wizard, bash, commands, don, office, processor, presentation, manager, cinderella, superwoman, described, side, anywhere, memory, stick, off, methods, restore, lets, 1066, battle, hastings, caesar, veni, vidi, viki, gettysburg, lords, prime, stronger, capitalizing, third, rotate, lord, taking, merging, born, storing, wikipedia, wiki, linux_adoption, thinking, points, missed, ever, institutions, adoption, fulfill, developers, international, laptop, olpc, bothering, said, development, means, built, together, catb, esr, writings, money, offering, flexibility, eric, raymond, everybody, circumstances, difficulties, knowledge, richard, stallman, president, definition, call, ourself, advocate, role, today, clearly, importance, everyone, giri, writes, mozilla, switch, avoid, searching, fix, arguments, acted, normally, ran, simultaneously, detected, launched, things, cookies, holding, mode, updated, board, scanner, smoothly, suddenly, morning, bookmarks, prompted, april, kids, fordham, databases, across, country, ignore, nation, warehouse, pregnancies, track, mental, illness, jail, sentences, part, appreciate, rfid, chips, advocatesforchildren, guarantees, article, queensbury, glens, falls, immigration, queries, regard, illegal, immigrants, denied, educations, plot, thickens, enforcement, judicial, authorities, cases, appropriate, emergencies, nurses, fire, marshals, court, orders, efforts, notify, parent, releasing, financial, aid, accrediting, research, organizations, helping, guarantee, confidentiality, whom, statute, national, agencies, enforcing, intends, transfer, challenge, teachers, legitimate, defined, procedures, prohibit, disclosing, written, consent, exceptions, greatschools, family, individuals, disabilities, establish, minimum, requirements, meet, maintaining, protecting, providing, students, individualized, iep, correspondence, personnel, aspe, hhs, datacncl, 1973privacy, tocprefacemembers, practice, relating, issuance, measures, redress, committee, analyze, recommendations, growing, concern, potential, infringement, liberties, led, belief, special, developed, due, huntonprivacyblog, attorney, andrew, cuomo, announced, 100, settlement, echometrix, developer, parental, monitors, alleged, complaint, trade, commission, ecometrix, deceptive, nejm, doi, pdf, 1056, nejmp0801736, poised, transformation, catalyzed, dossia, nonprofit, consortium, major, employers, healthvault, web, seeking, expanded, roles, trillion, england, journal, wps, portal, bocesofnys, virtualization, hosting, aware, involved, handing, custody, vendor, agency, boards, cooperative, big, grs, approved, compliant, formal, concerning, maintained, director, 9a47, cultural, albany, 12230, further, according, 8nycrr, regulations, commissioner, section, 188, 11c, copies, offsite, ideally, primary, accessibility, regional, disaster, nysed, mr_data_storage, shtml, communication, 355, harlem, west, seneca, 14224, suggestion, 4000, hopefully, entry, fashion, period, months, limited, megs, allows, room, thing, datetime, giving, settings, specify, zone, case, gmt, accounts, wbuell, join, login, collaborator, feature, format, true, false, goto, module, insert, choose, drop, box, sheet1, putting, monitor, checks, ends, wasn, otherwise, fancy, totally, automate, attaching, select, window, explanation, allexperts, 1059, modified, offers, compatibility, collaborators, space, presentations, programs, price, easily, collaborate, wysiwyg, discontinued, rocket, scientist, known, wamp, stands, oddly, recursive, resulting, revolutionary, protest, assumed, gentle, night, aging, father, himself, him, stop, poor, dylan, thomas, quarts, whiskey, stage, alcoholics, henry, alan, watts, max, quart, poemhunter, barbara, sea, runs, waters, heart, push, tide, beginning, experiences, gathered, provide, advantageous, undertake, disposal, engineers, pilot, substantiated, hacking, central, involving, minors, charter, standardized, wise, practical, needs, amateur, employee, knows, nor, 3rd, party, feel, pasted, lists, common, dates, confuse, sensitive, attached, regular, bugs, ironed, scene, conclusion, utilize, shared, either, artificial, cut, production, unstable, save, reopen, action, recent, included, vlookup, loose, corrupt, increasing, cutting, sections, 2003, grow, beyond, 15000, instabilities, editgrid, seemed, handle, impossible, future, uncertain, rumors, engines, promising, edit, privilege, computers, collaboration, meaningless, sake, profit, hire, fairly, thousands, manual, compare, lookup, lookups, pieces, borough, forumla, dividing, dob, 365, sequential, generated, previous, fictitious, recreate, formulae, loss, prompt, response, dear, recently, upgrade, benchmarking, counterparts, features, coming, users, stay, tuned, faced, details, dot, moderator, oct, regards, ramesh, india, 0530, hrs, phone, elaborate, fixed, immediately, after, prevent, occurring, stability, dan, idano, net, spreedsheets, verses, mention, 2006, during, initial, stages, refer, urls, ssl, wire, topic, username, explicitly, practices, seriously, completely, dependent, trust, factor, none, admins, infrastructure, replicates, reliability, availability, backups, compressed, encountered, reproduce, downloading, itself, button, toolbar, 10mb, apart, 65536, 256, hold, matrix, typo, zohoproblemlastline, xls, gap, sum, delete, empty, 10006, 10009, referred, earlier, deleted, openoffice, rest, cascaded, corrected, expected, seen, tested, worked, done, scenarios, observations, replied, team, speedy, reply, archive, seek, position, 30k, working, shift, unpaid, hour, commute,
Text of the page (random words):
s blog william buell s blog i seek any position 30k yr working any day of week any shift unpaid o t no problem within 1 hour s commute of south st seaport nyc archive for the programming category older entries speedy support reply from zoho october 11 2010 i am posting this to thank the team at http zoho com zoho cloud spreadsheet support replied as follow thank you for your detailed feedback we tried the scenarios that you mentioned in your email below are our observations we can also have a desktop sharing session using zoho assist to help us understand the issues better 1 copy paste large no of rows we had already tested zoho sheet with 10000 rows and 10 columns of data and this has worked fine we have also tried copy paste of all the 10 000 rows of the file sent by you the copy paste what we have tried was done on the same sheet we did not face any issue here let us know if you have tried to copy data from external applications and paste it in zoho sheet 2 formula corruption and error we noticed the formula error only in the following scenario and that too this is the expected behavior which can be seen in ms excel as well i am not sure if this is what you tried a import the file zohoproblemlastline xls b go to the last and copy the last 5 rows c give some 5 rows gap and paste it to the say a10010 cell the cell a10010 will have the formula as sum a10009 1 d now delete the in between empty rows from 10006 to 10009 e the cell a10006 now has the ref error as the cell referred by formula in this cell was a10009 earlier and it has been deleted now this is same behavior as in ms excel or openoffice f correct the formula in cell a10006 and rest of ref error cascaded will automatically be corrected if you have any other scenario other than above please let us know 3 zoho sheet size limit zoho sheet supports upto 10mb of file import upload apart this we support 65536 rows and 256 columns per sheet and a document can hold upto 1 million of cells rows and column matrix having data you had mentioned about a 50 mb file i believe it is a typo as zoho sheet supports files only upto 10 mb the 10 000 row excel file that you sent was actually a 5 mb file 4 export download has last rows of data missing we have not encountered any problem here we would like to know how we can reproduce this are you downloading from zoho docs that should work fine however can you try doing an export from the spreadsheet editor itself the export button is available on the spreadsheet editor s toolbar 5 regarding privacy and security of zoho we take security very seriously as our business of completely dependent on trust factor none of our admins have access to any content that is uploaded to our services our infrastructure automatically replicates the data for more reliability availability the backups are also automated where the data is compressed and password protected learn more at https blogs zoho com general security practices the files in your account are protected by your username and password your files are private in nature unless you explicitly make them public or share with others you might also want to look at this forum post on how sharing works in zoho sheet https forums zoho com topic can a public spreadsheet be password protected 3f you can access our services over ssl so that the data is encrypted and sent over the wire however i should mention that we did face an issue in 2006 during the initial stages of zoho sheet refer the below urls to learn more about the issue http dan idano net google spreedsheets verses zoho sheet 23 htm https blogs zoho com general some stability issues with zohosheet we fixed this issue immediately there after and we have made sufficient changes to prevent such an issue from occurring we are very particular about the security and privacy of user data 6 problems with embedding links and having them correctly parsed can you elaborate on the above issue regarding the issues you noticed can we have a desktop sharing session using zoho assist to help us understand the issues better we are based in india 0530 hrs let us know a time which would work for both of us also let us know your phone number so that we can talk while we look at your desktop regards ramesh my original email to zoho support i am writing at the request of by hyther moderator on 07 oct can you let us know what kind of instability you faced in zoho sheet you can email the details to support at zohosheet dot com for your information recently we did an upgrade to support large spreadsheets and our performance benchmarking says that our performance is far better than our online counterparts we have more features coming for serious business users stay tuned https blogs zoho com general zoho sheet 2 0 supports million cell spreadsheets additional browsers more hyther dear hyther thanks so much for your prompt response in the forum the best way for you to experiment an recreate the error instability is to simply attempt to copy and paste large numbers of rows to the bottom of the sheet as an easy way to increase test file size but then see if there is any corruption of formulae or loss of information the second problem was that when i downloaded to desktop the last row or two was missing i created a sheet of over 50 meg in size and over 10 000 rows as a test these names are all fictitious so anyone may have access to this sheet for test purposes the first cell is simply an sequential id number generated by adding 1 to the previous id the next columns are last name first name middle name date of birth age which is a forumla dividing now dob by 365 next comes a zip code the second sheet of the book is a zip code lookup for new york which lookups up 3 pieces of information including state which is all ny and borough i created this random meaningless test data for the sake of a small not for profit organization which may hire me to deal with the school records of children i am fairly certain that they will want me to sort through thousands of archival manual folders and compare to what is in their desktop spreadsheet and perhaps design a better spreadsheet i began this test in google documents spreadsheets and found that 2000 rows reached their size limit of 1 meg i did find that i could share the document with edit privilege on line with others i have several computers in my home so i could test the collaboration ability i next found a free application called editgrid which seemed to handle much larger than 1 gig files but it is impossible to contact anyone at their company and their future is quite uncertain based upon rumors in the search engines next i began to experiment with zoho which looks very promising regarding instabilities noticed my technique for increasing the file row size was simply to keep cutting and pasting large sections so as to add rows to the bottom whenever i did such copy paste in ms excel on the desktop an old 2003 version there was never any problem and i could then upload to zoho until i reached the 50 meg limit once i reached the upload limit i became curious to see if i could grow a sheet from within zoho beyond the 10000 15000 row 50 meg limit whenever i attempted to copy and paste large numbers of rows to the bottom of the spreadsheet which of course included the age formula and the zip vlookup i noticed that often i would loose formulas or they would be corrupted sometimes it was not every row that was corrupt but only certain rows i decided that perhaps since there was a problem with pasting in the zoho sheet that perhaps i should simply try to manually data enter additional rows since the pasting activity is really an artificial short cut to quickly increase file size but in daily production use the normal scenario would be to manually type each address one by one when i added a few rows like this and then downloaded the sheet back to my desktop i often noticed that the last row or two was missing or unstable i even made certain to save the document in zoho first and close it and then reopen it so that the download would be sure to take action upon the most recent saved version of the sheet i am certain that you are making regular progress with all your zoho apps so i imagine that in a year or two some of these minor bugs will be ironed out based upon the minor problems i have scene so far i have come to the conclusion that i would only be able to utilize online shared spreadsheets either in google or zoho as places to upload from a local drive so that people in the field could look up and access information and perhaps people in the field could add data in small sheets which would then be uploaded into a desktop database i have attached one of the test sheets do feel free to use the test data in any way you like since they are not real people i pasted lists of common last names and first names found on google to create the names i made most of the dates of birth for people over age 50 so that no one would confuse the data with that of children since in america the laws are sensitive regarding the privacy of children s data information regarding privacy and security of zoho i am curious to know if there have been any substantiated reports of hacking or files being compromised i realize that privacy and security will become a central issue for anything involving the school records of minors but i also realize that in america there are many public and charter schools which really need a cloud computing ability so that all schools would use the same standardized software and function under the same security and privacy protections that is to say it is not wise or practical for each and every school to farm out their application needs to some amateur employee who knows some excel or access nor to farm it out to some 3rd party consulting group perhaps this need in american schools might provide an advantageous project for the zoho company to undertake i am certain that the technology at the disposal of zoho engineers would make it easy for zoho to develop a pilot project for this application here is the link to my blog post where i have gathered some information about the student record problems in american schools https williambuell wordpress com 2010 09 30 electronic storage of student records click here for the above link i am new to zoho docs and i did notice some problems with embedding links and having them correctly parsed i am also beginning to blog about my zoho experiences at my wordpress posted in programming zoho leave a comment poetry and open source october 7 2010 barbara thanks light breaks where no sun shines where no sea runs the waters of the heart push in their tide http www poemhunter com poem light breaks where no sun shines poor dylan thomas was drinking two quarts of whiskey per day at the end most end stage alcoholics such as o henry and alan watts max out at one quart when i was in high school i assumed that do not go gentle into that good night was about his aging father but no it was about himself as the doctors told him if he did not stop drinking he would die he did die at age 36 regarding zoho i think that all programs and data should be available on the cloud internet in open source not proprietary and at a reasonable price people should be able to easily share and collaborate on documents spreadsheets there should be a wysiwyg what you see is what you get database generator similar to microsoft access or visual foxpro now discontinued one should not have to be a rocket scientist in apache mysql php known as wamp in windows and lamp in gnu linux ubuntu oh and gnu stands for gnu is not unix which is oddly recursive unix started out as open source but then became proprietary so linux was the resulting revolutionary protest posted in facebook programming leave a comment zoho cloud computing october 5 2010 i went to http zoho com and signed up for a free personal account which gives me a gig of space and zoho desktop applications for spreadsheets documents presentations etc my particular interest is spreadsheets and the ability to share them on line with other collaborators zoho offers a great deal of compatibility with microsoft s vba visual basic for applications i decided that i would like some vba code which will automatically date time stamp each row as it is modified i searched in google until i found the following tutorial link http en allexperts com q excel 1059 automated time stamp htm here is the code and explanation that i needed if you want to get fancy you can totally automate the process by attaching a macro to the worksheet right click on the sheet tab and select view code then paste the following macro in the window private sub worksheet_change byval target as range if target column 1 then exit sub target offset 6 time end sub what is does is monitor for any changes you make to the worksheet with every change the macro is run it checks to see if the change was made in column a target column 1 and ends if if it wasn t otherwise it places the time stamp in column f of that row target offset 6 you could also have it automatically enter the date in column e for you too by adding this line target offset 5 date or putting a date time stamp in column e target offset 5 now so all i had to do on my zoho spreadsheet was to right click on the tab of sheet1 and then click on view code i choose the event change from the drop down box and find that some code is already present so i simply insert the above code in the proper place so that i have rem sheet module private sub worksheet_change byval target as range application enableevents false on error goto enev rem add your code below if target column 1 then exit sub target offset 6 now enev application enableevents true end sub end of code of course i need to format the cells for date time i wanted to test the share with collaborator feature i created a group called wbuell then i sent an invite to a different email address that i sometimes use when i logged into my other email account i saw the zoho invite which requires me to join zoho with a login id and password i am able to share the same spreadsheet between my two accounts one interesting thing i noticed is that the datetime stamp code above was giving me a different time when logged into my other account it is necessary to go into the account settings and specify the correct time zone in my case gmt 5 new york i notice that an upload to zoho of any excel spreadsheet from my local hard drive is limited to 50 megs which is a size that allow me to create 10 000 address records in my test spreadsheet it may be possible from within zoho to create spreadsheets much larger than 50 meg i know that google documents spreadsheets can not be larger than 1 meg which allows me room for about 2000 address records in my test application i did notice some instability in zoho when i attempted to use copy and paste to increase my spreadsheet from 4000 records to 10 000 records in the sense that some ce...
|
