Improved trial concept f.controlType() and added
“mixed”to f.sponsorType()
Expanded functionality of ctrGenerateQueries() for
CTGOV2 expert searches
Bug fix for subsetting data frames when calculating trial
concepts
Removed long deprecated parameters from
ctrLoadQueryIntoDb(), dbGetFieldsIntoDf()
Increased testing coverage to more than 94% of code lines
ctrdata 1.23.0
Improvements
Refactored for EUCTR protocol data ctrLoadQueryIntoDb()
for large speed gain
Improved downloading more documents from ISRCTN, however needs live
webpage read
Replaced curl with httr2 and further
refactored file retrieval
Reduced dependencies using equivalent alternative functions
Bug fixes
Cover multiple sponsors in EUCTR for
f.sponsorType()
Change priority of CTIS fields for f.sponsorType()
Added typing of newly appearing CTIS fields
ctrdata 1.22.3
Added dev version of nodbi to GitHub Action
Added typing to CTIS field for f.statusRecruitment
Improved f.likelyPlatfromTrial (mangling title
excerpts, add a missing default, sort ids in
.maybeRelatedTrials, added back associated trials, updated
similarity and user info)
Accelerated file operations that still used cat
ctrdata 1.22.2
Added typing for further CTGOV2 and CTIS fields
Adapt a test to modified terminal output in certain IDEs
Refactored dfMergeVariablesRelevel() and keep type if
rows include only a single value
Fixed counting trial sites outside the EEA for EUCTR
Fixed regression in dbFindIdsUniqueTrials()
Fixed typo in ctrGenerateQueries()
Updated documentation
ctrdata 1.22.1
Bug fix
Adapt testing after SQLite 3.48.0 (in RSQLite 2.3.10 since
2025-05-02) accepts now up to 1000 arguments
Fixed EUCTR conversion to NDJSON in Javascript for rare
specific trial(s), thanks @machado-t (#45)
Revised dbFindIdsUniqueTrials() to work with more than
80,000 records, thanks @machado-t (#48)
Internal
Modify internal function .dbMapIdsTrials() to use both
CTIS1 and CTIS2 field names, and defer de-duplication to parent
function
ctrdata 1.22.0
Improvements
When using querytoupdate for CTIS, set
ctishistory = TRUE to create historic versions from
previously downloaded trial record, see
vignette("ctrdata_summarise")
Trial concept f.trialObjectives() improved with
structured data from CTIS and EUCTR
ctrGenerateQueries() now defaults to interventional
trials with medicines
ctrGenerateQueries() additionally provides a CTGOV
expert search query
ctrGenerateQueries() now also covers countries of trial
conduct
Bug fix
Fixed ISRCTN API term mangling
Fixed digesting marginal cases in notifications in
f.statusRecruitment()
Fixed ctrGenerateQueries to handle ‘or’ as needed for
certain filters
ctrdata 1.21.1
Bug fix
Fixed all f... clinical trial concept functions to
handle NAs, included in testing
Fixed round brackets for nesting logical operators in
queryterm, thanks @jacksknnr (#46)
Fixed CRAN NOTE on package size
ctrdata 1.21.0
Improvements
New feature: built-in functions that implement and calculate common
trial concepts across different registers, see
help("ctrdata-trial-concepts") which should largely avoid
that users have to code themselves and repeatedly common trial concepts,
such as recruitment start date, trial investigating a medicine as
intervention, trial being a platform trial etc.
New feature: function ctrGenerateQueries() to search
all registers from a user’s single input, e.g. intervention, phase,
dates
Refactored dfMergeVariablesRelevel(), factored out
returning data frame or tibble, thanks @machado-t (#45)
Bug fix
dbFindIdsUniqueTrials() excludes GB records from
EUCTR whenever there is at least one Member State or Third
country record
EUCTR no longer allows to search for the status of a
clinical trial, adapted testing to it
Correct ctrShowOneTrial() and
ctrLoadQueryIntoDb() for certain EUCTR trials
Early stopping if database collection is read-only
Added typing of fields newly appearing in CTIS
Documentation simplification and update
Changing vignettes from PDF to HTML
ctrdata 1.20.0
Improvements
New function ctrShowOneTrial() to inspect a trial
structure and data, and to select fields for
dbGetFieldsIntoDf(); in this context, make
ctrGetQueryUrl() work for identifiers of single trials
Improve and update documentation
Bug fix
Refactor dfTrials2Long to correct generating
identifiers for single-item groups
Correct using certain testing conditions
ctrdata 1.19.5
Improvements
Refactored dbFindFields() for speed and efficiency
Adapted to newly available expert search in CTGOV2
Bug fix
Correct CTGOV2 endpoint for document downloads
Adapted to curl v6 having renamed the timeout
parameter
Documents download (folders only for trials with documents;
excluding duplicates)
ctrdata 1.19.4
Fix vignettes and update documentation website (pkgdown)
Make dbFindFields() more robust, specify scalar search
fields to identify records
ctrdata 1.19.3
Improve Tampermonkey script (this serves to copy searches in any
register to the clipboard, and also can open a CTIS search
from an URL, see
https://rfhb.github.io/ctrdata/#id_2-script-to-automatically-copy-users-query-from-web-browser
Refactored parts of documents downloading for handling CDN
links
Simplify code now that CTIS provides an advanced
search
Code styling and linting
ctrdata 1.19.2
Improvements
Added typing for newly appearing variables in CTIS
Accelerated CTIS trial data processing
Bug fixes
Fix incomplete downloads from CTIS by disabling HTTP/2
multiplexing in another function
ctrdata 1.19.1
Improvements
Revised translation of location elements from search URL to API call
for CTGOV2
ctrdata 1.19.0
Possibly breaking changes
CTGOV has retired on 2024-06-25 the classic website and
API used by ctrdata since 2015. To support users,
ctrdata now automatically translates and redirects queries
to the current website. This helps with automatically updating
previously loaded queries
(ctrLoadQueryIntoDb(querytoupdate = <n>)), manually
migrating queries and reproducible work on clinical trials information.
This new functionality in ctrdata translates a user’s
search query URL from the classic website into a query for the current
CTGOV website, for all search parameters. Since the
structure and format of data differs between data retrieved from the
current API and previously retrieved from the classic API,
ctrdata will continue to identify the current API as
register = "CTGOV2", to support the analysis stage. In
addition, ctrdata documentation continues to include
examples of analyses with CTGOV data, as this may have been
downloaded earlier.
CTIS has been relaunched on 2024-06-17, and
ctrdata has been fully updated to it. At the moment,
CTIS provides basic searches and no search query URL. To
support users, ctrdata includes an updated script that
extracts a user’s search parameters from the register search page to the
clipboard and into the browser URL bar. In addition, the script triggers
a search for trials when opening such a query URL, see
https://rfhb.github.io/ctrdata/#id_2-script-to-automatically-copy-users-query-from-web-browser.
File names of CTIS documents start now with the document
type,
e.g. SbjctInfaICF - L1 SIS and ICF NL for publication.pdf,
since the prefix (document source) introduced in version 1.18.0 is no
more applicable.
Improvements
Reduced size of demo database in package, addressing
CRAN notes
Adapted ctrFindActiveSubstanceSynonyms() to
CTGOV2 API; this is now based on terms used in studies
Updated vignette and added inspecting a specific trial
Updated register information, adding caveats and issues
Updated estimated download sizes and user information
Avoided duplicate data and file retrievals
New attribute ctrdata-collection for data frames with
trial information; same content as attribute ctrdata-table,
which will be removed by end 2024
Split utils.R into files for functions and fields
Bug fixes
Correct partial date brackets for CTGOV2
Disable HTTP/2 multiplexing for CTIS
ctrdata 1.18.0 (2024-05-13)
Possibly breaking change
File names for documents downloaded from CTIS now
include the document type and use different separators (e.g.,
“parts2auth - SbjctInfaICF - …” as abbreviation of “Subject information
and informed consent form (for publication)”, was previously
“parts2auth_…”)
Improvements
Add retrieval of historic versions of trial records from
CTGOV2 (automatically retrieved from CTIS, not
available for other registers)
Added typing of newly appearing fields from CTIS
Increase testing coverage to 93.7% locally
Added missing CI for the combination of DuckDB and
CTGOV2
Bug fixes
Correct typing certain fields as (lists of) integers
Handle marginal case in dbGetFieldsIntoDf()
Changed unlink of intermediate files
Minor vignettes corrections
ctrdata 1.17.2 (2024-02-25)
Bug fixes
Switch sequence of API endpoints used with CTIS
Correct handling multiple public events with CTIS
Re-use CTIS downloads in a given session
ctrdata 1.17.1 (2024-02-05)
Improvements
Additional CTIS field types and possibly documents
(associated clinical trials)
Use ctId instead of id as
CTIS top-level field (a further synonym used in the API is
clinicalTrialId)
Bug fixes
Added handling of unexpected Unicode in protocol-related data from
one trial in EUCTR
Improved predicted download sizes and times for
EUCTR
Return with message if CTIS query did not result in any
trials
ctrdata 1.17.0 (2024-01-22)
Possibly breaking changes
Reimplemented dbGetFieldsIntoDf() to accelerate and
have more predictable, simplified returns, in particular for nested
fields; also attempts to recursively expand simply nested data into
additional columns in the returned data frame
Reimplemented dbFindFields() to accelerate; both based
on improved nodbi::docdb_query()
dbFindFields() now digests a sample of records to
quickly find fields, or all records if sample = FALSE but
taking increasing time with increasing number of records
If using nodbi::scr_postgres(), parameter
fields of dbGetFieldsIntoDf() is limited to
less than 50 fields; a message flags for any backend potential
compatibility issues, suggesting to use parent fields, e.g.,
a.b instead of c("a.b.c.d", "a.b.c.e")
Parameter stopifnodata of
dbGetFieldsIntoDf() is no more needed and deprecated
Reimplemented typing fields to speed up and to simplify
Improvements
Register data are re-used and not downloaded again in an interactive
session (that is, the same temporary folder is now re-used throughout a
user’s session)
Temporary folder can be set by users with
options(ctrdata.tempdir = "<user_specified_folder>")
Inform MS Windows users if cygwin was found so that
they may chose to delete it
Many fields added for typing e.g. as date in
dbGetFieldsIntoDf()
Bug fixes
Adapted and corrected information loading to newly available data in
CTIS
Corrected escaping, and back-conversion, of characters in
JSON from CTIS
ctrdata 1.16.0 (2023-11-24)
Possibly breaking changes
XML files are
converted slightly differently
EUCTR result-related information in attributes: e.g. new:
{"id":"PostAssignmentPeriod-46349"}, was:
{"@attributes":{"id":"PostAssignmentPeriod-46349"}}
Consequently, it should work to just delete @attributes
from field names such as
dbGetFieldsIntoDf("clinical_results.baseline.analyzed_list.analyzed.count_list.count.@attributes.value", db)
EUCTR protocol-related information although no differences were
found yet
CTGOV attributes of bare values remain not included in the resulting
NDJSON (e.g., some but not all records have
<start_date type="Actual">March 15, 2004</start_date>,
and this is converted to
{"start_date":"March 15, 2004"})
EUCTR:
some renaming to harmonise EU and 3rd country trial fields
new: e83_single_site_trial, was (EU trials):
e83_the_trial_involves_single_site_in_the_member_state_concerned
new: e83_single_site_trial, was (3rd country trials):
e83_will_this_trial_be_conducted_ at_a_single_site_globally
new: e863_trial_sites_planned_in, was (EU trials):
e863_specify_the_regions_in_which_trial_sites_are_planned
new: e863_trial_sites_planned_in, was (3rd country
trials):
e863_specify_the_countries_outside_of_the_eea_in_which_trial_sites_are_planned
new: e84_multiple_sites_in_member_state, was (EU
trials):
e84_the_trial_involves_multiple_sites_in_the_member_state_concerned
new: e840_multiple_sites_globally, was (3rd country
trials):
e84_will_this_trial_be_conducted_at_multiple_sites_globally
See also
https://github.com/rfhb/ctrdata/issues/26#issuecomment-1749555081
Bug fixes
corrected batch iterations over CTIS trials accommodating unclear
totalSize response
corrected translation of some fields from the browser URL to the API
call for CTGOV2 (closes https://github.com/rfhb/ctrdata/issues/32)
corrected minimum curl version to 5.1.0 (closes
https://github.com/rfhb/ctrdata/issues/31)
handled errors when saving EUCTR results (e.g., too long file path
name, closes https://github.com/rfhb/ctrdata/issues/30 and
https://github.com/rfhb/ctrdata/issues/28)
Improvements
Major
No external tools required any more
(Cygwin, perl, cat,
sed, php functionality for transforming text,
XML and NDJSON replaced by Javascript using R
package V8); addresses personally communicated concerns and
faciliates use of package ctrdata in more environments
(e.g., https://github.com/rfhb/ctrdata/issues/26); consequently, this
might be a breaking change for analysing certain fields, see above which
fields are affected.
Other
added results summary download for CTIS
added documents download for ISRCTN
factored out document download function
ensure dbFindFields() returns fields for EU and 3rd
country trials in EUCTR (addresses
https://github.com/rfhb/ctrdata/issues/26)
changed order of importing from CTIS into database, improved
speed
better checked data downloads, and repeat them where necessary
factored out temporary folder creation
added using options(ctrdata.tempdir = ...) if set
removed dfListExtractKey(), long deprecated
removed dfMergeTwoVariablesRelevel(), long
deprecated
reorganised code file layout
ctrdata 1.15.2 (2023-09-10)
fix handling as utf8 upstream multi-language strings from CTIS
correct creating lists for downloading documents for ctis
adding missing endpoints for CTIS found with increasing amount of
data, e.g. publicevents.temporaryHaltList.details for
2022-501559-99-00
ctrdata 1.15.1 (2023-08-29)
correct LaTeX documentation resulting in CRAN error
correct parts of downloading from CTIS, including file
name sanitisation
ctrdata 1.15.0 (2023-08-27)
added CTGOV REST API 2.0.0.-test as new register with identifier
CTGOV2
handle CTGOV classic interface as register CTGOV
improved ctrdataURLcopier.js to only rewrite searches
and views from CTIS
mangle CTIS: change partIIInfo object into array,
adding a new partIIIinfoKey so that
'{"partIIInfo": "<int>": {...}, "<int>": {...}}'
becomes
'{"partIIInfo": [{"partIIIinfoKey": <int>, ...}, {"partIIIinfoKey": <int>, ...}]}')
correct dbGetFieldsIntoDf() for specific lists
ctrdata 1.14.0 (2023-07-16)
fix dbFindIdsUniqueTrials() for single-record register
contents
expand number of CTIS variables that are typed as date
ctrLoadQueryIntoDb() new parameter
euctrresultsfilespath, deprecating
euctrresultspdfpath
ctrLoadQueryIntoDb() now also extracts and saves
results files other than PDF files
ctrFindActiveSubstanceSynonyms() returns NULL for
non-existing active substance
ctrdata 1.9.1 (2022-04-24)
type e811… variables
bugfix in dbGetFieldsIntoDf
bugfix annotations mix up for some backends
editorial update vignettes
ctrdata 1.9.0 (2022-03-13)
chunked trial batches in NDJSON files for accelerated
database import
if package dplyr is loaded, functions return a tibble instead of a
data frame
update and correct documentation
dbFindFields() returns a vector of fields which now has
as names the register in which a field occurs
accelerated binary checks (cygwin / Windows)
remove internet proxy mangling in order to use system configuration
(e.g., transparent proxies used, or environment variable https_proxy
specified by user)
refactored internal caching
correct dbGetFieldsIntoDf() for specific nested data
structures
correct dfTrials2Long() for specific fields
correct dbFindIdsUniqueTrials() when only single trial
in any register
modify field typing to decode HTML entities
type some fields as difftime, e.g. min_age in
CTGOV
speed up parts of dbGetFieldsIntoDf() and simplify more
fields
dbFindFields() returns names of all leaf and node
fields
improve and update documentation
changed EU Member State to default to DE for
dbFindIdsUniqueTrials()
corrected installCygwinWindowsDoInstall() to properly
update an installation (remove –prune-install)
test all binaries after installCygwinWindowsDoInstall()
and only cache successful binary testing
correct typing required_header.download_date
improve numbering in dfTrials2Long(), covering nested
items
thorough documentation improvement
simplified dbFindFields()
cleaned up testing binaries
cleaned up helper scripts
removed ctrGetQueryUrlFromBrowser(), long
deprecated
uses nodbi 0.6.0
can use PostgreSQL as backend
include PostgreSQL in Github Actions
ctrdata 1.8.0 (2021-11-18)
changes to match nodbi 0.5.0
simplifying database operations (user-visible functions:
ctrLoadQueryIntoDb(), dbFindIdsUniqueTrials(),
dbGetFieldsIntoDf()), without changes to API
ctrdata 1.7.1 (2021-08-22)
fix DBI not needed in Imports any more (CRAN Note)
fix potential file name issue in conversion script
fix dbFindFields() to never return _id (previously
depended on database backend)
changed tests (not on CRAN detection, register availability,
additional tests)
ctrdata 1.7.0 (2021-07-24)
much reduced database backend-specific code, using nodbi 0.4.3
(released 2021-07-23) which also introduces transactions for sqlite
using RSQLite >=2.2.4 (released 2021-03-12)
temporary directory creation only when needed, more automated
deletion
changes in detecting non-functioning register servers
further streamlined unit testing
ctrdata 1.6.0 (2021-05-09)
added support for ISRCTN
refactored checking binaries and caching this info
updated EUCTR download parameters
refactored ctrGetQueryUrl() and
ctrOpenSearchPagesInBrowser()
accelerated EUCTR results and history download and storage
external scripts now create multiple chunks of records
use further identifier fields with
dbFindIdsUniqueTrials()
adding user info which field entries could not be typed
ctrdata 1.5.3 (2021-04-19)
include message how to handle server certificate issues, by
propagating user settings for httr to curl operations
ensure identical return structures when no new trials found
dfTrials2Long(): harmonise identifier level assignment,
address cases where field occurs only once in input df
dfMergeTwoVariablesRelevel(): corrected and improved
user info
dfName2Value(): remove duplicate rows, e.g. from
duplicated criteria
ctrdata 1.5.2 (2021-04-05)
bugfix of EOL for converting EUCTR files
ctrdata 1.5.1 (2021-03-21)
bugfix for non-matching euctr protocol and result ids: any trials
from EUCTR for which results were downloaded with version 1.5.0 should
be downloaded again (ctrLoadQueryIntoDb())
dfTrials2Long() refactored and accelerated
API change: dfTrials2Long() return value (identifier
replaces main_id and sub_id)
new option to save EUCTR results PDF files in user-specified
directory
ctrdata 1.5.0 (2021-03-14)
return values of dbGetFieldsIntoDf() are now mostly
identical whether using nodbi::src_mongo() or
nodbi::src_sqlite(), to best ensure portability of analysis
code
permit dots in queries / URLs
improved handling of queryterm
renamed ctrGetQueryUrlFromBrowser() to
ctrGetQueryUrl()
soft deprecated ctrGetQueryUrlFromBrowser()
ensure parallel retrievals from EUCTR
speed up routines in dbGetFieldsIntoDf()
make dfTrials2Long() handle NA better
improved documentation, clarified examples
simplified internals for typing fields, start typing results
fields
ctrdata 1.4.1 (2020-11-03)
reset row names on data frames returned by functions
update curl parameters when accessing EUCTR
ctrdata 1.4 (2020-10-17)
new: easy access to variables with dfTrials2Long() and
dfName2Value()
improved dfMergeTwoVariablesRelevel() to maintain type
of data
revised and simplified vignettes
deprecated: dfListExtractKey()
refactored parts of euctr retrieval
notify user when euctr register server does not permit compression
and how long retrieval will take
fixed identifying unique ids
ctrdata 1.3.2 (2020-10-03)
quote system file paths
ctrdata 1.3.1 (2020-08-01)
fix error in CI tests
ctrdata 1.3.0 (2020-07-27)
workaround EUCTR certificate issue
streamline ctrGetQueryUrlFromBrowser()
better handling of complex fields
include further tests for query string handling, checking more
parameters and return values
better clean-up after testing
ctrLoadQueryIntoDb(querytorerun = ...) now looks for
the date when the querytorerun was last run, to more often use euctr
update options
switching from travis to github action
upped coverage of code tested
ctrdata 1.2.1 (2020-05-18)
tinytest >= 1.2.1 to avoid regression error
correct testing detail
ctrdata 1.2 (2019-12-07)
correct cygwin install detail
ctrdata 1.1 (2019-11-12)
release after nodbi 0.4 is available
update description for installation from github
handled mixed arrays and text values in same key of ctgov trial
records
more user information during importing
further nesting added for euctr trial records
user verbose information extended for record importing
improved parsing of euctr trial records
correct re-opening of sqlite connection
ctrdata 1.0.1 (2019-10-22)
correction of testing
ctrdata 1.0 (2019-10-16)
switch to nodbi::scr_{mongo,sqlite}() with
re-implementation of most functions
switch from testthat to tinytest, so that users can check with
tinytest::test_package("ctrdata")
improvements to euctr trial import
new function dfListExtractKey()
speed up testing bash commands under windows
ctrdata 0.18.2 (2019-04-30)
extended compatibility with cygwin and Windows
find and use any cygw* under windows
refactored escaping bash command when called under windows
corrected typing date fields
ctrdata 0.18.1 (2019-04-14)
simplified cygwin install
updated documentation
corrected inconsistent handling of query terms
added automated proxy handling
ctrdata 0.18 (2019-04-11)
release version
bug fixes in field typing
move to use remote mongodb server
updated vignettes
ctrdata 0.17 (2019-03-27)
improve dbFindFields() formatting
added parameter to force running a query again
added further typing (some of the numeric fields)
improve cygwin install attempts and information
removed dependency on local mongodb installation (major
rewrite)
improved support for remote mongodb servers (note changes in host /
db / uri parameters)
Important: Added no checking of SSL certificates for EUCTR because
the EUCTR server is not sending the required intermediate and root
certificates, thus failing curl and httr, see
https://www.digicert.com/help/?host=www.clinicaltrialsregister.eu
fixed EUCTR results retrieval (curl return value order not
predictable)
removed second time adding metadata in one function
streamlined user information and progress feedback
ctrdata 0.14.3 (2019-03-12)
turned error into message when no new trials are found
prevent failing tests if no new trials found in rss feed
ctrdata 0.14.2 (2019-03-07)
harmonise user information
ctrdata 0.14.1 (2019-03-07)
replaced RCurl (which failed for some register servers) by httr and
curl
create README.md from README.Rmd
ctrdata 0.14 (2019-03-06)
intention to submit to CRAN, therefore changing several warnings to
messages, improve testing of tool chain applications
ctrdata 0.13.3 (2019-03-03)
prettified dbFindFields() by removing count symbols (XX.) from
paths
improve converting of invalid XML from EUCTR result files to
JSON
ctrdata 0.13.2 (2019-02-28)
made EUCTR retrieval more robust
added marginal case for url of single trial in EUCTR
extended timeout for checking online status of EUCTR
ctrdata 0.13.1 (2019-02-24)
added typing of dates and some logical fields when using
dbGetFieldsIntoDf()
ctrdata 0.13 (2019-01-06)
dbGetVariablesIntoDf() is deprecated, use
dbGetFieldsIntoDf() instead
dbFindVariable() is deprecated, use
dbFindFields() instead
in dbMergeTwoVariablesRelevel() parameter varnames is deprecated,
use colnames instead
ctrdata 0.12.1 (2018-12-15)
added function ctrFindActiveSubstanceSynonyms() to
obtain synonyms for an active substance
added user information on number of trials in CTGOV to be
downloaded, and limit this to 5000 per query
corrected import from EUCTR for details = FALSE
ctrdata 0.12 (2018-05-19)
added possibility to add user’s annotations to records retrieved
with a query (new option annotate.text)
ctrdata 0.11.2 (2018-04-22)
changed queryterm processing
ctrdata 0.11.1 (2018-04-07)
improved installFindMongoBinaries(), should now better
detect mongo binary locations and use for example in cron scripts, which
may not have access to a user’s path information
ctrdata 0.11 (2018-01-28)
newly retrieved: EUCTR results history, into new fields
“firstreceived_results_date” and “version_results_history”
adding feature as per issue #8
ctrdata 0.10.4 (2017-12-28)
note on compatibility with mongoDB versions
fixing issue #8
simplified license
ctrdata 0.10.3 (2017-11-24)
changed custom-built “x5_trial_status” to “p_end_of_trial_status”
provided by EUCTR
ctrdata 0.10.2 (2017-11-22)
editorial project updates
ctrdata 0.10.1 (2017-07-30)
now loading results from euctr where available as xml
ctrdata 0.10.0 (2017-07-25)
fully load results from ctgov
prepare loading results from euctr
ctrdata 0.9.14 (2017-06-28)
refactored system calls
windows now part of continuous integration
ctrdata 0.9.13 (2017-06-23)
refactored ctrLoadQueryIntoDb()
ctrdata 0.9.12 (2017-06-18)
Preparing for new CTGOV interface
Improved documentation
Corrected ctrGetQueryUrlFromBrowser return value
ctrdata 0.9.11.1 (2017-02-04)
Improved documentation
ctrdata 0.9.11 (2017-01-15)
Added functionality: EUCTR fallback import mechanism if large JSON
file fails to import into mongoDB (by splitting and importing one JSON
file for each trial, tested with several thousand trials)
ctrdata 0.9.10.1 (2017-01-12)
Fixes issues with conversion of EUCTR records that did not have
details.
Fixes issue that placebo information was converted into IMP
fields.
ctrdata 0.9.10.0 (2016-12-28)
Added metadata attributes to returned objects to indicate database,
query, timestamp etc.
ctrdata 0.9.9.5 (2016-12-14)
Added option ctrLoadQueryIntoDb(querytoupdate = "last")
to re-download last query in collection
ctrdata 0.9.9.4 (2016-11-18)
Added progress indicator to ctrLoadQueryIntoDb() to
indicate network download traffic
ctrdata 0.9.9.3 (2016-11-17)
deduplication in dbFindIdsUniqueTrials() optimised for
speed and memory, added check by ISRCTN
ctrdata 0.9.9.2 (2016-11-13)
corrected deduplication in dbFindIdsUniqueTrials()
ctrdata 0.9.9.1 (2016-11-12)
renamed ctrQueryHistoryInDb() to
dbQueryHistory()
note: change in json format of query history, breaking
compatibility
refactored all concerned functions to use mongolite
rmongodb is no more supported
ctrdata 0.9 (2016-10-17)
changed implementation of dbFindIdsUniqueTrials()
editorial changes to examples
ctrdata 0.8.1 (2016-09-07)
added field to indicate source register
improved ctrLoadQueryIntoDb() with
details = FALSE
added example for map plotting
ctrdata 0.8 (2016-09-04)
dbFindIdsUniqueTrials() now encapsulates
dfFindIdsUniqueEuctrRecord()
dfFindIdsUniqueEuctrRecords() removed
installation instructions updated after recently rmongodb was
removed from CRAN
ctrdata 0.7 (2016-05-29)
dbGetVariablesIntoDf() changed to concatenate values in
array and objects
completed test adaptation for travis
improving perl regex
checking helper applications
ctrdata 0.6.2 (2016-04-20)
add / update field “record_last_import” for every imported / updated
record
ctrdata 0.6.1 (2016-04-02)
changed to provide vignettes
ctrdata 0.6 (2016-02-25)
different update mechanism for EUCTR implemented
corrected function name from db… to
dfFindUniqueEuctrRecord()
ctrdata 0.5.9 (2016-01-23)
Corrected bugs
Started preparation of submission to CRAN
Preparing to include package unit tests
ctrdata 0.5 (2015-11-29)
Published on github
Improved documentation
ctrdata 0.4 (2015-10-08)
Renamed all functions for consistency and ease-of-use
ctrdata 0.3 (2015-10-06)
Added functionality to download xml data from CTGOV, which includes
more data than the csv format
ctrdata 0.2.8
Changed and extended how history of queries is included in
database.
New function dbCTRQueryHistory()
ctrdata 0.2.7
Added function for merging variables such as from different
registers and optionally to merge values into new values
Note that function findCTRkey() was renamed to
dbFindCTRkey() because it acts on the database
ctrdata 0.2.5
Added function for selecting preferred language versions of trials
from EUCTR
Improved use of automatic proxy configuration script
ctrdata 0.2.2
Added proxy function and improved installation of cygwin under MS
Windows