The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.

A simple connection between FormShare and R for advanced analytics.

Description

FormShare is an advanced data management platform for Open Data Kit (ODK) . This R Package provides a simple connection object between FormShare and R for advanced analytics.

Requirements

Details

This class encapsulates all functions to execute analytics in FormShare directly from R.

Public fields

user_id

The user ID in FormShare.

api_key

The API key used to connect to FormShare.

api_secret

The API secret used to connect to FormShare

server_url

The FormShare server to connect to

logged_in

Whether the used has a valid connection

api_token

Token to use in other functions

token_url

FormShare URL to retrieve a valid token

Methods

Public methods


Method new

Create a new FormShare object.

Usage
my_connection = FormShare$new(
  server_url = "https://formshare.org",
  user_id = "your_user",
  api_key = "your_api_key",
  api_secret = "your_api_secret"
)
Arguments

server_url

Server URL. By default https://formshare.org

user_id

The user ID to use

api_key

The API Key to use.

api_secret

The API Secret to use.

Returns

A connection object to FormShare.


Method get_api_key

Get the current API key.

Usage
current_api_key = my_connection$get_api_key()

Method set_api_key

Sets the current API key.

Usage
my_connection$set_api_key("new_api_key")
Arguments

new_key

New API key


Method get_api_secret

Get the current API secret

Usage
current_api_secret = my_connection$get_api_secret()

Method set_api_secret

Sets the current API secret.

Usage
my_connection$set_api_secret("new_api_secret")
Arguments

new_secret

New API secret


Method get_server_url

Get the current server URL

Usage
current_url = my_connection$get_server_url()

Method set_server_url

Sets the current server URL.

Usage
my_connection$set_server_url("new_url")
Arguments

new_url

New server URL


Method login

Log-in to the FormShare server and stores a API token

Usage
my_connection$login()
Returns

True of False if the connection was successful.


Method get_repositories

Return the repositories that the user has access to.

Usage
my_repositories = my_connection$get_repositories()
Returns

A data frame with repositories that the user has access to.


Method get_tables

Get the tables in a repository.

Usage
my_tables = my_connection$get_tables("repository_id")
Arguments

repository

The repository to use

Returns

A data frame with tables inside a repository.


Method get_fields

Get the fields in a table of a repository.

Usage
my_fields = my_connection$get_fields("repository_id", "table_name")
Arguments

repository

The repository ID to use

table

The table to use

Returns

A data frame with fields inside a table.


Method execute

Executes an SQL and returns it result.

Usage
data = my_connection$execute("repository_id", "SELECT * FROM maintable")
Arguments

repository

The repository to use

sql

SQL to execute

Returns

A data frame with the result of the execution. Return TRUE if the result is empty or if the execution does not return any data. For example when executing a “CREATE VIEW”


Method get_table

A convenient function to return the contents of a table.

Usage
data = my_connection$get_table("repository_id", "maintable")
Arguments

repository

The repository to use

table

Table to retrieve

Returns

A data frame with data of the table


Method clone

The objects of this class are cloneable with this method.

Usage
clone = my_connection$clone(deep = FALSE)
Arguments

deep

Whether to make a deep clone.

License

GPL V 3.0

Author

Carlos Quiros

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.