<!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>Filling the Database</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_topic2" id="xps10_pagetitle">Filling the Database</div>
      <hr noshade="true">
      <div class="title_division">The Library Tool Data File</div>
      <p class="para_division">The ASCII files, which are used to store the library data, are identified by the following environment variables. The actual file paths can be seen by going to Help-&rarr; NX log file.</p>
      <p class="para_division">For tools:</p>
      <p class="para_division"><i class="variableText">${UGII_CAM_LIBRARY_TOOL_ENGLISH_DIR}</i>\tool_database.dat
      </p>
      <p class="para_division"><i class="variableText">${UGII_CAM_LIBRARY_TOOL_METRIC_DIR}</i>\tool_database.dat
      </p>
      <p class="para_division">For holders:</p>
      <p class="para_division"><i class="variableText">${UGII_CAM_LIBRARY_TOOL_ENGLISH_DIR}</i>\holder_database.dat
      </p>
      <p class="para_division"><i class="variableText">${UGII_CAM_LIBRARY_TOOL_METRIC_DIR}</i>\holder_database.dat
      </p>
      <p class="para_division">For machines:</p>
      <p class="para_division"><i class="variableText">${ <a class="links" href="javascript:void(0)" onclick="top.openFile('mfggeneral/com_lib_terminology.html');return(false);">UGII_BASE_DIR</a>}</i>\MACH\resource\library\machine\ascii\machine_database.dat
      </p>
      <p class="para_division">For devices:</p>
      <p class="para_division"><i class="variableText">${ <a class="links" href="javascript:void(0)" onclick="top.openFile('mfggeneral/com_lib_terminology.html');return(false);">UGII_BASE_DIR</a>}</i>\MACH\resource\library\device\ascii\device_database.dat
      </p>
      <p class="para_division">For feeds and speeds:</p>
      <p class="para_division"><i class="variableText">${ <a class="links" href="javascript:void(0)" onclick="top.openFile('mfggeneral/com_lib_terminology.html');return(false);">UGII_BASE_DIR</a>}</i>\MACH\resource\library\feeds_speeds\ascii\feeds_speeds.dat
      </p>
      <p class="para_division"><i class="variableText">${ <a class="links" href="javascript:void(0)" onclick="top.openFile('mfggeneral/com_lib_terminology.html');return(false);">UGII_BASE_DIR</a>}</i>\MACH\resource\library\feeds_speeds\ascii\cut_methods.dat
      </p>
      <p class="para_division">${ <a class="links" href="javascript:void(0)" onclick="top.openFile('mfggeneral/com_lib_terminology.html');return(false);">UGII_BASE_DIR</a>}\MACH\resource\library\feeds_speeds\ascii/part_materials.dat
      </p>
      <p class="para_division"><i class="variableText">${ <a class="links" href="javascript:void(0)" onclick="top.openFile('mfggeneral/com_lib_terminology.html');return(false);">UGII_BASE_DIR</a>}</i>\MACH\resource\library\feeds_speeds\ascii\tool_materials.dat
      </p>
      <p class="para_division">For setups:</p>
      <p class="para_division"><i class="variableText">${ <a class="links" href="javascript:void(0)" onclick="top.openFile('mfggeneral/com_lib_terminology.html');return(false);">UGII_BASE_DIR</a>}</i>\MACH\resource\template_dir\template.dat
      </p>
      <p class="para_division">The ASCII Data File is a list of records. The general structure of a record is:</p>
      <p class="para_division">record-type parameters</p>
      <p class="para_division">There are two record types which are referred to by the following keywords:</p>
      <ul>
         <li>
            <p class="para_item"> <a class="links" href="javascript:void(0)" onclick="top.openFile('mfggeneral/com_lib_filling_database.html#com_opts_com_lib_filling_database_format');return(false);">FORMAT</a></p>
         </li>
         <li>
            <p class="para_item"> <a class="links" href="javascript:void(0)" onclick="top.openFile('mfggeneral/com_lib_filling_database.html#com_opts_com_lib_filling_database_data');return(false);">DATA</a></p>
         </li>
      </ul><a name="com_opts_com_lib_filling_database_format"></a><p class="para_division">A FORMAT record describes the list of parameters ( <a class="links" href="javascript:void(0)" onclick="top.openFile('mfggeneral/com_lib_terminology.html');return(false);">DB_ID</a>s) to be found in the subsequent DATA records and consists of the keyword FORMAT followed by a list of attribute identifiers.&nbsp;The attribute identifiers are used as DB_ID values within the DB_ALIAS structures of the Definition File (dbc_tool_ascii.def). You can define your own attribute identifiers which you need to describe your tools. The FORMAT line includes all the parameters which you wish to input for each data record in that class.&nbsp;For example:
      </p>
      <table cellspacing="0" align="center">
         <tr>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">FORMAT</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">&nbsp;LIBRF</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">&nbsp;T</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">UGT</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">UGST</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">ST</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">DESCR</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">MATREF</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">MATDES</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">HLD</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">HLDDES</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">DIA</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">FLEN</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">FN</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">HEI</p>
            </td>
         </tr>
      </table><br><p class="para_division">DB_IDs used in FORMAT statement above:</p>
      <table bgcolor="#f7f7f7" cellspacing="2" align="center">
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">LIBRF</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Library Reference</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">T</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Tool Type</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">ST</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Tool SubType</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">UGT</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">NX Internal Type</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">UGST</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">NX Internal Subtype</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">DESCR</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Description</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">MATREF</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Reference to cutter material table</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">MATDES</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Cutter material description</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">HLD</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Holding system (Type of Machine Adapter)</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">HLDDES</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Holding system description</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">DIA</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Diameter</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">FLEN</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Flute Length</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">FN</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Number of Flutes</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">HEI</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Height</p>
            </td>
         </tr>
      </table><br><table border="0">
         <tr>
            <td valign="top" align="left"><img align="left" src="../graphics/note.gif" alt="Note" title="Note"></td>
            <td valign="bottom" align="left" width="100%">
               <div class="para_note">
                  <p class="para_note_body">A hash sign (#) indicates a comment - everything after this sign to the end of the line is ignored.</p>
               </div>
            </td>
         </tr>
      </table><a name="com_opts_com_lib_filling_database_data"></a><p class="para_division">Each DATA record contains the data for one tool in the database. A DATA record consists of the keyword DATA followed by a list of attribute values separated by '|'. The DATA record corresponding to the above FORMAT line might look like this:</p>
      <p class="para_division">DATA | ugt0201_001 |02| 01|01|01| End Mill |TMC0_00006|HSS-Co5-TiN | 320 | Steep Taper 20 | 10.5 | 35.3| 4| 55</p>
      <p class="para_division">In the data record:</p>
      <ul>
         <li>
            <p class="para_item">There must be the same number of parameters as there are DB_IDs in the FORMAT line above (an empty parameter is permissible).</p>
         </li>
         <li>
            <p class="para_item">Each parameter must be separated by the pipe symbol ( | ). At the end of the record there is no pipe symbol.</p>
         </li>
         <li>
            <p class="para_item">The first non blank character after DATA must be a pipe symbol. </p>
         </li>
         <li>
            <p class="para_item">If a record does not start with either FORMAT or DATA, it is treated as continuation of the previous FORMAT or DATA record. </p>
         </li>
      </ul>
      <p class="para_division">The following attributes are common to all tool types and subtypes:</p>
      <table bgcolor="#f7f7f7" cellspacing="2" align="center">
         <tr bgcolor="c0c0c0" valign="middle">
            <th colspan="2" rowspan="1" valign="top">
               <p class="para_th">Attributes Common to all Tool Types and Subtypes</p>
            </th>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">LIBRF</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Unique identifier (library reference) for a tool</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">T</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Classification type of a tool.</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">ST</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">&nbsp;Classification subtype of a tool.</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">UGT</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">NX Internal Type</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">UGST</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">NX Internal Subtype</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">DESCR</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Short tool description</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">MATREF</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Reference to cutter material table (tool_materials.dat)</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">MATDES</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Cutter material description</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">HLD</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Holding system for mounting tool to machine . HLD is used to check whether the tool can be mounted to a pocket of the tool carrier of the machine. The HLD value here has to match one of the holding systems specified in the pocket definition in the postprocessor .def file of the machine.</p>
               <p class="para_td">If you are using this attribute to mount a device to a device holder in a machine tool model, the HLD value has to match the holder system under which you classified the device holder in the Machine Tool Builder application.</p>
            </td>
         </tr>
         <tr valign="middle">
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">HLDDES</p>
            </td>
            <td colspan="1" rowspan="1" valign="top">
               <p class="para_td">Holding system description</p>
            </td>
         </tr>
      </table><br><table border="0">
         <tr>
            <td valign="top" align="left"><img align="left" src="../graphics/warning.gif" alt="Warning" title="Warning"></td>
            <td valign="bottom" align="left" width="100%">
               <div class="para_warning">
                  <p class="para_warning_body">&nbsp; The attributes LIBRF, T, ST are mandatory.</p>
               </div>
            </td>
         </tr>
      </table>
   </body>
</html>