[MSNoise] populate stations table with script

[Thomas Lecocq]

Hi Phil !

Indeed, the populate step actually only lists the stations from the 
archive. No files are read at this point.

Aurélien has written some updated populate code to read the metadata 
information from dataless or inventoryXML , but we still have to make it 
clean in order to make it available.

Meanwhile:

1/ you can populate "normally"
2/ select - deselect the stations you want in the Station table (if you 
are using 1.4: in the Admin).
3/ write a small python script to interact with the API: use "connect", 
"get_stations" and "update_station" to update the existing fields.

Let me know how it goes,

Thomas

Le 26/04/2016 00:04, Phil Cummins a écrit :
> Hi,
>
> I'm new to msnoise, and was unable to find a searchable archive for 
> this list(?), apologies if the question has been asked before.
>
> I want to populate my station table, and msnoise has scanned my sds 
> database and identified all the stations. However, it has only filled 
> out the name fields, and I need at a minimum the locations, and would 
> like to do the instruments as well.
>
> So I would like to find a way to populate the stations table using a 
> python script. Presumably one would use pymysql? I have never used 
> pymysql, and was wondering if maybe someone had such a script. If you 
> do, could you please send it to me?
>
> (actually, I want to do it this way in any case, since in future my 
> sds database will have more stations than I want to use with msnoise).
>
> Thanks,
>
> - Phil
>
>