269421056006b2060ce04dca9660fcbe8f5798af galt Fri Jun 17 11:42:32 2016 -0700 updated gbNode.shortLabel for node 3. diff --git src/hg/geoIp/README src/hg/geoIp/README index d9ceb6e..4044c6e 100644 --- src/hg/geoIp/README +++ src/hg/geoIp/README @@ -21,31 +21,31 @@ It seems odd that nobody has an easy to download cvs or tab-delimited continents list. To convert csv to tab-separated: cat continent.csv | gawk -F "," '{print $1 "\t" $2}' > continent.tab I have my data, so now I load the tables: This is a little script that runs autoSql on each .as to get the .sql files However these .sql files are not checked in to git since they are so easily generated. ./make-sql took the old gbNode.tab with US and euro, and added the japan record: vi gbNode.tab -| 3 | genome-asia.ucsc.edu | JP | Asian node of UCSC Genome Browser at the RIKEN institute of Japan | Japan Server | +| 3 | genome-asia.ucsc.edu | JP | Asian node of UCSC Genome Browser at the RIKEN institute of Japan | Asian Server | changed "\" to tab char. made a script to create and load the .as tables some of them actually do not have any data yet, since the data is created by joins of other tables ./load-tables note that because the script is so simple and some of the tables do not have .tab files, they will give errors. We will fill the empty tables later by inserting from a join of other tables. gbNode geoIpNode