Depending
on your computer settings, your spreadsheets may not look exactly like
the examples below. For example, your Excel®
settings may cause blank rows to insert in between rows with text. These
extra rows do not harm the spreadsheet.The following are examples of export .TXT for the various STORIS domains after they have been converted to Excel® spreadsheets for translation. The spreadsheet formats used by the Translation Tool are similar for all translation domains. The first sample, for the Screens domain, describes each column in detail. The remaining domain samples describe only context-specific variations.
Domains: Screens, Data, Dictionary, Help, Lookups, Menus, Messages, DTS Query Tabs
Depending
on your computer settings, your spreadsheets may not look exactly like
the examples below. For example, your Excel®
settings may cause blank rows to insert in between rows with text. These
extra rows do not harm the spreadsheet.
Each spreadsheet contains the record ID in the first column of each data row. During the export process, the Translation Tool inserts a tilde character (~) as a prefix to each record ID. This combats issues caused by leading zeros in the record ID. Some of the spreadsheet examples below do not include the tilde character (~) in the data rows of the first column. For example, in the Screens domain spreadsheet (see example below), "PGM.TEST.PGM" will display in your spreadsheet as "~PGM.TEST.PGM". When importing translation spreadsheets back into STORIS, the Translation Tool ignores the leading tilde (~) character in the record key.
Typically, there is only a single Translation Type (for example, Description) per data file, though there are some data files with more than one field available for translation.
Used for the tool tips that display when you hover the mouse over a field.
