WLink - Import data in a WLink field
There are two different ways to import for a link field:
-
Create a link to an existing record in the target table.
-
Create a new record in the target table and make the link.
-
Open the Import window. For instructions see Data import.
-
For scenario A (create a link to an existing record in the target table) we need to have the name (or id) of the mother table and the name (or id) from the target table.NameGrowth(Name field target table)BIO 14138575CellGrowth_1155-5mgNote that in this example the Cell growth table should have a record called 138575CellGrowth_1155-5mg.When importing based on the name of the record, it is possible to import 2 links for 1 record.Go to More options and select CSV file separator. Then use the separator that is selected in the import toolThe default separator is Semicolon (;).NameName field target tableBIO 14138575CellGrowth_1155-5mg;138576CellGrowth_1255-5mg
-
For scenario B (Create a new record in the target table and make the link) we need to have the same as scenario A plus the growth values for the W field (and other information if preferred).NameGrowth(Name field target table)Lactose growth (W field in target table)BIO 14138576CellGrowth_1155-5mg1;23;2;34;3;45;4;46Note that in this example the Cell growth table should not have a record called 138576CellGrowth_1155-5mg.For practicing purposes, copy the following to clipboard:Name Growth Lactose growthBIO 14 138576CellGrowth_1155-5mg 1;23;2;34;3;45;4;46
-
In BioloMICS in step 1 of the import wizard, click "Paste tabular data".
-
In step 2, check "Show target fields (max 1 level)" on the top-right to see all the fields of the target tables.
-
Link the fields to the corresponding field in the database.The Name field target table (Growth) should be connected to the Record name of the target table (Cell growth).The Lactose growth should be connected to the W field in the target table (Cell growth).
-
In step 3, append or merge the data. For more information about merging data in a WLink field, click here.