{"id":3899,"date":"2014-05-21T03:19:56","date_gmt":"2014-05-21T03:19:56","guid":{"rendered":"http:\/\/szapp.com\/?p=104"},"modified":"2014-05-21T03:19:56","modified_gmt":"2014-05-21T03:19:56","slug":"fun-with-maps-marker-pro","status":"publish","type":"post","link":"https:\/\/wsbj.com\/sorabji\/2014\/05\/21\/fun-with-maps-marker-pro.html","title":{"rendered":"Fun With Maps Marker Pro"},"content":{"rendered":"

\t\t\t\tThis turned into a shit show. I mean, this is what Szapp.Com is about: documenting the amount of time wasted on stuff that just does not work as specified.<\/p>\n

The Maps Marker Pro plugin for WordPress<\/a> (which I expect to purchase\u00a0after getting to know it better during the free 30-day trial) is the most beautiful and comprehensive mapping plugin for WordPress.\u00a0While most mapping plugins have a singular bias toward Google Maps the Maps Marker Pro (a.k.a. “Leaflet Maps Marker”)\u00a0<\/span>allows mapping from OpenSourceMaps, Bing. MapQuest, and others. It’s a quality product but not without its timesucking documentation perils.<\/p>\n

Drawn by the promise of importing GPS tracks directly from KML (Keyhole Markup Language) files I spent ludicrous amounts of time searching and clicking and hunting and pecking for where this support was to be found. I could not for the life of me figure out where the option to import KML files existed. All I could find is support for the GPX, CSV, XLS, and XLSX formats, though the FAQ clearly stated “Can I\u00a0<\/span>import<\/span>\u00a0markers via CSV or\u00a0<\/span>KML<\/span>? Yes, this feature is available since\u00a0<\/span>Maps Marker Pro<\/span>\u00a0v1.4″<\/span>\u00a0(The plugin is now at version 1.6). I\u00a0opened a support ticket and looked forward to a reply, whilst clicking and searching and hunting for this feature. It was 5am in the country where the software is developed so I didn’t expect an immediate reply.<\/p>\n

A reply did come quickly enough, though, and to the credit of its author the claim that KML files can be imported directly into Maps Marker Pro has been removed from the web site’s FAQ. I was also offered a 20% discount should I choose to purchase the plugin. I think that adds up to about eight bucks, or about one dollar for every hour I spent staring at this.<\/p>\n

Whilst waiting the above reply\u00a0response I found myself in mental limbo,\u00a0questioning my general intelligence in trying to get KML converted to CSV or anything else natively supported by Maps Marker Pro.<\/p>\n

Simply opening the KML file in Excel and saving it as CSV should have solved the problem, but for some reason Maps Marker Pro complained that the column headings either did not exist or were invalid.<\/p>\n

The next likeliest route should have been GPSBabel<\/a>, a software I remember\u00a0downloading years ago\u00a0but which I can’t recall successfully using. The first times I attempted to convert from KML to GPX I was treated to insouciant error messages that I wish I could remember. I forgot to note them but I think they ended with “error Message 1” or “error condition 1”. After a reboot GPSBabel\u00a0was able to convert KML to GPX but it only showed start and end points, failing to\u00a0illustrate tracks (as shown in the successful result below).<\/p>\n

Another promising piece of software — the KMLCSV converter<\/a> — failed to start after complaining that I had no JRE (Java Runtime Environment) installed in its path.<\/p>\n

\"KMLCSV

KMLCSV Java Runtime Environment must be available<\/p><\/div>\n

 <\/p>\n

Of course I have a current version of the JRE installed, but KMLCSV\u00a0for some reason wants it installed in its own directory. Older version of Java are available for download (KMLCSV wanted version 1.6 or newer, suggesting it does not work with the most modern\u00a0versions) but those legacy Java platforms\u00a0are notoriously bad news.<\/p>\n

Sticking with a modern version of Java\u00a0I copied over the “jre7” folder from the Java directory, renamed it to “jre” and got a new complaint:<\/p>\n

\"Failed

Failed to load the .INI shared library jvm.dll<\/p><\/div>\n

I thought this KMLCSV Converter might simply have required a reboot (it did not work after reboot, which I did not perform until the next day) but in lieu of that\u00a0I looked for solutions in a text-parsing language I could trust: Perl. Ultimately this worked but, of course, it was\u00a0not without its perils — I was unable to install the\u00a0DateTime::Format::HTTP module on my preferred dedicated server, so I had to do it on another.\u00a0Nevertheless,\u00a0from one ONO HIROKI’s web pages<\/a> comes a blessedly simple script to convert KML to CSV<\/a>. This rant is not meant to\u00a0pronounce\u00a0that\u00a0Perl is\u00a0a preferred route for this task (though text-strangling such as this is precisely where the Practical Extraction and Reporting Language\u00a0shines) but to document\u00a0the time wasted staring at erroneously\u00a0documented plugins\u00a0and software applications\u00a0that seem to work for everyone but me.<\/p>\n

Now I am up and running with maps, maps, maps to come. Here is a first one showing my 7.71 mile walk\u00a0through Queens<\/a>.<\/p>\n

 <\/p>\n

 <\/p>\n