Yuri Litvinenko

Local journalist from Russia, writing in English for Tedium and Nintendo Life. This site is a place for personal stuff and articles too specific to be published elsewhere.

Twitter · LinkedIn · me@ylitvinenko.com

How to Embed Creative Commons Metadata in Office Documents

Photographers, artists, and writers use Creative Commons licenses to open their work to the worldwide community. But how would you do the same with your Microsoft Word document?

Technically, you don’t have to do anything special to release files made in Microsoft Office under Creative Commons license: just choose the variant you are comfortable with, print its name in the document itself and give a link to the license. A wizard on the Creative Commons web site can even generate the most preferable legalese.

But while this might be enough for humans, algorithms scraping the Internet for CC-licensed content need specially formatted descriptions. Machine-readable metadata is what search engines rely on when you limit the results to CC-licensed works only. On the Web, metadata are usually embedded in the HTML code using the RDFa format. Files generated by Adobe software, from images to PDF documents, use XMP profiles instead.

Back in 2006, Microsoft released an add-in for Word, Excel, and PowerPoint which allowed to mark documents with machine-readable Creative Commons license. Originally designed for Ofice XP/2003 and 2007, it was updated over time to provide support for versions up to 2013. However, if you have anything newer than that, the installer found on Microsoft’s web site will refuse to work.

Thankfully, the workaround does exist, and I’ve personally tested it with the latest, x64-based monthly build of Office 365. But, from my experience, here are just two mentions of it on the Internet, and both of them are not available in English. In this post, I’ll give a loose translation of a French blog post (which, in turn, is a translation from Chinese), as well as an overview of the tool.

How to install Creative Commons add-in for Microsoft Office 2016 and later

  1. Install Microsoft Visual Studio Tools for the Microsoft Office system (version 3.0 Runtime) (x86), Please note that you need to install the 32-bit version, no matter which platform your Windows or Office installation for.
  2. Update them with Service Pack 1.
  3. You’ll need the add-in files from the system it was already installed on. (Alternatively, you may use this archive; while I’ve tested it, you shouldn’t usually trust strangers offering you executables.) Copy the folder from the archive to C:\Program Files (x86) folder, or C:\Program Files for 32-bit Windows.
  4. Import keys from three registry files (for Word, Excel, and PowerPoint respectively) from this archive. You may need to edit them to omit the (x86) if you are running a 32-bit version of Windows.

Creative Commons add-in should now load on the next startup of Office apps it was made for.

How to license Microsoft Office files under Creative Commons

You’ll notice the To use a Creative Commons license, you need to download it first by selecting Licenses > New License… Unless you are dedicating the document to the public domain, the wizard asks you several questions: whether you are allowing commercial uses; what’s your modification policy; and what is the jurisdiction of the license you are going to apply. (Be sure to not select deprecated CC Sampling license.)

After the license is downloaded, you may apply it by clicking Licenses and selecting it from the dropdown list. The licensing works a bit different in Word compared to Excel and PowerPoint. With spreadsheets and presentations, the metadata are embedded in the document itself, and the visual data (Creative Commons button and the legal notice) can be changed or replaced. In Word, however, both visual and metadata are kept in a single locked field. While this provides greater security, it might result in a language disparity if the document itself is not in English. To remove the field, you have to use the Document Licensed button.

What it may be useful for?

Despite the tool being supported throughout the lifespan of five Office versions, the adoption of CC-licensed Microsoft Office documents is virtually nonexistent. Fiddling with search operators in Google revealed that, out of several dozen Word files with Creative Commons metadata, most of them were actually clippings of Wikipedia articles and other free web content.

Uploading Office files for public use when PDF files would suffice is an Internet mauvais ton. Still, using the add-in might be useful where interactivity matters — in feature-rich PowerPoint presentations and, most notably, complex Excel spreadsheets. And for me, it’s just nice to see one of the most prominent file formats in computing supporting Creative Commons on a technical level — even if few efforts were made in this regard since 2006.

 No comments    150   4 mon   Guides

Microsoft Kin Creators Reflect on What Was Cut and Planned

It’s impossible for a company as prolific as Microsoft to not make at least a few stinkers. But their first attempt to release a mobile phone under their own brand could not be described as anything but a disaster. Kin phones, released at the dawn of the current mobile landscape, were discontinued just six weeks after their US launch. It took a multitude of factors to make it fail — the feature set was not great for a targeted demographic, the competition was strong, and Verizon’s plans were just too steep.

