XSL / XSL-FO and tables

le_huck 0 Newbie Poster

14 Years Ago

hello guys!

i'm quite new here and i'm probably posting this on the wrong place, but hey, here goes nothing! :P

so, i have this lovely XML (not!) that was obtained through a yahoo pipe, and had a JSON decode, in order to transform it in a XML that could be stored in a MySQL database.

<?xml version="1.0" encoding="ISO-8859-1"?>
<json>
  <count>16</count>
  <value>
    <title>uniprot 7</title>
    <description>Pipes Output</description>
    <link>http://pipes.yahoo.com/pipes/pipe.info?_id=0ef2cf38a34d6aef3392b6996ef41108</link>
    <pubDate>Sat, 03 Apr 2010 19:17:42 +0000</pubDate>
    <generator>http://pipes.yahoo.com/pipes/</generator>
    <callback />
    <items>
      <content>BPTF_HUMAN</content>
      <description />
      <title />
    </items>
    <items>
      <alternativeName>
        <fullName>Bromodomain and PHD finger-containing transcription factor</fullName>
      </alternativeName>
      <alternativeName>
        <fullName>Fetal Alzheimer antigen</fullName>
      </alternativeName>
      <alternativeName>
        <fullName>Fetal Alz-50 clone 1 protein</fullName>
      </alternativeName>
      <recommendedName>
        <fullName>Nucleosome-remodeling factor subunit BPTF</fullName>
      </recommendedName>
      <description />
      <title />
    </items>
    <items>
      <name>
        <content>BPTF</content>
        <type>primary</type>
      </name>
      <name>
        <content>FAC1</content>
        <type>synonym</type>
      </name>
      <name>
        <content>FALZ</content>
        <type>synonym</type>
      </name>
      <description />
      <title />
    </items>
    <items>
      <content>MRGRRGRPPKQPAAPAAERCAPAPPPPPPPPTSGPIGGLRSRHRGSSRGRWAAAQAEVAP
