« DSPACE sql for items that have not been withdrawn | Main | SQL to find handles that correspond to a specific language.iso in DSPACE »

Documentation of php code to query DSPACE DB

Code Purpose Documentation complete
port_meta_field_uniq_count.php Get a count of the unique
values for a field (metadata_id)
yes
port_file_handles_to_meta.php Take a file of DSPACE handles and dump
the associated metadata to an excel file
yes
port_DSPACE_sql.inc.php Set of utility functions no
port_metadata_id_to_full_table.php Finds all the metadata associated with non null
values of a metadata id e.g dc.subject.mesh has a metadat_id of 62
./port_metadata_id_to_full_table.php 62
will make an excel spreadsheet of all the
metadata where dc.subject.mesh
is not null
yes
port_metadata_count.php Gives a count of occurrences of a metadata text field
yes
port_sql_column_diff.php Does a diff between two SQL columns no

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)