Changing metadata using SQL

[Christian Bischof]

I ask myself if it is a good idea to change metadata directly using SQL. The change of metadata via API or pyDataverse can be very complicated, if you have to change a lot of datasets. I see two problems:

1. You lose the tracking of the metadata changes, the version number and the details.

2. To address the correct id of the table datasetfieldvalue, if you only want to change the last version of a dataset and not all version of a dataset.

Are there any other things that should be considered?

There is one case documented https://guides.dataverse.org/en/5.12.1/installation/advanced.html where changes are also made directly via SQL. I assume there is no possibility to do it with the API.

Best Christian

[Range, Jan]

Hi Christian,

there is a Python library called EasyDataverse that wraps pyDataverse and simplifies changes to the metadata. You can find it here:

Maybe it helps solving your problem :)

All the best,

Jan

Am 20.06.2024 um 11:02 schrieb Christian Bischof <christia...@univie.ac.at>:



--
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-commu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/084019b9-b0a8-4de3-b940-5ca0c6c637cfn%40googlegroups.com.

[Christian Bischof]

Thanks, I will give it a try.

Best Christian