KTRLSSPRGGSSSRRKPPPPPPAPPSTSAPGRGGRGGGGGRTGGGGGGGHLARTTAARRA
VNKVVYDDHESEEEEEEEDMVSEEEEEEDGDAEETQDSEDDEEDEMEEDDDDSDYPEEME
DDDDDASYCTESSFRSHSTYSSTPGRRKPRVHRPRSPILEEKDIPPLEFPKSSEDLMVPN
EHIMNVIAIYEVLRNFGTVLRLSPFRFEDFCAALVSQEQCTLMAEMHVVLLKAVLREEDT
SNTTFGPADLKDSVNSTLYFIDGMTWPEVLRVYCESDKEYHHVLPYQEAEDYPYGPVENK
IKVLQFLVDQFLTTNIAREELMSEGVIQYDDHCRVCHKLGDLLCCETCSAVYHLECVKPP
LEEVPEDEWQCEVCVAHKVPGVTDCVAEIQKNKPYIRHEPIGYDRSRRKYWFLNRRLIIE
EDTENENEKKIWYYSTKVQLAELIDCLDKDYWEAELCKILEEMREEIHRHMDITEDLTNK
ARGSNKSFLAAANEEILESIRAKKGDIDNVKSPEETEKDKNETENDSKDAEKNREEFEDQ
SLEKDSDDKTPDDDPEQGKSEEPTEVGDKGNSVSANLGDNTTNATSEETSPSEGRSPVGC
LSETPDSSNMAEKKVASELPQDVPEEPNKTCESSNTSATTTSIQPNLENSNSSSELNSSQ
SESAKAADDPENGERESHTPVSIQEEIVGDFKSEKSNGELSESPGAGKGASGSTRIITRL
RNPDSKLSQLKSQQVAAAAHEANKLFKEGKEVLVVNSQGEISRLSTKKEVIMKGNINNYF
KLGQEGKYRVYHNQYSTNSFALNKHQHREDHDKRRHLAHKFCLTPAGEFKWNGSVHGSKV
LTISTLRLTITQLENNIPSSFLHPNWASHRANWIKAVQMCSKPREFALALAILECAVKPV
VMLPIWRESLGHTRLHRMTSIEREEKEKVKKKEKKQEEEETMQQATWVKYTFPVKHQVWK
QKGEEYRVTGYGGWSWISKTHVYRFVPKLPGNTNVNYRKSLEGTKNNMDENMDESDKRKC
SRSPKKIKIEPDSEKDEVKGSDAAKGADQNEMDISKITEKKDQDVKELLDSDSDKPCKEE
PMEVDDDMKTESHVNCQESSQVDVVNVSEGFHLRTSYKKKTKSSKLDGLLERRIKQFTLE
EKQRLEKIKLEGGIKGIGKTSTNSSKNLSESPVITKAKEGCQSDSMRQEQSPNANNDQPE
DLIQGCSESDSSVLRMSDPSHTTNKLYPKDRVLDDVSIRSPETKCPKQNSIENDIEEKVS
DLASRGQEPSKSKTKGNDFFIDDSKLASADDIGTLICKNKKPLIQEESDTIVSSSKSALH
SSVPKSTNDRDATPLSRAMDFEGKLGCDSESNSTLENSSDTVSIQDSSEEDMIVQNSNES
ISEQFRTREQDVEVLEPLKCELVSGESTGNCEDRLPVKGTEANGKKPSQQKKLEERPVNK
CSDQIKLKNTTDKKNNENRESEKKGQRTSTFQINGKDNKPKIYLKGECLKEISESRVVSG
NVEPKVNNINKIIPENDIKSLTVKESAIRPFINGDVIMEDFNERNSSETKSHLLSSSDAE
GNYRDSLETLPSTKESDSTQTTTPSASCPESNSVNQVEDMEIETSEVKKVTSSPITSEEE
SNLSNDFIDENGLPINKNENVNGESKRKTVITEVTTMTSTVATESKTVIKVEKGDKQTVV
SSTENCAKSTVTTTTTTVTKLSTPSTGGSVDIISVKEQSKTVVTTTVTDSLTTTGGTLVT
SMTVSKEYSTRDKVKLMKFSRPKKTRSGTALPSYRKFVTKSSKKSIFVLPNDDLKKLARK
GGIREVPYFNYNAKPALDIWPYPSPRPTFGITWRYRLQTVKSLAGVSLMLRLLWASLRWD
DMAAKAPPGGGTTRTETSETEITTTEIIKRRDVGPYGIRSEYCIRKIICPIGVPETPKET
PTPQRKGLRSSALRPKRPETPKQTGPVIIETWVAEEELELWEIRAFAERVEKEKAQAVEQ
QAKKRLEQQKPTVIATSTTSPTSSTTSTISPAQKVMVAPISGSVTTGTKMVLTTKVGSPA
TVTFQQNKNFHQTFATWVKQGQSNSGVVQVQQKVLGIIPSSTGTSQQTFTSFQPRTATVT
IRPNTSGSGGTTSNSQVITGPQIRPGMTVIRTPLQQSTLGKAIIRTPVMVQPGAPQQVMT
QIIRGQPVSTAVSAPNTVSSTPGQKSLTSATSTSNIQSSASQPPRPQQGQVKLTMAQLTQ
LTQGHGGNQGLTVVIQGQGQTTGQLQLIPQGVTVLPGPGQQLMQAAMPNGTVQRFLFTPL
ATTATTASTTTTTVSTTAAGTGEQRQSKLSPQMQVHQDKTLPPAQSSSVGPAEAQPQTAQ
PSAQPQPQTQPQSPAQPEVQTQPEVQTQTTVSSHVPSEAQPTHAQSSKPQVAAQSQPQSN
VQGQSPVRVQSPSQTRIRPSTPSQLSPGQQSQVQTTTSQPIPIQPHTSLQIPSQGQPQSQ
PQVQSSTQTLSSGQTLNQVTVSSPSRPQLQIQQPQPQVIAVPQLQQQVQVLSQIQSQVVA
QIQAQQSGVPQQIKLQLPIQIQQSSAVQTHQIQNVVTVQAASVQEQLQRVQQLRDQQQKK
KQQQIEIKREHTLQASNQSEIIQKQVVMKHNAVIEHLKQKKSMTPAEREENQRMIVCNQV
MKYILDKIDKEEKQAAKKRKREESVEQKRSKQNATKLSALLFKHKEQLRAEILKKRALLD
KDLQIEVQEELKRDLKIKKEKDLMQLAQATAVAAPCPPVTPAPPAPPAPPPSPPPPPAVQ
HTGLLSTPTLPAASQKRKREEEKDSSSKSKKKKMISTTSKETKKDTKLYCICKTPYDESK
FYIGCDRCQNWYHGRCVGILQSEAELIDEYVCPQCQSTEDAMTVLTPLTEKDYEGLKRVL
RSLQAHKMAWPFLEPVDPNDAPDYYGVIKEPMDLATMEERVQRRYYEKLTEFVADMTKIF
DNCRYYNPSDSPFYQCAEVLESFFVQKLKGFKASRSHNNKLQSTAS</content>
      <description />
      <title />
    </items>
    <items>
      <content>Q16EU1_AEDAE</content>
      <description />
      <title />
    </items>
    <items>
      <submittedName>
        <fullName>Fetal alzheimer antigen, falz</fullName>
      </submittedName>
      <description />
      <title />
    </items>
    <items>
      <name>
        <content>AAEL015015</content>
        <type>ORF</type>
      </name>
      <name>
        <content>AaeL_AAEL015015</content>
        <type>ORF</type>
      </name>
      <description />
      <title />
    </items>
    <items>
      <content>MSSRKSAAAAGEGSSAGKRRGRPPKSQSSAMERPKSKFQYHLLKKPKYLCKDGSNGDSRF