Behind the story of a giant company releasing a dud (don’t we all love them, if only instinctively?) lies another one — of hard work and hopes for the future. For all its cons, Kin’s deep social integration, if implemented better, could make a difference in a bloodbath of 2010 mobile phone market.

Instead of making a summary of what we already know of Kin, I’ve decided to talk to people involved in its creation. Not only they shed more light on why Kin turned out to be the way it was, but also showed Microsoft was interested in evolving their phones over time — if only they didn’t flop.

Three-dimensional UI: too much for first-gen Tegra?

Microsoft had the presence in the mobile market since the 1990s, licensing their Windows CE operating system to device manufacturers. Kin One and Kin Two, on the other hand, were the company’s first attempts at releasing its own complete product. They were not traditional smartphones, though, but feature phones with touch controls and a subset of iPhone and Android functionality.

In 2010, before the influx of cheap Android handsets, it was yet sensible to release so-called “touch phones.” Kin phones and their contracts, however, weren’t cheap, and the platform, being targeted to teens and tweens, notably lacked features vital to the digital generation — Internet chats, for example.

The software issues could realistically be resolved over time, as Microsoft implemented an over-the-air update system. The hardware, though, was here to stay, and the choice of components raised the eyebrows even back then. Kin phones marked the first time Tegra, Nvidia’s system-on-a-chip, was used in a mobile phone. But it was the aging APX 2600 chip, first used in Microsoft’s Zune HD media player, while devices powered by next-generation Tegra were already announced at that point.

The chip might be one of the causes for performance woes, documented well enough in regards to both final and pre-release hardware. In 2012, Wired obtained internal videos showing how poorly the system responded to swipes and touches, among other things.

The videos have vanished from the source by now. One of them was uploaded to YouTube; I’ve mirrored it to the Internet Archive.

It’s hard to imagine the UI was initially going to be way more visually impressive. Erik Hunter, who was working for a design studio Method at the time, was responsible for the UI motion design of Kin phones. According to him, Method and Kin’s lead designers collaborated on creating a three-dimensional, motion-rich UI. The look, featuring a drastically different design language, is shown on Hunter’s web site.

“There were lots of interactions which didn’t end being developed, like the motion on the lock screen, the Spot [sharing widget] icon animation, and the scrolling tiles. Most of the interactions and animations we designed ended up not being possible,” says Hunter, citing the processing power and the features being cut in development.

One of the visual features implemented at some point was the 3D effect on the Loop, a home screen displaying social media updates. Chris Furniss, responsible for implementing the UI on device with XAML and Silverlight, was involved in downscaling the designers’ vision to what the hardware was able to do.

“The UI, in general, had a cool parallax effect as you swiped back and forth, or scrolled up and down through your social feed. That had to be cut, which affected the way text had to be layered over photos and so forth,” Furniss explains.

The 3D effect can be seen at 0:20 mark of the video.

Intelligent Spot and prospects of Kin Three

The eye candy wasn’t the only thing that had to be cut. The video above shows the Spot, one of Kin’s trademark features, featuring a dashboard filled with sections and features. In the final version, all it could do is to serve as a drag-and-drop target for SMS, MMS, and email attachments. Even without any social media integration, it was seen as one of the most clever features of the phones.

The concept video, however, shows the Spot not only sending photos to Facebook or Twitter, but serving as a system scrapbook, storing reminders and sets of objects to share. According to Furniss, it was supposed to be even more than that; “a context-sensitive bucket which you could drop anything into and Kin would figure what you were intending.”

“We were never given a reason for why the Spot wasn’t as powerful as we originally designed it,” Hunter adds. He points to the internal conflict between Microsoft’s managers and multiple mobile teams, reported by Engadget at the time, but did not confirm it from his own perspective.

Kin Two had twice the memory over Kin One, as well as better camera.

Kin has almost instantly built the image of a teenager phone — and that’s the case for oddly-shaped Kin One, marketed to pre-teens and teens. Furniss describes that the Kin Two model, looking like a contemporary QWERTY side slider and having better specifications, was aimed at a 25- to 35-year-olds. (Notably, according to him, Kin One was specifically designed to appeal to the female audience, with Kin Two being a “men’s phone.”)

But looking forward, Microsoft and its partners were already planning to reach another demographic. A third developer, who decided to remain anonymous due to NDAs, shared that Kin lineup was going to evolve as the audience captured by first-generation models changed their taste.

“If Microsoft Kin is a mobile device designed specifically for a younger, millennial audience, our job was to think about how the device needs to change as this audience becomes older,” they describe their role in the project. The source states their team researched the potential new audience and outline new features for the future Kin.

