Table view (*) – IATE Online Help

The table view ☍, which is only accessible to internal users, offers an overview of selected entries to facilitate their management (e.g. validation monitoring, pre-IATE follow-up, missing languages, protection monitoring).

In this page, you will find out how to:

Add entries to your table view
Choose which information to display
Apply generic actions to your whole table
Apply actions to selected entries

Read more on User groups and access rights.

Add entries to your table view

Click on the ‘Actions’ button to add entries to your table view:

Add entries by ID: provide one or more IATE entry IDs, separated by commas or line breaks;
Add entries from collection: select the collection(s) you wish to view in your table;
Add entries from bookmarks: select a bookmark list;
Add entries from file: upload a file containing a list of IDs.

Customise your table

The selected entries are loaded in the table with a range of criteria or metadata displayed in columns. To configure your table view, click on the ‘Actions’ button then the ‘Choose and sort columns’ icon. On the left, there is a list of all the available columns. To display a column in your table, drag and drop it into the right-hand box.

To view the table in full-screen mode, click on ‘Actions’ then on the ‘Expand’ button.

Description of the columns

Entry ID
Primarity
Domains (multiple values displayed and exported in the same column)
LIL Note: content of the ‘Note’ field at language-independent level (LIL)
LIL Management: content of the ‘Management’ field at LIL
Collections (LIL) (multiple values displayed and exported in the same column)
Collections: includes collections at the three levels: LIL, language level (LL) and term level (TL)
Has language (table): detailed overview of all EU languages + LA and MUL with an indication of whether they are present on the entry or not
Languages: list of languages present on the entry, including non-EU languages
Missing languages: list of languages not present on the entry
Multilingualism: list of languages present on the entry, followed by a list of languages not present on the entry. Languages present are displayed in green, languages not present are displayed in red.
Anchor language : language code of the anchor language, if one is specified on the entry
Terms (Anchor language): term(s) present in the anchor language (if specified)
Term: term in the interface language or, if no term is present in that language, in either EN, FR or DE (in that order) or in other EU languages in alphabetical order
All terms: list of all terms present on the entry in all available languages, including lookups. Display order: EN-FR-DE, followed by other EU languages in alphabetical order, LA, MUL and non-EU languages.
Terms per language (table): number of TLs per language
Terms (en): list of existing terms in English
Terms (fr): list of existing terms in French
Terms (de): list of existing terms in German
Definition (Anchor language): definition in the anchor language, if present
Definition (en): definition in English, if present
Definition (fr): definition in French, if present
Definition (de): definition in German, if present
Language level note (Anchor language): LL note in the anchor language
Language validation (table): detailed overview of the LL validation status per language
Terms validation status (table): detailed overview of the TL validation status per language, with an indication of the number of TLs with each status
All terms validated (table): detailed overview per language with an indication of whether all TLs are validated (= v -meaning yes-) or whether some are not validated/pre-IATE (= x -meaning no-)
Has pre-IATE terms (table): detailed overview per language with an indication of whether any pre-IATE TLs are present (= v -meaning yes-)
LL Not validated: list of languages which have an LL with the status ‘not validated’
TL Not validated: list of languages which have at least one TL with the status ‘not validated’
Protected levels: sum of all protected levels (LIL, number of LLs and number of TLs). Note that protection via collection is not taken into account in the table view.
Protected at LIL: lock icon indicating whether or not the whole entry is protected
Protected at LL: lock icon indicating whether or not the language section is protected
Protected at TL: sum of protected TLs per language
Owner (LIL): indication of the LIL data owner
Owners per language: indication of the LL data owners
Owners per term: indication of the TL data owners
Ownership (all levels): indication of all the data owners per level
LIL confidentiality: icon indicating whether or not the whole entry is confidential
Confidential levels: sum of all confidential levels (LIL, number of LLs and number of TLs)
LL confidentiality: icon indicating whether or not the language section is confidential
Confidential TLs: sum of confidential TLs per language.
LIL creation date: date and time when the LIL was created.
LIL last modification date: date and time when the LIL was last modified.

Unless otherwise specified, languages are always sorted in the following display order: EU languages, LA, MUL, non-EU languages (if included).

Apply generic actions to all entries

Save IDs to file: saves a list of IDs from the table to a file. This file can be uploaded in the table view or in other parts of IATE.
Export table: launches a synchronous (i.e. immediate) export into Excel of the table as it is displayed (keeping all customisations).
Print: opens a glossary view of the IATE entries with limited metadata in a separate screen, to generate a paper or PDF version of the selected content. You have the option to include or exclude synonyms and to show or hide the IATE IDs, the hyperlinks to the entries and an index of terms in the selected languages. For an optimal print, you should select ‘Save as PDF’ and not ‘Adobe PDF’.
Sort: allows you to sort the content or reverse the current sorting. Keep in mind that you can also sort by columns not visible to the user in the table. Available sorting: entry ID (sorted by number); term, terms (de), terms (en), terms (fr) (sorted alphabetically); domains, collections, languages (sorted by number of languages, highest on top).
Empty table: removes all rows from the table.

The entries displayed in the table view are saved in your browser’s temporary local storage. This means that it will no longer be available when you change browser or computer, or when new versions of IATE are deployed.
However, you can save your list to a file and retrieve it by clicking on ‘Add entries from file’. We suggest that you save your table view lists regularly.

apply actions to selected entries

Select entries individually or use the check box

in the first column header to select all the entries at once.

Remove from table: removes selected rows from the table
Delete entries from IATE (*)
Add to bookmarks
Add to watch list
Add to batch attachments operation (*)
Add to batch collections operation (*)
Add to merge operation (*)
Add to project (*)
Validate all (*): the same validation rules apply here as in other parts of IATE: depending on your role, institution and working languages, you can validate certain entry levels (LLs and TLs for the selected languages) in batch. Note that pre-IATE levels remain as they are. For further details, see the validation section of the IATE Handbook ☍.

(*) User groups and access rights

Check below what different IATE users can do using the table view:

User group	Table view	Entry management actions
EXTERNAL USERS	No	None
INTERNAL LOGGED-IN USERS	Yes	None
*ADVANCED USERS*	Yes	Delete entries from IATE Add to batch attachment operation Add to batch collections operation Add to merge operation Add to project Validate all