STPSASRASSPQGSEESRPSTSRRSAPAKAPRSAKAAKGRKSTGGRGRGGNNRKSYTYHE
SEYHYGSDFGDDSDKSDGYDDSMRSASDSEDSLANESESDFSIHSFSASTGIICQKEPSP
DPVWLQDRDYPPLELPASSEDLLVPNNIVLKCTSIYEIIRRFRNLVRLSPFRLEDFAAAI
MCEDQSPLLTEIHIMLLKAILREEDSQQTHFAPLDQKDSVNIALYLIDSITWPEVLRSYI
ESDPSLDQQVLEVLTVNEYPFVAPEDRLKVLQFLTDQFLVTTTVRDDMLQEGPIHYDDHC
RICHRLGDLLCCETCPAVFHLECVDPPLVDVPSEDWQCNLCKLHKVSGVMDCITSQEKQG
MLCRQELLGYDRHGRKYWFIGRRIFIETEDSSDVWYFSTVKQFEYLLSKLDPVDLEMHLC
KELDERRDEIIRHMTLTETITSQQKGNKKSYFELDNQRLEKLMEEEGLATKDADEKMDVD
DQKGAGDKDEESRLTRNKLTQISNGTLHFKLGMENGFKAYVNQYSINPIALNKPQRNEDR
DKKRHLSHKFSLTQASEFKWLGGGMNSTQTQIISTIKQSIIALEQAVASPFLHQNWSKLR
KTWIGAISACTKAKDFARILCILQACMRSVIFASVWHEQLGHTKMYKITSAEREEKKKLE
KREKRERDDEEERNRSTFNFVKYSLGLRHQVWKQKGEEYRIHGQWDWVWMSYSRRKGKKP
SRETNEISHVLIPIVAEVHKKLLKLDSKTHKAYQLVRVGSTDLDFMTGNEALDSRLEEKF
NQTETFQVPETFDVIDVSKALSTPGGRILYPKIAKTASVLDGLLQRRVDLKEAEERKIAK
VKDEEDISVNVIHKPETVQARLGECVEKQLQSIINSRHNVNVRNSLPLNKQPINRSNGEQ
VEPLIEKILPLRSKYQDVNAVVQTNKCYSLDCENGLCYSPLCLQKQAIKDELLPLLKKVQ
ALQSTPMANPTIAGVKSILEQKLTEYKAENFDSMLANFSMNRYRSILDEWDSAHMHLIEY
DEQLIQSMAAPKMPEEHNNNVTNEVEIKTEDAPDMVVKEEIVSTEGEPDLNGSERMDDSL
KLNENSNSISENSCDEPRSTRRGRPRSSKNNSMVIEDTEVKVKEEEVMILPKKEHKPNRR
FALPSRCVKKEDSEDKELAPDGSTRVYSVSSTKGKIYLRKALEPEVKVKSETKPAAAVVG
PVKPKYPAVNYFWTRKQTTSMMVLPMHELLKLARNGGRLSAAGFHHMAKNNNSVWPYPCA
RPLFKTCWLYRTLNLSTLSAVGLQLRIIWTCLRWDDMAMKPATSDGKHQVTTESEIMSLE
ILKHRFAGIFHERMQYLRRKVVIPLELPKTVREVQSIRSGLRKRKRAESPQQTEPQVSEE
WIDEDKLELWEIKLYGEKQEKLAAAQAQHVTRTSTGKLPITRQTPSTSGESSNSSTSTTS
GNSGNNASTTNVQNKSAVISSKASREEITEKMEQQLRIQRAAHNQKRAMELKQQDGATPP
KQTIVQRRIIVKNADGTTKVIQQNITQPARASPASATTAATSSPQAQQASPAPAKPDGPQ
KVQIIRGPDGKVSVRGLNPGQQLIQTADGKLHVLSAAPATSVTVTSPTAVTQPQPQQIQV
QPQQVQIQPQQQAAPVVVSSPTVTQQIVNKSPSIVVRNQAGQPIKQIIQKQVVQKVSLRN
CGQLIATTGSPVQKVVTQSNLQQLLQGAGQKVVVESNTGQSPVQTQKVLVATSPPGQPVQ
KQILIQNATPGSPQQIIINQAGGQKVVQQIVASPGQQIMIGGQRIMIGGGQKIISNQPIQ
IQQNQQIQQIQQIQQVQQKVQQVHQIVTSTPQPQQPQQIQIQIQQPVAQPPPQPQLQTIQ
AQPAPLTQGQSLTQQLSSGKLQLANLNGQQVLIRPLGNNQAQVVAHIKTQPNGTAQIIPL
ANAVDPPPAPVQPQTIQQVVQAAPTQQATIQQVVQQPVTQTTIVQQAFNTSGGSQTTFQQ
LAAATQQQQLQQQQQQQQLDPVEQTLLQGQPPGTVIKCVTAQVIQTQQGPRIVLQGLQGS
EFTPQQSALVQQQVKQQLLKAQESNGKQGVLGPTKIYLAIQPSQQQVVAAQPPPLAPVQI
KHDGGTTHIQLHQQVSSHQESRYYTSRSYFILQADSTVTTTTPTVEDSELPVSGSLTTTI
KTAASTSNNDNKPQILSNIVINDAKTSEEKDDSFVVTPDYIQQTIKNALKQENLNPEIEE
KLLNLQRYQEKQMKTDDRSAAIALQHNYSNMSSNREHHHHHSTPVKSKKRSHRGEDDDDE
WMMDTPKRRPTKSGGSSLSSVERKAQLNRHKEQLKKDILKKRSHLERELQVQIQKELSTE
LAARCKQEQQQIKQEHSGKQHATAAATPSTPAEKGSHSKKRSSASVSKEDKVQKTPKHAQ
GSSKAEKASKASGKKGSKKKEKILCLCRTPYDDTKFYVGCDLCHNWFHGDCVGISEEQSK
EIDEFVCSECKHARETQELYCLCKQPYDESQFYICCDKCQDWFHGRCVGILQSEAEFIDE
YICPNCQINNSVNFANMKSLSAKEFDNLKKLIKQIQHHKSAWPFMEPVDPDEAPDYYRVI
KEPMDLQKVENKVNNQTYHTLSEFIGDMTKIFDNCRYYNPKESQFYRCAESLESFFVQKI
KFFRENLVEKKSAGTSSTSTSV</content>
      <description />
      <title />
    </items>
    <items>
      <content>FLNB_HUMAN</content>
      <description />
      <title />
    </items>
    <items>
      <alternativeName>
        <fullName>Beta-filamin</fullName>
      </alternativeName>
      <alternativeName>
        <fullName>Actin-binding-like protein</fullName>
      </alternativeName>
      <alternativeName>
        <fullName>Thyroid autoantigen</fullName>
      </alternativeName>
      <alternativeName>
        <fullName>Truncated actin-binding protein</fullName>
        <shortName>Truncated ABP</shortName>
      </alternativeName>
      <alternativeName>
        <fullName>ABP-280 homolog</fullName>
      </alternativeName>
      <alternativeName>
        <fullName>ABP-278</fullName>
      </alternativeName>
      <alternativeName>
        <fullName>Filamin-3</fullName>
      </alternativeName>
      <alternativeName>
        <fullName>Filamin homolog 1</fullName>
        <shortName>Fh1</shortName>
      </alternativeName>
      <recommendedName>
        <fullName>Filamin-B</fullName>
        <shortName>FLN-B</shortName>
      </recommendedName>
      <description />
      <title />
    </items>
    <items>
      <name>
        <content>FLNB</content>
        <type>primary</type>
      </name>
      <name>
        <content>FLN1L</content>
        <type>synonym</type>
      </name>
      <name>
        <content>FLN3</content>
        <type>synonym</type>
      </name>
      <name>
        <content>TABP</content>
        <type>synonym</type>
      </name>
      <name>
        <content>TAP</content>
        <type>synonym</type>
      </name>
      <description />
      <title />
    </items>
    <items>
      <content>MPVTEKDLAEDAPWKKIQQNTFTRWCNEHLKCVNKRIGNLQTDLSDGLRLIALLEVLSQK
