Community Member Monday: Iwan Tahari on LibreOffice migrations in Indonesia

Many companies around the world use free and open source software (FOSS) to reduce costs, improve reliability, and free themselves from vendor lock-in. Today we talk to Iwan Tahari from FANS, an Indonesian shoe manufacturer, which has migrated to GNU/Linux and LibreOffice:

Firstly, tell us about your company, and your role in it…

I work at the FANS shoes factory in Tangerang, Indonesia. Our company has produced FANS shoes since 2001. As an Operation Director, I have to maintain smooth operation in the whole process, to improve our product quality and services. Currently, we have remote offices in Medan, Palembang, Surabaya and Solo that connect directly to our factory in Tangerang. All of our offices use free and open source software for daily operations.

When did you decide to migrate to open source software – and why?

We started to introduce FOSS to our staff in 2007 by dual-booting MEPIS Linux and Microsoft Windows XP on one out of three PCs that we had. It was a complete failure; the users almost never booted into MEPIS. Learning from the past mistakes, in 2012 we did a partial migration with five new notebook PCs installed with Linux Mint 13, for all managers and some higher-level staff members. Seven old PCs were still running Windows XP.

In 2013, we migrated almost all of the PCs to FOSS – only one Windows PC was left in the research and development department, because it was still using Corel Draw. In March 2014, we had a special training for using Inkscape, a vector graphics program. After the training, we fully migrated to FOSS. As of today, we still use only FOSS in all of our operations.

The main reason we migrated to FOSS was to have reliable and stable operations. Around 2012-2013, there was a nasty computer virus in Indonesia called Brontok. The main anti-virus programs were not fast enough to handle the widespread attack, so the only way to fix it was to reinstall the operating system.

This was so bad because of the high downtime in the reinstallation process. The only PCs that were not affected were Linux-based PCs. Since we migrated to FOSS, we have never reinstalled the operating system because of viruses or malware, even though we never use anti-virus software on our Linux-based PCs.

The other reason we use FOSS is cost-saving. Proprietary licenses are very costly; for each application we have to purchase separate licenses for each machine, while with FOSS the programs are completely free and we can install them on as many machines as we want. Our company has saved 133 millions Rupiah by using FOSS (around USD 10,000).

Tell us about your initial experiences with FOSS…

My first experience with open source software as when I was a university student. I graduated from CalPoly (California Polytechnic State University) in San Luis Obispo. My major is MIS (Management of Information Systems). One of our computer classes introduced us to Red Hat Linux. Honestly, I didn’t have a good experience with it (I believe it was Red Hat 4.0).

It took a long time and it was very complicated just to install the OS on an early Pentium machine (just to get the display to work correctly, and the configuration was really difficult for a regular user too). Well, it had a GUI, and some applications like AbiWord and Gnumeric but it was painfully slow. So at that time I believed that open source software was not for a regular users.

After I graduated, I worked in the logistics department of PT. Rodamas Jakarta (a nation-wide distribution company). One day, I saw InfoLinux magazine (a local Indonesian magazine that focuses on open source software) in the IT department. The magazine had a lot of good articles, and it came with a CD/DVD that contained a variety of Linux distributions. I also subscribed to this magazine. I become more interested in the open source world, and tried several live distributions like Knoppix without installing the OS.

Some came with OpenOffice which was similar to Microsoft Office. I liked OpenOffice better than Gnumeric and Abiword. My wife used to work in Haga Bank (a local Indonesian bank now acquired by Rabobank). Her office was using Fedora Linux and OpenOffice for daily operations without any critical problems. Learning from her experiences, when I became Operation Director at FANS shoes, I started the FOSS migration.

Why did you choose LibreOffice?

Because most Linux distros thesedays come with LibreOffice. It’s better to use the office suite that comes with the distro; it saves us time, as we don’t have to install another suite. For our company, LibreOffice is the best replacement for Microsoft Office. If there were no LibreOffice, we would probably have never migrated to FOSS.

