The export process creates an Excel file, AdeliaCST_fr.xlsm, containing the translation manager's constants for translation.
When you open the constant file in Excel, it is advisable to enable the control that prevents the accidental modification of any cells whose values must not be changed. To do so, activate the 'Lock' macro using Excel's Tools/Macro/Macro/Run (after selecting 'Lock') menu option.
Export/Import tab
No.
Internal number used to identify the constant. This number is used during the import procedure.
The values in this column must not be changed.
Source text
Text of the source constant.
Any constant that is shaded is linked with the constant located above it.
The values in this column must not be changed.
Type
Constant type.
The values in this column must not be changed.
Translation
Text representing the source constant's translation in the language specified in the column header. Translations must be entered in this column.
Length
Constant length.
If the length is displayed in red, the translated constant must not exceed the stated number of characters.
The values in this column must not be changed.
Extension
Extension of the constant (N for None, R for Right, L for Left, F for Free).
Max Length
Maximal length authorized for the translation, which can be customized by modifying the Visual Basic AdeliaFonctionLgMax (MaxLgAdeliaFunction) function (e.g. by allowing 5% more for a button label, 200% for a pop-up menu, etc.).
By default, this function forbids translations to be longer than 250 characters, and checks in the case of a "N" extension that the translation length does not exceed that of the source text.
Control
This column displays the word "WARNING" if the translation exceeds the length indicated in the "Max Length" column for the lengths in red.
The values in this column must not be changed.
Comment
Remark associated with the constant.
The values in this column must not be changed.
Comment translation
Translation of the comment associated with the constant.
Program
Name of the source program or report of the constant in the case of a non-merged constant.
Program Description
Description of the program entered.
Program type
Source of the constant (program or report type) : V for Visual Adelia, AR for Adelia Report, CR for Crystal Reports, W for Adelia Web, A for Adelia.
Window / Transaction
Name of the window or transaction where the constant is designed. With controls on Interactive Visual programs, the control name is added.
Object
Graphical object (and property) name to which the constant is linked.
It can be used in the VB function to determine the possible extension depending on the graphical object type (button, menu, window title...).
Access
Double click on this cell to open the report designer in order to view the constant (Visual Adelia interactive window, report or transaction designer).
Latest translation
Date and time of the most recent change to the constant's translation in the Excel file. The values in this column must not be changed.
Export rank
Rank number in Excel during export creation.
Merged
This column contains a 'X' if the constant has several (merged) sources.
The values in this column must not be changed.
Source
This column contains one of the constant's sources.
The values in this column must not be changed.
Assoc.
This column contains a 'X' if this constant is one of several associated constants.
Application area
Application area to which the program or report mentioned in the "Source" column is attached.
Button: Stop timestamp/Start timestamp
By clicking the button Stop timestamp, the Excel macro used to indicate automatically when a translation was last modified is deactivated. Consequently, the "Last modification" column's header becomes "Last translation (Timestamp temporarily halted)".
By clicking the button Start timestamp, the Excel macro used to indicate automatically when a translation was last modified is reactivated. The title for the "Last modification" column's header remains "Last translation (Timestamp temporarily halted)".
Notes:
- When the macro indicating the last modification date is active, the option Cancel xxxx in the Edit menu is not active. This is why in the case of certain operations where deactivating the Cancel option is annoying, it can be interesting to stop timestamp to be able to use the option.
- The columns in the Excel file are not automatically sized according to the cell contents, and some cells may overflow. You can configure the column width by changing their size in the Excel template file %ADELIWS%\AdeliaMSG_en.xlsm (or %ADELIWS%\AdeliaMSG_fr.xlsm for the French version).
Information tab
Date & Time
Time stamp updated during export.
Version number
Adelia version (Version.PTF.Fix). Example: 10.3.2 indicates "version 10 PTF3 Fix 2".
Environment
Adelia environment from which the export was made.
Translation language
Translation language to which translations are linked.
Constants
Indicates whether the export relates to all the environment's constants, or only some selected programs.
With dictionary constants
Indicates whether the dictionary constants were exported.
Constants state
Indicates whether only translated , or not translated, or all constants were exported.
Source language
Source language of the export (either development language or a translated language).
Click below for further details about: