Looking for programmer for aggregate feature

Development
1

Hi everybody,

our research team is looking for a programmer that could add improved
export features to Aggregate. Mainly the feature to export value labels and
variable labels (prompt label from the xform) to statistical packages.

More details here:
http://code.google.com/p/opendatakit/issues/detail?id=495&start=100

If you're interested let me know.

Thanks,

Olivier Kalmus

Health Economics and Health Financing
Institute of Public Health
University of Heidelberg

2

Hey, if you are up for seeing this feature in http://formhub.org instead of on Aggregate, let us know.

The pre-requisite will be that the forms will have to come in as XLSform documents rather than xforms.

cheers,
--p

··· On Friday, February 24, 2012 8:52:36 AM UTC-5, Olivier Kalmus wrote: > Hi everybody, > > our research team is looking for a programmer that could add improved export features to Aggregate. Mainly the feature to export value labels and variable labels (prompt label from the xform) to statistical packages. > > > More details here: http://code.google.com/p/opendatakit/issues/detail?id=495&start=100 > > If you're interested let me know. > > > Thanks, > > Olivier Kalmus > > Health Economics and Health Financing > Institute of Public Health > University of Heidelberg

On Friday, February 24, 2012 8:52:36 AM UTC-5, Olivier Kalmus wrote:

Hi everybody,

our research team is looking for a programmer that could add improved export features to Aggregate. Mainly the feature to export value labels and variable labels (prompt label from the xform) to statistical packages.

More details here: http://code.google.com/p/opendatakit/issues/detail?id=495&start=100

If you're interested let me know.

Thanks,

Olivier Kalmus

Health Economics and Health Financing
Institute of Public Health
University of Heidelberg

On Friday, February 24, 2012 8:52:36 AM UTC-5, Olivier Kalmus wrote:

Hi everybody,

our research team is looking for a programmer that could add improved export features to Aggregate. Mainly the feature to export value labels and variable labels (prompt label from the xform) to statistical packages.

More details here: http://code.google.com/p/opendatakit/issues/detail?id=495&start=100

If you're interested let me know.

Thanks,

Olivier Kalmus

Health Economics and Health Financing
Institute of Public Health
University of Heidelberg

3

Hi,
I've been looking into the same thing, creating labels from an Xform. I see
that you are trying to come up with a Stata compliant label system. I use
SPSS, so that's what I have been looking into, using XSLT to transform the
Xform into a label file that can be imported into SPSS. In SPSS, a label
file is seperate from the data, it looks like this:

  • Here we define the label of the question b06.

VARIABLE LABELS b06 'water source'.

  • Then we define the various label for the values that b06 can take.

VALUE LABELS b06
1 'Dwelling (piped into the house)'
2 'Public tap'
3 'Protected well'
4 'Unprotected / Open dug well'
5 'River/stream/pond/lake/dam'
6 'Rainwater'
7 'Developed spring'
8 'Undeveloped spring'
9 'Bottled water/refilling'
88 'Other, specify __________________'.

*You can combine VARIABLE LABELING.

VARIABLE LABELS
b06 'primary water source'
b07 'secondary water source'
b08 'how far is the source'.

*each statement ends with a dot [.], and then EXECUTE.

EXECUTE .

The thing is, neither SPSS or Stata is used by everyone. Some use R, some
Access or even Excel. Have you had any success finding a more universal
file format for storing the variable and option labels?
I can't work on your project, but I would be interested in your solution.
Our work is open source, so whatever we come up with, we'll share.

☞§※☼:airplane::open_umbrella::slight_smile:
~Neil

··· On Fri, Feb 24, 2012 at 8:52 AM, Olivier Kalmus wrote:

Hi everybody,

our research team is looking for a programmer that could add improved
export features to Aggregate. Mainly the feature to export value labels and
variable labels (prompt label from the xform) to statistical packages.

More details here:
http://code.google.com/p/opendatakit/issues/detail?id=495&start=100

If you're interested let me know.

Thanks,

Olivier Kalmus

Health Economics and Health Financing
Institute of Public Health
University of Heidelberg

4

Sorry, hit reply too early.
We have a json representation of the form that has many of these things
exposed, so this should be fairly easy to do with formhub*. We are already
planning to add R support on formhub as well!

cheers,
--p

··· On Fri, Feb 24, 2012 at 3:03 PM, wrote:

Hey, if you are up for seeing this feature in http://formhub.org instead
of on Aggregate, let us know.

The pre-requisite will be that the forms will have to come in as XLSform
documents rather than xforms.

cheers,
--p