I have an interesting story about LibreOffice: one time, my brother called me to ask for some help with his computer. He said he had received a Microsoft Office document file (docx), but he couldn’t open it. Unfortunately, his computer had an outdated OS and MS Office (Windows XP and Office XP).

He said that it’s urgent, that he needed to read the content of this document now. Well, it was late at night, so he was not able to get the installer from the computer store. So I said to him, try downloading LibreOffice, and see if it can open the file. So, he installed LibreOffice in his PC. He was really fortunate that the docx file could be opened with just a little problem (the text was not aligned properly), but at least it was readable. Since then, his computer has LibreOffice, and he continues to use it.

How popular is FOSS in Indonesia?

Open source in Indonesia is getting more popular. In the server market, open source solutions are growing rapidly here because they are cheaper than proprietary software. Unfortunately, it is not the same for daily home or office use of FOSS. Proprietary software like Windows, Office, Adobe suite, Corel Draw etc. are so dominant here. People are already familiar with these proprietary programs and are hesitate to change. Piracy is the main cause of the slow growth of FOSS in Indonesia – currently, there are more people using pirated software than original legal software.

It is very easy to get pirated software in Indonesia. It can be acquired at many computer stores – and sometimes it is included for free when purchasing a PC. So in fact, it’s much easier to get pirated software than FOSS. Still, our government is a little bit strict with pirated software in medium and large companies. Because of that, some companies have adopted FOSS. So I believe Free Software will keep continue to grow in Indonesia, but the adoption rate of FOSS will depend on the how good its marketing is, and also how strict the law enforcement of pirated software is as well.

What were your personal experiences in the Indonesian open source community?

At the early stage of the FOSS migration, I pretty much did everything by myself. I learned FOSS mostly from the web. Fortunately, most FOSS literature is available in the English language, which I can understand. In our company, the LibreOffice migration was a lot easier compared with migrations to other programs like Inkscape and GIMP. At first, we were having trouble migrating to Inkscape until we met Sokhibi (owner of Istana Media, and writer of several open source books).

We invited him to train us using Inkscape. From there, he introduced us to Blankon Linux (a custom Indonesian Linux distro). He was the Documentation Coordinator of Blankon Linux. Then the Blankon community helped us a lot in our migration – we even have a custom version of Blankon Linux specifically for our company needs.

Together with Ahmad Haris (Blankon Public Relation Coordinator), we created a writing contest for using FOSS, and we released an Indonesian Inkscape guidebook. In 2015, we had the GNOME Asia Conference in Indonesia – this was my first time being a guest speaker at a FOSS conference. I met so many excellent people from around the world that were helping the FOSS movement! I was introduced to other local open source communities (such as openSUSE Indonesia, Ubuntu Indonesia, the Indonesian Linux User Group etc).

Since then, I have been active with our local FOSS community, and our company has sponsored several FOSS activities/projects. In 2018, we held an Indonesian conference for LibreOffice. It was a big success, so many people are eager to know about the software. Sokhibi also released an Indonesian LibreOffice Writer guide, which is sponsored by our company.

The LibreOffice project was born in Europe, and had strong roots in that continent. What should we do to increase the market penetration in Indonesia?

It should be easy for LibreOffice to become more widespread in Indonesia. Most Linux distributions already include LibreOffice, so it’s no problem for Indonesian Linux users. Now, the problem is that there are only a small amount of Linux users here. LibreOffice is not known to most Windows users. I think LibreOffice’s marketing community needs to learn/adopt the strategy of Mozilla Firefox in winning the browser war with Internet Explorer. VLC (VideoLan Client) is also another successful open source software that is widely adopted in Indonesia. So these things need to be done:

  1. Win the format war with MS Office
  2. Local content (tutorial, books for using LibreOffice in Indonesian language) – LibreOffice’s Help needs to be properly translated to Indonesian too
  3. LibreOffice videos. We need a lot of videos about LibreOffice tutorials in Indonesian language. LibreOffice Promotion videos. All LibreOffice videos should be available on popular streaming media.
  4. Active Indonesian LibreOffice social media (Facebook, Twitter, Instagram,etc) that are helping new users
  5. Indonesian LibreOffice ambassadors that are active within the community
  6. Reach out program toward schools and companies, and other institutions
  7. LibreOffice events, like the 2018 conference in Indonesia are good to penetrate the Indonesian market. Smaller events like release parties or mini conferences are also good. We could have join events with other FOSS projects
  8. LibreOffice marketing attribute like stickers, banners, T-shirts, etc
  9. Support for other platforms. Fully working LibreOffice for other platforms (ARM, RISC V, MIPS) should be available. The current LibreOffice viewer in Android is not enough. LibreOffice should also be available on emerging market of single-board computer platforms like Rasberry Pi, etc.