The work made by the developer was left unused, as Microsoft embarrassingly discontinued Kin over its low sales. Later that year, unsold phones got a revised firmware which, stripping social and cloud aspects, allowed to resell them as souped-up dumb phones. The failure of Kin, according to Business Insider, sank the morale within Microsoft.

“Leading up to the launch date of Kin, we were really excited. We were all in creative brainstorm mode for the next big thing, and spirits were high,” recalls Furniss the mood across his team just before the historically poor performance.

“We were given lots of room to explore and encouraged to push the boundaries of what can be done in a traditional mobile UI,” says Hunter from his point of view as Method employee.

The last app-less smartphone

Not only Kin phones had not held their value upon release, but they were also out in the most unlikely of times — both by Microsoft’s mobile divisions and the industry as a whole. Windows Mobile, Microsoft’s legacy mobile OS, was on its last legs, with people having high hopes for all-new Windows Phone. Kin’s mobile platform, having no app support as the world was captivated by them, looked out of place both in the market and in Microsoft’s pipeline.

“When Kin was being designed, it was before this huge paradigm shift to consuming everything via platform-specific apps... I don’t think the social media consumers of today are of the same mindset, they are too used to download specific apps for specific services,” reflects Furniss on how Kin, having no social media clients, embedded their feeds in the UI itself.

On a smaller scale, the idea of unified feed was transferred into Windows Phone, as the People app had a “What’s New” screen showing social media updates. But in 2015, as Facebook had to discontinue one of its APIs due to privacy concerns, Microsoft terminated Facebook integration, with apps like Twitter and LinkedIn dropping it afterward because of the public’s general disinterest. In 2018, commenting on yet another privacy scandals, Facebook called early system integrations “Facebook-like experiences.” The choice of words has clearly separated Facebook as used with apps and browsers and deep system integrations.

Kin phones were the only ones which fully bet on experiences, not apps. From Windows Phone to even more obscure platforms like BlackBerry 10 or Nokia Asha, it was usually a combination of two. The most recent feature phone platform, KaiOS, does not even try integrating social media it the system — but it has an app store and support for web apps.

To win that bet, Kin had to either be as good as planned or cost as much as it deserved. Unfortunately for everyone involved in its creation, it did neither.

 No comments    207   6 mon   Features

As Forbes Cracked Russia Up, I Talked to Local Lemon Experts

Contributing authors are dangerous to any media with a user platform — at least if neglected by the editor.

On Thursday, Lizzy Saxe, a Forbes contributor writing about food and business, submitted an article headlined “Want To Find A Rich Person In Russia? Look For The Lemons.” In the article, Harold Edwards, the CEO of a California-based agricultural company Limoneira expressed his theory of high demand for lemons in Russia. If lemons can’t grow there, he deducted, they should cost a lot, so Russians must use them to “communicate to people that they have the means to be able to afford them.”

Apparently, when I brewed some lemon tea, I was a “wealthy Russian” who “incorporates lemons into my lifestyle.”

The article, while being featured on Forbes’ social media and getting around 25,000 hits by the time of writing, seems to be mostly ignored by the US media. It’s not really a well-researched article to pick up seriously; the piece was based solely on claims of Limoneira’s CEO, with 7 out of 11 paragraphs, the lead one included, featuring him or the company in a positive light.

As the author hadn’t bothered to check whether Edwards was right, the story was widely ridiculed in Russia both on social media and by press outlets. Lemons are, of course, not a “bling of produce” in the country. With the average retail cost of 117.40 rubles per kg in December 2018 (1.74 US$, or around 13 rubles cheaper than a Big Mac), lemons are three times cheaper than in the US, going by US Department of Agriculture’s annual data.

Soviet tradition with imperial roots

While the reasoning was wrong, local analysts confirm the claim which sparked it. According to AB-Centre, an agriculture think tank, Russia is the second biggest importer of lemons, with the top one being the US. With the purchase amount of 213,000 ton in 2018, the sector has not only recovered after the Russian monetary crisis of 2014–2015 but set the all-time record. Analysts note there wasn’t any notable downfall to recover from, though. With price changes not affecting the demand, importers got away with only the slight reduction of the supply.

“The consumption pattern is traditional for Russian culture,” notes Alexei Plugov, AB-Centre’s General Director. “For example, the most popular folk remedy during the flu is to drink lots of lemon tea. It’s similar to tangerines as traditional New Year treats, with most countries not incorporating then into holiday dishes.”

