iDrive tip: Copying Microsoft FRx Specification Set Information

How to Copy Microsoft FRx Specification Set Information from One Location to Another Location
This article describes two different methods of moving your specification sets from one location to another.

Method 1
Copy the .F32 file or files to the new location.

  1. Copy the *.F32 file from the shared SysData folder in the first location to the same directory in the second location. Make sure that you rename any .F32 files in the new location to *.OLD before you copy them.
  2. Start Microsoft FRx at the second location, and then create a new specification set with exactly the same name as the specification set at the first location. To view the Specification Sets window, click Company, and then click Specification Sets. You do not have to do this step if only the Default specification set is used. Make sure that you point each specification set to the correct .F32 file in the drop-down box.Note specification sets are uniquely identified by the corresponding specification set name and the corresponding .F32 file.
  3. In the Specification Sets window, click New.
  4. Type the name of the specification set in the Name box.  The name must be exactly the same as the specification set name at the original location.
  5. In the Location box, click the drop down arrow and browse to the .F32 file.
  6. Click Save.
  7. Assign the specification set to the company by clicking Company and then clicking Information.  Select the new specification set from the drop down list.

Method 2
Export and import building Blocks, whole specification sets, or individual reports.

  1. In the first location, click Company, and then click Specification Sets to view the Specification Sets window.
  2. Select the specification set that contains the reports to be exported.
  3. Click the Export button. To select the desired components from the List of Catalogs, click to select the Mark Related Rows, Columns, and Trees check box. The building blocks that make up the catalog are automatically selected.
  4. When all the selections are made, click the Export button.
  5. The default location for the output file opens to the IO_DATA directory. The default file name is frxexp.tdb.  Both the file location and the file name can be overwritten. However, the .TBD file extension must be used.
  6. At the second location, open the Specification Sets window to locate an existing specification set, or create a new specification set.
  7. Click Import.
  8. Select the .TDB file from the appropriate location to start the import. As soon as the import is complete, the building blocks that are imported are available when the Company Information record is set to use that specification set.

Note When catalog IDs are exported from a company and imported to a system where that company does not exist, the following warning message occurs:
Company does not exist, setting to default Company
When this message occurs, the system sets the current catalog to the default company.