Visualizing your Success

5 06 2015

Some people think that personal success can be measured in bucks, clicks, +1s, or Likes.

So I won’t be surprised if somebody wants to visualize his personal value with a chart created with Apple’s spreadsheet app Numbers for iOS.

Here is the tutorial.

  • Step 1
    Create a new spreadsheet within Numbers.
  • Step 2
    Create a table (table 1, top left) and enter the months and the corresponding number of bucks or clicks in a month.
    The last row should contain the sum. It’s needed to display the relative amount of success (the ratio bucks / total x 100).

2015/01/img_3776.png

  • Step 3
    Create another table (below the first table). This table isn’t really needed but usually it’s worth to separate the data from its visualization.
    Refer to the the first two columns of table 1 by using terms like ‘=Table 1::A1′. This will show the months and the absolute values of bucks.
  • Step 4
    Now let’s create the crux of the matter.
    Use the built-in function REPT (Repeat) with the money bag (from Apple’s Emoji keyboard; activation via Settings – General – Keyboard – Keyboards – Add New Keyboard and select Emoji).

Refer to Apple’s excellent help for this function and all the others to understand the parameters.

  • Param 1
    the symbol you want to use for the bar graph
  • Param 2
    the length of the bar (the monthly value in % of the total)

Use it and you will see that Numbers for iOS is perfectly adapted to touch screens.

Note
If you want to refer to a cell of an other table in a function, just tap on it instead of entering the table number and the coordinates. That’s perfect user experience, isn’t it?

Now your visualized success is always with you, on an iPhone, an iPad, or an  Watch.

I suggest to publish your stats quarterly on the internet like Apple does in its U.S. Securities and Exchange Commission (SEC) filings.

Summary …

The usage of functions in Numbers is explained in meaningful helps.
An alternative is to enter the values in a table and use the feature Create Chart from Table. But that would be too easy. Always following the KISS principle doesn’t help you to improve your knowledge.

Related links …

Avoid a Liquidity Bottleneck

An Invoice created with Numbers

If Then Else

Thanks for visiting iNotes4You.





Creating Collages

10 05 2015

People say …

A picture is worth a thousand words.

And there is more …

Humans are designed to absorb visualized information in a jiffy and in many cases remember this information much longer than any other stimulation of senses.

Create collages on your iPad. It’s not only funny but also lets you digest the topic again.

Earlier I posted this image with an ironic content about Apple’s payment system, which works with the iOS devices starting with iPhone 6 and iPad Air 3.

2015/01/img_38931.png

It’s an example for what you can do on an iPad. See the appropriate ingredients, apps, and devices to create collages in the image below. The collage was also created with Apple’s presentation app Keynote.

2015/01/img_3916.png

It might be also worth creating some images with photos of your last holiday. Once you started you’ll love it.

The iPad is definitely a shining example for disruptive technology.

It’s because a touchscreen is much nearer to human activities than any other device or textbook could be. What we do is mostly what we do with our hands. It’s our first approach to new things. Creating artworks, modeling new devices, or writing down all the ideas leading to Einstein’s E=m c c equation on a sheet of paper while walking through the room and reflecting our thoughts is almost always done by hand.

Summary …

Stay hungry, stay foolish, and be creative with your iThing.

Related links …

iPad @ Universities

About the iPad

If you use images you should know something about the Copyright

The Copyright

Thanks for dropping by.





About Encryption

29 12 2014

Would you like to be able to use QR-Codes in order to let people quickly get some sensitive information, but also want to be able to restrict the number of people with access to the data? And what about iWork documents containing personal data? Is there a way to securely manage them?

IMG_3645-2.PNG

If you use an app like Qrafter by Kerem Erkan you may have the idea to use password-protected QR-Codes for sending sensitive data e.g. via mail or a messaging app like iMessage.

IMG_3322.PNG

The idea seems to be fascinating but let’s face the facts with an answer of the developer Kerem I got via E-Mail:

The encryption is 48-bit, meaning it is weak for any sensitive information. More secure encryption methods take too much data and QR Codes do not have such capacity. You should not use QR Code encryption for anything sensitive.

