l i n u x - u s e r s - g r o u p - o f - d a v i s
L U G O D
 
Next Meeting:
December 2: Social gathering
Next Installfest:
TBD
Latest News:
Nov. 18: Club officer elections
Page last updated:
2008 Jan 16 16:34

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] collaborative data storage (of excel files)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox-tech] collaborative data storage (of excel files)



On Tuesday 15 January 2008 09:57:57 pm Jeff Newmiller wrote:
> Dylan Beaudette wrote:
> > On Tuesday 15 January 2008, Henry House wrote:
> >> On 2008-01-15, wrote Dylan Beaudette:
> >> [...]
> >>
> >>> YES - this is how I would approach this problem if I were in a position
> >>> to babysit their data. I have put together several LAPP
> >>> (linux-apache-postgres-php) projects- but only for things I was
> >>> directly working on. I was searching for some kind of compromise
> >>> between doing it correctly (i.e. a database) and doing it less
> >>> incorrectly via SVN or the like.
> >>
> >> Well the good thing about using SVN is that at least no data will be
> >> lost once it is committed. So even if person A overwrites person B's
> >> work, the data can be recovered (albeit with manual intervention). And
> >> if this happens it just might demonstrate the need for a proper
> >> RDBMS-base solution to those in charge.
> >
> > Yeah... It looks like they will be resorting to their old system of
> > personal communication mitigated data disaster prevention (PCMDDP)....
> > When it crashes and burns I think that I will have them go with an SVN +
> > CSV file setup.
> >
> > Thanks for all of the great ideas!
> >
> > Dylan
>
> I highly recommend using a real database with ODBC client access.
> Microsoft Access is quite easy for Microsofties to get used to,
> and has already been mentioned can serve as a front-end for connecting
> to the shared data. OpenOffice can also present a tabular user interface
> with no programming.  No programming means practically no maintenance on
> your part.  They can use a query builder to get subsets of
> the data, copy it into Excel, and analyze it to their hearts
> content.  Another advantage of this is that it is easy to copy/paste
> large blocks of data around (including appending their data to the table)
> which is not so easy with a web interface.

Jeff,

Sounds like a great idea. Want to implement it as a donation? I am working 
with others who do not have the training or time to be interested in such 
things. I advocated something like this last year, but they went with 
the 'email a spreadsheet around' approach. 

When they asked me to host the file on a machine I manage for the lab I got 
roped into looking out for their data. I will keep all of the suggestions 
around for when their approach leaves them in a world of data pain.

Thanks again,

Dylan
_______________________________________________
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech



LinkedIn
LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
facebook
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
Sunset Systems
Who graciously hosts our website & mailing lists!