The Import Welsh Translations screen requires .xls Excel files that are formatted as below.

 

In general, the Welsh translations will be in Column C with the corresponding IDs in Column A.

Column B is generally the English version of the description/title and is not imported except in the case of Narratives where column B indicates the Narrative code to be translated.

The first row of the file controls what type of translation will be imported.

The type/content of each export file is dictated by the A1 cell. The import looks for one of the following keywords:

• SCREEN
• TASK
• MENU
• POST
• COURSE
• VACANCY
• NARRATIVE

Examples, with the keywords highlighted below:

For the "SCREEN" format, Cell B1 should include keyword "TAB" or "TITLE" to identify whether the translations are of "Screen Titles" or the "Screen Tab Titles". The first keyword found in the cell will be used.

Screen ID	Screen Tab Title	Welsh Translation
MD55S3	Personal Details
MD55S31	Passport Number
MD55S34	Case History

 

Screen ID	Screen Title	Welsh Translation
MD55S3	Personal Details
MD55S31	Person Passport Number
MD55S34	Employee Case History

 

Task ID	Task Title	Welsh Translation
HREMPALL	All Details
HREMPAPP	Internal Applicants
HREMPAPPL	Appraisal File

 

Menu ID	Menu Title	Welsh Translation
HRMAINMENU	ResourceLink Main Menu
HRMANDATE	Mandate Returns
HRMEMBER	Member Administration

 

Post ID	Post Long Description	Welsh Translation
LOHCLERK	LOH CLERK
ACPOST2	ACPOST 2A LONG DESC
LOHPOST	LOH 39HRLY WEEK

 

Course ID	Course Long Description	Welsh Translation
WORD6	MS Word 6
ORA10GA	Oracle 10g Admin
PAYMTH	Monthly Payrolls

 

Vacancy ID	Vacancy Long Description	Welsh Translation
JAVADEV	Java Developer
CARETK	Caretaker
FRONTS	Frontline Support

 

For the Narrative format, column B is used to identify the Narrative Code against which the Welsh Translation is stored.

Narrative Cat	Narrative Code	Welsh Translation of Long Desc
RSNCHG	LEAVE
RSNCHG	NEW
RSNCHG	PROM