For the sake of security, it’s hard to beat the old-school, in-person hand off. It’s not the most sexy of options in the digital age, but surely there’s something titillating about a top-secret document hand off. Bring your briefcase and make it like a spy movie. Or don’t.

Don’t send your sensitive documents over email. It may seem private, but even if you’re using an email account that uploads attachments over a more secure HTTPS connection, like GMail, you have no control over your recipient’s server, and they may download your attachment from an unencrypted HTTP connection. Now say they did that from a public Wi-Fi network. Things just got very un-secure.

Some basics …

If you want your data to be NSA-resistant all files must be encrypted on your device before being transferred to the cloud. Your password should never be stored on your device or, if it’s stored there should never leave it. So no unauthorized user, not even employees of your provider, could ever access your data. Client-side encryption is the keyword.

Since encryption occurs before files leave your device it effectively wraps a protective wall around your data in the cloud. Employees then have very limited access to your data. They can only see how many files you have stored and how much storage space they occupy. The files themselves, as well as all metadata (folder names, file names, comments, preview images, etc.), are encrypted. The following chart illustrates three typical encryption schemes. The scheme in the middle is what is used by most cloud storage providers.

IMG_3323.PNG

What matters most when encrypting data is not the particular encryption algorithm (e.g. AES), but how it is used. Basically, there are three encryption schemes:

  • 1 None
    No encryption is used. Your data is sent to the storage in plain view, visible to anyone who has access to your network connection as well as to the storage provider. This is a little bit like sending someone a postcard: everyone involved in handling the postcard can read it.
  • 2 Encrypted connection (e.g. SSL)
    In this scheme, a secure channel is established between your computer and the storage provider before data is uploaded. That way, no one can eavesdrop on the transfer. However, the provider sees all your data. Often storage providers implement additional measures like creating corporate policies that disallow their employees to view your data. Another additional measure is using encrypted disks to store your data, so someone breaking into the data center and stealing the hard drives won’t be able to read it. However, it is still visible to the provider and its employees. This approach has the advantage that the provider can process your data for you, such as for creating a search index. Also, it is technically easy to make the data available in the web browser or through an API. The problem with this approach is that your privacy is limited. The storage provider can, for example, be forced to provide your data to a government agency. What’s more, employees will be able to read your data even if prohibited by company policies. It is also much more likely that bugs or other errors could result in data leaks. This is the most widespread approach implemented by cloud storage providers.
  • 3 Client-side encryption
    This approach is inherently more secure than the others. Apart from Box and Wuala, there are only a few other cloud storage providers following this scheme, mostly backup services. All data is encrypted locally on your device before it is uploaded. No one not explicitly authorized by you can see your data. Since not even the storage provider can see your data, they cannot be forced to hand it over to government agencies. The employees are also not able to read your data. As a side effect, it is impossible to recover your password in case you forget it. You can test your cloud storage provider’s security by checking whether they offer password recovery or password reset. If yes, then it does not employ client-side encryption. With client-side encryption, security is embedded deeply in the design of the storage.

    One of the main challenges with client-side encryption is key management. If you only want to back up, a single master key is enough. However, if you want to be able to share data selectively, your cloud storage must feature a sophisticated key management scheme.

With this in mind here is a more secure method to store sensitive data permanently or to exchange information with others.

Use a secure cloud storage, e.g. WUALA or BOX or an encryption software like BOXCRYPTOR and send the information as an encrypted file, a simple text message, a PDF file, or an iWork document.

Say you and your tech-savvy recipient set up a shared folder. Anything you put in that folder would travel encrypted from your folder to the provider’s servers to your recipient’s folder. That’s it.

Boxcryptor …

You use a cloud storage with standard, that means no, additional sevcurity?
Don’t worry. There is a solution for all well-known clouds including all other clouds which support the WebDAV protocol. It’s an application developed by the German company Secomba GmbH.

This video explains how Boxcryptor works.


(2:36 min)

Boxcryptor creates a virtual drive on your device that allows you to encrypt your files locally before uploading them to your cloud or clouds of choice. It encrypts individual files – and does not create containers.

IMG_3324.PNG

