knitr::opts_chunk$set(echo = TRUE) knitr::opts_chunk$set(message = FALSE) # knitr::opts_chunk$set(results = 'hide')
'upwaver' is a wrapper around the 'Upwave' API that allows users to access the 'Upwave' API from within R.
While using 'Upwave' (https://www.upwave.io/) you might come to a point where you want to extract detailed information of ongoing projects or you might want to upload Cards to certain Boards directly out of a Excel sheet. 'upwaver' is a small tool to solve such problems without copy-pasting a lot of content.
The package was designed based on the given 'Upwave' API (https://upwavehq.github.io/api/).
Each organisation (company, team) with an 'Upwave' account has its own <TEAM_DOMAIN>
.
You can see this on the frontpage of your 'Upwave' account: (https://<TEAM_DOMAIN>.upwave.io
).
The 'upwaver' package refers to this <TEAM_DOMAIN>
as organisation
.
To access information of your account (domain), you need an access token. It can be obtained
by visiting your account settings. Click your profile image, select “Settings” and find your
API-Key in the “Account” tab. The 'upwaver' package refers to the API-Key as token
.
An 'Upwave' account consits of different Boards (projects) on which an organisation works
simultaneously. The 'upwaver' package identifies a Board with the board_id
and board_name
.
board_name
: it's the casual name (title) you give to a Board board_id
: That's the unique ID you see in the browser-link when watching your Board (i.e:
https://<TEAM_DOMAIN>.upwave.io/board/board_id/view/...
)Each Board consits of different Cards which can be seen as lots of "work packages". The contain Information about the actual tasts to do inside the project. They are the objects to talk to when using 'upwaver'
The 'upwaver' package gives three basic functionalities to directly access 'Upwave' information.
Use list_boards()
to get a list of all boards of your organisation. Archived boards will
not be shown in this list.
my_board_list <- upwaver::list_boards("4597", "807a0c3451c04602b4dbfdc0338a65f7") my_board_list$count summary(my_board_list) summary(my_board_list$results[[1]])
Use board_details()
to get detailed background Information about a specific board.
my_board_details <- upwaver::board_details("4597", 14351, "807a0c3451c04602b4dbfdc0338a65f7") summary(my_board_details)
Use list_cards()
to get detailed Information about all Cards of a specific board. This
includes cards that are marked as completed.
my_card_list <- upwaver::list_cards("4597", 14351, "807a0c3451c04602b4dbfdc0338a65f7") my_card_list$count summary(my_card_list) summary(my_card_list$results[[1]])
An additional feature of upwaver is the storypoints_and_status()
function. It's was designed by our
institue for internal reasons. Nevertheless it might be useful for your organisation as well.
If working with agile methods (i.e. SCRUM, agile testing, ASD, ...) you might want to work with
storypoints in order to estimate time resources. Our institute works with storypoints in the
following way. Each 'Upwave' Card has a short text at the bottom the Card description that says:
"Aufwand: X SP" or "Aufwand: X AT" as an indicator for the estimated storypoints.
The value X
, title and status of every Card is be caught by storypoints_and_status()
and
given as a list.
my_storypoints <- upwaver::storypoints_and_status("4597", 14351, "807a0c3451c04602b4dbfdc0338a65f7") my_storypoints$storypoints_status my_storypoints$sum_storypoints
For own puposes we created a function that directly uploads Userstorys to the leftmost column of a desired Board from a local excel file. This might me helfpul when a list of basic tasks has been defined in an exel-sheet during a meeting or similar and you don't want to copy paste it all into 'Upwave'
The function needs several input parameters to coordinate the source (excel file) with the desired 'Upwave' Board. Keep in mind that the excel file needs the following three columns:
US-ID
: The Number you want to give to your Card (Userstory)name
: The name (title) of your Userstorydescription
: The description of your Userstory# create_card_from_excel( # excel_file = "path_to_your_excel_file", # sheet = "name_of_the_excel_sheet" or number_of_the_excel_sheet, # line_number = line_nr_you_want_to_upload, # organisation = "your_organisation", # board_id = your_board_id, # board_name = "your_board_name", # token = "your_token")
To upload several Cards, we recomment a simple for-loop
# for (i in 1:30) { # create_card_from_excel(..., line_number = i, ...) # }
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.