Difference between revisions of "XBio:D Data Management"
(Created page with "---- '''xBio:D Data Management''' This section provides instructions on performing common data management tasks on the xBio:D database that are not privy to general users. ...") |
m (Protected "XBio:D Data Management" ([Edit=OSUC users group] (indefinite) [Move=OSUC users group] (indefinite) [Read=OSUC users group] (indefinite))) |
(No difference)
| |
Revision as of 15:57, 21 July 2015
xBio:D Data Management
This section provides instructions on performing common data management tasks on the xBio:D database that are not privy to general users. These tasks are not available through web applications and must either be performed by running a script or a database procedure.
Change Occurrence Record (Specimen) CUID
In the Oracle SQL Developer, turn DBMS_OUTPUT on, then run the procedure EXEC updateSpmID(old_cuid, new_cuid);. The procedure will only produce output when a problem occurred.
Merged/Remove Locality Name
In the Oracle SQL Developer, turn DBMS_OUTPUT on, then run the procedure EXEC change_locality(obsolete_loc_name, valid_loc_name);. The procedure removes the obsolete locality and places all of the occurrence records from the obsolete locality into the valid locality name. There is also an additional, optional parameter coll_date, which accepts the format DD-MON-YYYY, that will change the functioning of this procedure to change only those occurrence records that were collected on that particular date. If all of the occurrences were collected on that day, the locality is removed. The procedure will only produce output when a problem occurred.
