Import CSV from any device, any way you like, into Collabora Online 6.4.9

 

With the release of Collabora Online 6.4.9, it is now possible to import CSV files or structured text any way you like on any of your devices. We included a new dialog that makes the import process just as convenient as you are used to it on full-screen interface of your browser. This update does also include several performance and UX improvements.

Import CSV through browsers on mobile devices

Collabora Online allows you to access documents trough browsers of any kind of device. No matter if you are using it on a large monitor, laptop, tablet or smartphone – the flexible interface will provide you with a feature rich and consistent user experience. Collabora Online 6.4.9 introduces a new dialog allowing to import CSV files through mobile devices.

The dialog will show up whenever you access a CSV file or any other type of structured text through the browser of your mobile device. Inside the dialog you can adjust various settings for the import process:

  • Define character set
  • Choose language
  • Define import starting row
  • Specify separator options
  • Edit string delimiter
  • See a preview of the imported CSV

 

More features and improvements

There is more in to discover in this new version. Elements you might not notice at first glance, but do add substantial value to your workflow.

    • Performance improvements in Calc
    • Performance improvements in Writer (table editing)
    • User interface fixes in the NotebookBar
    • Fixed rendering of page background gradients

Find furtherdetails to this and earlier releases in the Collabora Online 6.4. release notes. Access your free demo today to test all the new features.

 

 

About Collabora Productivity

Collabora Productivity is the driving force behind putting LibreOffice in the cloud, providing Collabora Online and a range of products and consulting to enterprise and government. Powered by the largest team of certified LibreOffice engineers in the world, it is a leading contributor to the LibreOffice codebase and community. Collabora Office for Desktop and Collabora Online provide a business-hardened office suite with long-term, multi-platform support. Collabora Productivity is a division of Collabora, the global software consultancy dedicated to providing the benefits of Open Source to the commercial world, specializing in mobile, automotive and consumer electronics industries. For more information, visit www.collaboraoffice.com or follow Collabora Office on Twitter .

Read More

How to: easily deploy Collabora Online on your Kubernetes setup

All you need to deploy Collabora Online on your Kubernetes setup, is applying these configuration settings on your installation of Collabora Online.

Install Collabora Online on Kubernetes in 3 easy steps

With the increasing use of the Kubernetes, we are happy to provide an easy way to deploy our online on your Kubernetes setup.
Thanks to Collabora developer lpranam, Collabora Online can be setup with Kubernetes and also a key feature such as collaborative editing will work correctly. Therefore it is vital to ensure that all users editing the same document end up being served by the same pod. Using the WOPI protocol, the http/https URL includes a unique identifier (WOPISrc) for use with that document. Thus load balancing can be done by using WOPISrc – ensuring that all URLs that contain the same WOPISrc are sent to the same pod. We use a reverse proxy to achieve this load balancing mechanism. HAProxy provides the easiest way to achieve all are requirements for this setup.

Pre-installation checklist

  1. running Kubernetes cluster
  2. The helm command-line tool
  3. The kubectl command-line tool

Configuration files can be found at github.com/CollaboraOnline/online/tree/master/kubernetes/helm/collabora-online

Installation steps

  1. Install HAProxy ingress controller
    kubectl apply -f https://raw.githubusercontent.com/haproxytech/kubernetes-ingress/master/deploy/haproxy-ingress.yaml
  2. Prepare the namespace in the Kubernetes cluster with this command
    kubectl create namespace collabora
  3. Install collabora online helm chart
    helm install collabora-online ./kubernetes/helm/collabora-online/

Accessing online service

The following steps may vary a little according to your cloud providers. Here we demonstrate how to access the online with a minikube setup on a local machine.

HAproxy is installed as a NodePort service so to access any service through HAProxy we can use the node’s ip.

  1. To get your node ip with minikube minikube ip

example output

192.168.0.106

2. Each container port is mapped to a NodePort port via the Service object. To find those ports

kubectl get svc --namespace=haproxy-controller

example output

In this instance, the following ports were mapped:

  • Container port 80 to NodePort 30536
  • Container port 443 to NodePort 31821
  • Container port 1024 to NodePort 30480

3. Now in this case to make our hostname available we have to add the following line into /etc/hosts:

192.168.0.106 loolwsd.public.example.com

Feedback and community

If you have feedback, or want to get involved somehow: here’s our cool-dev community!

Read More