Excel, XML, and CSV

I never thought the day would come when I would say that I wished that I had a Windows version of MS Excel. I am simply aghast. But never-the-less I have been looking for an XML parsing solution for OS X and can not find one which is graphically oriented.

I want to move certain XML encoded content to my blog and the best way (that I can figure) to do this is to import CSV files (although there is a WordPress plugin for importing XML).

I want to be able to do this, but the Mac version of Excel does not do this:

I really want to drag and drop, but this tutorial makes it look easy-ish to do at the command line. http://blog.mclaughlinsoftware.com/oracle-sql-programming/how-to-convert-xml-to-csv-and-upload-into-oracle/


What am I Using this for? Well I would like to use it with itunes XML, Endnote XML, Bookpedia XML, BibTeXXML, SIL-OLAC data as XML, WorldCat Data as XML? Glotalogue data as XML.

Learning to make Polygons in Google Earth

Today I am messing around and making KML and GPX files from our trip to Nigeria.

Reading: https://developers.google.com/kml/documentation/kml_tut#polygons and http://projects.visualstudies.duke.edu/isismapping/sites/default/files/isisguides/earthguide.pdf.
Watching:

http://www.youtube.com/watch?v=OGGpTqkbCWo

I hope to take some of our photos, a polygon of the language area, and our GPX route traces and overlay them on an Open Street Map page in WordPress.

The one thing I don't think is possible with GoogleEarth is to move polygons. I created them and then they were about a mile off, so I just wanted to move them... not possible. - to my knowledge.

Lexical Database Archiving Questionnaire

Featured

It's true!

I am asking around on different mailing lists to gain some insight into the archiving habits of linguists who use lexical databases. I am specifically interested in databases created by tools like FLEx, ToolBox, Lexus, TshwaneLex, etc.

Background Story Continue reading

Thanksgiving can start now

I am thankful that our car did not get towed last night. Lately she's been rather cranky at night and it is cold. We were out with some friends and she would not start after dinner. We got a ride home, but had to leaver her in a three hour parking lot for longer than three hours. Fortunately every morning she starts up on the first try (so far). Not quite sure what is wrong, there is some heavy rattling in the engine.
20131123-090027.jpg

Lexical Data Management helps (with SIL software)

This is a quick note to record some of the things I have learned this week about working with lexical data within SIL's software options.

  1. There is information scattered all over the place:
  2. What should the purpose of the websites be? to distribute the product or to build community around the product's existence?

Business Intelligence

I was reading this article Buckle Up: Apple’s Next 3 Years Will Be Insane by Mike Elgan 2:49 pm PDT, Nov 9th 2013, On Cultofmac.com about Apple's business practices.

It reminds me, that regardless of which business we are in, we need to understand the problem space in which we are trying to make a difference. We could think about interactions through the eyes of web design and ask questions like, where are people having difficulties or where are they having less than satisfying experiences? We can ask these sorts of questions in a variety of business endeavors/markets on levels like scripture engagement and our experiences surrounding scripture engagement. We could ask the same type of question about academic and language-based materials. At all levels of inquiry and service delivery, an organization with strategic goals still needs to know: what the market is, and what the market member's pain points are. Additionally an organization needs to have the freedom creatively alleviate those pain points. Just because we can do something doesn't mean it's the right time to do something. Knowing when and how is still very important. By thinking strategically, one can make sure that the tools are in place to respond at the next opportunity. Acting strategically is carrying through with what was planned when the opportunity comes.