7.7 Jobnet Flow Output window

From the Jobnet Flow Output window, you can output jobnet definitions to Microsoft Excel in flow format. This window uses Microsoft Excel.

Figure 7‒12: Jobnet Flow Output window

The following describes the displayed items.

Output whole job hierarchical tree

Select this option to output information for the specified unit and all its subordinate units.

Output n levels of job hierarchical tree. Specify n:

Select this option to output information for a specified number of hierarchical levels below the specified unit.

Specify the number of hierarchical levels as a value from 1 to 2,147,483,647. The default is 1.

If you specify 1, the system outputs information for the units directly below the specified unit in the hierarchy.

Insert a page break before a jobnet

Select this check box to insert a page break between jobnets.

Start

Starts the jobnet flow output process.

Cancel

Cancels processing and closes the window.

When you click Start in the Jobnet Flow Output window, Microsoft Excel starts and the jobnet definitions are reproduced in flow form in Microsoft Excel.

Figure 7‒13: Example of jobnet flow output (When the data layout has one column, without a last update time)

Figure 7‒14: Example of jobnet flow output (When the data layout has one column, with a last update time)

Figure 7‒15: Example of jobnet flow output (When the data layout has two columns, without a last update time)

The jobnet flow output feature outputs a jobnet flow image to a new Microsoft Excel workbook.

The entire jobnet flow image occupies one sheet in Microsoft Excel. When jobnet flow output is performed for multiple jobnets, the jobnet flow images cascade downward.

The name of each jobnet is displayed in full, prefixed by Name:.

The jobnet flow image appears after the jobnet name.

A jobnet flow image can contain a maximum of 100 x 100 jobs per jobnet.

When you collect job operation information from JP1/AJS2 - Manager 08-10 or later or JP1/AJS3 - Manager 09-00 or later, last update time appears at the top of the image only if you configured the system to collect it.

Cautionary notes:

• In the following circumstances, only the full jobnet name is output:

  • There are no units to display in the jobnet

  • The unit is a root jobnet or manager jobnet

  You can check the definition items in the Job Operation Document Output window or by outputting the information to a CSV file.

• Do not specify 1 for n in Output n levels of job hierarchical tree. Specify n: if you selected a job group in the unit tree in the Job Operation Document Output window. If you specify 1, nothing is output. Specify a number that includes a hierarchical level in which jobnets are defined.

• The amount of information jobnet flow map output functionality can output depends on the maximum number of lines and columns allowed by Microsoft Excel. If the output information exceeds these limits, Microsoft Excel will terminate abnormally.

  You can find out how many lines and columns Microsoft Excel allows by viewing the Help or other documentation for Microsoft Excel.

• Do not use Microsoft Excel while jobnet flow output is in progress. Doing so might affect not only the jobnet flow image being output, but also any other files you are working on.

• If jobnet flow output produces a cell in Microsoft Excel that contains more than 255 characters, ##### might appear as the cell data in Microsoft Excel.

• If a piece (generation) of data output to Microsoft Excel in a jobnet flow image exceeds 4,000 bytes, the jobnet flow output functionality outputs a cross () and the text The data has too many characters to display in its place. Each cell output to Microsoft Excel cannot contain more than 32,000 bytes or 255 lines of data. Data exceeding these limits is truncated, and information about the name and attributes of the unit that caused the problem are output to a log file (installation-folder\Log\ajs2po.log or %allusersprofile%\Hitachi\JP1\JP1_DEFAULT\JP1AJS2PO\Log\ajs2po.log). If this occurs, take action such as dividing the input data over several jobnet flow images.

• You cannot perform multiple instances of jobnet flow output concurrently, or perform jobnet flow output at the same time as map output. If you attempt to do so, the tasks are processed sequentially in the order in which they were executed.

• You cannot perform jobnet flow output if the default printer is unavailable.

  Jobnet flow output uses landscape as the page orientation when outputting information to Microsoft Excel. If the default printer is unavailable, Microsoft Excel generates an error in relation to the printer settings and jobnet flow output fails.

  In this situation, use one of the following workarounds:

  • Make the default printer available

  • Set a dummy local printer as the default printer

  • Delete all printers

  Keep in mind that if your default printer is a networked printer, the status of the print server will affect the availability of the printer.

• Jobnet flow output will fail if the jobnet flow definition file specified in the Environment Settings window cannot be found. Make sure that the file specified in the Environment Settings window exists at the specified location.

• The processing time for jobnet flow output depends on the rendering performance of Microsoft Excel. Images take longer to render as the number of units and relation lines increases. If the source information contains a large number of units or relation lines, you can split the units across several images or limit the number of hierarchical levels in the output data.

• The cell's character string might not be fully displayed. Edit the cell's height in Microsoft Excel as necessary.

• If the items are not displayed fully in the print and print preview, you can extend the display area to display the cutoff items. For details on how to extend the size of the display area, see 7.19 Environment Settings window.

To Page Top