Thinking of the culture barrier and language barrier: which is the bigger one for open source?

With better technology, the language barrier will become smaller and smaller. We can now use many translation applications to help people adopt FOSS in many different languages. However, a culture barrier like the “piracy culture” I mentioned is not an easy thing to be solved. Probably it needs several generations of efforts to significantly reduce it. To end piracy, people need to change their mindset which I think is very difficult. We need to fight this piracy culture because it is bad for the whole community. For Indonesia, I believe this is number one enemy to the FOSS movement.

Finally, where do you see LibreOffice in five years from now?

I see great prospects for LibreOffice. In five years, I am sure LibreOffice will be gaining more and more users. The format war will be a long war, but in the end, the Open Document Format (ODF) will win the war. Like the web browser wars where the proprietary browsers are losing, I believe LibreOffice will one day win over MS Office. From version to version, LibreOffice is getting better and better while still retaining format compatibility, which is the key benefit of using LibreOffice. I believe LibreOffice will have a high chance to become the most-used in Indonesia with great efforts. When LibreOffice becomes the number one office suite here, I think all of the remaining South East Asia countries will follow.

Thanks to Iwan for his thoughts and feedback! One of the goals of LibreOffice is to be available in as many languages as possible, so if you’re reading this and want to help translate the interface into your native language see here to get started!

Community Member Monday: Onyeibo Oku

LibreOffice is a truly international project – its user interface has been translated into over 100 languages, and our community is made up of contributors all across the globe. Today we talk to Onyeibo Oku from Nigeria, who is helping to promote LibreOffice and open standards…

Tell us a bit about you!

I live in Enugu, which is in Enugu State, Nigeria. I lecture in a state university – and I also do graphic design and love music! By music, I mean “music” as an art – not just for consumption.

Although I didn’t go through formal training or education in music, I learned a bit of sight-reading (slow though), interpretation of chords, movements etc. and I play the keyboard (piano etc.). I communicate my understanding of music through digital sequencing. That implies that I compose and arrange sometimes. My choice of reference (genre) is wide but I appreciate classical, contemporary classics, jazz and choral music the most.

Sometimes I’m active on IRC: I spend some time in the #fedora-qa (quality assurance) channel on Freenode. I also visit #python when I run into problems with my programming. For communication I use Telegram, and I am also on Twitter and LinkedIn.

How do you use LibreOffice in your work?

I write reports and do grade sheets with Libreoffice. Every lecturer prepares result sheets – I do mine with LibreOffice. I also collaborate with students authoring research papers using Writer. The commenting feature is indispensable.

How are you promoting FOSS and LibreOffice?

I operate the ##floss4arch channel on Freenode. There, I discuss the benefits of open source tools in the practice of Architecture with students of the Enugu State University of Science and Technology. I am a Fedora Ambassador, and a (former) council member of the Free and Open Source Software Foundation for Africa (FOSSFA).

What are the challenges to adoption of FOSS in Nigeria?

The major challenge with adopting FOSS in Nigeria is the perception of “free”. Free things are considered “inferior”. Despite this mindset, it is hard to find a Nigerian who uses the internet without experiencing open source solutions like Firefox. Therefore, they’re mostly oblivious to how open-source products are pushing standards worldwide. Since Nigeria is weak in enforcing copyright laws, the average citizen has a skewed interpretation of licensing and the importance of software “freedom”.

