openmolecules.org Forum: Functionality

Home » DataWarrior » Functionality » Database Access

Show: Today's Messages :: Polls :: Message Navigator

Database Access [message #205]

Fri, 04 November 2016 16:39

sawildman
Messages: 1
Registered: November 2016
Location: University of Wisconsin

Junior Member

I would like to use the "Retrieve Data from Custom URL" feature to access an in-house database that is significantly more complicated than the examples.
I currently access this database with a bash script that involves
1. Setting an access key
2. Calling curl to initiate the data export
3. Waiting for the export to finish (calling curl to monitor progress)
4. Calling curl to actually retrieve the data export
Each of these curl calls requires the access key to be included

Is there a way to set all of this into a DataWarrior macro, or to use a macro to call my bash script?

Scott

Report message to a moderator

Re: Database Access [message #207 is a reply to message #205]

Sun, 06 November 2016 00:06

thomas
Messages: 730
Registered: June 2014

Senior Member

If you can't put the process into one URL, the "Retrieve Data from Custom URL" won't do it.
Calling a bash script from DataWarrior is not possible either. But possibly you could automate the process
by changing and extending your bash script such that the last curl call writes the data into a defined file
and the next bash command launches DataWarrior with the filename as parameter.

Thomas

Report message to a moderator

Previous Topic:	Select columns to hide/show
Next Topic:	Using Set Value Range option

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri May 09 13:44:13 CEST 2025

Total time taken to generate the page: 0.03344 seconds