Page 1 of 1

Connecting to R directly to CSWEB

Posted: October 8th, 2021, 5:40 pm
by Yass
Please is it a possibility of connecting R directly to csweb using the database credentials and read .csdb.

Thanks

Re: Connecting to R directly to CSWEB

Posted: October 9th, 2021, 4:58 pm
by htuser
Hi Yass,
Yes It's possible to connect to the parsed MySQL database. The Database where processed cases are stored.
https://www.csprousers.org/help/CSWeb/d ... tings.html
This is possible by using RmySQL package: https://cran.r-project.org/web/packages ... index.html

You can also connect to CSDB files using : https://db.rstudio.com/databases/sqlite/
Since data are stored without label in theses databases, you should export data to R to have a label files for R.
Hope this help you

Re: Connecting to R directly to CSWEB

Posted: October 10th, 2021, 7:09 pm
by Yass
Thanks htuser