RMYRKYHQRPTFRQMQLENVSVALEFLDRESIKLVSIDSKAIVDGNLKLILGLVWTLILH
YSISMPVWEDEGDDDAKKQTPKQRLLGWIQNKIPYLPITNFNQNWQDGKALGALVDSCAP
GLCPDWESWDPQKPVDNAREAMQQADDWLGVPQVITPEEIIHPDVDEHSVMTYLSQFPKA
KLKPGAPLKPKLNPKKARAYGRGIEPTGNMVKQPAKFTVDTISAGQGDVMVFVEDPEGNK
EEAQVTPDSDKNKTYSVEYLPKVTGLHKVTVLFAGQHISKSPFEVSVDKAQGDASKVTAK
GPGLEAVGNIANKPTYFDIYTAGAGVGDIGVEVEDPQGKNTVELLVEDKGNQVYRCVYKP
MQPGPHVVKIFFAGDTIPKSPFVVQVGEACNPNACRASGRGLQPKGVRIRETTDFKVDTK
AAGSGELGVTMKGPKGLEELVKQKDFLDGVYAFEYYPSTPGRYSIAITWGGHHIPKSPFE
VQVGPEAGMQKVRAWGPGLHGGIVGRSADFVVESIGSEVGSLGFAIEGPSQAKIEYNDQN
DGSCDVKYWPKEPGEYAVHIMCDDEDIKDSPYMAFIHPATGGYNPDLVRAYGPGLEKSGC
IVNNLAEFTVDPKDAGKAPLKIFAQDGEGQRIDIQMKNRMDGTYACSYTPVKAIKHTIAV
VWGGVNIPHSPYRVNIGQGSHPQKVKVFGPGVERSGLKANEPTHFTVDCTEAGEGDVSVG
IKCDARVLSEDEEDVDFDIIHNANDTFTVKYVPPAAGRYTIKVLFASQEIPASPFRVKVD
PSHDASKVKAEGPGLSKAGVENGKPTHFTVYTKGAGKAPLNVQFNSPLPGDAVKDLDIID
NYDYSHTVKYTPTQQGNMQVLVTYGGDPIPKSPFTVGVAAPLDLSKIKLNGLENRVEVGK
DQEFTVDTRGAGGQGKLDVTILSPSRKVVPCLVTPVTGRENSTAKFIPREEGLYAVDVTY
DGHPVPGSPYTVEASLPPDPSKVKAHGPGLEGGLVGKPAEFTIDTKGAGTGGLGLTVEGP
CEAKIECSDNGDGTCSVSYLPTKPGEYFVNILFEEVHIPGSPFKADIEMPFDPSKVVASG
PGLEHGKVGEAGLLSVNCSEAGPGALGLEAVSDSGTKAEVSIQNNKDGTYAVTYVPLTAG
MYTLTMKYGGELVPHFPARVKVEPAVDTSRIKVFGPGIEGKDVFREATTDFTVDSRPLTQ
VGGDHIKAHIANPSGASTECFVTDNADGTYQVEYTPFEKGLHVVEVTYDDVPIPNSPFKV
AVTEGCQPSRVQAQGPGLKEAFTNKPNVFTVVTRGAGIGGLGITVEGPSESKINCRDNKD
GSCSAEYIPFAPGDYDVNITYGGAHIPGSPFRVPVKDVVDPSKVKIAGPGLGSGVRARVL
QSFTVDSSKAGLAPLEVRVLGPRGLVEPVNMVDNGDGTHTVTYTPSQEGPYMVSVKYADE
EIPRSPFKVKVLPTYDASKVTASGPGLSSYGVPASLPVDFAIDARDAGEGLLAVQITDQE
GKPKRAIVHDNKDGTYAVTYIPDKTGRYMIGVTYGGDDIPLSPYRIRATQTGDASKCLAT
GPGIASTVKTGEEVGFVVDAKTAGKGKVTCTVLTPDGTEAEADVIENEDGTYDIFYTAAK
PGTYVIYVRFGGVDIPNSPFTVMATDGEVTAVEEAPVNACPPGFRPWVTEEAYVPVSDMN
GLGFKPFDLVIPFAVRKGEITGEVHMPSGKTATPEIVDNKDGTVTVRYAPTEVGLHEMHI
KYMGSHIPESPLQFYVNYPNSGSVSAYGPGLVYGVANKTATFTIVTEDAGEGGLDLAIEG
PSKAEISCIDNKDGTCTVTYLPTLPGDYSILVKYNDKHIPGSPFTAKITDDSRRCSQVKL
GSAADFLLDISETDLSSLTASIKAPSGRDEPCLLKRLPNNHIGISFIPREVGEHLVSIKK
NGNHVANSPVSIMVVQSEIGDARRAKVYGRGLSEGRTFEMSDFIVDTRDAGYGGISLAVE
GPSKVDIQTEDLEDGTCKVSYFPTVPGVYIVSTKFADEHVPGSPFTVKISGEGRVKESIT
RTSRAPSVATVGSICDLNLKIPEINSSDMSAHVTSPSGRVTEAEIVPMGKNSHCVRFVPQ
EMGVHTVSVKYRGQHVTGSPFQFTVGPLGEGGAHKVRAGGPGLERGEAGVPAEFSIWTRE
AGAGGLSIAVEGPSKAEITFDDHKNGSCGVSYIAQEPGNYEVSIKFNDEHIPESPYLVPV
IAPSDDARRLTVMSLQESGLKVNQPASFAIRLNGAKGKIDAKVHSPSGAVEECHVSELEP
DKYAVRFIPHENGVHTIDVKFNGSHVVGSPFKVRVGEPGQAGNPALVSAYGTGLEGGTTG
IQSEFFINTTRAGPGTLSVTIEGPSKVKMDCQETPEGYKVMYTPMAPGNYLISVKYGGPN
HIVGSPFKAKVTGQRLVSPGSANETSSILVESVTRSSTETCYSAIPKASSDASKVTSKGA
GLSKAFVGQKSSFLVDCSKAGSNMLLIGVHGPTTPCEEVSMKHVGNQQYNVTYVVKERGD
YVLAVKWGEEHIPGSPFHVTVP</content>
      <description />
      <title />
    </items>
    <items>
      <content>LRRK2_HUMAN</content>
      <description />
      <title />
    </items>
    <items>
      <alternativeName>
        <fullName>Dardarin</fullName>
      </alternativeName>
      <recommendedName>
        <fullName>Leucine-rich repeat serine/threonine-protein kinase 2</fullName>
        <ref>1</ref>
      </recommendedName>
      <description />
      <title />
    </items>
    <items>
      <name>
        <content>LRRK2</content>
        <type>primary</type>
      </name>
      <name>
        <content>PARK8</content>
        <type>synonym</type>
      </name>
      <description />
      <title />
    </items>
    <items>
      <content>MASGSCQGCEEDEETLKKLIVRLNNVQEGKQIETLVQILEDLLVFTYSEHASKLFQGKNI
