Can I get down now dad?

Tramps like us, baby we were born to code

Converting the WURFL to SQL

The WURFL is getting a bit of a whopper these days but it is surprisingly easy to convert it all to a SQL table.

Download the WURFL and then go get the handy XSLT Tools.

Converting the WURFL to a pile of inserts is as simple as:
xsltproc roll_out_into_sql.xsl wurfl.xml > wurfl.sql

By default this only adds a few capabilities but you can add loads more by adding them to the roll_out_capabilities.xml file.

After all this you get:


.
.
insert into wurfl_devices
(id,user_agent,preferred_markup,model_name,brand_name,resolution_width)
values ( 'nokia_n81_ver1_sub310035', 'NokiaN81-3/10.0.035 UNTRUSTED/1.0', 'html_wi_oma_xhtmlmp_1_0', 'N81', 'Nokia', '240');

insert into wurfl_devices
(id,user_agent,preferred_markup,model_name,brand_name,resolution_width)
values ('mot_v9m_ver1_subopwv','MOT-V9m/1.1 UP.Browser/6.2.3.4.c.1.123 (GUI) MMP/2.0', 'html_wi_oma_xhtmlmp_1_0', 'RAZR V9m', 'Motorola', '240' );
.
.

This is all jolly handy but I can’t stop being slightly appalled by the syntax of XSL. Like all declarative languages once you go over a level of complexity they become pretty tricky to read and maintain. They often seem to introduce half baked procedural bits which make it worse. Sigh.