On Friday, February 24, 2012 8:52:36 AM UTC-5, Olivier Kalmus wrote:

Hi everybody,

our research team is looking for a programmer that could add improved
export features to Aggregate. Mainly the feature to export value labels and
variable labels (prompt label from the xform) to statistical packages.

More details here: http://code.google.com/p/
opendatakit/issues/detail?id=495&start=100

If you're interested let me know.

Thanks,

Olivier Kalmus

Health Economics and Health Financing
Institute of Public Health
University of Heidelberg

On Friday, February 24, 2012 8:52:36 AM UTC-5, Olivier Kalmus wrote:

Hi everybody,

our research team is looking for a programmer that could add improved
export features to Aggregate. Mainly the feature to export value labels and
variable labels (prompt label from the xform) to statistical packages.

More details here: http://code.google.com/p/
opendatakit/issues/detail?id=495&start=100

If you're interested let me know.

Thanks,

Olivier Kalmus

Health Economics and Health Financing
Institute of Public Health
University of Heidelberg

On Friday, February 24, 2012 8:52:36 AM UTC-5, Olivier Kalmus wrote:

Hi everybody,

our research team is looking for a programmer that could add improved
export features to Aggregate. Mainly the feature to export value labels and
variable labels (prompt label from the xform) to statistical packages.

More details here: http://code.google.com/p/
opendatakit/issues/detail?id=495&start=100

If you're interested let me know.

Thanks,

Olivier Kalmus

Health Economics and Health Financing
Institute of Public Health
University of Heidelberg

--
Prabhas Pokharel
http://twitter.com/prabhasp
Nepal mobile: +977 98137 91044
US mobile: +1 347 948 7654
skype/facebook/whatever: prabhasp

5

I would also encourage generating this type of information from an
XLS2XForms source document.

Note that once you generate these additional documents, you can upload them
to Aggregate as a media file associated with your form, ensuring that they
are tracked with the form definition (yes, they would then be copied down
to all phones, but having them uploaded as a media file ensures they are
tracked and maintained with the form).

If you need additional information in these documents, it would also be
easiest to add a new headers and value columns for this information to the
XLS file. XLS2XForms could then be changed to incorporate data from those
additional columns into these generated documents.

Mitch

··· On Fri, Feb 24, 2012 at 1:16 PM, Prabhas Pokharel < prabhas.pokharel@gmail.com> wrote:

Sorry, hit reply too early.
We have a json representation of the form that has many of these things
exposed, so this should be fairly easy to do with formhub*. We are already
planning to add R support on formhub as well!

cheers,
--p

On Fri, Feb 24, 2012 at 3:03 PM, prabhas.pokharel@gmail.com wrote:

Hey, if you are up for seeing this feature in http://formhub.org instead
of on Aggregate, let us know.

The pre-requisite will be that the forms will have to come in as XLSform
documents rather than xforms.

cheers,
--p

On Friday, February 24, 2012 8:52:36 AM UTC-5, Olivier Kalmus wrote:

Hi everybody,

our research team is looking for a programmer that could add improved
export features to Aggregate. Mainly the feature to export value labels and
variable labels (prompt label from the xform) to statistical packages.

More details here: http://code.google.com/p/
opendatakit/issues/detail?id=495&start=100

If you're interested let me know.

Thanks,

Olivier Kalmus

Health Economics and Health Financing
Institute of Public Health
University of Heidelberg

On Friday, February 24, 2012 8:52:36 AM UTC-5, Olivier Kalmus wrote:

Hi everybody,

our research team is looking for a programmer that could add improved
export features to Aggregate. Mainly the feature to export value labels and
variable labels (prompt label from the xform) to statistical packages.

More details here: http://code.google.com/p/
opendatakit/issues/detail?id=495&start=100

If you're interested let me know.

Thanks,

Olivier Kalmus

Health Economics and Health Financing
Institute of Public Health
University of Heidelberg

On Friday, February 24, 2012 8:52:36 AM UTC-5, Olivier Kalmus wrote:

Hi everybody,

our research team is looking for a programmer that could add improved
export features to Aggregate. Mainly the feature to export value labels and
variable labels (prompt label from the xform) to statistical packages.

More details here: http://code.google.com/p/
opendatakit/issues/detail?id=495&start=100

If you're interested let me know.

Thanks,

Olivier Kalmus

Health Economics and Health Financing
Institute of Public Health
University of Heidelberg

--
Prabhas Pokharel
http://twitter.com/prabhasp
Nepal mobile: +977 98137 91044
US mobile: +1 347 948 7654
skype/facebook/whatever: prabhasp

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com