HVPLLIVLDSYMRVASVQQVGWSLLCKLIEVCPGTMQSLMGPQDVGNDWEVLGVHQLILK
MLTVHNASVNLSVIGLKTLDLLLTSGKITLLILDEESDIFMLIFDAMHSFPANDEVQKLG
CKALHVLFERVSEEQLTEFVENKDYMILLSASTNFKDEEEIVLHVLHCLHSLAIPCNNVE
VLMSGNVRCYNIVVEAMKAFPMSERIQEVSCCLLHRLTLGNFFNILVLNEVHEFVVKAVQ
QYPENAALQISALSCLALLTETIFLNQDLEEKNENQENDDEGEEDKLFWLEACYKALTWH
RKNKHVQEAACWALNNLLMYQNSLHEKIGDEDGHFPAHREVMLSMLMHSSSKEVFQASAN
ALSTLLEQNVNFRKILLSKGIHLNVLELMQKHIHSPEVAESGCKMLNHLFEGSNTSLDIM
AAVVPKILTVMKRHETSLPVQLEALRAILHFIVPGMPEESREDTEFHHKLNMVKKQCFKN
DIHKLVLAALNRFIGNPGIQKCGLKVISSIVHFPDALEMLSLEGAMDSVLHTLQMYPDDQ
EIQCLGLSLIGYLITKKNVFIGTGHLLAKILVSSLYRFKDVAEIQTKGFQTILAILKLSA
SFSKLLVHHSFDLVIFHQMSSNIMEQKDQQFLNLCCKCFAKVAMDDYLKNVMLERACDQN
NSIMVECLLLLGADANQAKEGSSLICQVCEKESSPKLVELLLNSGSREQDVRKALTISIG
KGDSQIISLLLRRLALDVANNSICLGGFCIGKVEPSWLGPLFPDKTSNLRKQTNIASTLA
RMVIRYQMKSAVEEGTASGSDGNFSEDVLSKFDEWTFIPDSSMDSVFAQSDDLDSEGSEG
SFLVKKKSNSISVGEFYRDAVLQRCSPNLQRHSNSLGPIFDHEDLLKRKRKILSSDDSLR
SSKLQSHMRHSDSISSLASEREYITSLDLSANELRDIDALSQKCCISVHLEHLEKLELHQ
NALTSFPQQLCETLKSLTHLDLHSNKFTSFPSYLLKMSCIANLDVSRNDIGPSVVLDPTV
KCPTLKQFNLSYNQLSFVPENLTDVVEKLEQLILEGNKISGICSPLRLKELKILNLSKNH
ISSLSENFLEACPKVESFSARMNFLAAMPFLPPSMTILKLSQNKFSCIPEAILNLPHLRS
LDMSSNDIQYLPGPAHWKSLNLRELLFSHNQISILDLSEKAYLWSRVEKLHLSHNKLKEI
PPEIGCLENLTSLDVSYNLELRSFPNEMGKLSKIWDLPLDELHLNFDFKHIGCKAKDIIR
FLQQRLKKAVPYNRMKLMIVGNTGSGKTTLLQQLMKTKKSDLGMQSATVGIDVKDWPIQI
RDKRKRDLVLNVWDFAGREEFYSTHPHFMTQRALYLAVYDLSKGQAEVDAMKPWLFNIKA
RASSSPVILVGTHLDVSDEKQRKACMSKITKELLNKRGFPAIRDYHFVNATEESDALAKL
RKTIINESLNFKIRDQLVVGQLIPDCYVELEKIILSERKNVPIEFPVIDRKRLLQLVREN
QLQLDENELPHAVHFLNESGVLLHFQDPALQLSDLYFVEPKWLCKIMAQILTVKVEGCPK
HPKGIISRRDVEKFLSKKRKFPKNYMSQYFKLLEKFQIALPIGEEYLLVPSSLSDHRPVI
ELPHCENSEIIIRLYEMPYFPMGFWSRLINRLLEISPYMLSGRERALRPNRMYWRQGIYL
NWSPEAYCLVGSEVLDNHPESFLKITVPSCRKGCILLGQVVDHIDSLMEEWFPGLLEIDI
CGEGETLLKKWALYSFNDGEEHQKILLDDLMKKAEEGDLLVNPDQPRLTIPISQIAPDLI
LADLPRNIMLNNDELEFEQAPEFLLGDGSFGSVYRAAYEGEEVAVKIFNKHTSLRLLRQE
LVVLCHLHHPSLISLLAAGIRPRMLVMELASKGSLDRLLQQDKASLTRTLQHRIALHVAD
GLRYLHSAMIIYRDLKPHNVLLFTLYPNAAIIAKIADYGIAQYCCRMGIKTSEGTPGFRA
PEVARGNVIYNQQADVYSFGLLLYDILTTGGRIVEGLKFPNEFDELEIQGKLPDPVKEYG
CAPWPMVEKLIKQCLKENPQERPTSAQVFDILNSAELVCLTRRILLPKNVIVECMVATHH
NSRNASIWLGCGHTDRGQLSFLDLNTEGYTSEEVADSRILCLALVHLPVEKESWIVSGTQ
SGTLLVINTEDGKKRHTLEKMTDSVTCLYCNSFSKQSKQKNFLLVGTADGKLAIFEDKTV
KLKGAAPLKILNIGNVSTPLMCLSESTNSTERNVMWGGCGTKIFSFSNDFTIQKLIETRT
SQLFSYAAFSDSNIITVVVDTALYIAKQNSPVVEVWDKKTEKLCGLIDCVHFLREVMVKE
NKESKHKMSYSGRVKTLCLQKNTALWIGTGGGHILLLDLSTRRLIRVIYNFCNSVRVMMT
AQLGSLKNVMLVLGYNRKNTEGTQKQKEIQSCLTVWDINLPHEVQNLEKHIEVRKELAEK
MRRTSVE</content>
      <description />
      <title />
    </items>
  </value>
