Connecting to R directly to CSWEB

Discussions about syncing data via Bluetooth, Dropbox, FTP, and using CSWeb
Forum rules
New release: CSPro 8.0
Post Reply
Yass
Posts: 103
Joined: November 11th, 2017, 1:26 am

Connecting to R directly to CSWEB

Post by Yass »

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

Thanks
htuser
Posts: 631
Joined: December 19th, 2011, 6:26 pm
Location: Silver Spring Area, MD, USA

Re: Connecting to R directly to CSWEB

Post 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
G.VOLNY, a CSProuser from Haiti, since 2004
Yass
Posts: 103
Joined: November 11th, 2017, 1:26 am

Re: Connecting to R directly to CSWEB

Post by Yass »

Thanks htuser
Post Reply