{{ images:lookuptableentries.jpg}}
====== Load key-value pairs from clipboard ======

To load key-value pairs into a lookup table, select the table to be filled from the list of value tables and open the table by double-clicking on it.
You will now see the properties of the lookup table in the right pane and can change them there if necessary.
On the left you see the sections **System** and **Standard** with the two menu items **Entries** and **Location queries**.
Click on **Entries** to open the **Grid View** of the key value pairs.
Here, entries can now be maintained manually or entered from the clipboard via **Paste Lookup Values**.
Preparatory you have ideally created a table in EXCEL((Alternatively a tab separated list in a text editor can be used.)) with four columns of the following contents:

  - Foreign key((LookupTable-Key))
  - (optional) Foreign key description((LookupTable-Key-Description))
  - lookup value((ValueProvider-Key))
  - (optional) lookup value description((ValueProvider-Key-Description))

Select the cell range of all rows and the four columns and copy this selection to the clipboard with [Ctrl]+[c]
and paste this into the table with the menu command **Paste Lookup Values** or keyboard shortcut [Ctrl]+[v]. Finish your entries by clicking on the {{images:floppy_disk.png?nolink}} button, so that the values are transferred to the eBiss database.

{{:images:sign_warning.png?nolink|}} Note: Even if the second and fourth column must be filled only optionally, four columns must be selected, so that the import does not break.