Any file dropped into an encrypted folder within the Boxcryptor drive will get automatically encrypted before it is synced to the cloud. To protect your files, Boxcryptor uses the AES-256 and RSA encryption algorithms.

Boxcryptor is free for one device and one cloud provider. You cannot use two iOS devices to manage encrypted files as long as both devices are linked to Boxcryptor. If you want to share encrypted files with others you can do that without a subscription.

A workaround …

You cannot turn off iCloud for individual iWork documents. So, creating a new document with sensitive data is a risk because the content automatically finds its way into iCloud.
Even if you turn off iCloud for documents but still use iCloud for backing up your device, your documents will be stored in iCloud and Apple has the key to decrypt them.

Here is a workaround which lets you manage encrypted iWork documents using Boxcryptor.

IMG_3325-0.PNG

This is definitely not a comfortable way but the only option to keep sensitive information away from unauthorized people. Even if government comes knocking there is no chance to decrypt your data regardless of the provider keeping your files. I would understand if you say “I hear the message well but lack faith’s constant trust.”.

Summary …

Sad to say that effective encryption is still not a standard feature of using cloud storages. Even Apple doesn’t use client-side encryption and so you should be careful when creating documents with sensitive data. Even if you deactivate syncing via iCloud your documents will find their way into the cloud when your iPad or iPhone initiates the next backup to iCloud.

Related links …

About QR-Codes

Mystic signs of progress

About encryption

Notes on encryption

About clouds

The cloudy iCloud

Risky free clouds

iOS cloud clients

Box for iOS

Thanks for flying with iNotes4You.





Facts about iWork for iCloud

6 07 2014

Since October 2013, shortly after Apple’s Keynote event, iWork for iCloud is available as a beta version going along with a redesign of it’s components Keynote, Numbers, and Pages. The iOS 7 adapted productivity tool is now free for new purchased devices.

20140326-091416.jpg

iWork for iCloud now allows working on documents across all kind of devices even on devices of other vendors. This works with every any browser like Safari, Google Chrome, or Microsoft Internet Explorer after signing in to iCloud with your Apple ID on iCloud com.

Use copies …

It’s always good to have a copy.

20140326-100131.jpg

Resolve conflicts …

If you use iWork on more than one iOS device and activated syncing via iCloud conflicts might occur if one of the devices you are working on is temporarily disconnected from the internet. In this case the document is saved locally on your device but cannot be updated in iCloud.

There seems to be a problem with iWork documents if one of the iOS devices wasn’t connected to the internet when editing a document.
But don’t panic. There is a way to fix it in a jiffy.

Just keep both versions of the document and decide later which one you finally want to keep.

This method of resolving conflicts is much more sophisticated than resolving conflicts which might occur in other apps like e.g. ByWord, a simple markdown text editor where you only can keep one version.

20140326-085254.jpg

And Apple wouldn’t be Apple if there would’t be more:

Edited documents are saved to iCloud along with a *history of the edits* you made. So when you open the document on another iOS device, you can undo individual edits, just as if you made them on that device.

If an iOS device is not connected to the internet a local copy of an iWork document is used to allow editing.
If you finish your work and the internet connection is still not available you will see an up-pointing arrow on this document in the documents overview. It means that the document is waiting for an upload to iCloud. The arrow disappears if your device connects to the internet again via WiFi or a cellular connection.

File sizes …

I myself use iWork for iOS extensively.
File sizes always matter if it comes to your iCloud data plan (5 GB for free), your data plan you fixed with your mobile provider, and the memory of your device.

So here are some average values for the ZIP files of iWork documents …

App Content File size
Keynote 100 slides 100 MB
Numbers 2 tables 1.1 MB
Pages 10 pages 3.5 MB

Notes

Keynote
The ZIP file of the mentioned Keynote presentation consists of 489 single files, primarily images.
Numbers
The ZIP file of the mentioned Numbers spreadsheet consists of 11 files with 4 tables and 2 images.
Pages
The ZIP file of the mentioned Pages document consists of 21 files with 10 pages, a table, and 5 full-page images.

Go to Settings – General – Usage and you get a list with you installed apps and the amount of memory they use on you device. If you extensively use the presentation tool Keynote keep an eye on the used storage, Keynote is a cormorant space eater if you extensively make use of images.

