<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<!--
Copyright (c) 2006 UGS Corp.

All Rights Reserved.

This software and related documentation are proprietary to UGS Corp.
-->
<html>
   <head>
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <title>Migrating Spreadsheet Data</title>
      <script language="javaScript">
        abridged="false";
        displayConditions=new Array();
      </script>
      <link type="text/css" href="../css/main_styles.css" rel="stylesheet">
   </head>
   <body class="bodydocs" onload="top.pageLoader()" bgcolor="#FFFFFF">
      <div class="title_topic3" id="xps10_pagetitle">Migrating Spreadsheet Data</div>
      <hr noshade="true">
      <p class="para_topic">To assist you with migrating data between spreadsheet applications, NX provides a migration utility.</p>
      <div class="title_division">Platforms</div>
      <p class="para_division">On UNIX and Windows Alpha, you can migrate an Excel spreadsheet to Xess. On Windows Intel, you can migrate spreadsheet data from Xess to Excel and vice versa. On all systems, you don't need to have access to the spreadhseet where the data is stored. You only need access to the spreadsheet to which you are migrating.</p>
      <div class="title_division">Required Software</div>
      <p class="para_division">When migrating from Xess to Excel, you only need Excel. Similarly, migrating spreadsheet data from Excel to Xess requires only Xess (which also means that Exceed must be present).</p>
      <div class="title_division">Before You Begin</div>
      <p class="para_division">Before you begin, make a copy of the part containing the old spreadsheet data. Keep the copy until you verify that the new spreadsheet data is correct.</p>
      <div class="title_division">To migrate spreadsheet data:</div>
      <ol type="1" start="1">
         <li>
            <p class="para_item">Click on File&rarr;Utilities&rarr;Migrate Spreadsheet Data.</p>
         </li>
         <li>
            <p class="para_item">Select the spreadsheet format. NX stores three types of spreadsheets in parts: Modeling, Gateway, and Part Families. If a part does not contain all three types of spreadsheet data, the options for the types that are not present are unavailable. Select a new format for each type of spreadsheet data you want to migrate.</p>
         </li>
         <li>
            <p class="para_item">To perform the migration, click on OK. To perform the migration and leave the dialog displayed, click on Apply. Note: You cannot use Undo with spreadsheet migration. The system displays: Spreadsheet migration was [was not] successful. Check the Information window for more information about this migration. When the migration is complete, NX stores the migrated spreadsheet data in the part file, replacing the spreadsheet data in the old format. If you close a part file without saving it, the migrated spreadsheet data will not be saved.</p>
         </li>
      </ol>
      <div class="title_division">Errors</div>
      <div class="title_division">Error: Migrating without Excel</div>
      <p class="para_division">If you try to migrate Xess data to Excel without Excel installed, the system displays the following message:</p>
      <p class="para_division">[Modeling, Gatway, or Part Families] spreadsheet data in this part is in Excel format. Excel is not available on this computer and is needed to perform the migration. Please migrate this data on a computer with Excel.</p>
      <div class="title_division">Verifying Migrated Data</div>
      <p class="para_division">Because some data does not cleanly migrate from one spreadsheet to another, you should check every spreadsheet that you migrate.</p>
      <p class="para_division">You can manually verify migrated data. To do so, open an appropriate spreadsheet in NX (Gateway, Modeling, or Part Family). Look for Xess/Excel error messages, incorrect numeric values, differences in cells format, etc.</p>
      <p class="para_division">If the migration utility had problems during migration from Xess to Excel, it places an error message in the cell comment associated with the cell with the problem. Error messages start with the word UGERROR. Therefore, to find error messages, search for &quot;UGERROR&quot; in cell comments (Edit&rarr;Find menu).</p>
      <div class="title_division">Cleaning Up Migrated Data</div>
      <p class="para_division">No migration is perfect. Migrating data from a spreadsheet application with one set of supported features to an application with another always means losing data for the unsupported features. This will require some manual fix-up.</p>
      <div class="title_division">Xess and Excel Comparison</div>
      <p class="para_division">The following tables summarize and compare operators, built-in functions, and cell formats in Xess and Excel.</p>
      <div class="title_division">Cell Formats and Operators</div>
      <p class="para_division"> <a class="links" href="javascript:void(0)" onclick="top.openFile('utilities/fil_util_msu_cells_r.html');return(false);">Cell Formats</a> <a class="links" href="javascript:void(0)" onclick="top.openFile('utilities/fil_util_msu_ops_r.html');return(false);"> Operators</a> <a class="links" href="javascript:void(0)" onclick="top.openFile('utilities/fil_util_msu_fonts_r.html');return(false);"> Font Name Correspondence</a></p>
      <div class="title_division">Functions</div>
      <p class="para_division"> <a class="links" href="javascript:void(0)" onclick="top.openFile('utilities/fil_util_msu_funcs_r.html');return(false);">Functions</a> <a class="links" href="javascript:void(0)" onclick="top.openFile('utilities/fil_util_msu_datetime_r.html');return(false);"> Date and Time</a> <a class="links" href="javascript:void(0)" onclick="top.openFile('utilities/fil_util_msu_diglogic_r.html');return(false);"> Digital Logic</a> <a class="links" href="javascript:void(0)" onclick="top.openFile('utilities/fil_util_msu_eng_r.html');return(false);"> Engineering</a> <a class="links" href="javascript:void(0)" onclick="top.openFile('utilities/fil_util_msu_finance_r.html');return(false);"> Financial</a> <a class="links" href="javascript:void(0)" onclick="top.openFile('utilities/fil_util_msu_logic_r.html');return(false);"> Logic</a> <a class="links" href="javascript:void(0)" onclick="top.openFile('utilities/fil_util_msu_stats_r.html');return(false);"> Statistical</a> <a class="links" href="javascript:void(0)" onclick="top.openFile('utilities/fil_util_msu_string_r.html');return(false);"> String</a></p>
   </body>
</html>