PrimeCode CRW (Custom Report Writer) - User Manual
Contents
1. ii Related Documentation eren ii Customer Support ooo o o ii System Requirements iii PC Requirements iu ud uoo EORR RR 111 HP NonStop Guardian Requirements 111 System Overview oo o iv PrimeCode CRW Process Flow Installing the PC Application 1 Running the msi Install File 1 Un Installing the PC Application 2 Removing Custom Report Writer from Windows 2 Configuration Main Window 3 1 2 Main RR boh we RUD RES A i 2 Step 5 3 Profile Parameters Panel 0 0 5 AS Buttons i e deck do RC wagon a ar 5 5 Progress Afea os be 5 6 StatusBar a aa a E a aa e Ee a 9 lui PC 7 What Are sn om 3 7 Why Use Profiles 4 4 EE 7 Creating Profiles x ns 654 04 24 8 Loading Profiles s s o es scosceso tanane ririo 13 Modifying Profiles lt s 4 siirus a i soie a ERE 13 Deleting Profiles Re ca oa OR US 13 GUL Options es a ee ee Ra oe e ws 14 Splash Scies 6 4 wack em ERE UAR bb deck 14 Sounds s 14 Updating the Database Mr EET 15 L ggmngln 22. 330 99 moo o mo ms 15 The Database iow ome xe yc 9e Xem 17 APPENDIX A Database Tables y a e 1 APPENDIX B Queries VIEWS s sso aa e a ew ws 1 APPENDIX C Reports 0 Se UR LUE WR ee eg 1 APPENDIX D Database Field Descriptions een 1 ccc 0 40 eame RY ees 1 POURING as SEE tose Ss Rs dl 2 COMPDREL 24 544 584 4 e e n ee 2 COMPENT lt 2 2444248405 ER eee PES SER ARN SES 3 COMPENT 24 6 3 Soya Sis we gt Ed 4 atra Se tics Perego Atene Ba Ge oh sd 5 DEPREI 24 54 445 ap sone Sp Pe sedo 8 as 5 DISTRE odres ad Se 6 BVIDOGS ox Rove ROEGESACECEDG EUR ON X 8 BOY ae ee E 7 0200 th at Que later d des decem pa rs 7 LOCKENT ppe se ga koi e RP GE Wewa 8 n4 tes Ed ee ea Mo cae ARN E 9 PCRIREL ou io rs X Re E ES 9 PERVREL a v uuum Atm Ee xS Ard S SD 10 REEREL ss 4 965 3 ERE E Q5 10 RELENT eB abe We SD DEES CEE 11 REQREL xod da V 12 RULEENT 44 EPIA HERS BEES OA E AEN UE 13 SCHEMVER 20 45 454688454 4 ke o4 B BPGESST6 14 SECENT 2 ap Bea EEC ERA ee 15 STATEEN D OOS EES OE REG PREX 16 SVERREL bh AUS E oe a dey os ete 17 TEXTEND uuum a ca Be ww ee oe ke Rm De 18 TEXREE y aag 6 hn piste ee etd Gy mob Bde ek Sher ees 18 T
3. initiate an FTP connection between the PC and the HP machine to download the ASCII files from the NonStop A local SQL database will be updated with the new data PrimeCode CRW s database includes several built in reports which can be run right away using MS Access PrimeCotle CRW Custom Report Writer 2 0 3 PrimeCode CRW Process Flow Illustration shows the HP NonStop process on the left and the PC application on the right With regards to the PrimeCode repository and the ASCII files which are extracted from it all processes are Read Only Commence Update with PrimeCode CRA ASCII Files ASCII Files In Use Available Yes Semaphore file INUSEG placed to maintain exclusive use of ASCII files SCII Files to Retrieve are No Repository Newer Read Onl Yes Yes Semaphore file INUSEPC placed to maintain exclusive N use of ASCII files 0 Update anyway ASCII files Extracted from PrimeCode FTP ASCII files to PC side ASCII Files on PC being generated or in use by another PC Please try again later ASCII Files are Semaphore File INUSEG removed by CRVVX Semaphore File INLISEPC removed by CRVY Database Initialized ASCII Files Populate SQL Database User Manual Y vi PrimeCotle CRW Custom Report Writer 2 0 3 Installing the PC Application Run Y If any previous versions
4. in the Component place holder The user who created this release is stored in the Component place holder The creation date of this rel is stored in the comp pl h STATEID Number State of the release There should eventually be one entry per release per State RELEASESTATE Number RelStateCreated RelStateContentFrozen RelState VersionsFrozen RelStateDropped CONTENTDATE Date If RelStateCreated then the date at which the contents of the release are scheduled to be frozen optional If NOT RelStateCreated then the date at which the contents of release were frozen VERSIONDATE Date If RelStateContentFrozen or RelStateCreated the date at which the vers of all Components of the rel are scheduled to be frozen optional If RelStateVersionsFrozen or RelStateDropped the date at which the Versions of all Components or of the rel were frozen PROMOTEDATE Date If RelStateVersionsFrozen or RelStateDropped then the date at which the release was last promoted Otherwise NULL DROPDATE Date If RelStateDropped then the date at which the release was dropped If NOT RelStateDropped then NULL INCLUDESOURCE Number Ship Source Components with the release CHANGEID ENVIRONMENT 1 GUARDIAN 1 OSS PrimeCode CRW Custom Report Writer 2 0 3 Appendix D II REQREL Description prior to another release Requisites Relationships between Releases and Requisites Releases required to
5. the Catalog is listed in alphabetical order Under each Rule name is listed the qualified name of the Sources and their associated Target Object which utilized this Rule Component Versions by State States at which Components exist are listed Beneath each State is a listing of every Component at that State and its Version Component names are qualified to represent their location in the Catalog Timestamp Version numbers are Objects Components by Language Component names are organized by Language and then by Type Current Licenses by Location The Location of the Release and the Release name are listed for every Licensed Release Deny Expiry Date and License flags are included Current Licenses by Release Licensed Releases are sorted by Release and then Location Install Activity by Location Locations are listed with each of the Releases which have been Distributed or Installed there Continued on next page Install Activity by Release Releases are listed with each of the Locations to which they have been Installed or Distributed to Releases by Release State All Releases are listed sorted by the Release State i e Contents Frozen Versions Frozen etc Rules Rules for the Catalog are listed sorted by the group at which they were placed Details include the Rulename State Language and Steps Security Entry Catalog Security records for this Catalog are displayed sorted by use
6. the default 1 From the Main Menu Select Options Application Settings or Ctrl S Click the Load button next to the profile name 3 Select one of the existing profiles and click OK Modifying Profiles To modify an existing profile s name or parameters you must load it making it the current default profile L To load a new default profile see Loading Profiles above Make appropriate changes and click Update Profile or OK Y Clicking Update Profile will save your changes but not close the Options dialog You can reload any other profile or make other modifications to the current one Y Clicking OK will save your changes and close the Options dialog The last loaded profile becomes the Default Profile Deleting Profiles The current profile will be deleted and the current default will be cleared You will be prompted to specify a new default profile 1 Click the Delete Profile button 2 Confirm the deletion 3 Select a replacement Default Profile from the Profiles List Box User Manual 13 GUI Options The GUI graphical user interface of this program can be modified slightly to suite a preference The modifiable components of this interface are the Splash Screen and the Sounds Splash Screen You may control whether or not the splash screen will display on start up and if so for how long You may toggle on and off the splash screen display on start up with the check box If the Show
7. to bring over and where to put them It also controls which local SQL database will be created updated to reflect the data collected from PrimeCode or RMS Why Use Profiles Profiles allow a user to specify all of the parameters of a SQL database update by referring to just the profile name More importantly profiles allow individuals to maintain separate copies of a local database and ensure that only the appropriate database gets updated and at intervals that satisfy their requirements Example If the ASCII files are prepared frequently one analyst may wish to work with the newest data that is contained in these files for an up to date picture of the statistics and will update frequently Another however may want to work with data that was retrieved at a certain date and frozen to reflect for example the statistics for the year ending Anyone updating the same database he she is evaluating will refresh the statistics to reflect the condition at the latest time the Guardian ASCII files were generated in effect losing the view of the database at year end User Manual Creating Profiles Profiles contain essential information about how an update will take place In fact the profile controls what gets updated A profile must exist for an update to be executed Creating or maintaining profiles is done through the PrimeCode CRW PC Interface To create a profile 1 Launch the PC program Custom Report Writer 2 Select Profile Mana
8. A brief description of the Component LANGUAGE String The language of the Component LOGICALNAME String A name which can be used in place of the Component Id and or physical name SYSTEM String Physical System Name VOLUME String Disc volume name dat1 SUBVOL String Subvolume name FILENAME String Last segment of physical file name up to 8 characters SYSTEM2 String Presentation Name VOLUME2 String Presentation Name SUBVOL2 String Presentation Name Continued PrimeCode CRW Custom Report Writer 2 0 3 Appendix D 3 COMPENT Ti Description Components FILENAME2 String Presentation Name GROUPID Number DEFINENAME String The define name a unique system wide alias can be used in Source files extracted for compile instead of the Component id SYSTEMNUMBER Number Creator GROUPNUMBER Number Creator USERNUMBER Number Creator CREATIONDATE Date The date the Component was created MODIFICATIONDATE Date The date the Component was submitted ACCESSDATE Date The date the Component was last extracted or compiled FLAGS Number LOR of all special component flags E CS e Number Line number increments for extracted files DEFAULTTRIGGERCHAR String A character used to trigger embedded macros to expand Range Null 0 to NUMCHILDREN Number Computed number of children 1 is undefined STATUSTIME Number STATUS Text APPROVALREQUIRED
9. COMPONENT UIDRELEASE UIDUSERCHANGE UIDLOCATION or UIDLICENSE IDENTID Number A unique identifier within RecordType LOGICALNAME String Attribute symbolic name SEQUENCE Number A sequence number to support multiple attributes with same logical name ATTRIBUTEDATA String The Value of the Attribute COMPDREL Ti Description Rules of compiled relationships relationships defined between Source and Object Components which have been involved in a compile This relationship is a permanent link between two Components A Rule Id has been associated with this Rule superseding the Rule name TARGETID Number A link to the target Version SOURCEID Number A link to the primary Source Version RULEID Number The Id of the Rule used PrimeCode CRW Custom Report Writer 2 0 3 Appendix D 2 COMPENT Components Ti Descri tion COMPONENTID Number A unique Component identifier PARENTID Number The Component Id of the primary parent of this Component 1 is undefined 0 is the root of the Catalog KIND Number The Components kind or type is used to determine some of the variations of actions upon them such as compilation This field is the key in the table Componentkinds which describes the kind Id number MODE Number A component type Used to determine the nature of actions required during extract and release promotion DESCRIPTION String
10. Components Created by Date A crosstab chronological listing by date of all Components that were created and the number of Components created on that date for each Component Type _ Type of Components Created by Month A crosstab chronological listing by month of all Components that were created and the number of Components created in that month for each Component type APPENDIX D Database Field Descriptions ARCHENT Description The archives of the RMS PrimeCode Catalog contain copies of all Data Files Objects which have been submitted and any compiled Objects SYSTEM String The System portion of the archive name of the Component VOLUME String The Volume portion of the archive name of the Component SUBVOL String The SubVolume portion of the archive name of the Component FILENAME String The last portion of the archive name of the Component End of archive name VERSIONID Number The Component Version archived SYSTEM2 String The managed filename of the component VOLUME2 String SUBVOL2 String FILENAME2 String End of managed filename VERSION String The Version or Version date of the archived Date Component PrimeCode CRW Custom Report Writer 2 0 3 Appendix D AUXENT Description Auxiliary Attributes many of which are user defined qualities of a Component RECORDTYPE Number The type record UID
11. EXTSUB popper teretna dtt eng 19 TEXVAL Ge ela eh Ged Be om de acta cel Slat cee d 19 CHGENT oor a es Fs a Rv X3 ben d 20 MERSENI iea s Aei Gate 8 Ged PEOR mos D doen 21 Preface Introduction PrimeCode CRW Custom Report Writer is a PC application designed to complement PrimeCode a software configuration management tool from Emperex PrimeCode is a powerful tool that can be used to control every facet of the program development life cycle but has limited reporting capabilities Much useful information is stored in the HP NonStop Enscribe database used by PrimeCode but is inaccessible by more common PC tools PrimeCode CRW will facilitate access to this information by extracting data from the Enscribe database to produce a SQL database on a Windows PC On NT and Windows 2000 systems a System DSN can be setup to make this data available to any computer on the network via ODBC Access to the details from this source could provide important statistics for monitoring trend analysis and usage pattern determination Several built in report generators are included with PrimeCode CRW and using SQL queries or tools such as Microsoft Access or Crystal Reports users can design and run their own custom reports User Manual Purpose This User Guide details the components of the PC interface for PrimeCode CRW and its operation for updating a database which is analogous to the RMS Catalog An o
12. Number PrimeCode CRW Custom Report Writer 2 0 3 Appendix D 4 COMPREL Ti Description Rules of compile relationships relationships defined between Source and Object Components which have not yet been used in a compile A Rule name identifies the Rule and it can be edited or renamed at this point TARTETID Number A link to the target Component SOURCEID Number A link to the primary Source Component RULENAME String A link to the Rule used to compile the target Version of the target Component RuleName is resolved using the groupId of the Sourceld KIND Number Specifies the type of the compile relationship CompRelTraverse CompRelNonTraverse CompRelDocument NOT USE DEPREL Descri Dependencies for each Version What entities does a Version depend on to exist TARGETID Number A link to the target Version SOURCEID Number A link to the Source Version KIND Number DepKindSource DepKindObject DepKindData DepKindProcessor PrimeCotle CRW Custom Report Writer 2 0 3 Appendix D 5 DISTREL Description Distributions A history of the Distributions comprised of a specific Version of a manifest and its location LOCATIONID Number A unique Component location identifier COMPONENTID Number The actual item release or Component which was distributed VERSIONID Number The actual Version of the release mani
13. Primetotle crw Custom K eport Writer User Manual CRW_D20 2 03 for PrimeCode 3 5 x with RMS D20 xx PrimeCotle CRW Custom Report Writer 2 0 3 Custom Report Writer and PrimeCode CRW are trademarks of Emperex Corporation PrimeCode CRW contains intellectual property which is proprietary to and a trade secret of Emperex Corporation Unauthorized reproduction of this document is strictly prohibited For any occurrence of the words PrimeCode CRW the trademark is assumed All other brand names are trademarks or registered trademarks of their respective companies Copyright 2000 2009 All rights reserved No part of this document may be reproduced in any form by any means without express written permission from Emperex Corporation Document History Edition Release Date First Edition CRW 1 0 0 May 2001 Second Edition CRW 1 1 0 December 2001 Third Edition CRW 1 1 1 March 2002 Fourth Edition CRW 2 0 0 September 2002 Fifth Edition CRW 2 0 0 May 2003 Sixth Edition CRW D20 2 0 1 September 2003 Seventh Edition CRW D20 2 0 1 May 2006 Eighth Edition CRW D20 2 0 3 February 2009 CRWX D9023 D20 07 D20 15 5955 Airport Road Suite 200 Mississauga Ontario Canada L4V 1R9 Ld 905 677 6666 905 677 6671 uere C 5 WWW emperex com Table of Contents Preface Introduction co UR o RERO a a eo acto is i Purp s 54 230534 HE e ii Who Should Read This Manual
14. Splash Screen on Start up check box is checked you may select from the dropdown list a choice for the number of seconds the splash screen will display Sounds Custom Report Writer emits sounds on two events e Each time a step in the update process completes e When an update is finished To change the wav file which is played for either of these events click the Browse button to the right of the field and navigate to the wav file of your choice in the Open dialog and select it Check the Use Sounds checkbox to enable or disable sounds This feature can be controlled by double clicking the sounds icon on the status bar as well You can test your chosen sound by clicking on the filename after selecting it PrimeCodle CRW Custom Report Writer 2 0 3 Updating the Database Start To begin Custom Report Writer s generation of a SQL database 1 Click on the Start Update button Logging In Once you have created at least one valid profile you can launch the Update Database function of Custom Report Writer If you do not have a profile set up refer to the Configure PC Application on page 3 To continue the update you must login to the HP machine to access the extracted ASCII files produced by the HP component of this software The User Authentication Window will display the profile being used and the host system to be connected to Users are prompted for Username and Password Using Profile Indicates current profi
15. alog upgrade detailing its history DICTVERSION Number In the form of A00 The release of RMS There may be multiple records in the file which represent the upgrade history of the RMS product for this site VERSIONDATE Date The release date of DictVersion as specified by the RMS suppliers INSTALLATIONDATE Date The date on which DictVersion was installed REASON Number A link to information describing the nature of the release PrimeCode CRW Custom Report Writer 2 0 3 Appendix D 14 SECENT Ti Description Security records for the Catalog Not ACP security There may be 2 records for any given user They will appear identical except for the Kind and Masks fields which will determine if the security record 1s allowing security or denying it for the branch of the Catalog COMPONENTID Number Reference to the Component corresponding to this security entry STATEID Number The State Id for the Component which is secured Nil may be specified for all States KIND Number SecDeny SecAllow SYSTEMNUMBER Number The system on which the user must reside when using the specified Component dRMS VAL ALLUSERS or dRMS VAL LOCALSYSTEM may be specified GROUPNUMBER Number The group number of the user having security access to a given Component dRMS VAL ALLUSERS may be specified only if dRMS VAL ALLUSERS is specified in UserNumber USERNUMBER Number The user numb
16. and their Kind between Components Distributions De normalized version of table DISTREL Produces a table of all Locations to which Releases have been Installed or Distributed to Continued on next page PrimeCode CRW Custom Report Writer 2 0 3 Appendix B EventLog Not currently used LicenseFile De normalized version of table LICREL Produces a table of all Release To Location Licenses Locks De normalized version of table LOCKENT Produces a table of all Locked Components with all relevant details OrgTree De normalized version of table ORGENT For RMS internal use only PCRToRelease De normalized version of table PCRIREL Produces a table listing UserChanges included in Releases PCRToVersion De normalized version of table PCRVREL Produces a table listing UserChanges Linked to Component Versions References De normalized version of table REFREL Produces a table listing References and their Kinds between Components Releases De normalized version of table RELENT Produces a table with details about all Releases RequisiteFile De normalized version of table REQREL Produces a table listing Requisite Relationships and their Kinds between Releases Rules De normalized version of table RELEENT Produces a table with full listings of the text of all Rules SchemaVersion De normalized version of table SCHEMVER Produce
17. e Demote Manager Secure Thaw Lock Read Freeze Modify Delete Add _TextRecordKinds _VersionFlags Timestamp Fingerprint Disabled Protected _LAST UPDATE The date stamp of the ASCII files used to create update this database APPENDIX B Queries Views Predefined queries created using the tables in the SQL database are the foundation on which the preformatted reports are based The following queries are de normalized versions of the original tables containing all their relevant values It is suggested that you use these and other custom made queries to create your own reports Some sample reports are provided and are described in Appendix C Archive De normailzed version of table ARCHENT Produces a table listing the Archive Filename of each Component in the catalog along with its Logical Name AuxFile De normalized version of table AUXENT List of Auxiliary Attributes and their Data CompilationRules De normalized version of table COMPREL Produces a table listing Rules and the Source and Target Components linked by the Rule CompiledRules De normalized version of table COMPDREL Produces a table listing all Sources that have been compiled to Objects and the Rule used Component De normalized version of table COMPENT Produces a table with details for every Component in the Catalog Dependencies De normalized version of table DEPREL Produces a table identifying Dependencies
18. een Source and Object Components which have been involved in a compile This relationship is a permanent link between two Components A Rule Id has been associated with this Rule superseding the Rule name COMPENT Component Info COMPREL Rules of compile relationships relationships defined between Source and Object Components which have not yet been used ina compile A Rule name identifies the Rule and it can be edited or renamed at this point DEPREL Dependencies for each Version What entities does a Version depend on to exist DISTREL Distributions A history of the Distributions comprised of a specific Version of a Manifest and its Location EVTLOG Event Log is not currently used LICREL Licences which have been secured for RMS PrimeCode catalogs or remote Installs LOCKENT Lock entities i e Locked for Work Edit etc ORGENT The organization of the Catalog as a group and details of each Group it contains as well as each Component in each Group Records are created by any process which links compiles or adds a Component PCRIREL Any relationships between a UserChange Id formerly Program Change Request and Releases PCRVREL Any relationships between a UserChange Id formerly Program Change Request and Versions of Components REFREL References from Versions to other Components RELENT Releases collections of Components which can be referred to as one unit that have b
19. een assembled REQREL Requisites Relationships between Releases and Requisites Releases required to install prior to another Release RULEENT Defined Compile Rules SCHEMVER Versions of the Catalog One record is created for each Catalog upgrade detailing its history SECENT Security records for the Catalog Not ACP security There may be two records for any given user They will appear identical except for the Kind and Masks fields which will determine if the Security Record is Allowing Security or Denying it for the branch of the Catalog STATEENT The established States and their Weights used to define stages in the SCM process being used STRREL Relationships between the established States determining their order in the life cycle progression SVERREL StateOfVersion contains one record per Version at a given State Promoting a Component from one State to another causes modification of this file TEXTENT Text is an entity containing all descriptive values in the system Other entities can have links to text if descriptive values are needed This file is analogous to the DDL DICTOTF file TEXTREF TEXTSUB TEXTVAL UCHGENT User Change Identifiers or Program Change Requests VERSENT Information on each Version within a Component In addition to these tables Custom Report Writer uses a number of auxiliary tables containing constant definitions used to replace nu
20. er 2 0 3 2 Step Confirmation Panel The four steps in the update process are illustrated on the left side of the main window and confirmation of their completion is displayed as each step is finished 3 Profile Parameters Panel The current profile parameters are displayed on the right side of the main form in Expanded View mode This is visual confirmation for the user that the correct database is being updated and being accessed by intended user 4 Buttons Two buttons Start Update and Cancel Update are alternatively greyed out when running the application Click on Start Update to begin the SQL database update 5 Progress Area The progress area will indicate progress for various stages of the updating process with file transfer animations and progress bars to confirm that the application is running 6 Status Bar Short descriptions of the current action are displayed on the status bar An icon indicating the status of the sound for this application is displayed Double clicking this icon will toggle the sounds on and off The status bar displays the current date and time User Manual 5 PrimeCotle CRW Custom Report Writer 2 0 3 Profiles What Are Profiles PrimeCode CRW can be launched but cannot perform its main objective of updating your SQL database without a valid User Profile A User Profile governs the file transfer process from the HP NonStop computer to your PC specifying which ASCII files
21. er of the user having security access to a given Component dRMS VAL ALLUSERS may be specified MASK S Number The type of access permitted PrimeCotle CRW Custom Report Writer 2 0 3 Appendix D 15 STATEENT Description The established States and their weights used to define stages in the SCM process being used STATEID Number A unique State identifier STATENAME String A unique State name WEIGHT Number Importance of State STATECLASSID Number Class of which this State is a part STRREL Descri Relationships between the established States determining their order in the life cycle progression STATEID Number A link to State identifier PRESTATEID Number A link to a State identifier which can precede Stateld PrimeCotle CRW Custom Report Writer 2 0 3 Appendix D 16 SVERREL Descripti StateOfVersion contains one record per Version at a given State Promoting a Component from one State to another causes modification of this file CHANGEDATE Date The time at which the change occurred COMPONENTID Number Component id STATEID Number State id VERSIONID Number Version id SYSTEMNUMBER Number System number of user responsible for changing States GROUPNUMBER Number Group number of user responsible for changing States USERNUMBER Number User number of user responsible for changing Sta
22. fest which was distributed DISTRIBUTIONDATE Date A time when the Distribution occurred KIND Number DistTypeDistrib DistTypelnstall DistTypeAcquire DistTypeFallback SYSTEMNUMBER Number User responsible for Distribution GROUPNUMBER Number User responsible for Distribution USERNUMBER Number end user REASON Number A link to the Reason for the Distribution PrimeCode CRW Custom Report Writer 2 0 3 Appendix D 6 EVTLOG Description HP NonStop Event Log File Not currently accessed by CRW CLASS Number The class of the event EVENTNUMBER Number The number of the event EVENTDATE Date The date and time the event was generated Time TEXT Text The actual text of the event LICREL Ti Descri Licences which have been secured for RMS PrimeCode catalogs or remote installs LICENSEID Number A unique license identifier RELEASEID Number The release licensed to the associated location LOCATIONID Number The location licensed for the associated release DENY Number yes no EXPIRYDATE Date The date the license expires LICENSEFLAGS Number LicenselInherit or LicenseNonInherit PrimeCotde CRW Custom Report Writer 2 0 3 Appendix D 7 LOCKENT Te Descripti Lock entities i e Locked for work edit etc COMPONENTID Number A Component identifier VERSION Stri
23. gement from the Options dialog From the Main Menu Options Application Settings or Ctrl S First Profile If this is the first profile you have created all the fields are blank Mandatory fields required in the creation of a profile are indicated by an asterisk Supply all mandatory fields and any others you want recorded in the profile New Profiles If any profiles have been created previously one of them will be currently loaded as the Default Profile You can simply type over some or all of the fields with the exception of NT SOL Database and Temp ASCII Files to clone and existing profile by modifying and renaming it Creating and modifying the NT SQL Database field is described on page 11 3 When finished creating modifying or adding a profile Click Save As New Profile Y DO NOT click the OK button This will close the Options dialog and save the modifications to the current profile failing to create a new one Field sensitive help is available for each of the fields on the form PrimeCotle CRW Custom Report Writer 2 0 3 PROFILE COMPONENTS The following pages describe each of the fields on the Profile Management dialog Field sensitive help is available for each of these in the on line help NAME Profile Name The profile name is used to identify a set of parameters which control the way a database update is carried out You can invoke an entire saved environment for your SQL database upda
24. hat is not newer than a current version of that file found on your PC Windows will prompt you to keep or overwrite the file you have It is usually safer to answer Yes and keep your newer version file A successful install will be acknowledged by the message Custom Report Writer has been sucessfully installed Un Installing the PC Application To thoroughly uninstall Custom Report Writer run the crw d20 2 0 1 msi file again or use the Add Remove programs utility in Control Panel Y If you have created a local database in the same directory Un install will be unable to completely remove all the contents from the Custom Report Writer directory Manually delete files not installed by PrimeCode CRW PrimeCode CRW maintains the parameters of your established Profiles in the Windows Registry When you uninstall PrimeCode CRW these registry entries are preserved so that new installations will have knowledge of Profiles you have created If you wish to uninstall PrimeCode CRW and completely remove all traces of it you must manually remove these registry enties Removing Custom Report Writer from Windows Click the Start button on the Windows Task Bar Select Settings Control Panel Double Click the Add Remove Programs icon Scroll through the programs listed and select Custom Report Writer Click the Add Remove button Click Yes to confirm your choice or No to cancel e Click Yes to keep any shared fi
25. he HP NonStop and to download the ASCH files from the HP NonStop to the ASCII file directory on the PC There are no other special requirements here that would not be already satisfied in order to run PrimeCode User Manual System Overview An analogous database will be created on a Windows PC comprised of data from the PrimeCode Enscribe database This local database can then be used to generate reports A two tier system involving both the HP NonStop and a Windows PC is used The first step in this process will be the creation of several ASCII files containing the extracted data from the Enscribe database A procedure for updating these text files at regular intervals can be established using a batch scheduler to launch a program The ASCII files will be stored in a volume subvolume location on the HP NonStop designated by the user during installation of the HP NonStop components of this software Guardian Username and Password combinations are required as communication with the HP NonStop is involved and users must logon to the HP Profiles enable users to specify both the input and the location for the output created when they use that profile thus maintaining private copies of the SQL database created on the PC platform Updates of these personal databases can be initiated when appropriate to the needs of the individual user who implements a profile With Username Password verification and login to the HP PrimeCode CRW will
26. hich is used to trigger variable replacement when extracting the Component for compile of read access REASON Number A link to an explanation of why the Version was created VERSIONFLAG Number Details about field contents CHECKVALUE String A value used to check the integrity of the Version outside of RMS known locations PRESENTATIONDATE Date The date corresponding to the local Version STATUSTIME STATUS APPROVALREQUIRED PrimeCode CRW Custom Report Writer 2 0 3 Appendix D 21
27. install LEFTID Number A link to a Component id RIGHTID Number A link to a Component id REQUISITECLASS Number RelPreRequisite RelCoRequisite RelAnteRequisite RelContraRequisite RelReplaceRequisite MASK S Number Evaluation type Establishes the time at which the release is evaluated for requisites of all types i e At Freeze Acquire Install Fallback or All OPTIONAL Number evaluation only if release exists PrimeCode CRW Custom Report Writer 2 0 3 Appendix D 12 RULEENT Descripti Defined Compile Rules RULEID Number The unique Rule identifier GROUPID Number Group Id under which this Rule applies as a default RULENAME String A unique Rule name within the group STATEID Number Always null for Rule LANGUAGE String The language associated with a given Rule PROCESSORID_1 Number The Component Id of the external compiler product used in the Rule can be null TEXTID_1 Number A link to the actual command text PROCESSORID Number TEXTID_ Number PROCESSORID_64 Number TEXTID_64 Number ENVIRONMENT Number The target environment to which this Rule applies This is a pointer to the environment which will be used during the compile NOT USED PrimeCode CRW Custom Report Writer 2 0 3 Appendix D 13 SCHEMVER Ti Description Versions of the catalog One record is created for each Cat
28. l Not Specified ASCII files Vol Subvol dat5 nhascii r Default Username Currently Used Not Specified rms neil Guardian side PC side SQL Database C My Documents neils mdb r ODBC System DSN Not Specified r Temp ASCII files folder 3 C Neil PrimeCodeCRW TmpASCll files Availability 9 11 05 2001 11 59 AM User Manual Main Menu File Options and Help menus are available on the Main Menu File Exit Alt F4 Options Application Settings Ctrl S Expanded View Ctrl E Help Contents Fl Visit the Emperex Website Ctrl D Visit Product Website Ctrl P About Ctrl A Closes Custom Report Writer Opens a dialog for adjusting profile parameters or creating selecting a new profile This dialog also provides access to customizable features in the GUI The profile parameters display can be toggled on and off by checking this option Launch On line Help This option will launch the default browser and go to the Emperex Corporation web site Visit Product Website This option will launch the default browser and go to the product website Newer versions of help will be available here as they are created Details of your version of Custom Report Writer The About Box provides a button for displaying useful system information and links to our websites PrimeCotle CRW Custom Report Writ
29. le used Host System The node name of the Guardian system where your PrimeCode Catalog resides Auto filled by information in your profile Username Your Guardian Username group user For ease of use you can store this parameter in your profile and have this field auto filled Password Your password is required to log in to the host system To Log in 1 Provide a Username and Password 2 Click the OK button The update process governed by the profile you have loaded will resume Watch for confirmation of each step as it is completed on the main form When Custom Report Writer has finished if there are no other databases to update close the program and launch whichever reporting tool you intend to work with User Manual 15 PrimeCotle CRW Custom Report Writer 2 0 3 The Database The SQL database is MS Access 2000 compatible User Manual PrimeCotle CRW Custom Report Writer 2 0 3 APPENDIX A Database Tables The following tables within the database created by Custom Report Writer correspond to the individual tables in the RMS Enscribe database A full field description for each table is given in Appendix D ARCHENT The Archive contents This contains all Data files and Objects which have been submitted as well as all compiled Objects AUXENT Auxiliary Attributes many of which are user defined qualities of a Component COMPDREL Rules of compiled relationships relationships defined betw
30. les Click the OK button to finish Click OK to close the Add Remove Dialog 10 Close the Control Panel PrimeCotle CRW Custom Report Writer 2 0 3 Configuration Main Window Features The PrimeCode CRW Main Window has two major components The left side of the window illustrates the various stages in the process of updating the SQL database Confirmation of each stage is given as it is completed The right side panel illustrates the parameters of the current profile in use The Default Profile Parameters are shown for your visual confirmation The extended view of the Main window showing the profile parameters can be toggled on and off by selecting Expanded View from the Options menu or by pressing Ctrl E Custom Report Writer File Options Help tep 1 User Authentication Get User Login Information DONE Verify User Login Information DONE Look for Newer Data Transfer ASCII Data Files Close FTP Connection Step 3 SQL Database Initialization Initialize SQL Database Tables Step 4 SQL Database Update Update SQL Database Tables Fi F3 r Current Profile neil r Host System Name borg r AMS Catalog Process Not Specified r RMS DB Vol Subvo
31. mbers in the original tables with meaningful strings that are provided for the query views _CompilationRelationship Kinds Traverse NonTraverse Document ComponentFlags Bug Fix Acquiring DistribParams Frozen Configurable IsChildDependant ProgId ComponentKinds Source Document Object Group Release Data Manifest Subrlease Variant Location SubSystem Keyed Blob ComponentModes Normal Release External System Volatile Reference Most Components are of type Normal System types cannot be changed by the user _CRWVERSION Associates the SQL database with the appropriate CRW software version DependancyKinds Source Data Object Processor Release Child DistributionKinds Acquire Distribute Fallback Install DistributionKinds2 Class Mask Active Mask Active Partial Superseded Manual Automatic _ Full Names of Components Pulls information from the COMPENT table and produces a table of full Component names by traversing the Catalog tree back to the root This table is used by many other queries that utilize full Component names _LicenseFlags Inherit NonInherit _LockKinds Edit Work Freeze Read Compile ReleaseEnvironmentK inds ReleaseStates Created Content Frozen Versions Frozen Dropped _RequisiteKinds PreRequisite CoRequisite AntiRequisite ContraRequisite Replace Requisite _SecurityKinds Deny Allow _SecurityMasks Admin Promot
32. ng The Version or Version date of the Component Date which is locked LOCKKIND Number Edit Work Read Compile Freeze SYSTEMNUMBER Number The user who locked this Component GROUPNUMBER Number The user who locked this Component USERNUMBER Number The user who locked this Component LOCKDATE Date The date when this lock was created EXPIRYDATE Date The date and time after which the lock will be unrecognized This primarily applies to read locks which can be cleaned up REASON Number A link to the reason for the lock USERCHANGEID Number The PCR being associated with the change EXTRACTFILE String The file to which the locked Component was extracted This name either a local NonStop Kernel name or a network name This is the last field and the null terminator must be included in the record The records CAN be variable length PrimeCotle CRW Custom Report Writer 2 0 3 Appendix D 8 ORGENT Description The organization of the Catalog as a group and details of each group it contains as well as each Component in each group Records are created by any process which links compiles or adds a Component Note StateId or VersionId will contain a value but never both as Versions do not have State ids or States Version Ids PARENTID Number A link to the parent Component of this entry LOGICALNAME String It is used to refer to a Component by State rathe
33. of PrimeCode CRW have been installed it is necessary to first un install before continuing See Un Installing below ning the msi Install File Insert the PrimeCode CRW CD into the CD ROM drive An auto run program may display a menu of choices Select Install PrimeCode CRW If you are not configured for AutoRun use the Start Run procedure below Y Running install file from the Auto Run Menu requires that you select to run the installation from its current location START RUN 1 Click the Start button on the Windows Task Bar and select Run 2 Navigate using the Browse button to the Setup exe program D PrimeCode_FCS_x x x CRW crw_d20_2 0 1 msi Where D is assumed to be the CD ROM drive OR To display the Auto Run Menu run this line instead D PrimeCode FCS_x x x default htm The Browse dialog will initially display only files of type program Switch this to All Files to see the default htm file 3 Click Open Click OK PrimeCode CRW will prompt you to close all running applications PrimeCode CRW will be installed by default to C ProgramFiles Custom Report Writer To change this click on the Change Directory button and then use the Drive File Combo boxes in the dialog to specify a different location Continued User Manual Accept the suggested program group name add Custom Report Writer to an existing group or name a new group which will be created Y If PrimeCode CRW attempts to load any file t
34. of the RMS Enscribe database Specify here where on the HP these files have been saved In the Guardian operating system the format of a Volume Subvolume location is volume subvolume Default Username This field is optional For normal security a Login for the HP NonStop is required when you initiate an update process Any valid Guardian Username can be given at this time but you can include your Username for convenience among the saved parameters in your profile so that it is automatically filled for you Example The User Profile specifies the Default Username RMS NEIL and this field is auto filled when you begin your update PrimeCotle CRW Custom Report Writer 2 0 3 PC SIDE COMPONENTS NT SQL Database The name of your SQL database is mandatory This database is the destination for the information contained in the files that PrimeCode CRW will download from the HP NonStop computer This field is not edited directly but supplied using the Browse button to its right T an Existing Database creat Prim R 1 Click the Browse button 2 Navigate to the location of an existing database and select it 3 Click Open To create a New Database 1 Click the Browse button The Open File dialog is presented 2 Navigate to the folder where you want the new database to reside E It is recommended that the database be located in any folder other than that where PrimeCode CRW was installed This will simplify yo
35. out descriptions Continued on next page PrimeCode CRW Custom Report Writer 2 0 3 Appendix B 4 _ Impact of Promoting Releases Uses Visual Basic code Function RleaseImact RID As String to analyze the contents of a Release and calculate the Impact of any Release changes to its contents and thus on the whole Catalog Note This may take a while Physical Location of Pulls information from the COMPENT table and Components produces a table of physical locations SYSTEM S VOLUME SUBVOLUME and the number of Components that are stored there This is a good way to figure out how far and wide a catalog extends _ Release Contents Uses Visual Basic code Function RleaseContents RID As String extract the contents of a Release and produces a table of all Releases and the Components they include _ Type of Components Created Pulls information from the COMPENT table and by Date produces a crosstab table with dates and counts of each type of Component created on that date _ Type of Components Created Pulls information from the COMPENT table and by Month produces a crosstab table with months and counts of each type of Component created on that month PrimeCode CRW Custom Report Writer 2 0 3 Appendix B 5 APPENDIX C Reports A number of sample reports are provided in the SQL database created by Custom Report Writer These can be accessed from within MS Access CompilationRules Each Rule known to
36. r A number of auxiliary report samples are included Components Accessed in the Last A listing of Components in this Catalog which Month have been accessed during the last month Components Accessed in the Last listing of Components in this Catalog which Week have been accessed during the last week Components Created by Each A 3 D pie chart representation of all the User Graph Components created broken down by user Components Created by Each Component details of all Components created by User Table each user Components Modified in the Last table listing of all Components modified in the Month last month Components Modified in the Last table listing of all Components modified in the Week last week Continued on next page Components without Descriptions by User2 Information from the COMPENT table is used to produce a listing by user showing Components created by each without a description Total number of Components created by each user is also given together with a percentage for Components without descriptions Impact of Promoting Releases Calculates the Impact of any changes to Release contents Physical Location of Components A listing of subvolumes and the number of Components which have their managed file at that location on disk _ Release Contents Releases are listed along with the Components which are included in them _ Type of
37. r than by Version COMPONENTID Number A link to a specific Component STATEID Number A link to a specific State can be null or the STATEID VERSIONID Number A link to a specific Version can be null or the VERSIONID NOTE both State and Version are never set PCRIREL Ti Description Any relationships between a UserChange Id formerly Program Change Request and releases RELEASEID Number A Release that included the associated UserChange USERCHANGEID Number A UserChange included in the associated Release PrimeCode CRW Custom Report Writer 2 0 3 Appendix D 9 PCRVREL Description Any relationships between a UserChange Id formerly Program Change Request and Versions of Components VERSIONID Number The Versionld that has the PCR linked to it USERCHANGEID Number The UserChangeld REFREL Description References from Versions to other Components REFERENCEORID Number A link to the Source s Version REFERENCEEID Number A link to the Source Version KIND Number CompKindSource CompKindObject CompKindData PrimeCotle CRW Custom Report Writer 2 0 3 Appendix D 10 RELENT Ti Description Releases collections of Components which can be referred to as one unit that have been assembled RELEASEID Number A link to the Component Id acting as a place holder for the release The logical name is stored
38. re the foundation on which the preformatted reports are based It is suggested that you use these and other custom made queries to create your own reports Some sample reports are provided and are described in Appendix C Components Accessed in the Last Month Pulls information from the COMPENT table and produces a table of all Components accessed in the last month Components Accessed in the Last Week Pulls information from the COMPENT table and produces a table of all Components accessed in the last week Components Created by Each User Pulls information from the COMPENT table and produces a table of users and the number of Components created by each Components Modified in the Last Month Pulls information from the COMPENT table and produces a table of all Components modified in the last month Components Modified in the Last Week Pulls information from the COMPENT table and produces a table of all Components modified in the last week Components without Descriptions by User Intermediate query used by the following query Components Without Descriptions by User2 Components without Descriptions by User2 Pulls information from the COMPENT table and produces a table of users and the number of Components created by each without providing a description for the Component Total number of Components created by each user is also given together with a percentage for Components with
39. s a table with all the Versions of the RMS Catalog used to create the SQL database Continued on next page PrimeCode CRW Custom Report Writer 2 0 3 Appendix B 2 Security Entry De normalized version of table SECENT Produces a table listing all Security Entries that exist in the RMS Catalog for every user StateOfVersion De normalized version of table SVERREL Produces a table listing all Component Versions and their State States De normalized version of table STATEENT Produces a table listing all State names available in the RMS Catalog StateTransitions De normalized version of table STRREL Produces a table listing pairs of States indicating valid transitions Text De normalized version of table TEXTENT Produces a table listing the full text of all descriptive values The records in this table are used as part of the de normalization process of the rest of the tables UserChange De normalized version of table UCHGENT Produces a table listing all User Changes Id s Versions De normalized version of table VERSENT Produces a table of different Versions of Components and details about them The records in this table are used as part of the de normalization process of the rest of the tables PrimeCode CRW Custom Report Writer 2 0 3 Appendix B 3 The following predefined queries are a result of some analysis of the original tables described in Appendix A These too a
40. te by loading a single profile Naming Rules Profile names may contain a maximum of 16 characters and may include spaces GUARDIAN OS SIDE COMPONENTS Host System Name The host system name of the HP NonStop computer you will access must be provided Alternatively the IP address of the HP NonStop can be used RMS Process Name This field is for your reference only It will not affect the way PrimeCode CRW will work The process RMSMON the monitor process for RMS which underlies the PrimeCode software resides with the Enscribe database on the HP NonStop machine For your visual confirmation you can record here the RMS Catalog s Process name i e SK RMP to confirm which Catalog or database you are going to be associating with If you do not know where your catalog is you can start RMSCOM by typing the following at a TACL prompt lt Volume gt lt Subvolume gt RMSCOM lt SMonitorName gt Enter The response should indicate your catalog location on a line similar to the following CURRENT CATALOG IS BORG SDATS KRMS User Manual RMS DB Vol Subvol This field is for your reference only It will not affect the way PrimeCode CRW will work For your visual confirmation you can record here the Volume and Subvolume for the location of your RMS database ASCII Files Vol Subvol A program residing on the HP NonStop computer will regularly produce a set of ASCII files which contain the relevant content
41. tes REASON Number A reason for promoting the Component PrimeCotle CRW Custom Report Writer 2 0 3 Appendix D 17 TEXTENT Ti Descri Text is an entity containing all descriptive values in the system Other entities can have links to text if descriptive values are needed This file is analogous to the DDL DICTOTF file TEXTID Number A unique text identifier TEXTSEQ Number A sequence number for the text id This field enables multiple commands to be executed for a given text id REFERENCECOUNT Number The number of instances of entities which reference the text item This field is only relevant in the TextSeq 0 record When referenceCount 0 it is safe to delete the textId This could be done immediately or in a house keeping related function TEXT String The actual text string associated with the text id TEXREF Descri VALUEPTR Number HASH Number REFERENCECOUNT Number PrimeCotle CRW Custom Report Writer 2 0 3 Appendix D 18 TEXTSUB Description Relationships between the established States determining their order in the life cycle progression TEXTRECKIND Number Either TextRecKindOriginal or TextRecKindReference VERSIONID Number A unique version identifier ORDINAL Number Ordinal line number where the substitution occurs OFFSET Number Offset in the line where the subs
42. titution occurs LENGTH Number Length of the text starting at offset to substitue for VALUEPTR Number Pointer to the text TEXVAL Ti Description VALUEEN Number VALUE Text PrimeCode CRW Custom Report Writer 2 0 3 Appendix D 19 UCHGENT Description User Change Identifiers or Program Change Requests USERCHANGEID Number A unique PCR identifier CHANGENAME String A unique user defined name reference with a change DESCRIPTION Number A link to text associated with the user change identifier STATEID Number State of the user change BUGFIXSTATEDID Number State of the user change for bug fixes TESTCOMPONENTID Number NOT USED AVAILABLETOGROUP Number The group Component Id in which this PCR can be referenced PrimeCotle CRW Custom Report Writer 2 0 3 Appendix D 20 VERSENT Te Descripti Information on each Version within a Component VERSIONID Number A unique Version identifier COMPONENTID Number A link to the Component which references this record VERSION String The Version or Version date of the Component Date which references this record CREATIONDATE Date The date when this Version was created SYSTEMNUMBER Number User who created the Version GROUPNUMBER Number User who created the Version USERNUMBER Number User who created the Version TRIGGERCHARACTER String The character w
43. ur uninstall procedure should you ever need to uninstall Uninstalling is required when updating your version of PrimeCode CRW 3 Type the name of the new database in the Filename field and click Open PrimeCode CRW will prompt you for permission to create the new database 4 Click Yes User Manual 11 ODBC System DSN The ODBC System Data Source Name is saved in your profile for reference PrimeCode CRW does not respond any differently depending on the input to this field It is basically a reminder to any user who has created a database what alias name points to the correct driver for accessing the database you created An ODBC driver contains information about how to connect to a certain type of database A system ODBC DSN unlike a user DSN is available to all users on the network L Future versions of PrimeCode CRW will generate and or associate System DSNs with generated SQL databases Temp ASCII files folder Specify the location on your local filling system where the ASCH files retrieved from the HP NonStop will be stored This is a mandatory field in the collection of data that is used to update your SQL database Use the Browse button to navigate to the desired folder PrimeCotle CRW Custom Report Writer 2 0 3 Loading Profiles Loading another profile changes the location from where PrimeCode CRW will retrieve the ASCII files and the location of the resulting database To load a profile making it
44. verview of the data in the database is included to assist in the design of custom reports Who Should Read This Manual This manual is intended for users of PrimeCode CRW and or the database it creates In this guide you will find procedures for updating a SQL database and field descriptions for the data which is available to query for reporting purposes Related Documentation e PrimeCode CRW Installation Configuration and Administration Guide PrimeCode CRW On line Help e PrimeCode Installation Guide PrimeCode User Manual Customer Support We offer two types of support Send us an e mail or call the numbers below E mail support emperex com Phone Regular Hours Monday Friday 9 a m 6 p m Eastern Standard time at 905 677 6666 After Hours Support 905 667 6666 i PrimeCotle CRW Custom Report Writer 2 0 3 System Requirements PC Requirements Minimum Operating System Memory Free hard disk space for application for database Recommended Operating System Memory for 700 000 components for 7 000 000 components for 32 000 000 components for 51 000 000 components Free hard disk space for application for database HP NonStop Guardian Requirements Windows 95 32 MB 5 MB 1 5 MB 1000 components Windows 95 98 2000 XP or Windows NT 32 MB 64 MB 96 MB 128 MB 5 MB 1 5 MB 1000 components A working FTP server will be required to upload the CRWD20xx file from the CD to t
Download Pdf Manuals
Related Search