Able to SDV a CRF through Excel?

shaundoty

Hi Everyone,

Just wondering if there is a way to have Excel VBA connect to the EDC and to SDV on source documents which have been determined by the Excel user.

I was checking the API but may have missed whether it is possible to SDV through code at all.

Thanks!

lindsay.stevens

Currently there's no API for that, but it's possible to get the job done
through automated interaction with the HTML pages. Look into Selenium for
that.

It might be a little tricky to hook Selenium into vanilla Excel VBA, since
the closest Selenium driver is C# (VBA can load DLLs). A good alternative
might be to use Python with the "xlwings" plugin (which you may find useful
for much more!).



On 1 Sep. 2017 04:54, "shaundoty"
wrote:

OpenClinica https://forums.openclinica.com/
shaundoty started a new discussion: Able to SDV a CRF through Excel?

Hi Everyone,

Just wondering if there is a way to have Excel VBA connect to the EDC and
to SDV on source documents which have been determined by the Excel user.

I was checking the API but may have missed whether it is possible to SDV
through code at all.

Thanks!