| Title: | Convert 'ODK' or 'XLSForm' to 'SPSS' Data Frame |
|---|---|
| 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'. |
| Authors: | Muntashir-Al-Arefin |
| Maintainer: | Muntashir-Al-Arefin <[email protected]> |
| License: | GPL-3 |
| Version: | 1.5 |
| Built: | 2024-10-12 04:55:28 UTC |
| Source: | https://github.com/cran/odk |
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/
data("gs.data")data("gs.data")
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")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")
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/
data("odk.frame")data("odk.frame")
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")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")
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'.
odk2spss(xlsx, pb.url=NULL, pc.data = NULL, out.path = NULL)odk2spss(xlsx, pb.url=NULL, pc.data = NULL, out.path = NULL)
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 |
odk2spss() create a '*.sps' file.
Open '*.sps' file by 'SPSS' softwere and Run.
Then we will get 'SPSS' data frame with data.
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.
Muntashir-Al-Arefin [email protected]
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 = NULLlibrary(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