A glass of lemon tea in podstakannik became a staple of train travels in Russia. Credit: Jürg Vollmer, CC BY-SA 3.0

The case for tangerines is worth focusing on a little bit more. For most older Russians, the strong connection between tangerines and New Year celebrations goes back to the Soviet Union, with its short supply to imported fruit. To meet at least some demand for citruses, Russia had to rely on its own resources — or on the resources of other Soviet republics.

Raisa Kulyan, head of the laboratory of fruit crops selection at Russian Research Institute of Floriculture and Subtropical Crops, points to Georgia as the Soviet Union’s main supplier of both lemons and tangerines. Plains of Abkhasia were more suitable for growing lemons on the open field then Krasnodar Krai, the only subtropical region of independent Russia.

“There were more territories, and the subtropical zone was wider. Nowadays, we are limited by Adler and Sochi regions [of Krasnodar Krai],” she says, lamenting the mountainous terrain of Russian subtropics.

The researcher notes we shouldn’t attribute the popularity of lemons in Russia solely to Soviet distribution chains. “Historical background is crucial for their popularity. Not without reason people were growing lemons on their windowsills during the time of Peter the Great,” Kulyan referred to Pavlovo lemonarium near Nizhny Novgorod, in the centre of European Russia.

First mentions of lemons in Russian go beyond the history of the Russian Empire, back to the time of tzars. Domostroy, a 16th-century collection of household rules, mentions recipes and remedies using lemons. Being a popular work, it shows the citrus was not an unwitnessed fruit even for low-ranking nobles.

The quest for Russian lemons

Despite the attempts of local farmers, it’s impossible to stumble upon homegrown lemons in Russian stores. Last year, local manufacturers have just entered the market at the level of the country — as a blip on the chart, with the share less than 0.01%. But Kulyan states more entrepreneurs are interested in growing lemons locally.

According to the scientist, all it takes for lemons to grow is the temperature above 5 °C (41 °F) during the winter — a goal achievable with heated or plastic-sheet greenhouses even in southern Siberia. The most suitable for moderate climate is the Meyer lemon, she says; the low-growing, undemanding cultivar notable for its orange cortex.

Georgiy Siverskiy, an Usbek farmer. Credit: IA Ferghana

In Uzbekistan, a country in Central Asia on the south from Russia, local farmers even adopted them for growing without greenhouses. To shield lemons from cold winds, they grow them in trenches. Bringing them to Russia as “Tashkent lemons,” exporters hope to meet the demand once taken by Spanish and Greek manufacturers barred from selling produce to Russia by economic sanctions. But with a 0.3% share of imported lemons, they have to go a long way — and face Turkey and Argentine keeping more than three-fourths of the production.

To the possible dismay of the head of Limoneira, who claimed Russian favor Californian lemons over any other kind, there was no official import of lemons from the US in both 2017 and 2018.

Add some yellow to a greenback

Joking and being curious simultaneously, some Russians thought Edwards was confused by a Russian vernacular. Popularized in the 1990s, “lemon” means “million” of dollars or rubles in thieves’ slang. With the last syllable stressed, both words sound similar in Russian, with “lemon” being some sort of mangled shortening. According to two philologists reached by a Russian newspaper Argumenty i Fakty, the word first appeared during the Russian Civil War of 1917–1922 accompanied by the depreciation of the ruble. As the Soviet Union collapsed, more people got access to once unimaginable sums of money, reviving the word in process.

The most crucial point right now is, the word got another meaning just for brevity. According to the Leonid Belovinsky, Doctor of History, there was no analogy with actual lemons.

Lemons growing in Bryansk Oblast. Credit: Anatoly Tarantsov, CC BY 3.0

For Russians, lemons might not be metaphorical golden nuggets portrayed by the Forbes’ article, but the country’s fascination with them is worth a deeper look even from within Russia itself. While the article has started just as an exercise in fact checking, it has provided me with a different point of view on a mundane ingredient. From ever-growing supply from abroad to greenhouses in Siberia, Russians’ love for lemons surely goes beyond the imaginary desire to somehow show off.

Meanwhile, Forbes has “corrected” the article “to more accurately reflect social status in Russia” — if the removal of a single paragraph counts as a correction.

The cover photo is composed of “Valencia market – lemons” by Hans Hillewaert, CC BY-SA 4.0, and a USSR stamp “Friendship Tree, Sochi with label” (1970), no copyright.

The Russian version of the article is published by Pervoistochnik.

 No comments    96   8 mon   Features
Earlier Ctrl + ↓