Exporting iWork documents …

If you use ‘Send a copy’ or ‘Open in another app’ for an iWork document you have to choose a format (e.g. for Numbers, PDF, Excel, or CSV within the app Numbers).

20140326-085430.jpg

If you choose the native iWork format for Keynote, Numbers, or Pages the app then generates a ZIP file. It contains the document, images used in the document, and a further ZIP file index.zip which contains properties of all objects you created in the document.

This is quote different from former versions of iWork which produced a single file with the extensions .keynote, .numbers, and .pages. The reason is the new collaboration feature of iWork for iCloud. It needs to save all objects separately to check whether they have been changed or not.

And it’s quite different from Microsoft Office documents which can only be edited by a single person.

This file can be easily opened on all devices running on iOS or OSX.
If you want to open Apple’s proprietary file format from within a cloud client app like Microsoft’s OneDrive client just choose ‘Open in Another App’ and then select the appropriate iWork app.

Syncing ….

iWork sync documents via WiFi or Cellular connections.
Go to Settings – iCloud – Documents+Data and at the end of the list you will find the option ‘Use Cellular Data’ to turn syncing via Cellular networks on or off. If you have a small sized data plan or work on large file sizes it’s recommended to set this option to OFF.

Optimizations …

I already explained that each iWork file is split into a set of files which allows improved collaboration features as well as performance improvements.

See what happens if you open an iWork app which files have been edited on other devices.

20140326-085537.jpg

In a first step you only can see the file names and after downloading the preview images iWork looks up file sizes so that only small files are immediately downloaded and others are downloaded not until you want to look into the content or edit it.

iCloud security …

iCloud secures your data by encrypting it when it is sent over the Internet, storing it in an encrypted format when kept on server (review the table below for detail), and using secure tokens for authentication. This means that your data is protected from unauthorized access both while it is being transmitted to your devices and when it is stored in the cloud. iCloud uses a minimum of 128-bit AES encryption—the same level of security employed by major financial institutions—and never provides encryption keys to any third parties.

iWork documents are part of the ‘iCloud – Documents + Data’ section in ‘Settings’ for your device. Documents are encrypted at a minimum of 128-Bit AES in transit (when sent over the internet) and at rest (when stored on Apple’s servers).

When you access iCloud services using Apple’s built-in apps, authentication is handled using a secure token. Using secure tokens eliminates the need to store your iCloud password on devices and computers. Even if you choose to use a third-party application to access your iCloud data, your username and password are sent over an encrypted SSL connection.

Summary …

I’d like to think Apple products are perfect and (not surprisingly) they obviously are (with some resyrictions). A powerful new approach to collaborative working. Apple’s ecosystem got a forward-thinking improvement.

Related links …

iWork to AirPort

iCloud, a paradigm shift

iWork and Sharing

Apple: iCloud Security

Thanks for visiting iNotes4You.





iWork to Airport

30 06 2014

iWork for iOS syncs all your iWork documents via iCloud with all your other devices running on the same Apple ID. Sometimes it’s useful to save an iWork document on an external storage e.g. a USB stick connected to your router e.g. an Apple AirPort Extreme.

There seems to be a problem with iWork documents winging to an USB storage.
I’d like to think Apple products are perfect but they obviously aren’t.
But don’t panic.
There is a way to fix it in a jiffy.
There is an app for that.

Here is how you can do it seamlessly.

The hardware and software …

This is my home configuration, an iPad, an iPhone, and an Apple Airport Extreme router connected to cable internet via a CISCO modem.

20140322-103727.jpg

I use the USB port of the router to connect external storage media with the WiFi network.

To seamlessly connect to external storages I use the app FileBrowser by Stratospherix. Over time it was improved many times and seems to be the best app to connect to local storages as well as cloud storages via WebDAV or predefined connections to well-known cloud providers like Dropbox, OneDrive, Box, or even Point.io. It also supports Microsoft’s SMB protocol (Server Message Block) to automatically connect to Windows networks and since the last update the FTP protocol (File Transfer Protocol) is supported with which you can seamlessly access web servers.

