Difference between revisions of "IFALT"
DanielRenfro (Talk | contribs) (New page: Category:TableEdit ==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 p...) |
DanielRenfro (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
==specifications== | ==specifications== | ||
Each field is '''tab delimited''', and each new row is seperated by a '''newline.''' | 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. | 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. | ||
| − | + | ||
| − | + | {|class = 'sortable' border="1" cellpadding="4" cellspacing="0" style="margin: 1em 1em 1em 0; border: 1px #aaa solid; border-collapse: collapse;" | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | {|class = 'sortable' border=" | + | |
|- style="background-color:#bbcc55; font-size:larger;" | |- style="background-color:#bbcc55; font-size:larger;" | ||
!|column!!data!!notes!!required? | !|column!!data!!notes!!required? | ||
| − | |- | + | |- |
| | | | ||
1 | 1 | ||
| Line 19: | Line 12: | ||
Page title | Page title | ||
| | | | ||
| − | This can come from the [[Pagelist.php]] script. | + | This can come from the [[Pagelist.php]] script. |
| | | | ||
| − | yes | + | yes |
| − | |- | + | |- |
| | | | ||
2 | 2 | ||
| Line 30: | Line 23: | ||
Do not include the '''Template:''' namespace prefix -- it is assumed. | Do not include the '''Template:''' namespace prefix -- it is assumed. | ||
| | | | ||
| − | yes | + | yes |
| − | |- | + | |- |
| | | | ||
3 | 3 | ||
| Line 39: | Line 32: | ||
Do not include the '''Template:''' namespace prefix -- it is assumed. | Do not include the '''Template:''' namespace prefix -- it is assumed. | ||
| | | | ||
| − | yes | + | yes |
| − | |- | + | |- |
| | | | ||
4 | 4 | ||
| Line 50: | Line 43: | ||
Avoid tabs and newlines at all costs. | Avoid tabs and newlines at all costs. | ||
| | | | ||
| − | sometimes (if update type is not clear_old ) | + | sometimes (if update type is not clear_old ) |
| − | |- | + | |- |
| | | | ||
5 | 5 | ||
| Line 57: | Line 50: | ||
Metadata | 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. | + | 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 | + | no, but it's a good idea to have some metadata |
| − | |- | + | |- |
| | | | ||
6 | 6 | ||
| Line 68: | Line 61: | ||
see below. | see below. | ||
| | | | ||
| − | no, defaults to ''merge'' | + | no, defaults to ''merge'' |
| − | |- | + | |- |
| | | | ||
7 | 7 | ||
| Line 77: | Line 70: | ||
things that go here should follow the normal URL-style query string format. key=value&key2=value2. For more information, see the PHP [http://us2.php.net/parse_str parse_str] function man page. | things that go here should follow the normal URL-style query string format. key=value&key2=value2. For more information, see the PHP [http://us2.php.net/parse_str parse_str] function man page. | ||
| | | | ||
| − | no | + | no |
| − | + | ||
| − | + | ||
| − | + | ||
|} | |} | ||
| − | + | ||
==update types== | ==update types== | ||
| Line 110: | Line 100: | ||
<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 | <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 | ||
</tt> | </tt> | ||
| + | |||
| + | [[Category:TableEdit]] | ||
Latest revision as of 02:27, 15 January 2010
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. |
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
- 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.
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
