Connecting to R directly to CSWEB

Discussions about syncing data via Bluetooth, Dropbox, FTP, and using CSWeb
Post Reply
Yass
Posts: 94
Joined: November 11th, 2017, 1:26 am

Connecting to R directly to CSWEB

Post by Yass » October 8th, 2021, 5:40 pm

Please is it a possibility of connecting R directly to csweb using the database credentials and read .csdb.

Thanks

htuser
Posts: 527
Joined: December 19th, 2011, 6:26 pm
Location: HAITI

Re: Connecting to R directly to CSWEB

Post by htuser » October 9th, 2021, 4:58 pm

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

Yass
Posts: 94
Joined: November 11th, 2017, 1:26 am

Re: Connecting to R directly to CSWEB

Post by Yass » October 10th, 2021, 7:09 pm

Thanks htuser

Post Reply