</json>

then, when retrieved from the database, it would be formated with this XSL:

<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
  <html>
  <body>
  <font size="1" face="Verdana">
  <h2>Titulo</h2>
	<table border="1" 
	cellspacing="0"
	cellpadding="5">
      <tr bgcolor="#699C4D">
        <th>Protein name</th>
		<th>gene name</th>
		<th>sequence</th>
      </tr>
      <xsl:for-each select="/json/value/items">
      <tr>
        <td><xsl:value-of select="recommendedName/fullName"/></td>
        <td><xsl:value-of select="name/content"/></td>
		<td><xsl:value-of select="content"/></td>
      </tr>
      </xsl:for-each>
    </table>
  </font>
  </body>
  </html>
</xsl:template>
</xsl:stylesheet>

at this moment, i'm using a php script to this to with the two files, and the result is a messed table, but it's a table!
[IMG]http://web12.twitpic.com/img/82312167-bffc658f9b7dec3e45b7a98afe1c9165.4bb85fde-full.png[/IMG]

so, in order to prevent this, i tried to use the same XML and a XSL-FO code to format it:

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0"
	xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
	xmlns:fo="http://www.w3.org/1999/XSL/Format"
	xmlns:xs="http://www.w3.org/2001/XMLSchema">

	<xsl:template match="/">
		<fo:root xmlns:fo="http://www.w3.org/1999/XSL/Format">
			<html>
				<body>
					<font face="Verdana" size="1">
						<h2>XSL-FO (devia ser FUUUUUUUUU!)</h2>
						<fo:table-and-caption>
							<fo:table border="solid">

								<fo:table-column border="0.5pt solid black" column-width="25mm"></fo:table-column>
								<fo:table-column border="0.5pt solid black" column-width="25mm"></fo:table-column>
								<fo:table-column border="0.5pt solid black" column-width="25mm"></fo:table-column>

								<fo:table-header>
									<fo:table-row>
										<fo:table-cell>
											<fo:block font-weight="bold">Protein name</fo:block>
										</fo:table-cell>
										<fo:table-cell>
											<fo:block font-weight="bold">Gene Name</fo:block>
										</fo:table-cell>
										<fo:table-cell>
											<fo:block font-weight="bold">Sequence</fo:block>
										</fo:table-cell>
									</fo:table-row>
								</fo:table-header>

								<fo:table-body>
									<fo:table-row>
										<!--><xsl:for-each select="/json/value/items"><-->
										<fo:table-cell>
											<fo:block>
												<!--><xsl:value-of select="recommendedName/fullName"/><-->Coluna 1</fo:block>
										</fo:table-cell>
										<fo:table-cell>
											<fo:block>
												<!--><xsl:value-of select="name/content"/><-->Coluna 2</fo:block>
										</fo:table-cell>
										<fo:table-cell>
											<fo:block>
												<!--><xsl:value-of select="content"/><-->Coluna 3</fo:block>
										</fo:table-cell>
										<!--></xsl:for-each><-->
									</fo:table-row>
								</fo:table-body>
							</fo:table>
						</fo:table-and-caption>
					</font>
				</body>
			</html>
		</fo:root>
	</xsl:template>
</xsl:stylesheet>

i have the foreach commented, because i didn't need it to perform any action while the table wasn't working, but i've tested it before and i know it works and that it fetches data from the XML.

when i put it to work in a browser, all i get is this:
[IMG]http://web2.twitpic.com/img/82313747-8a9f4eb3fc6cab332dd92dfc7e8abd96.4bb85fdd-full.png[/IMG]
no columns! :|

what on earth am i doing wrong? any tips on this last piece of code or how can i improve the simple XSL?

best regards! ;)

xml

Edited 14 Years Ago by le_huck because: n/a

1 Contributor
0 Replies
100 Views

Be the first to reply

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.