Extracting Bending Data from Bendable Pipes and Tubes

atarget.gif (1372 bytes) This task shows you how to extract bending data from Bendable Pipes and Tubes and transfer it into a Microsoft Excel worksheet. Bending data can be fed into Bending machines to precisely create bends in bendable tubes and pipes.
ainfo.gif (980 bytes)
  • The standard macro supplied with this product displays bending data  in a sample format. However, a user with some Microsoft VBScript experience can change the script supplied to change the format.
  • The sample script assumes that the bendable objects are placed on a run under a distribution system or a logical line.
  • For more information on placing parts, see Placing Parts in a CATProduct Drawing.
ascenari.gif (1364 bytes) 1. Using Windows Explorer, locate the intel_a\code\command subdirectory.
2. Copy the files PslTubingExtract.CATScript and PslTubingExtractTemplate.xls to C:\temp (with read-write access). Select the two files and click the right mouse button. Click Properties in the drop-down menu that displays. The Properties dialog box will display. Uncheck the Read-Only option.

AT0201A.gif (27747 bytes)

3. In the specifications tree, select  the logical line or distribution system under which the run containing the bendable objects has been placed.

AT0201B.gif (12778 bytes)

4. Click Tools - Macro - Macros. The Macro dialog box will display. Select External File from the drop down list, select PslTubingExtract.CATScript and click Select. The Select External File dialog box will display. Select PslTubingExtract.CATScript and click Open. This will again display the Macro dialog box. Select PslTubingExtract.CATScript and click Run. Data will be extracted from the bendable objects and displayed in an Excel worksheet, part of which is displayed below. (CATIA will create the table, but you must have Excel installed!)

AT0201C.gif (16611 bytes)

aendtask.gif (1477 bytes)