GMOD

IFALT

(Redirected from TableEdit/IFALT

specifications

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

Page title

This can come from the Pagelist.php script.

yes

2

Page template

Do not include the Template: namespace prefix -- it is assumed.

yes

3

Table template

Do not include the Template: namespace prefix -- it is assumed.

yes

4

Row data

Each cell is delimited by the double-pipe.
If a cell is empty, you can either place a space there or just put another double-pipe. If the remainder of the cells for a row are empty, you can omit them completely.
Avoid tabs and newlines at all costs.

sometimes (if update type is not clear_old )

5

Metadata

Any data that should get saved to the row_metadata table in the database should be put here. Avoid tabs and newlines at all costs.

no, but it's a good idea to have some metadata

6

Update type

see below.

no, defaults to merge

7

Other / Misc

things that go here should follow the normal URL-style query string format. key=value&key2=value2. For more information, see the PHP parse_str function man page.

no

update types

  1. append
    • force an append
  2. merge (default)
    • try and find matching row and merge new row with it, falling back on an append.
  3. 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.

example

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`
lacZ:Gene Gene Gene_sequence_features_table 1||2||3 more metadata append key2=value2        

Category:

Documentation

Community

Tools