46 Responses to “Converting the WURFL to SQL”

  1. Rizki Says:

    That’s a wise asnwer to a tricky question

  2. Bertha Says:

    Alaonzaam-iaformatikn found, problem solved, thanks!

  3. insurance auto Says:

    Oh look at those colours… absolutely beautiful. This is why I love autumn (or fall, whatever you want to call it ) the shallow DoF works really well, too. but then, I’m a bit of a sucker for shallow dof shots!

  4. http://darroughphotography.com/car-insurance-in-humble-tx.html Says:

    Thanks for sharing excellent informations. Your web-site is very cool. I’m impressed by the details that you have on this web site. It reveals how nicely you perceive this subject. Bookmarked this website page, will come back for extra articles. You, my pal, ROCK! I found just the info I already searched all over the place and simply could not come across. What an ideal site.

  5. auto insurance Says:

    If not for your writing this topic could be very convoluted and oblique.

  6. auto insurance Says:

    Your post is a timely contribution to the debate

  7. cheap car insurance Says:

    Crocker Cookie Mix $2 each -$1/2 Betty Crocker Cookie Mixes, Any 17.5 Oz. Pouches – CouponNetwork.com or use .40/1 Betty Crocker Cookie Mix, any 17.5 oz or larger pouch – 11-13-11 SS or use .40/1

  8. car insurance quotes Says:

    Hei!Jeg er følger og jeg elsker bloggen din!J-eg elsker også bokstaver på veggen, så jeg vil gjerne ha: you are my sunshine eller verdenskartet!Klem Kari

  9. car insurance rates Says:

    Per Mail habe ich das Team von Drive Now auch schon kontaktiert, aber außer der Rechnung habe ich bis jetzt nichts erhalten.

  10. http://capitancp.com/dirt-cheap-car-insurance-quote.html Says:

    Play informative for me, Mr. internet writer.

  11. http://apartments-cannes-azur.com/auto-insurance-in-colorado.html Says:

    What a pleasure to find someone who thinks through the issues

  12. http://infonewstoday.com/lynn-eves-insurance.html Says:

    Good point. I hadn’t thought about it quite that way. :)

  13. http://www.agaveconstructionandlandscaping.com/decorativewalls.htm Says:

    Sara / Rosa,Muchos ánimos y todo mi apoyo. Podría hablar de académicos vendidos, universitarios ignorantes, situaciones bochornosas…, pero los hechos ya lo hacen por sí solos. Este Gobierno debe estar encantado con tanto encefalograma plano entre la juventud. Para que luego hablen de fascismos…Ay, pobre país!

  14. http://insurance.dynu.com/aami_car_insurance_customer_service.xml Says:

    Wow that was odd. I just wrote an extremely long comment but after I clicked submit my comment didn’t show up. Grrrr… well I’m not writing all that over again. Anyway, just wanted to say superb blog!

  15. http://jbh-soft-furnishings.com/ocean-ride-toms-river-nj.html Says:

    Thanks for introducing a little rationality into this debate.

  16. full coverage auto insurance Smithfield VA Says:

    MOsilva disse:Bom, até o final deste mês o congresso terá de aprovar o orçamento para o ano que vem. Tomara que os Exmos. Deputados e Senadores não esqueçam das necessidades das FFAA brasileiras. Se não, me acordem ano que vem…SDS.

  17. http://teamjuicebasketball.com/discount-codes-on-car-insurancer.html Says:

    This is a very must read article. It’s not only historical but this is a data about the future. Anyway with todays technology measles is treatable. The main problem here is overpopulation in the third world countries. Although the vaccine and the cure is available but its accessibility to the affected population is the main obstacles. And this obstacle are war, politics, corrupt officials and access to the area.

  18. direct insurance tampa fl Says:

    set of sunglasses within their autos. If you are generating your automobile, the particular glare through light might cause short-term blinding. Actually, glare coming from light certainly are a main cause for a lot of accidents. This kind of mishaps could possibly be avoided in the event you’ve shades. It’s also necessary for specialist owners, which typically push big autos such as the university busses also as vehicles to put on shades contemplating that the implications

  19. car insurance eu ncb Says:

    I can already tell that’s gonna be super helpful.

  20. commerz finanz kredit Says:

    Actually interesting and particular post. I like items such as generating a lot more homework, developing writing skills, and also related things. These kinds of secrets support in being a qualified person on this topic. This page is extremely valuable to myself because individuals like you committed time to learning. Regularity may be the key. But it really is not too easy, as has been designed to be. I am not an expert like you and plenty of times I feel really giving it up.

  21. wiso mein geld ing diba rahmenkredit Says:

    Esss lo mejor! No hay serie q se le parezca, desde que termino estaba anhelando q saliera la peli, su exito es segurissimo aunque sean los mismos capitulos todo el mundo lo va a ver. quiero q sea 2011!!

  22. cheap health insurance Says:

    At last! Someone with real expertise gives us the answer. Thanks!

  23. insurance form 1095-a Says:

    pisze:Dark to taki zimny brąz czy tylko tak wyszła na zdjęciach? Bo jeżeli rzeczywiście tak wygląda to mój portfel będzie znowu biedny :D W sumie do podkreślenia brwi używam cieni ale kredka jest szybsza więc się może skuszę :D

  24. http://autoversicherungvergleich.tech/autoversicherung-wie-teuer-für-fahranfänger.html Says:

    You two look great in the pool!! Mom and Baby swimming sessions in your future? These sessions look like fun at our local pool (didn’t know they existed when our children were infants).

  25. gvv autoversicherung Says:

    Yo soy tu fan me encanta Embed flash movies and videos in Worpress with valid XHTML shortcodes | Nikos Web Development and Web Design, enviare por google+este maravilloso articulo

  26. lebensversicherung finanzierung steuerschädlich Says:

    I know what you mean Carolyn, it is a bit worrying what is sprayed on our food these days. Even though they look perfect, I always give them a good scrub before eating! At least with these being cooking apples they will be peeled and we know that the insides are wonderfully juicy and become ever so fluffy when cooked.

  27. http://www.versicherungskosten.pw/ Says:

    Wonderful story, reckoned we could combine a handful of unrelated data, nevertheless seriously really worth taking a search, whoa did 1 master about Mid East has got much more problerms at the same time

  28. http://arbeitskraftabsicherung.top/arbeitskraftabsicherung-definition.html Says:

    Finding this post has solved my problem

  29. political science courses online Says:

    Sinon chapeau pour la photo de l’article. Là, pour le coup, on sent qu’il y a eu de la recherche.C’est une des plus horribles photos d’un des membres du groupe qui m’aie été donné de voir. On ne pouvait pas faire plus moche et mieux pour décrédibiliser le groupe.J’attends avec impatience le gros plan sur les dents de Thom Yorke pour un prochain article sur Radiohead …

  30. http://firstumcbartow.org/broadspire-workers-comp-phone-number.html Says:

    “A 30 day “pauseâ€? for borrowers 90 days in the hole?One someone has taken the hit to their FICO from a 90 day late, does 30 days even matter?”Exactly, grim – how does walking away hurt these people? Their credit score is already effed. Any reasonable person advising someone who’s 90 days late and significantly underwater has to at minimum suggest the walkaway.I’m pretty sure that the Hope Now hotline won’t do that.

  31. ctp insurance companies Says:

    Hi Carol , if you do not get a answer here please visit this website VETERAN’S BENNEFIT’S NETWORK Google this will come up and you will scroll down to compensation/ claim’sthese people are very helpfull and knowledgeable good luck !!

  32. http://bestekreditje.info/wenn-dispo-kredit-gekuerzt-wird-millionär.html Says:

    Wah, thanks banget mas udah review acara Bukbar kemarin, saya juga salah satu founder , moga di lain waktu kita bisa kumpul bareng lagi ya

  33. darlehen lebensversicherung Says:

    Created the greatest articles, you have.

  34. http://buyautoinsurance.online/TN/Antioch/full-coverage-car-insurance/ Says:

    Es el capital el que no trabaja, el que no confía en el sistema porque sabe que el sistema se hunde.Hemos llegado de forma irremediable a los límites del crecimiento. Ni siquiera la esclavitud podría salvar al capitalismo.

  35. kredit darlehen orte autofinanzierung laufzeit Says:

    la machine lance balles est lancée surle Lenglen. 5-2 davydenko double break et une cadence a asphyxier le bodybuildé espagnol.il ne pourrait que rester le bon vieux tomy chez les iberes?

  36. http://www.cialisnetista.info/ Says:

    Hey there! I know this is sort of off-topic but I had to ask. Does building a well-established blog like yours require a lot of work? I am brand new to operating a blog however I do write in my journal everyday. I’d like to start a blog so I can share my personal experience and feelings online. Please let me know if you have any kind of recommendations or tips for new aspiring blog owners. Appreciate it!

  37. viagra cialis online Says:

    �—�´Ñ€�°�²Ñ�т�²Ñƒ�¹Ñ‚�µ!�£�²�°�¶�°�µ�¼Ñ‹�¹ �š�¸Ñ€�¸�»�» �¡�µÑ€�³�µ�µ�²�¸Ñ‡!�œ�¾�µ�¹ �œ�°�¼�µ 56 �»�µÑ‚. �’Ñ€�°Ñ‡�¸ Ñ��º�°�·�°�»�¸, чт�¾ у �½�µÑ‘ �²Ñ�т�°�» �¶�µ�»Ñ‡�½Ñ‹�¹ �¿Ñƒ�·Ñ‹Ñ€ÑŒ �¸ �½�µ�¾�±Ñ…�¾�´�¸�¼�¾ �µ�³�¾ у�´�°�»�µ�½�¸�µ. ���¾ �²Ñ��µ �¾Ñ��»�¾�¶�½Ñ��µÑ‚Ñ�Ñ� т�µ�¼, чт�¾ �¾�½�° Ñ��µ�¹Ñ‡�°Ñ� �¿Ñ€�¾Ñ…�¾�´�¸Ñ‚ �ºÑƒÑ€Ñ� х�¸�¼�¸�¾Ñ‚�µÑ€�°�¿�¸�¸. 5 �´�½�µ�¹ �² �¼�µÑ�Ñ�ц �´�¾ �¼�°Ñ€Ñ‚�° 2011 �³. �£�—�˜ �¿�¾�º�°�·�°�»�¾, чт�¾ �º�°�¼�½�µ�¹ �½�µÑ‚. �œ�¾�¶�½�¾ �»�¸ �´�µ�»�°Ñ‚ÑŒ �¾�¿�µÑ€�°Ñ†�¸ÑŽ? �˜ чт�¾ �´�µ�»�°Ñ‚ÑŒ?�—�°Ñ€�°�½�µ�µ Ñ��¿�°Ñ��¸�±�¾!

  38. cialis generika online kopen Says:

    Setiap gadget yang kita pakai akan memberikan kode khusus sebagai identifikasi dalam jaringan internet yang disebut dengan IP.Memiliki akun ganda akan langsung diketahui oleh twitter. Tetapi selama tidak digunakan menyalahi aturan yang lainnya nggak masalah sih.

  39. cialis compresse cosa serve Says:

    Uno dei pochi libri dal quale non sono riuscito a staccarmi, e che ho dovuto leggere "tutto in una botta". Molto, molto bello davvero. :)

  40. comprimés cialis à vendre France Says:

    You’ve got it in one. Couldn’t have put it better.

  41. quotes on car insurance Says:

    Oleellista on mielestäni sekin että olisiko ollut sellaista testiä edes olemassa joka tämän riskin nousun olisi paljastanut? Vieläkään ei tiedetä mikä laukaiseva tekijä oli, ja miksi tosiaan myös rokottamattomilla riski kasvoi jopa kolminkertaiseksi- ja juuri parissa pohjoismaassa. Parhaassa tapauksessa tuo data osoittautuu vielä tulevaisuudessa hyödylliseksi uusien lääkkeiden kehittelyssä, ja ehkä tuo arvokasta lisätietoa narkolepsiasta.

  42. http://littlefalconofficial.com/MA/Braintree/affordable-auto-insurance/ Says:

    oooh il est diamnche soir, c’est toujours très dur pour moi les dimanches soirs.. Mais là ta sélection me mets du baume au coeur.. Je comprends tout à fait ce que tu ressens et ta sélection nous gate pour ça! oui à nos petits moments chauds à nous ! avec tabourets laineux pour moi tasse à coeur et vernis essie tout doux, j’adooore :)

  43. sofort barkredit ohne arbeitsnachweis englisch Says:

    i love the forza three game.i would realy love to see in the new forza cars like the ford mondeo st220,audi a4 dtm 162,audi rs5,toyota rxi,mecedes c63,hummers,range rover sport super charged and could you guys please make more smoke when the car spins.

  44. http://preciodeviagra.top/viagra-con-receta-rica.html Says:

    9564Posted on December 26, 2012 at 8:22 am157Do you mind if I quote a few of your articles as long as I provide credit and sources back to your weblog? My blog is in the very same area of interest as yours and my users would truly benefit from some of the information you provide here. Please let me know if this okay with you. Many thanks!

  45. no down payment car insurance in Round Rock TX Says:

    Peggles! Freshly back from vacay only to be Freshly Pressed!!! HUZZAH!! I shan’t bring the party down by complaining that this post didn’t appear in my reader – thanks to Darla I’m not TOO far behind!This was so great. I’m still thinking about the trench coat creeper and wondering if I have enough adult beverages to erase the memory of someone else’s memory. I also need to toast to you! Man, time to head to the liquor store.

Leave a Reply

Couldn't find your convert utility. Check that you have ImageMagick installed.