What does LibreOffice need most right now?

For me, I think Libreoffice Calc should be able to retain header images when saving to MS Office DOC/DOCX file formats (and vice-versa). Currently, logos placed within headers disappear when the document is migrated to Microsoft’s format. A better commenting feature would certainly attract increased usage among the academics. Writer also sometimes seems jerky when working on documents with numerous pages.

What tools do you use for your work?

Apart from LibreOffice, I use Inkscape, GIMP, Blender, and Scribus. Python comes in when I need to automate tasks that support it. Then, I use Geany and Gedit for coding. Lilypond, Timidity++, Ardour and Audacity come into play when I need to arrange or sequence music.

Anything else you want to mention?

Yes – I work with FOSS 90-95% of the time. Open source software technologies are revolutionary!

Thanks to Onyeibo for his time! Anyone can help to promote LibreOffice and open standards in local communities: discover our existing native language projects, and also the regional mailing lists. If you want to start a new community, leave a comment below and we’ll get in touch!

Community Member Monday: Ahmad Haris

Today we talk to Ahmad Haris, who helps out with LibreOffice events in Asia, and has recently joined The Document Foundation’s Membership Committee. (Click here to learn more about the benefits of membership.) Here’s what he had to say…

Where do you live, how can people find you on the web, and what are your interests outside of LibreOffice?

I live in Bogor, West Java, Indonesia. However, I was born in East Java (the opposite side). I’m active on Facebook, Twitter, and sometimes Google+ and IRC (last one only for meetings with GNOME Foundation Members).

When I’m not working on LibreOffice, I play the guitar, or ride my motorcycle πŸ™‚

What have you been doing in the LibreOffice community?

I helped to organize the Indonesia LibreOffice Conference 2018 in March this year. (See the full report here.) That’s my biggest contribution so far. Before that, I just using and testing the software.

How did you get involved?

In 2008, I was migrating a city (Central Aceh – Aceh Province) and a province (Yogyakarta Province) here in Indonesia to use Free and Open Source Software (FOSS). At that time I used OpenOffice.org. I was helping the government to use it for two years, based on my job. Then time flied… LibreOffice arrived, so I moved to it.

What does LibreOffice need most right now?

In my opinion, LibreOffice needs a growing community, especially in developing countries in South East Asia or Africa. And we need to do more research, for instance on how people in those locations use office suites, what kind of templates they need, and so forth. In Indonesia, many users ask about page borders (a feature in other office software).

What tools do you use?

My main tools in all of my laptops (I have more than one, for travelling, for work and for playing/recording music) are LibreOffice, Visual Studio for code editing, Inkscape for vector graphics, Gimp for bitmap graphics, and Audacity for editing audio.

Anything else you want to mention?

To increase technical contributions to LibreOffice, I’d like to see more how-to guides for beginners, such as for contributing code for the first time, and organising workshops. Also, we should highlight success stories about implementations of and migrations to LibreOffice (I can help here, in terms of Indonesia).

A big thanks to Haris (as he likes to be known!) for his support and contributions to our worldwide community. And to everyone reading this, wherever you are on the planet, you too can make a difference and help to spread the word about LibreOffice. See here to get started!

Interview: Guilhem Moulin on LibreOffice infrastructure and services

A large free and open source software project like LibreOffice requires a lot of infrastructure, to support our users, developers and worldwide community. Today we speak to Guilhem Moulin, who is in charge of TDF’s infrastructure and services, about new developments and how others can get involved…

To start, please give us a quick overview of TDF’s public infrastructure.

The public infrastructure is powered by about 50 Kernel-based Virtual Machines (KVM) spread across 4 hypervisors plugged to an internal 10Gbps switch and hosted at Manitu in St. Wendel (Germany), and managed with libvirt and its KVM/QEMU driver. The virtual disk images are typically stored in GlusterFS volumes β€” distributed across the hypervisors β€” except for some transient disks (such as cache) where the IOPS need is higher and the redundancy less important.

