IFALT

From GMOD
(Redirected from Table Editor/IFALT)
Jump to: navigation, search

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'/>


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