What to do if Software Manager is not Importing all Tables

Please see the information below if you have an issue trying to get certain 'other' tables to import into Wise Package Studio's software Manager. I wish I had read a tip like this before spending considerable time trying to find out what was wrong.

The Problem I was Experiencing

In WPS v7 SP2, if I check the environment tables or choose to import all tables on the Setup - Preferences option, when I import an MSI with Environment Variables I don't get to see them in Software Manager. On MSDE with a simple package with an Environment variable set and the Software Manager preferences set to import Environment tables. There is no Environment table in the Table Query option in Software Manager and no table in the MSDE Software Manager Database. I think there are probably more tables that don't import either. Please be aware in case you are depending on 'other' tables to be imported. Not sure if this is specific to MSDE and / or SQL Server and which versions.

A Solution that Saved the Day

Set Software Manager preferences:

1. Select Setup menu > Preferences.
   The Preferences dialog appears.
2. Specify the tables to include when a Windows Installer package is imported to the Software Manager database.

   Import required tables only
   This is the default. Mark this to import only the tables that are required for working in Software Manager and ConflictManager.

   Import all tables
   Mark this to import all columns in all tables in the .MSI. This includes any custom columns or tables.

   Import required tables and additional tables
   Mark this to include the required tables plus other tables you specify. When you mark this option, you must specify tables to include; see the next step.

   Custom tables are not imported when you select this option, because they are not listed in the checkboxes.

3. If you select Import required tables and additional tables, the checkboxes become enabled.

   Expand the top level checkboxes to see lists of tables.

   To import a table, mark the top level checkbox as well as the table name below it. To mark all the checkboxes, click Check All.

   Both the top level and the table checkboxes in the second level must be marked or the tables will not be imported. When you mark a second-level checkbox, its parent is marked as well. When you clear a parent checkbox, its second-level checkboxes are cleared.

4. Click OK.

   Now, when a Windows Installer package is imported to the Software Manager database, the tables you specified are imported, provided they contain data. This does not affect packages that have already been imported.