With FileBrowser, the iPad or iPhone becomes a powerful tool for business and private use. The app is easy to use and allows files to be downloaded, edited and uploaded back to the original location or distributed to other employees, partners or customers. With FileBrowser, users can access their documents from their mobile device and no longer need to take bulky laptops to meetings or out of the office when visiting clients.

Let’s take a look on this universal app by summarizing its features in a mind map.

20140322-103820.jpg

Feel free to download this map from my Box account.

The alternative file formats have been created with iThoughts HD for iPad (.ITMZ file format). Compatibility to other tools is limited. The DOCX file format is suggested for those who don’t use a mind mapping tool. The file contains the image as well as a detailed outline of all topics.

Application File format
Adobe Reader PDF
Apple iWork/Microsoft Office DOCX
iThoughts ITMZ
MindManager MMAP
XMind XMIND

The steps …

Step 1
Connecting to an attached storage

20140322-103355.jpg

20140322-103456.jpg

20140322-103602.jpg

Step 2
Using ‘Open in Another App’ in iWork

20140322-104231.jpg

20140322-104336.jpg

20140322-104437.jpg

i

An alternative …

An alternative to FileBrowser is GoodReader by Good.iWare. The app connects to the attached storage via SMB protocol.

20140322-103941.jpg

About SMB …
In computer networking, Server Message Block (SMB), also known as Common Internet File System (CIFS) operates as an application-layer network protocol mainly used for providing shared access to files, printers, serial ports, and miscellaneous communications between nodes on a network.

Not only does SMB allow computers to share files, but it also enables computers to share printers and even serial ports from other computers within the network. For example, a computer connected to a Windows network could print a document on a printer connected to another computer on the network, as long as both machines support the SMB protocol.

Though SMB was originally developed for Windows, it can also be used by other platforms, including Unix and Mac OS X, using a software implementation called Samba. By using Samba instructions, Mac, Windows, and Unix computers can share the same files, folders, and printers. This is great for those Windows-based office networks where there is a graphic designer who refuses to use anything but a Mac and a tech guy who does everything on his Linux machine.

Because of the many more features of FileBrowser, the clean UI, and the support of Point.io it’s more powerful than GoodReader.

An application …

If you don’t trust in cloud services or if your documents contain sensitive data you might want to disconnect iWork from iCloud.

Unfortunately you cannot deactivate iCloud syncing for single documents.

So you have to go to Settings – iCloud – Documents + Data and cut the connection for an app e.g. Numbers.

20140322-105723.jpg

From now on documents created with Numbers are saved locally and you can use the procedure iWork-To-Airport to save backup copies on the storage attached to you AirPort router.

Summary …

iOS devices with installed iWork apps should be improved regarding access to Apple’s routers and there should be an option for excluding single documents from automatically saving them on iCloud.

Related links …

Point.io

Thanks for dropping by.





Avoid a Liquidity Bottleneck

18 06 2014

To avoid a liquidity bottleneck at the end of a month you can use Apple’s iWork app Numbers. Once you created an appropriate spreadsheet with the necessary information you can predict your account balance more or less accurately (if the rare event of a crashed iOS device doesn’t happen and you are out of warranty claim).

Here is an example to create the spreadsheet using functions implemented in Numbers and some other tricky algorithms. The good news is, it’s synced with all your other devices via iCloud. So the information is available wherever you are.

The components …

What you need is

  • Apple’s iWork app Numbers
    It’s part of Apple’s iWork suite, the pendant to Microsoft’s Office suite with one important difference: it’s optimized for touch screens and seamless to use even on the small screen of an iPhone and all your documents are automatically synced with all your devices. You can even work on your documents if you don’t have access to one of your Apple devices because there is iWork for iCloud with which you can work on documents via browsers like Safari, Google’s Chrome, or Microsoft’s Internet Explorer.
    And it’s free for newly purchased devices.
  • A spreadsheet within Numbers
    which allows to predict the account balance
  • Access to your bank account
    to look up the transactions and the actual balance.

If you are not familiar with programming a spreadsheet don’t hesitate to download my template from my Box account. It’s free and there is no copyright on it. If you downloaded the template you can (easily) adapt it to your needs. The following description might help.

