Import extension language/dialect batch file formats

Google sheets for batch upload file creation and editing

Google sheets can be used to quickly generate .tsv files from a worksheet tab, via its File > Download > Tab separated values (current sheet) menu function. Google sheets also offers useful file sharing and commenting options, so can be an efficient approach to defining, reviewing, and refining extension translation terms prior to importing into the Authoring Platform.

Here are some example .tsv translations (New Zealand) batch upload files:

Description Additions

Concept ID	GB/US FSN Term (For reference only)	Translated Term	Language Code	Case significance	Type	Language reference set	Acceptability	Language reference set	Acceptability	Language reference set	Acceptability
706690007	Web-based application software (physical object)	Me tono rorohiko-a-paetukutuku	mi	cI	SYNONYM	Maori	PREFERRED
706689003	Application programme software (physical object)	He raupaparorohiko raupaparorohiko	mi	cI	SYNONYM	Maori	PREFERRED
442376007	Test with result pending (observable entity)	Whakamatau me te hua ka tatari	mi	cI	SYNONYM	Maori	PREFERRED

Reference file: NZ-translations-template - Description Additions.tsv

Description Changes

Description ID	Term (For reference only)	Case significance	Type	Language reference set	Acceptability	Language reference set	Acceptability	Language reference set	Acceptability
70056012	Insertion of catheter into heart chamber	cI	SYNONYM	NZ English	ACCEPTABLE	US English	ACCEPTABLE	GB English	ACCEPTABLE
3658267015	Inflammatory disorder due to increased blood urate level	ci	SYNONYM	NZ English	PREFERRED	US English	ACCEPTABLE	GB English	ACCEPTABLE
150085018	Gout	CS	SYNONYM	NZ English	ACCEPTABLE	US English	PREFERRED	GB English	PREFERRED

Reference file: NZ translations-template - Description Changes.tsv

Description Inactivations

Description ID	Term (For reference only)	Inactivation Reason	Association Target ID1	Association Target ID2	Association Target ID3	Association Target ID4
51691000210118	GDM-Gestational diabetes mellitus screening	Erroneous
51631000210119	Screening for diabetes mellitus during pregnancy	Outdated

Reference file: NZ translations-template - Description Inactivations.tsv

Provide Feedback