Extension:TableEdit/IFALT format
specificationsEdit
Each field is tab delimited, and each new row is seperated by a newline. If a field is empty, you can either skip it completely (and put the double pipes immediately next to each other as in the first row in the example below,) or insert the word NULL as a space-holder. NULL will be ignored by the loader.
| column | data | notes | required? | 1;2;3 |
|---|---|---|---|---|
| 3;2;1 | ||||
| 4;6;5 | ||||
| 1;2;3 | ||||
| 7;7;7 | ||||
| 9;4;2 |
update typesEdit
- append
- force an append
- merge (default)
- try and find matching row and merge new row with it, falling back on an append.
- clear
- set a timestamp at the beginning of script execution, and clear_old will use that to delete any row_data from before the script ran.
exampleEdit
lacZ:Gene Gene Gene_sequence_features_table a||b||c metadata for the row append key=value&arr[]=foo+bar lacZ:Gene Gene Gene_sequence_features_table 1||2||3 more metadata append key2=value2 lacZ:Gene Gene Gene_accessions_table EcoCyc (EcoliWiki Page) lacZ:Gene Gene Gene_accessions_table EcoCyc:EG10527 lacZ:Gene Gene Gene_accessions_table EchoBASE (EcoliWiki Page) lacZ:Gene Gene Gene_accessions_table EchoBASE:EB0522 lacZ:Gene_Product(s) Product GO_table_product ||GO:0009088|| || || || || ||Seeded from EcoCyc 11.6 <ref name = 'LIB:EcoCyc11.6'/> lacZ:Gene_Product(s) Product GO_table_product ||GO:0005575|| || || || || ||Seeded from EcoCyc 11.6 <ref name = 'LIB:EcoCyc11.6'/> lacZ:Gene_Product(s) Product GO_table_product ||GO:0003617|| || || || || ||Seeded from EcoCyc 11.6 <ref name = 'LIB:EcoCyc11.6'/>
<span style="color:#ff9700">lacZ:Gene</span> <span style="color:#aaff00">Gene</span> <span style="color:#00ffe1">Gene_sequence_features_table</span> <span style="color:#1d6fff">a||b||c</span> <span style="color:#ff2022">metadata for the row</span> <span style="color:#da37e0">append</span> key=value&arr[]=foo+bar<br /> <span style="color:#ff9700">lacZ:Gene</span> <span style="color:#aaff00">Gene</span> <span style="color:#00ffe1">Gene_sequence_features_table</span> <span style="color:#1d6fff">1||2||3</span> <span style="color:#ff2022">more metadata</span> <span style="color:#da37e0">append</span> key2=value2