All our public VMs run Debian GNU/Linux (currently a mix of Jessie β€” which are to be upgraded β€” and Stretch), each typically hosting a single service for better isolation. The rest of the stack is fairly usual: systemd as PID 1 & service manager, a mix of MySQL and PostgreSQL as RDMS, and nginx as SSL/TLS endpoint & reverse HTTP proxy. All of this is orchestrated and managed using saltstack.

About half of our Virtual Machines host public-facing websites; the other half are used for test instances, various production backends and internal services, as well as for tinderboxes and other hacking VMs. Some of these websites are mostly useful for developers, such our Bugzilla or gerrit instances β€” an overview of the development-focused sites can be found at https://devcentral.libreoffice.org. The remaining sites include the main LibreOffice website, the download page, the Wiki, Askbot, and of course the blog.

Beside these VMs, we also operate a handful of other machines for backups, monitoring, and mail systems, which are hosted offsite for obvious reasons.

What have been the most significant infra developments in the last six months?

Single Sign On (SSO) is probably what’s been the most visible to the community. Traditionally each frontend (Wiki, Bugzilla, Askbot, etc.) has its own private authentication backend, so once someone sign in to multiple services, they would have to remember multiple sets of credentials, which is cumbersome and makes password & email rotation difficult.

We now have a central authentication system (which uses an LDAP DIT as backend), but aren’t pointing individual services to it, as it would 1/ expose the shared credentials to all services hence increase the attack surface; and 2/ doesn’t solve the fact that users would have to enter their password to each service individually. Instead we’re deploying a solution using the SAML 2.0 protocol: unauthenticated users are redirected to an authentication portal against which they can authenticate, and they are redirected to the protected page afterwards.

Not all services have been migrated to SSO yet. An issue is that we have to unify accounts (people use different usernames in different services); and while we want a β€œcritical mass” of active user accounts in LDAP before migrating a service, it’s been rather difficult to reach out to people β€” even among TDF officials! β€” and convince them to create an account in the new system. Fortunately since we migrated the authentication system of our wiki, more and more people (among whom a lot of dormant accounts, probably spammers unfortunately) started using the new system.

While it’s only visible to infra team members, we also replaced our Graphite (+ Carbon + Icinga2) based monitoring system with Prometheus (+ data exporters + alert manager). Furthermore, still on the monitoring front but public this time, we just deployed a new service, CachetHQ, to show a quick overview of TDF’s infra status:
https://status.documentfoundation.org.

Last but not least, earlier this spring we were fairly busy with GDPR compliance.

What are you working on at the moment, and what are your plans for the next six months?

Aside from daily maintenance and occasional emergencies (system crashes, hardware hiccups, performances issues, etc.), infra team members still spends quite a lot of time on the above, as this is not completely finished yet. Projects for next year include working on a better backup solution, in particular regarding database snapshots. The data collection system for download metrics needs some improvement, too.

Finally, what cool things can new volunteer admins do to get involved and help the project?

We have a wide variety of systems, ranging for highly sensitive (election, internal mail, LDAP DIT, whitebox monitoring) to pretty much fully public beside the access logs (bitergia dashboard, blackbox monitoring). We can’t give upfront access to the sensitive side of the spectrum to everyone, but there are things to help with on the other side too (developer-focused services are typically less sensitive, since development is open anyway).

Sometimes we also start fresh and replace a service with something equivalent on a brand new box; in that case there is no sensitive data at stake, and it’s a great way for new volunteer admins to gain trust. I mentioned the monitoring migration earlier; we could also imagine replacing our ageing MirrorBrain deployment with a more modern solution like Mirrorbits, for instance.

Thanks to Guilhem for his time and help. If you’re interested in joining our infra community and gaining valuable experience in a large FOSS project, see here to get started!

Community Member Monday: Battsengel Ichinnorov

It’s time for another LibreOffice contributor interview! Today we speak to Battsengel Ichinnorov, a new TDF member, who helps to localise LibreOffice for Mongolian users…

Where do you live, and are you active on any social media?

I live in Munich, Germany, and I follow The Document Foundation and LibreOffice on Telegram. You can find some of my work on GitHub.

