Technical FAQs

Ask a Question

How to convert network ‘Descriptor’ to ‘Page Title’ in a ProWORX 32 project

Goals and Symptoms

Convert the network ‘Descriptor’ to ‘the ’Page Title’ in a ProWORX 32 project.

Facts and Changes

ProWORX 32 version 2.xx

Causes and Fixes

‘ProWORX 32’ lacks the ability to print the network descriptor on the same page as the Logic network
printout. It only allows the printing of the ‘Page Title’ on the network printout. This may be a problem
for ‘ProWORX NxT’ users that convert a project containing only network descriptors to a ‘ProWORX 32’
project.



The following procedure provides a workaround to convert the network ‘Descriptor’ to the 'Page Title' so
that they can be printed with the network. (The resolution is very lengthy but, it should only take about 5
minutes o perform the conversion.)

Before the network ‘Descriptor’ can be converted to the 'Page Title', the text from the nine separate
'Descriptor’ lines will need to be merged in a temporary worksheet.

  • Open the 'ProWORX 32' project.
  • Export the documentation to an Excel spreadsheet by right-clicking on the project name and
selecting 'Export\Documentation'.



  • Open the Excel spreadsheet that the documentation was exported to.
  • Click on the horizontal scroll arrow that can be found at the bottom left corner of the spreadsheet until
the 'Network' tab is displayed.

.
  • Click on the 'NETWORK' tab to open the sheet.


  • Scroll across the sheet to view the ‘Descriptor' column.
  • Highlight the nine columns labeled ‘Descriptor 1’ through ‘Descriptor 9’.
  • Right click and select copy.


  • Create a new temporary blank worksheet.
  • Paste the ‘Descriptor' columns to the new worksheet.
  • Insert a column between the ‘Descriptor' columns (In my example, the extra columns are shown highlighted in grey)
  • Resize the new column to 2 character widths.
  • Click on the first cell of the new column, add a space using the spacebar and hit the 'Enter' key
to insert a carriage return. (The carriage return is used to separate the 'Short Comment' lines
when they are merged.)
  • Repeat the last step for the other new columns.
  • Click on the the letter for the column field (i.e., 'D' in my example below) to highlight it.
  • Type the keys 'Ctrl-D' to fill down the column.
  • Repeat the last two steps for the other extra columns.



(The steps in this page is used to create the formula for merging the network ‘Descriptor' lines.)
  • Click on the cell in Row 1 Column A and type in '='.

  • Click on the cell in Row 1 Column C and type in '&'


  • Click on the cell in Row 1 Column D and type in '&'.


  • Click on the cell in Row 1 Column E and type in '&'.
  • Click on the cell in Row 1 Column F and type in '&'.
  • Click on the cell in Row 1 Column G and type in '&'.
  • Click on the cell in Row 1 Column H and type in '&'
  • Click on the cell in Row 1 Column I and type in '&'.
  • Click on the cell in Row 1 Column J and type in '&'.
  • Click on the cell in Row 1 Column K and type in '&'.
  • Click on the cell in Row 1 Column L and type in '&'.
  • Click on the cell in Row 1 Column M and type in '&'.
  • Click on the cell in Row 1 Column N and type in '&'.
  • Click on the cell in Row 1 Column O and type in '&'.
  • Click on the cell in Row 1 Column P and type in '&'.
  • Click on the cell in Row 1 Column Q and type in '&'.
  • Click on the cell in Row 1 Column R and type in '&'.
  • Click on the cell in Row 1 Column S and type in '&'.
  • Hit the Enter key.

(If steps are followed correctly, you should see something similar to the following. )


Note: If you make a mistake, clear the error using the backspace key, There is a Microsoft bug
where if the enter key is hit and the user tries to go back and edit hte cell, Excel will only
return the formula and not the merged text.

  • Click on column 'A' to highlight it.
  • Type the keys 'Ctrl-D' to fill down the column with the formula that was type in. (This is the step where all of the four 'Short Comment' lines are merged into one comment.)



When the fill-down operation is complete, the merged network descriptors will be displayed in column 'A'.


  • Highlight the merged network descriptors.
  • Right-click and select copy. (This copies the merged network descriptors to the clipboard)


  • Switch back to the 'ProWORX 32' exported documentation database spreadsheet.
· Locate the line that has the number 1 and click on it to select it.


  • Scroll across the ‘NETWORK’ sheet and locate the 'Page Title'.


  • Click on the cell under the ‘Page Title’ column to deselect it.
  • Right-Click and select 'Paste Special’.


  • Click on the radio button labeled 'Values' in the 'Paste Special' window.
  • Click on 'OK' to close the 'Paste Special' window.




(This shows the merged network descriptors imported into the project's documentation database.)



  • Save the documentation database.
  • Backup the 'ProWORX 32' project.
  • Open the 'ProWORX 32 project'.
  • Right-click on the project name and select 'Import Documentation\Overlay'.


  • If you type in a network number in the 'Documentation' window, it will show the 'Page Title'
that was converted over.


  • Click on 'File\Report Setup' to bring up the 'Report Setup' window.
  • Click 'Print Preview'.


  • Open the page for the Network to view the ‘Page Title’










Was this helpful?
What can we do to improve the information ?