I have been inputting my data into text files using a text editor on a Windows 2000 PC. I would like to create a front end form that does validation on the fly to reduce the errors in my input and make it possible for family members that are not into computers to help me out with data input tasks. I assume that my form program would translate the input into a text file which I would then read in the normal way into R. Does anyone have any suggestions of some software that makes it easy to set this up. I was hoping not to have to put a major time commitment into learning it nor to create the form so something with a fast learning curve and not too much required expertise is preferred. Free software is preferred, cheap software is second best but any suggestions are welcome. -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
You might consider the use of a spreadsheet (e.g, Excel?) - if your data isn't too complex, import in R should be easy. AFAIK you can easily define input forms in Excel for validation purposes in a `family compliant' way... g., -d ggrothendieck at yifan.net wrote:> > I have been inputting my data into text files using a text > editor on a Windows 2000 PC. > > I would like to create a front end form that does validation > on the fly to reduce the errors in my input and make it > possible for family members that are not into computers > to help me out with data input tasks. > > I assume that my form program would translate the > input into a text file which I would then read in the > normal way into R. > > Does anyone have any suggestions of some software that > makes it easy to set this up. I was hoping not to have to put > a major time commitment into learning it nor to create the form > so something with a fast learning curve and not too much > required expertise is preferred. > > Free software is preferred, cheap software is second best > but any suggestions are welcome. > > -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- > r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html > Send "info", "help", or "[un]subscribe" > (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch > _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._-- Mag. David Meyer Wiedner Hauptstrasse 8-10 Vienna University of Technology A-1040 Vienna/AUSTRIA Department of Tel.: (+431) 58801/10772 Statistics and Probability Theory mail: david.meyer at ci.tuwien.ac.at -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
The "cadillac" version would be to use something like Perl/Tk or the
tcl/tk extensions to R to write an input mechanism.
If you were using linux, pgaccess or a web-based solution would make
sense, but neither will be simple under windows.
If you already own Access, that would be an option, but it's decidedly
non-free.
A spreadsheet is probably the best price-performance compromise.
ap
----------------------------------------------------------------------
Andrew J Perrin - andrew_perrin at unc.edu - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
269 Hamilton Hall, CB#3210, Chapel Hill, NC 27599-3210 USA
On Thu, 2 May 2002 ggrothendieck at yifan.net wrote:
>
> I have been inputting my data into text files using a text
> editor on a Windows 2000 PC.
>
> I would like to create a front end form that does validation
> on the fly to reduce the errors in my input and make it
> possible for family members that are not into computers
> to help me out with data input tasks.
>
> I assume that my form program would translate the
> input into a text file which I would then read in the
> normal way into R.
>
> Does anyone have any suggestions of some software that
> makes it easy to set this up. I was hoping not to have to put
> a major time commitment into learning it nor to create the form
> so something with a fast learning curve and not too much
> required expertise is preferred.
>
> Free software is preferred, cheap software is second best
> but any suggestions are welcome.
>
>
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
> r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
> Send "info", "help", or "[un]subscribe"
> (in the "body", not the subject !) To: r-help-request at
stat.math.ethz.ch
>
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
>
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at
stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
For Win32 systems you might like to look at EpiData:
http://www.epidata.dk
which is freeware but not GPL. A tutorial is available from my website:
http://www.myatt.demon.co.uk
At present it exports to Excel, dBase, Stata, SPSS, and text files ...
not too difficult to import the text file into R.
I hope that helps,
Mark
DISCLAIMER - I like EpiData and use it for all my data-entry tasks but I
did have a hand in designing the thing so I would.
ggrothendieck at yifan.net writes:>
>I have been inputting my data into text files using a text
>editor on a Windows 2000 PC.
>
>I would like to create a front end form that does validation
>on the fly to reduce the errors in my input and make it
>possible for family members that are not into computers
>to help me out with data input tasks.
>
>I assume that my form program would translate the
>input into a text file which I would then read in the
>normal way into R.
>
>Does anyone have any suggestions of some software that
>makes it easy to set this up. I was hoping not to have to put
>a major time commitment into learning it nor to create the form
>so something with a fast learning curve and not too much
>required expertise is preferred.
>
>Free software is preferred, cheap software is second best
>but any suggestions are welcome.
>
>-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
>r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
>Send "info", "help", or "[un]subscribe"
>(in the "body", not the subject !) To: r-help-request at
stat.math.ethz.ch
>_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
--
Mark Myatt
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at
stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
ggrothendieck at yifan.net Writes:>I have some additional thoughts. I have been playing with >tcl/tk recently and also noticed that R supports tk via the >tcltk library. > >I wonder if it would make sense to integrate EpiData with >tcl/tk? If EpiData could generate tcl/tk and/or R/tk output this >would give integration with popular GUIs: MS-Windows and >X-Windows and be of interest to the large base of tcl/tk and/or R >users. It alternately might be possible to develop a widget based >on the EpiData user interface that could be of interest to >tcl/tk and R/tk users. Since tcl/tk programs and R/tk programs >are just text files this is consistent with the text processing nature >of EpiData.I have suggested that EpiData adopt tcl/tk (or python/tk) as a scripting language and these things are being considered. If you have nay ideas on how EpiData might be improved or made more useful then please put them through the 'official' channels on the EpiData website: http://www.epidata.dk Best wishes, Mark -- Mark Myatt -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._