search

GeoNet / fits

Field Time Series
Apache License 2.0
4 stars 13 forks source link

what is the best way to deal with data when I need to change the methodID? #79

Closed rumachan closed 8 years ago

rumachan commented 8 years ago

@gclitheroe As a result of new methodIDs, I will want to replace some data with methodID = A, with the same data, but with methodID = B.

What is the best way to go about that? Can I do an upload with --delete-first, but have a blank input csv file? Will that actually delete the existing data? I could then upload the same data with the new methodID.

Or, is this something for the 'database manager'?

gclitheroe commented 8 years ago 
What is the best way to go about that? Can I do an upload with --delete-first, but have a blank input csv file? Will that actually delete the existing data? I could then upload the same data with the new methodID.

Not totally sure how this would work (without checking the code). I'm pretty sure it would work.

As a result of new methodIDs, I will want to replace some data with methodID = A, with the same data, but with methodID = B.

If you want to change all data methodID = A to methodID = B this is a one line job in the DB. 

Or, is this something for the 'database manager'?

Yes. But in the mean time I'm happy to help.