XBio:D Data Management

From xBio:D Wiki
Revision as of 15:57, 21 July 2015 by Jcora (talk | contribs) (Protected "XBio:D Data Management" ([Edit=OSUC users group] (indefinite) [Move=OSUC users group] (indefinite) [Read=OSUC users group] (indefinite)))
Jump to navigation Jump to search


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.

Retrieved from "https://xbiod.osu.edu/index.php?title=XBio:D_Data_Management&oldid=2118"