1.7.2 Notes on using the definition information management template
-
If a warning is displayed when you open the definition information management template, click the Enable macros button.
-
Since the definition information management template uses a significant amount of memory, try not to open multiple templates.
-
Do not change the format of any cells.
A format appropriate for the definition item is already set for each cell. If you change this format, the processing results of import and export may become invalid.
-
Do not delete any columns.
If you delete any columns, import and export processing will not function properly. If there are any unnecessary columns, customize them so that they are not displayed. For details about this customization, see 3.1.4 Environment settings and 3.2 Environment settings parameters.
-
After copying or cutting cells to be pasted in another area, paste them in the same column. If you paste them in a different column, the input restrictions will not match those set for the rest of the column, and the processing results may become invalid.
-
If the value of a cell is longer than 256 characters, it will be displayed as a hash sign (#), but this will not affect import or export.
-
If the number of characters in a cell exceeds 1,024, only the first 1,024 characters are displayed in the cell. To edit after 1,024 characters, first select the cell, and then use the formula bar.
-
Note that editing a cell containing a long string might take time.
-
If the string in a cell exceeds 1,024 characters, JP1/AJS3 - Definition Assistant prints only the first 1,024 characters.
-
If multiple lines are defined in a cell which allows inputting values from the drop down list, edit with the arithmetic bar after selecting the cell. If multiple lines are defined in the cell, using the drop down list to select a value results in discarding values in the multiple line.
-
You cannot use the macro functions of the current version for the execution result files created by the previous versions. Before using them, you must convert the execution result files to the format of the current version. To convert the execution result files of the previous versions, execute the following commands:
ajsdaconvert -i folder-for-execution-result-file-before-conversion -o folder-for-execution-result-file-after-conversion
For the details about the ajsdaconvert command, see ajsdaconvert in 7. Commands.
-
Due to the Excel specifications, a single quotation mark (') at the beginning of the value entered in a cell is treated as a prefix and cannot be recognized as a character. Therefore, if definition information beginning with' is imported, the beginning ' will not be recognized in the definition information management template. If you use the execution result file for this import to export definition information to the manager host by using a batch definition, individual definition, or the modification function, note that the ' that could not be recognized when importing will be lost.
-
When processing takes a long time, No response might be displayed in the title bar of the window. However, processing is being performed and there is no problem.
-
When you specify a host name with an IPv6 address, it might not be possible to use special IP addresses or notation. For details about the special IP addresses and notation that cannot be used, see the JP1/Base User's Guide.
-
Do not save the definition information management template as a different file format using the save function of Excel. If it is changed to a different one when saved, JP1/AJS3 - Definition Assistant may cause an error during startup, or not work properly.
-
Do not change the R1C1 reference style set for the definition information management template.
-
If you are using an Excel file whose reference style is set to A1 style (which uses English letters for column headings), opening the definition information management template in the same Excel process causes the reference style of the Excel file you were just using to change to R1C1 style (which uses numeric values for column headings).
-
If you are using the definition information management template, opening an Excel file whose reference style is set to A1 style in the same Excel process causes the Excel file to be displayed in R1C1 style.
-
If, while using the definition information management template, you want to use an Excel file whose reference style is set to A1 style, you have to open the Excel file in an Excel process# that is different from the one in which the definition information management template is being used.
- #
-
The method used to start an Excel file in a different Excel process varies with the Excel version. One way to do this is to use the /x option. For details about how to start an Excel file in a different Excel process, contact Microsoft Corporation.
Generally, Excel files open in the same Excel process (same instance).
-
When all of the following conditions are satisfied, the reference style of the Excel file that was open in the same Excel process in which the definition information management template was open changes to A1 style.
-
The environment settings parameter FINISHING-REFERENCESTYLE is set to the value IV.
-
The reference style of the Excel file at the time when the definition information management template was started was A1 style.
-
All the definition information management templates were closed.
-
-
If a definition information management template created with versions earlier than JP1/AJS3 - Definition Assistant 12-10 is open in the same Excel process in which a definition information management template created with JP1/AJS3 - Definition Assistant 12-10 or a later version is open, the setting specified by the environment settings parameter FINISHING-REFERENCESTYLE might not become enabled. To enable the setting specified by FINISHING-REFERENCESTYLE, first close the definition information management template whose version is earlier than 12-10, and then close the definition information management template whose version is 12-10 or later.