SuperOrca - Pantaray Research
Contents
1. O d ICEs to Run S XPLOGO CUB WinXP Logo Validation ICEO1 ICED2 ICED4 O MERGEMOD CUB Merge Module Validation z Yalidate Show INFO Messages Show Warning Messages 5 ICE Type Description ICEO1 Info ICEO1 Simple ICE that doesn t test anything ICEO1 Info Created 04 29 1998 Last Modified 08 17 1998 ICEO1 Info Called at 11 28 53 ICEO2 Info ICEO2 ICE to test circular references in File and Component tables ICEO2 Info Created 05 18 1998 Last Modified 10 12 1998 ICE04 Info ICEO4 ICE to validate File table sequences according to Media table ICEO4 Info Created 05 19 1998 Last Modified 09 24 1998 Info Max Sequence in Media Table is 130 On the Predefined Validation File area select the validation file you want to use alternatively you can use another validation file by checking this option and selecting another file If you want to only certain ICEs check the ICEs to Run check box and enter the ICEs numbers separated by colon You can hide Info messages by unchecking the Show INFO Messages option You can hide Warning messages by unchecking the Show Warning Messages option Finally click the Validate button to perform the validation 13 Merge MSM File Use Merge MSM File to merge a Merge Module in to the current MSI file Click Merge MSM File and the following dialog will open Merge MSM File C MSM DB2 DB2 Base Client Merge Module msm Language Root Directory Primary Fea2. SuperOrca MSI Editor User Manual version 1 0 Version 1 0 July 8 2008 www pantaray com Pantaray Research LTD Table of Contents Introduction cider pz vere rre dde 1 SuperOrca advantages compared to Orca 1 Application Screen LLuuuuuuuuuuusue 1 File Menu tec ease e UE ars stress Ese MP EU 2 a pe cpm 2 SAVE AS irritado a dro educ ete eria 2 ar Mcr 2 Elias ddr aid idas ved 2 Edit Menu SA 3 Find s ducibus P pet ote leas Heth else e rel 3 FNA NEX ii pd RM Ceu eR CR eae eR NC CER 3 Searc MAI Tables sxiwce cake ie RR NO we VR ou dew Re o e 3 Search All Clear lilii 3 A A NE 3 Table Menu suse eese 4 Add System Table 23er EX EUER dad ROUND E eR RRCR 4 Add Custom Table 12222 x a A 5 Update Table Schema nnan anaana aaa a 6 Drop Table cresrerssi PEREERLERVE REI err RR Re as 6 Duplicate Table cuu peer etx PER E ELE ew eee teeny PEE 6 oil MMTMEEMTCCT ocrrm 7 EXPO Tables sirenas dote det ard be dd o et ea eee 7 Imp rt Table d di E pex ao 7 Tools Menu o an anaana aaea aeaaeae 8 PIEUWBW DISIOQS crudo med eee bu e eem mee eerie eee et 8 Compare MSI Files i24 ex eR cris xA OR ER eR CR RR eee 9 Summary Information cekck c x RR ERE RR RR ERR RE 11 El A arit do E KC READER KR RR 12 Merge MSM File 20 rere xr RE REOR RUP RR ROR RR wed 13 RUMS ee rrr eee he bee L668 beet ee eee ne So 14 lastall MSI UD c obi Rather EE
3. PESE eb PERLE T EE ERE 14 Uninstal MI DO oeste vere rb e poter A 14 Rebuild MSI File isere Ree reg EE REPERI ER EE CR dcs 14 Table List Popup Menu 0005 15 Update Table Schema 0c cece 15 Drop Table odo ips tb BUR ea ad RA Auge 15 Duplicate Fable 5 s d a prev pase RE mop Pn e Rt 15 Display System Tables 2e dc b B Rp Hte REP d 15 Add ROW o DP ete te P exit redu PERPE a 15 EXPO Tables raros FICUTI a aa E 15 Import Table us oo xe key o t te uto S boe ded 15 Table Content Popup Menu 16 PRUNE oett per A ead goal fes cad 16 Search All Tables cata Re ee e RBRUM URDU 16 GOO rc SE is o Seien Pes UP ad 16 PUE Olla Shion aes Oh eui Ade NUS D iter dec Ma 17 Copy CCU Las t re ta he NS im Eid re DE ND MEA du RET 17 Paste Cell 22 es 17 lter Cell x scada ER 17 o A A Ue e E Ha EN NER 17 Paste GUID solis ede otr ae See r PEE e 17 Import Text Flles scort Ena n ERG 17 Read Binary from file 0 sure A 17 Write Binary to file 2 ios odia rs eae Bae ce dra 17 CODY ROW Sorese de Gh aa ot ide e Doge 17 Paste ROW tu i eae OELE GRE EEEE a Seeger gees 17 Add ROW e MC 18 Alter ROW AO pumaana aua et Se eRe eee Behe te 18 Drop ROWS aori Pireweh db eee whose ee abe Ss noes bes tv E 18 Introduction SuperOrca from Pantaray Research Ltd is a direct replacement to the Orca utility from Microsoft SuperOrca may be used to examine and modify an MSI database Supe
4. System Table Use Add System Table to add one of the MSI predefined tables to the database The program will display a list of all System Tables The gray colored names are already present in your database so you can only add the black colored names You can select several tables and add them in one click li Add System Table SEE Tables Validation ActionText AdminExecuteSequence AdminUISequence AdvtExecuteSequence AdvtUISequence Appld AppSearch BBControl Billboard Binary BindImage CCPSearch CheckBox Class ComboBox CompLocator Component Control ControlCondition ControlEvent Tables 103 1 Ppp Add Custom Table Use Add Custom Table to add a table of your own design to the database When you select this option the following dialog will appear Add Custom Table Table Name MyTable Column Name Add Column Q MyColumn Delete Column Rename Column Type 2 Integer 16 Bit Integer 32 Bit O String O Localizable String O Binary Adding a new table involves the following sequence of operations 1i 2 3 Enter a name for the table in the field Table Name Click the Add Column button and add as many columns as you wish In the table Click the names of the columns just added and for each column define the following e Type of the field e Length in bytes of the field e Nullable Yes No You can use the Up amp Down button to set the order o
5. above Confilcts Errors where detected during the Merge process Click Accept to continue with merging or Cancel to abort Click Accept to complete the merge operation or Cancel to abort the operation Run MSI Use Run MSI to launch your current MSI file This option will have the same effect as double clicking the MSI file from windows explorer Install MSI i Use nstall MSI i to launch your current MSI file using the i command line option This is the best option to run your MSI file for installation Uninstall MSI x Use Uninstall MSI x to launch your current MSI file using the x command line option This is the best option to uninstall your MSI file Rebuild MSI File Use Hebuild MSI File to create an exact duplicate of your current MSI file When doing an extensive work on an MSI file the file might grow in size because of empty holes left in the database The rebuild operation will condense the MSI file so that holes are completely eliminated The resulting file will be placed in the current directory beside the current MSI file The name of the resulting file will be the same as to original with added to the start of the name 15 Table List Popup Menu When you right click the table list area a special menu will popup Use this menu to perform certain table oriented operation Most of the operations in this menu refers to the currently selected table Some of the operations are also accessib
6. 5 characters lnn Lnn Binary Data v Y nn indicates number of bytes 4 Status Bar Located at the bottom of the screen the status bar will indicate the number of tables in the current database and the number of rows in the selected table File Menu Open Use Open to open an existing MSI file Using this option you can open a regular MSI file as well as a Merge Module file MSM The names of the files you open will be added to the history list at the bottom of the File menu so you can easily reopen them in the future Save As Use Save As to save the existing MSI file under a new name thus creating a copy of the old file New Use Newto create a completely new MSI or MSM file When you select New you will be prompted to select a starting template The following template are available Empty Msi Schema Msi Sequence Msi UlSample Msi Schema Msm Exit Select Exitto close the program IMPORTANT Every operation made with SuperOrca that modify the database is immediately written to the MSI file so when you close the program you will not be prompted to save any changes made to the database Edit Menu Find Use Find to find a certain text literal inside any table fields After entering the text literal the program will search the current table starting from the current location If a match is found the relevant cell will be highlighted If a match is not found the application will search the ne
7. a Dialog SetVersionxP VersionOS Windows XP Directory TargetExe File 0004 orf i Compare MSI Files MSI Filet C _PROJECTS MURRAY Target __ MSI File2 C MSI_PROJECTiqstp Q qstp_XXX ms hide half empty pairs CustomAction Action s72 Type i2 Source 572 Target 5255 Streams _InstallEnvironment 3074 ShellDil InstallEnvironment Component _InstallEnvironment 3073 ShellDil InstallEnvironment Control ControlEvent Prompt ppRunning 51 MandatoryText Application is running now It is recorr CreateFolder y Custom ction SetVersion00 51 VersionOS Windows 2000 Directory Feature TargetExe 210 File_0000002 sel FeatureComponents E File InstallExecuteSequence InstallUISequence Media Property OF ile SelfReg Tables 16 File_0000004 11 Summary Information Use Summary Information to display and edit the Summary Information of the current MSI file Summary Information Title Languages 1033 Security No restriction Source Image C Short File Names v Source is Compressed C Administrative Image C Elevated privileges are not required 12 Validate Use Validate to validate the current MSI file Click Validate and the following dialog will open las Validate MSI C MSI_PROJECT qstp Q qstp msi Predefined Validation File E Another Validation File DARICE CUB Full MSI Validation LOGO CUB Win2K Logo Validation
8. and the second line reflects the content of MSI File2 There are 2 types of differences e lfarow exists in one table and absent from the other table this row will display in black characters and the other line will be empty e f arow exists in both tables but only diverse in some fields the relevant fields will display in red characters You can check the Hide Half Empty Pairs option to hide lines that exist only in one table 10 If you click a line in the list the relevant table and location in the current MSI file will highlight with red background ls SuperOrca C _PROJECTS MURRAY Target Developing_New_Business_Ideas_Present mE File Edit Table Tools Help CustomAction Action s72 Type i2 Source 572 Target 5255 AdvtExecuteSequence A ErrorDotNet 19 ProductName Require BBControl B ErrorIsAdminInst 19 Error You are not admini Billboard ErrorIsAdminUnInst 19 Error You are not adminis Binary ErrorversionOS 19 Error This application is n CheckBox PromptProgRunning 51 MandatoryText Program is running now I ComboBox SetMandTextSpaceEnour 51 MandatoryText MandatoryTextSpace Complus SetMandTextUserInf MandatoryText MandatoryTextUser Component SetWersion03 VersionOS Windows 2003 Control SetVersion95 VersionOS Windows 95 ControlCondition SetVersion98 VersionOS Windows 98 ControlEvent SetVersionME VersionOS Windows ME CreateFolder SetVersionNT VersionOS Windows NT 4 0 SetVersionvS VersionOS Windows Vist
9. f the columns in the table Set the number of the Primary Keys in the table According to the MSI standard primary keys are always the first fields of the table Update Table Schema Use Update Table Schema to modify the structure of existing table This operation can be performed on system tables as well as custom tables Updating a table is done using a dialog and techniques similar to the ones used for Add Custom Table Drop Table Use Drop Table to delete the currently selected table from the database Duplicate Table Use Duplicate Table to create a new table with the exact structure and content of the currently selected table Duplicate Table Enter new table name InstallExecuteSequencel Cancel When you select this option the program will display an input dialog with a name similar to the name of the currently selected table Modify this name as you wish and click OK Add Row Use Add Row to add a row of data to the currently selected table When you select this option the program will display a dialog similar to the following Add Row Action s72 Condition 5255 Sequence I2 Cancel This dialog will contain text input controls for all the columns in the currently selected table Enter data in each input box as required and click OK You can click the GUID button to add a GUID Global Unique ID to the selected input box Export Table Use Expo
10. isplay on the Top Right area When you click a control in the list it s properties will display on the Bottom Right area Control Next Next Compare MSI Files Use Compare MSI Files to compare 2 MSI files Normally you will compare the current file with another file located on your disk Click Compare MSI Files and the following dialog will open i Compare MSI Files MSIFiel C PROJECTSIMURRAWTargetl___1 MSI File2 C MSI_PROJECT qstp Q astp_XXX ms CustomAction Action s72 Type i2 Source 572 Target 5255 _Streams _InstallEnvironment 3074 ShellDll InstallEnvironment Component _InstallEnvironment 3073 ShellDll InstallEnvironment Control ControlEvent Prompt4ppRunning 51 MandatoryText Application is running now It is recor CreateFolder Custom ction SetVersion00 51 VersionOS Windows 2000 Directory TargetExe 210 File_0000004 Feature TargetExe 210 File_0000002 FeatureComponents File InstallExecuteSequence InstallUISequence Media Property OF ile SelfReg Tables 16 Select MSI File1 8 MSI File2 using the Browse buttons The system will compare the 2 files and display the differences On the left side you will see a red list of all the tables that contain differences Hide half empty pairs Click any of the tables and the right side will display a list of the actual differences This list is built of pairs of lines In any pair the first line reflects the content of MSI File1
11. le from the Main Menu Update Table Schema Drop Table Duplicate Table v Display System Tables Add Row Export Table Import Table Update Table Schema See explanation to this item under Table Menu Update Table Schema Drop Table Use Drop Table to delete the currently selected table from the database Duplicate Table See explanation to this item under Table Menu Duplicate Table Display System Tables The MSI database contains the following 3 system tables e Columns e Streams e Tables Normally those tables are hidden You may check this option to add those table to the table list Some operations are not allowed on System tables Add Row See explanation to this item under Table Menu Add Row Export Table See explanation to this item under Table Menu Export Table Import Table See explanation to this item under Table Menu Import Table 246 Table Content Popup Menu When you right click the table content area a special menu will popup Use this menu to perform certain Row or Cell oriented operation Most of the operations in this menu refers to the currently selected Row or Cell Some of the operations are also accessible from the Main Menu Find Search All Copy Cell Alter Cell Paste GUID Import Text File Copy Row Add Row Alter Row Drop Row Find See explanation to this item under Edit Menu Find When using this option from the popu
12. p menu the text in the currently selected cell will be copied to the Find dialog Search All Tables See explanation to this item under Edit Menu Search All Tables When using this option from the popup menu the text in the currently selected cell will be copied to the Find dialog Goto If the currently selected cell points to an existing item in another table then selecting this item will take you to the relevant table and row 17 Cut Cell Use this option the copy the content of the currently selected cell to the clipboard and then clear the cell This option can be executed only on a nullable cell Copy Cell Use this option the copy the content of the currently selected cell to the clipboard Paste Cell Use this option the copy the content of the clipboard to the currently selected cell Alter Cell Use this option the change the content of the currently selected cell Clear Cell Use this option to clear the currently selected cell This option can be executed only on a nullable cell Paste GUID Use this option to add a GUID Global Unique ID string to the currently selected cell Import Text File Use this option to read the content of a text file to the currently selected cell Read Binary from file Use this option to read the content of a binary file to the currently selected cell This option can be executed only on a Binary cell Write Binary to file Use this option to write the content of the c
13. rOrca Highlights e Can be freely downloaded from the internet no need to download and install the complete Microsoft SDK e Will allow you to scan and manipulate all MSI database table in an intuitive and user friendly manner e SuperOrca will not lock the MSI file so you can test it with other tools or even install it while the file is open in SuperOrca e A powerful Compare function that will compare two MSI files e A Search all function that will search a text literal across all database tables in one operation Application Screen The SuperOrca screen contains the following 4 elements 1 Main Menu Most of the operations of the application are accessible from this menu 2 Table List The left area of the screen will contain a list of all the tables contained in the current MSI file Clicking a table name will select this table the name of the table will appear at the top of the list and the table content will be displayed on the right area 3 Table content The right area of the screen will display the content of selected table This display is composed of columns and rows The header of each column will contain the name of the column An asterisk in front of the name will indicate a Key column Each column name include a description of the column type in parenthesis Type Regular Nullable Integer 16 bit i2 I2 Integer 32 bit i4 I4 String 1 255 characters snn Snn Localizable String 1 25
14. rt Table to export the currently selected table to a stand alone text file Import Table Use Import Table to import a previously exported table into the current MSI database IMPORTANT The format of the exported file is the same as the one used by Orca Thus you can use the last 2 functions to exchange table files with Orca Tools Menu Preview Dialogs Use Preview Dialogs to get a preview off all the dialogs defined in your setup When you click Preview Dialogs the following dialog will display A it Preview Dialogs Dialogs Component Type AdminBrowseDlg Back PushButton AdminInstallPointDlg Bitmap Bitmap AdminRegistrationDlg BottomLine Line AdminwelcomeDlg Cancel PushButton BrowseDlg Next PushButton CancelDlg Texti Text CompleteDlg Text2a Text CustomizeDlg Text2b Text DestinationFolder Text4 Text DiskCostDlg ErrorDlg ExitDialog FatalError FilesInUse LicenseAgreementDlg MaintenanceTypeDlg Maintenance WelcomeDlg MandatoryDlg OutOfDiskDlg OutOfRbDiskDlg PrepareDlg ProgressDlg ReadmeDlg i ReadmeDlg2 Width ResumeDlg Height SetupTypeDig Attributes ShortcutsDlg UserExit Property UserRegistrationDlg Text ButtonText Ba VerifyReadyDlg VerifyRemoveDlg veriFyRepairDlg Help WaitForCostingDlg WelcomeDlg ButtonText_Back E When you select a certain dialog from the list on the left side the relevant dialog image will display on the screen Also the list of controls in this dialog will d
15. ture Additional Features M_2 7 M Complete E Complete C AdminToolsFolder AppDataFolder C Bin C CommonAppDataFolder C CommonFilesFolder C CommonFilesFolder 364323 C CRNET 3643236F FC70 11 CRWebService 70A290FA Y Parameters Restore Defaults Name DB2 COPY NAME KEEP SHORTCUT NO DEFAULT INSTANCE NAME DB2 DB2 RSP FILE Note Prameter Description The is the name of the DB2 Copy Click the Browse button to select the MSM file you want to merge into the current MSI file Set data as needed in the different dialog and click Merge 14 Prior to clicking merge you can check the Show Conflicts option this will result a display of a screen similar to the following las Merge Conflicts 5 Sequencing Conflict MSM Table ModuleInstallExecuteSequence Keys SelfRegModules MSI Table InstallExecuteSequence Keys SelfRegModules 4 Merge Conflict MSM Table Validation Keys Patch Header MSI Table Validation Keys Patch Header 4 Merge Conflict MSM Table Validation Keys MsiDigitalSignature Table MSI Table Validation Keys MsiDigitalSignature Table 4 Merge Conflict MSM Table Validation Keys CustomAction Type MSI Table _Validation Keys CustomAction Type 4 Merge Conflict MSM Table _Validation Keys LaunchCondition Description Accept MSI Table _Validation Keys LaunchCondition Description Accept Cancel The
16. urrently selected cell to a binary file This option can be executed only on a Binary cell Copy Row Copy the content of the currently selected row to the clipboard Paste Row Paste the content of the clipboard to the current table This option can be executed only if a valid row of identical structure was placed in the clipboard using the Copy Row operation 18 Add Row See explanation to this item under Table Menu Add Row Alter Row Use this option to alter the content of the currently selected row When you select this option a dialog similar to the following will display Add Row Feature_ s38 Feroupo09 Component_ s72 Comp_0000012 Cancel Drop Row Use this option to erase the currently selected row 19 Contact Information Please send us any comment and request concerning this product Email support pantaray com Pantaray Research Ltd Kibbutz Dvir D N Hanegev ISRAEL Phone 972 8 9111326 Fax 972 8 9111372 Email admin pantaray com
17. xt table When all tables are searched the application will prompt for a search starting from the first table Find Next Click Find Next to find the next occurrence of the text literal Search All Tables Use Search All Tables to search a certain text literal inside all the tables in the MSI file The program will scan all tables and find all the occurrences of the text literal in all the tables The table names and cells that contain the text literal will be highlighted with green background is SuperOrca C MSI_PROJECT qstp Q qstp msi PEE Edit Table Tools i EJ i A InstallUlSequence i ControlCondition FatalError Find what versionh Find Next ControlEvent UserExit CreateFolder _RemoveQsey _ Match whole word only CustomAction _InitInstallDir Dialog Setversion9s L Match case Directory SetVersion98 Error SetVersionME x 490 EventMapping SetVersionMT JT 400 Feature SetYersion00 D FeatureComponents SetVersionxP SetYersion03 SetVersionvS LaunchConditions FindRelatedProducts AppSearch CCPSearch NOT Installed RMCCPSearch NOT Installed CostInitialize E FileCost Tables 44 Rows 28 Search All Clear Use Search All Clear to hide the green highlight from the last Search All Tables operation Refresh Use Refresh to reload the current MSI file from the disk This operation is useful if the MSI file is being modified by another application while it is still opened in SuperOrca Table Menu Add
Download Pdf Manuals
Related Search