Reveal Admin and User Scripts
For a copy of the scripts, please contact support@revealdata.com.
Script Name | Target Database | Purpose | Can be run in Review Manager? | Last confirmed version |
|---|---|---|---|---|
EntityType_Table.txt | Reveal AI project database | Pulls entity information from Reveal AI/NexLP. | Yes | Reveal AI 2.8 |
Script_to_Pull_PER_Info.txt | Reveal AI project database | Reports the business card and Pseudonym information from Reveal AI via SQL script. | No | Reveal AI 2.8 |
Combine_Date_Time.txt | Review project database | Combine two fields (one date field and one time field) into a single date/time field. | Yes | Review 10.3 |
Dupe_Status_Part_1.txt & Dupe_Status_Part_2.txt | Review project database | Dupe_Status_Part_1.txt – Starts the process to generate the Original/Duplicate designation to parent documents, must be run first. Dupe_Status_Part_2.txt – Finishes the process to generate the Original/Duplicate designation to parent documents, must be run second. | Yes | Review 10.3 |
Duplicate_Copies.txt | Review project database | Provides the Original/Duplicate designation to parent documents only. | Yes | Review 10.3 |
MasterDateTime_and_MasterDate_ Update.txt | Review project database | Updates MASTERDATE and MASTERDATETIME. Master date information is pushed down from parent documents to children. | Yes | Review 10.3 |
Page_Count_Update.txt | Review project database | Populates a "Page_Count" field with counts from images either loaded or tiffed on the fly. | Yes | Review 10.3 |
Parent_and_Child_List_Bates_ Overlay_to_Fields.txt | Review project database | Creates a list of all children production BegDocs and populates it to a field for the top-level parent. Child documents all receive the BegDoc of the top-level parent in a different field. | Yes | Review 10.3 |
ParentChildStandAlone_Field_ Population_Script.txt | Review project database | Sets custom field values for each record as "Parent", "Child", or "Stand Alone" based on query. | Yes | Review 10.3 |
Propagate_Parent_DateTime_To_ Children.txt | Review project database | Populates a selected datetime field from parent to children documents where selected date time field is null, such as email sent date. | Yes | Review 10.3 |
Resorting_Tag_Choices.txt | Review project database | Allows the resorting of tag options within a review project. | Yes | Review 10.3 |
Text_Size.txt | Review project database | Places the MB size of a text set into a custom field named "TEXT_LENGTH_MB". | Yes | Review 10.3 |
Trim_Folder_Path.txt | Review project database | Trims the folder path for loaded documents. Used to remove internal paths from folder paths. | Yes | Review 10.3 |
Cloud_AI_Functions.txt | Review project database | Pull general statistics from labeling, translation, and transcription jobs. | No | Review 10.3 |
Prod_Sizes.txt | Review project database | Pulls production sizes from target database. | No | Review 10.3 |
Review_ProjectDB_TeamsUsersTypes.txt | Review project database | Provides a report of teams and users for a target project. Provides a second report of users and teams assigned to specific items, such as folders. | No | Review 10.3 |
Review_UserManagement_ RoleGroupUsersPerms.txt | Review project database | Provides a list of roles, groups and users across all Review project databases. | No | Review 10.3 |
User_Search_History_Review.txt | Review project database | Reports each users search history, sorted by date. | No | Review 10.3 |
Max_billing.txt | Review User Management database | Pull peak hosting for review over a period of time. | No | Review 10.3 Processing 10.3 |