TableExportToIdt

MAKEMSI quickly and reliably creates MSI files in a non-programmatic way

Source Code

Commands

TableExportToIdt

The "TableExportToIdt" Command

This command allows you to export some or all tables in a database (in ".idt" format), all binary streams will also be extracted. The "Export to .IDT" facility (or "ORCA") are the easiest ways of manually exporting. You should probably read the "IDT Export Flakey" section.

To extract all files out of CAB files you could unarchive any extracted ".cab" files but its easier to use the installed "MSI MENU... do do this (administrative install).

This command takes these parameters:

TABLE (optional)
This is the complete name of a single table to be exported. It can export non-standard tables such as "_SummaryInformation" and "_ForceCodepage". If you supply this parameter you should not also supply "TABLES"!
TABLES (optional)
If you are not exporting a single table then you wish to export any table listed in "_Tables" matching a regular expression. If this parameter is not supplied then the regular expression for all entries is used. Your regular expression should cover the full text of the table name. If you supply this parameter you should not also supply "TABLE"!
The regular expression "B.* matches any table which starts with upper case "B", and ".*B.* would match any table which contains an upper case "B".
DIR (optional)
This optional parameter specifies the directory where the ".IDT" files should be placed. Any extracted binary files will be placed into subdirectories.
The default for this parameter can be set via the DEFAULT_TABLEIE_EXPORT_DIRECTORY macro.

EXAMPLE - Import .IDT files

This example is the complete script required to export all tables in a database:

;--- Include the correct support (MAKEMSI.MMH/DEPT.MMH for MSI Creation) ----
#include "OpenMsi.MMH"

;--- Do the work ------------------------------------------------------------
<$Msi "UISAMPLE.msi" ReadOnly="Y">
   <$TableExportToIdt>                               ;;All "normal" tables
   <$TableExportToIdt TABLE="_SummaryInformation">   ;;Output summary information
   <$TableExportToIdt TABLE="_ForceCodepage">        ;;Output database code page information
<$/Msi>

Microsoft awarded me an MVP (Most Valuable Professional award) in 2004, 2005, 2006, 2007, 2008 & 2009 for the Windows SDK (Windows Installer) area.

Please email me any feedback, additional information or corrections.
See this page online (look for updates)