In which areas of the LibreOffice project are you active?

I am translating the wiki and LibreOffice itself into Mongolian (for instance, I made the keyboard layout for Mongolian for Windows: German and English. After this, I will create them for Linux.)

How did you get involved with LibreOffice?

A friend of mine, Dennis Roczeck is a helper and admin on the wiki.

What was your initial experience of contributing to LibreOffice like? What else do you plan to work on?

Everybody has a goal to reach, and mine is a free office for Mongolian people! Firstly I want to build a team and finish the user interface translation, then maybe get involved in development and/or ops and/or devops πŸ™‚

What tools do you use for your work?

So I know many tools, but the best is for me for programming, to save time and be productive, is IntelliJ IDEA. Other tools which I use: Atom, Notepad++, ConEmu for WSL in Windows.

What do you do when you’re not working on LibreOffice?

Meet my friends and go hiking in the Alps, and study programming languages or test new technologies. At the moment I’m looking at Docker, Kubernetes and Terraform in the cloud.

Thanks to Battsengel for all his contributions! If you’re reading this and also want to join our friendly community, and help to make LibreOffice even better, we’ve made a page just for you. There are lots of ways to get involved – we look forward to meeting you!

Community Member Monday: Sam Tuke

Over the last few years we’ve posted many LibreOffice contributor interviews on this blog. Today, we catch up with Sam Tuke who is a member of the marketing community and helps out with QA too…

Where do you live, and are you active on IRC/social media?

I live in Berlin, Germany. Originally I’m from Suffolk, England. I like Twitter and Mastodon for community news. For my business, which makes Free Software newsletter app phpList, I use Facebook and Telegram too.

In which areas of the LibreOffice project are you active?

The marketing team, and filing occasional bugs.

How did you get involved with LibreOffice?

While in high school I started a small business building computers for local people. They needed an office suite to come with their new PCs, and OpenOffice.org was the perfect fit. I’ve been a user and advocate ever since, following my friends to LibreOffice when it was established.

Later on I became a full time Free Software developer, and after that a campaigner. From 2014 I worked on marketing LibreOffice-related products at Collabora. It was an exiting time and I had the opportunity to announce LibreOffice for Android and LibreOffice Online.

What was your initial experience of contributing to LibreOffice like?

Much like other open source apps: find and use a complicated bug tracker to report an annoying problem. But I was encouraged by quick follow up by a friendly bug triager, and since then several issues that I reported have been fixed and released. Satisfying!

What does LibreOffice need most right now?

Marketing. It’s a brilliant software suite which offers great potential value to most people alive today, particularly when you consider the mobile and web-based products. Reaching all those people who stand to benefit from LibreOffice is hard work, but it’s worth doing. Italo Vignoli and Mike Saunders have been making strides in this direction, and that’s fantastic to see.

Also: focus. With so many different kinds of users out there, LibreOffice can suffer from being too powerful for it’s own good. LibreOffice has had the benefit of contributions from a variety of usability experts and professionals. There’s plenty more to do, but recent releases, and particularly LibreOffice 6.1 include gratifying improvements from Kendy, Heiko, Andreas and others, which I’m eager to see.

What tools do you use for your work?

Markdown everywhere: Gedit, Writer, Nextcloud notes, and Pandoc to convert between them. Sometimes I also use Thorsten’s odpdown to make presentations.

Calc handles internal financial reporting at the firm, with many charts, and a few arcane formulas which LibreOffice fortunately includes. Draw is great for quick colourful diagrams like server infrastructure and organisational charts.

What do you do when you’re not working on LibreOffice?

Since finishing a Master’s degree in spring I’ve become a mentor of startups in West Africa, and had time so speak at more Free Software conferences at home and abroad. In order to keep up with new interns at work I’ve also been reading textbooks on marketing and security – perfect for long sunny evenings in the park.

Thanks Sam! Stay tuned to the blog for more interviews. In the meantime, if you’re new to the LibreOffice project and want to help us make it even better, start here!