The spreadsheet …

The template contains two essential tables.
The first table is designed to enter the actual account balance, the performed transactions as well as periodical transactions. I call it the Dynamic table

The second table contains the dates for periodical transactions like rents or taxes to be paid in advance. I call it the Static Table.

Here is how it looks like:

20140314-185914.jpg

And here is the download link

Application File format
Apple Numbers numbers

Notes

If you tap on the link and downloaded the file you will see a control ‘Open in Numbers’ for a short time. If the message is gone just tap on the display again.

If you want to work with the template it’s highly recommended to do it with a copy of the original.

The dynamic table …

To predict the approximate liquidity at the end of a month you have to enter the actual account balance and monitor what’s expensed during the month by accessing the transactions with an online banking tool or a browser.

20140314-190023.jpg

The spreadsheet contains the necessary formulas to add or subtract incoming and outgoing money transfer. For cash payments (food, has, etc.) an approximate amount can be set on a weekly basis.

20140314-190850.jpg

Every time you get fresh cash from your bank you can reduce the remaining value with a so-called ‘Stepper’ control.
A Checkbox is used for payments on a monthly basis e.g. your health insurance. Just set it to true if the payment is expensed.

The static tables …

The first table is just for calculating a date 30 days prior to the actual date to point to an upcoming payment. The second table is for documentation purposes only and not used in any calculation.

The EOMONTH function returns a date 30 days prior to the actual date.

20140314-190209.jpg

This the conditional statement which sets the factor to -1 for all months (3, 6, 9, 12) with a due date. It can be easily adapted to other periods resp. months.

20140314-190303.jpg

This simple conditional statement sets a marker to emphasize upcoming payments.

20140314-190352.jpg

Summarized:

The kernel statement (image 2) sets the factor to -1 according to due dates.
Factor x Base Value defines the content in the column ‘Value’ which is part of the summarization to get the total liquidity.

The adaption …

You have to adapt the template by entering all the necessary values. A look on your last statements of account helps to find out the values. Some of them will be fixed values others vary and you have to define an average value.

You can use the COPY+PASTE feature to add more lines of similar type. In the context menu select ‘PASTE FORMULAS’ to let numbers adapt the clipboard content.

Summary …

If you run into the red it’s not my fault.
I’m sure the reason is your optimism bias or a shaking finger followed by wrong entries.

Related links …

An invoice created with numbers

If … Then … Else

Thanks for calculating with iNotes4You.





iWork and Sharing

28 05 2014

Apple’s iWork applications (Pages, Numbers, Keynote) save files automatically on iCloud and sync them across all your devices. With iWork on iCloud you can also access documents via browsers (Safari, Chrome, IE) without using an Apple device.

If you save a spreadsheet on iCloud, you can share a link to it with others. Recipients can open and edit the spreadsheet in a supported browser on a Mac or a Windows computer, and see all the changes others have made. Collaborators don’t need an iCIoud account to view and edit documents.

20140226-084103.jpg

iCIoud keeps your spreadsheet up-to-date across all your iOS devices, your Mac, and the web, so you and your collaborators always have access to the latest version.

Sharing a link …

If the document is open, tap ‘Share’ (top right), then tap ‘Share via iCloud’. Select an option for sharing. The full link appears in the body of an email, a SMS, or a Twitter or Facebook message or just copy the link to the clipboard to use it elsewhere.

20140226-082703.jpg

Any further edits you make to the document after you shared it are visible to the recipients of the link. The link remains the same. The only thing you have to do is to notify the recipients if a newer version is available.

Using a password …

An iWork document has only one password. If you already added a password, that password applies when you share a link. If you haven’t added a password, you can add one, then share.

  • With the spreadsheet open, tap on Tools, then tap Set Password.
  • Enter the password in the Password field, then enter it again in the Verify field.
  • Enter a hint to remind you of the password if you forget it.
  • Tap Done.
  • Tap on Tools, tap Share and Print, then tap Share Link via iCIoud.
  • Tap the method you want to use to send.
    The tull link appears in the body of the email, tweet, or post.</em

20140226-084222.jpg

