| Type: | Package |
| Title: | Convert 'ODK' or 'XLSForm' to 'SPSS' Data Frame |
| Version: | 1.5 |
| Date: | 2017-11-28 |
| Author: | Muntashir-Al-Arefin |
| Maintainer: | Muntashir-Al-Arefin <muntashir.a2i@gmail.com> |
| Description: | After develop a 'ODK' https://opendatakit.org/ frame, we can link the frame to 'Google Sheets' https://www.google.com/sheets/about/ and collect data through 'Android' https://www.android.com/. This data uploaded to a 'Google sheets'. odk2spss() function help to convert the 'odk' frame into 'SPSS' https://www.ibm.com/analytics/us/en/technology/spss/ frame. Also able to add downloaded 'Google sheets' data or read data from 'Google sheets' by using 'ODK' frame 'submission_url'. |
| License: | GPL-3 |
| Depends: | R (≥ 3.4.1) |
| Imports: | gsheet, openxlsx, utils |
| NeedsCompilation: | no |
| Packaged: | 2017-11-27 12:17:03 UTC; munta |
| Repository: | CRAN |
| Date/Publication: | 2017-11-27 14:07:28 UTC |
'Google Sheets' Data for 'odk.frame'
Description
After develop a 'ODK' frame, we can link the frame to 'Google Sheets' and collect data through 'Android'. This data uploaded to a 'Google sheets'. The gs.data is a 'Google sheets' data collected though odk.frame file.
Both odk.frame and gs.data are in 'xlsx' format. To develop your own 'ODK' frame visit https://build.opendatakit.org/
Usage
data("gs.data")Examples
library(odk)
data(gs.data)
data(odk.frame)
### For convert 'odk.frame' to 'SPSS' frame and input Corresponding 'Google Sheets' data
odk2spss(xlsx=odk.frame, pc.data=gs.data, out.path="spss.sps")
'Google Sheets' or 'XLSForm' Dummy 'ODK' Frame
Description
After develop a 'ODK' frame, we can link the frame to 'Google Sheets' and collect data through 'Android'. This data uploaded to a 'Google sheets'.The odk.frame is a 'ODK' data frame. The gs.data is a 'Google sheets' data collected though odk.frame file.
Both odk.frame and gs.data are in 'xlsx' format. To develop your own 'ODK' frame visit https://build.opendatakit.org/
Usage
data("odk.frame")Examples
library(odk)
data(odk.frame)
data(gs.data)
### For convert 'odk.frame' to 'SPSS' frame and input Corresponding 'Google Sheets' data
odk2spss(xlsx=odk.frame, pc.data=gs.data, out.path="spss.sps")
Convert 'ODK' or 'XLSForm' to 'SPSS' Data Frame
Description
After develop a 'ODK' frame, we can link the frame to 'Google Sheets' and collect data through 'Android'. This data uploaded to a 'Google sheets'. odk2spss() function help to convert the 'ODK' frame into 'SPSS' frame. Also able to add downloaded 'Google sheets' data by using pc.data or read data from 'Google sheets' by using 'ODK' frame 'submission_url'.
Usage
odk2spss(xlsx, pb.url=NULL, pc.data = NULL, out.path = NULL)
Arguments
xlsx |
path of 'ODK' or XLSForm questionniare frame in 'xlsx' format. |
pb.url |
Published link of 'Google Sheets' for data, if |
pc.data |
path of data file in 'xlsx' format, if |
out.path |
path of output file with file name (ex: path/output_file.sps).if |
Value
odk2spss() create a '*.sps' file.
Open '*.sps' file by 'SPSS' softwere and Run.
Then we will get 'SPSS' data frame with data.
Note
odk2spss() worked nicely for taxt, single choice, multiple choice and numeric variable. Also work on other type variables.
Do not use ",",".","-" and "_" separator in variable name.
Do not use group variable in 'ODK' frame.
Always keep a non-empty variable as your last variable in 'ODK' frame.
Author(s)
Muntashir-Al-Arefin muntashir.a2i@gmail.com
Examples
library(odk)
data(odk.frame)
data(gs.data)
##--Convert 'odk.frame' to 'SPSS' data frame and input gs.data data set.
odk2spss(xlsx=odk.frame, pc.data=gs.data, out.path="spss.sps")
##### Internet connection needed if pc.data = NULL