Any further edits you make to the spreadsh after you share it are visible to the recipient of the link. Be sure to notify collaborators of the password so they can open it, even if you shared the spreadsheet before adding a password.
If your spreadsheet is already being shared, you can still add a password to it. Be sure to notify collaborators of the password so they can open the spreadsheet.

Resend a document …

You can share a spreadsheet link as many times as you wish.
With the spreadsheet open, tap Tools, tap Share and Print, then tap View Share Settings. Tap Send Link, then choose Mail, Messages, Twitter, or Facebook. Enter the requested information (for example, an email address or Twitter account).

Turn off iCloud sharing …

With the spreadsheet open, tap Tools, tap Share and Print, then tap View Share Settings. Tap Stop Sharing at the bottom of the pane.

20140226-084402.jpg

File formats …

If the recipient receives a link to a document the can choose the proprietary file format of iWork, that of Microsoft Office, or the Adobe PDF format for a download.

20140226-084451.jpg

PDFs can easily opened in Apple’s iBooks which offers the best reading experience.

The running iWork in iCloud …

iWork, Apple’s office suite for OS X and iOS, allows working on documents across all devices.

20140226-084552.jpg

Here is an example:

  • 1 On an iPhone I entered the text ‘Edited on the iPhone’ in a presentation managed by Apple’s app Keynote.
  • 2 Some seconds later a message pops up in iCloud opened on a Windows PC with Google Chrome. After accepting with ‘OK’ the document is accessible in the updated version.
    Note
    Don’t get confused with image 2. It was taken with my iPad while remotely connected to a Windows PC in the office.
  • 3 After entering the text ‘Edited on a PC’ in the browser-based version of iWork it appears on the iPhone after some seconds without any message.

20140226-093528.jpg

The image above shows the UI when working with a browser.
Learning difficulties: None.

Using an additional cloud storage …

In contrast to many other apps for file management iWork doesn’t support predefined cloud storages like Dropbox, Google Drive, or OneDrive. If you want to save iWork documents to other cloud accounts than iWork you have to use a WebDAV connection.

My post
WebDAV Basics
explains this protocol for communicating with remote servers.

Not all cloud providers support a WebDAV connection.
Since years I personally use Box and iDriveSync as additional cloud storages.
iDriveSync offers a secure solution since Feb 2013 because it works with client-side encryption, that means, only you have the key to encrypt and decrypt files. Your documents are encrypted already in transit and later on at rest on iDriveSync’s cloud servers. Box is working on a comparable solution.

Here are the WebDAV addresses of both competitors:

They can be used to save iWork documents via WebDAV.

20140226-084928.jpg

The steps …

  • 1 Tap on the action control (top left) in an iWork app.
  • 2 Select ‘Send a copy’.
  • 3 Select a document.
  • 4 Select ‘WebDAV’.
  • 5 Enter the URL given by your cloud provider (e.g. https://dav.box.com/dav).
  • 6 Enter you credentials.

iWork displays the folder structure. Select a folder for saving your document.

Restrictions …
iWork only supports the saving of documents. You cannot manage your files and folders.
So you need a file management app, either the native app of your cloud provider or a tool like FileBrowser with which you can access different accounts and move files between folders and accounts.

Notes …
1 If you share a link to a document saved on iCloud, recipients *cannot use mobile browsers* to edit the document on iCloud. He only can download it, work on it and send it back via mail. To avoid conflicts with your original document on iCloud it’s useful to save and share it on a different cloud storage.

This complicated workflow should be improved by offering a way to let recipients collaborate on iCloud documents even if they are on mobile devices.

2 If you create important documents you can use the ‘Copy’ function to always have a backup of each document on iCloud. This reduces your available space and it might be necessary to upgrade your iCloud plan. Saving a copy on a different cloud storage via WebDAV takes far less space on iCloud.

3 If you prefer to use Microsoft’s XLSX file format recipients also can access documents when using other mobile platforms.

Summary …

Again Apple provided useful features embedded in a simple but perfect UI.

Related links …

About WebDAV

About clouds

About iDriveSync

About file management

Thanks for paying attention.








Follow

Get every new post delivered to your Inbox.

Join 1,640 other followers