Reblog from iDriveSync

28 02 2013


Encryption should be offered by every cloud provider to build up a confidence base.

Originally posted on IDriveSync:

We know there’s always a concern about privacy when you upload stuff to cloud services. Luckily, we’ve got a way for you to keep your digital goodies under lock and key. Literally.

New accounts with IDriveSync now have the option of Private Key Encryption. This new feature will allow users to encrypt their data with AES-256bit encryption with a key known only to them. That means no-one but you can access it. Not us. Not hackers. Not the government. Not even the Borg.

Well, maybe the Borg, but even they’d have trouble.


Here’s how it works
Think of encrypted data like a jigsaw puzzle. Unencrypted, the puzzle is complete and easy to understand. Encryption jumbles the pieces all up, but puts numbers on the back so they can be reorganized easily. We’re using AES-256 bit encryption, which is basically the most difficult jigsaw puzzle ever devised. Private Key Encryption means…

View original 658 more words

Push and Pull

27 02 2013

We are not talking about pull-down menus or push-up bras.

This blog is about the technology to immediately transfer information to a recipient (Push) or to get information by asking if there are any news available (Pull).

What is Push and Pull?

The Post office is the active part and delivers the mail when there are new letters.
Getting a phone call and the daily newspaper are examples for the Push technology’s well.
In all situations you subscribed to something.

You are the active part when going to the post office and looking for new letters in your post office box. This generates more ‘traffic’ and so it’s not as efficient as the Push procedure.
I there is nothing new you flogged a dead horse.

Further examples of the Pull technology are browsing the web, where you ask via Google Search Engine and get the answer from a Web server which displays the site you were looking for.
No subscription is required to use the Pull technology. Unlike buying a newspaper at the kiosk your mobile device has to identify itself to get the requested information. This is done by your provider in connection with your SIM card.


Some of your iPhone apps are more pushy than others, and often you’d like them to stay that way. These apps take advantage of Apple’s push notification service to send you badges, sounds and alerts. However, too many notices from too many apps can get distracting, even annoying.
Push notifications of apps can be set up individually or collectively using SETTINGS of your device.

What does your device do?


Deactivate all push notifications …

Go to Settings – Notifications and turn off ‘Scheduled’.
Set suitable options for ‘Allow Calls From’ and ‘Repeated Calls’
Then go back to Settings and turn on ‘Do not disturb’.

Deactivate all push notifications for an app …

To completely turn off push notifications just turn off everything you just listed for that particular app: badges, banners, sounds, and whether the app appears in the ‘Notification Center’.

Not every app has to keep a connection open to some server, but there is one central connection that is kept alive for all push notifications for all apps.

In other words:
If you turn push off for an app that doesn’t receive any, there will be no change in battery life whatsoever. The easy way to know which push notifications are sucking your battery life, just look at what you’re receiving more often during the day. If you receive a Twitter notification every 5 minutes, all day long, the screen will always have to turn itself on to show it to you. This adds up usage minutes and drains battery power.

E-Mail …

Got to Settings – Mail, Contacts, Calendars – Fetch New Data.
If you turn on ‘Push’ you will get E-Mail immediately after your provider received a message for you. If you turn off ‘Push’ the timeframe below will be valid and uses the PULL technology that means, your device asks your provider whether there is anything new for you.

The battery life …

I found many articles saying that the battery life decreases rapidly when turning on push notifications. I started a test with 5 E-Mail accounts and activated notifications for Twitter, Facebook, LinkedIn, Google+, iMessage,, Quora, StumbleUpon, 4 forums via Tapatalk and the German sending messages nearly every 20 minutes.

Measuring the battery capacity on a normal day with Push and on another day without Push my impression was that there is no significant difference. This is admittedly subjective as I am not able to set laboratory conditions. 3-5% more or less battery power is marginal compared to the other 70 to 80% the iPhone consumes while doing other things.

If you want to save energy you must deactivate all settings which make the device to a smartphone and you better move over to a 20$ mobile phone.

You can find many suggestions about using push or pull to keep your battery alive for a longer time. All these discussions are for the trash, because the energy consumption depends on
how many notifications you get on an average and how Push is implemented in the different applications. Setting up Push requires to keep at least one connection alive all the time. Otherwise the pushing party would contact the nirvana. If there are less notifications it’s recommended to use Push technology because keeping a connection alive does not drain your power significant.

Pull technology is recommended for users who want to decide themselves what and what time he wants to really use the information. It’s monkey business to receive all the informations even if you have no time to read them.

So decide for yourself whether using Push or Pull.

My personal recommendation is, pull the information you want at a time you want and on an amount you want and don’t let the aliens give the beat. You only read your E-Mails when you are in a position to and have the time. Doing a manual download takes seconds and information can be read then or at your leisure.

Reducing energy consumption …

Here are some suggestions to reduce energy consumption when using Apple’s new operating system iOS 7.


The history …

The Apple Push Notification Service is a service created by Apple Inc. that was launched together with iOS 3.0 on June 17, 2009. It uses push technology through a constantly open IP connection to forward notifications from the servers of third party applications to the Apple devices.
Scott Forstall stated that push notifications were a better means to maintain battery life than background processes (which are used for pull technology) as far as receiving notifications are concerned.

A more technical view …

Apple Push Service Protocol

Thanks for dropping by.

SIRI’s skills

25 02 2013

SIRI is the implemented femininity of iOS devices although nobody knows how she looks like.
Did she improve her communication skills?

In the last update of SIRI’s skills Apple provided the opening of apps.
Activate SIRI and say ‘Open Settings’ and SIRI will open the device settings.

With iOS 5 Apple included a special URL scheme, for example


to enable direct access to special settings of the device via a Safari link. Some developers created a MobileConfig package that automatically adds many of these settings to your devices home screen with a self-explaining icon.

This doesn’t work with the actual iOS 6.

But with the help of SIRI it’s possible to directly access some settings.
It works via Apple’s Contacts app by defining an appropriate URL and forward the contacts name to SIRI.


There are some more settings which can be directly accessed to SIRI.
Some of them may be useful for security reasons when driving a car.

Here are some examples for keywords correctly executed by iOS 6.

Keyword opens
Bluetooth Bluetooth
CASTLE&path=STORAGE_AND_BACKUP iCloud Storage + Backup

But be careful.
The keywords are case-sensitive. If you enter ‘facetime’ instead of ‘FACETIME’ your device will execute a reset.

What you have to find out is the right name for the contact so that SIRI directly presents you the desired function without further proposals.

My proposal BLUE for opening the Bluetooth settings works well in Germany with my existing contacts.

A call on Apple …

To the decision makers of Apple:
Please allow the developers to implement commands like this:

SIRI, turn on Bluetooth.

Femininity and serving even male users can go together.

Thanks for reading my blog.
Comments are highly appreciated.

iTunes and File Sharing

24 02 2013

Introduction …

Apple offers an application called iTunes to install on a Mac/PC.
This application provides a functionality called File Sharing for supporting the transfer of files between an iOS device and a computer. When I talk about File Sharing I talk about the tab APPS in iTunes and not about music, photos, or other stuff.


You should always keep in mind that regular backups of your device are indispensable but there is no way to extract a single file from this backup for restoring it on your device. If you loose a file you must have a copy elsewhere to restore it, or, you must restore your complete device and loose all your data changed after the last backup.


For some other files the data exchange is also supported without the use of iTunes, e.g. the Photo Stream where photos are transferred automatically to iCloud and from there transferred to all other devices using the same Apple ID.

To understand File Sharing we first take a glimpse on the iOS filesystem.
Refer to the image above.

Specific folders are assigned for each app on your device. An app only can work with these folders and not with folders of another app. This is what Apple calls ‘The sandbox mode‘ and it’s designed for security reasons. An iOS app’s interactions with the filesystem are limited mostly to the directories within the app’s sandbox. Because it is in a sandbox an app is generally prohibited from accessing or creating files outside its home directory. One exception from this rule is when an app uses public system interfaces to access things such as the user’s contacts.

This design prohibits direct access from your computer to files on your device, e.g. you cannot copy a PDF which was generated by the app Scanner Pro after scanning a document.
However, a user must have access to some files on his iOS device to further use them on the computer. This functionality is provided by iTunes File Sharing.

How to use File Sharing …

How to install and configure iTunes see

Apple iTunes: How to set up an Apple ID

Connect your iOS device to your computer using the included Dock Connector to USB cable.
Launch iTunes on your computer. Select your iOS device from the Devices section of iTunes.

Click the Apps tab and scroll down to the bottom of the page.


If you do not see the File Sharing section shown in the image below, your iOS device does not have any apps that support File Sharing.


Under the File Sharing section, you’ll find a list of apps currently installed on your iOS device that support File Sharing. Select an app to view a list of the files associated with that app on your iOS device.

How to copy files from and to the iOS device …

Drag and drop files onto the Documents list to copy them to the app on your iOS device or…
Click the Add… button, locate the file or files you want to copy from your computer, and click Choose. The selected files will be copied to the app on your iOS device immediately. Select only files that are supported by the iOS device app. Refer to the iOS app’s documentation to determine which file formats are supported.

Avoid data loss …

Be careful …

If you delete an app on your iOS device
you also delete all files associated with it.
That’s a consequence of the above explained iOS file system.

To avoid losing files on your iOS device associated with the app, back up and copy shared files to your computer frequently, and especially prior to deleting the application from your iOS device.

To do this, select the files shown in the Documents section of the specific app and copy them to a local folder on your computer. The folder should be named with the app’s name.
If your device is an iPad, the app, which files you want to save is Apple’s Keynote than put the files in a well-named folder on your computer and name it like



It depends on the app’s functionalities which way is best to avoid data loss.
Some apps with iCloud support, such as Apple’s iWork suite, save files as a local copy on your device and in iCloud to push them to other devices.
With other apps not supporting iCloud but supporting ‘Send by E-Mail’ you may send a file to your own E-Mail address and use it as a backup.

Syncing …

What is syncing compared to file sharing?

Syncing (with your computer) means that changes to files you made on your iOS device are transferred to your computer’s local hard drive when you connect your device via USB to your computer, open iTunes, select your device and start Syncing.

Which data are synced?

Documents Directory – ApplicationHome/Documents
The Documents directory is the primary location to save user and application related content. This directory and its subdirectories, are backed up when a user does a sync with iTunes. This directory is also the repository for iTunes file sharing content.

Documents Inbox – ApplicationHome/Documents/Inbox
The Documents Inbox is primarily used when an application such as Apple’s Mail app calls an app with a request to open a specific file type.
The file passed to the application (from the Mail Inbox) is stored in the Documents Inbox directory.
The content in the Documents Inbox directory is backed up when a device is synced with iTunes.

tmp – ApplicationHome/tmp
As the name implies, the tmp directory is available for files that are used only while your application is running. The content in the tmp directory is not backed up when a device is synced with iTunes.

Library – ApplicationHome/Library
The Library directory is intended for content that is not user generated. The content in the Library directory is backed up when a device is synced with iTunes, with one exception, there is a Caches directory that is not backed up.

You might think that if you sync you already have a copy of your data on your computer.
That’s true, but not in all cases.



Files of the app Discount Spreadsheet (Luminant Software) are updated in the File Sharing section of iTunes every time and immediately after you connect your device via USB.

Files of Apple’s iWork suite on the other hand are possibly not displayed. The reason than is that they never were copied to iTunes. As I figured out data of some apps have to manually transferred to iTunes.

There is no general rule which app presents its data in the File Sharing section of iTunes. If you don’t see any files after selecting an app, open the app on your iOS device and try to find an option (like File Sharing, e.g. app 1Password) or a command (like ‘Copy to iTunes’, e.g. apps of iWork suite) to transfer files to iTunes.

The possible behaviors of apps syncing with iTunes File Sharing sections are

  • automatically
    e.g. Tap Forms, Plain Text, Discount Spreadsheet
  • not automatically, only after manual action like ‘Copy to iTunes’
    e.g. iWork (Numbers, Pages, Keynote)
  • after entering credentials and selecting a command like ‘PC iTunes File Sharing’
    e.g. Safety P+V, Safety Notes
  • on demand after activating this feature in Settings of the app (File Sharing ON)
    e.g. 1Password

Syncing with iCloud …

For Apple’s iWork suite keep in mind that turning off syncing with iCloud stops syncing across all of your other devices and iWork files are only stored locally on your iOS device. You should never set the option ‘Use iCloud’ to OFF (Settings – options for Keynote, Numbers, Pages) if you work on more than one device.


If you possibly turn it to ON later you will get a lot of messages regarding different versions of your documents and you have decide for each single document what to do (Keep it from this or that device or both).


Summary …

There are apps supporting file sharing, other apps which do not, apps syncing with iCloud or not, apps providing backup functionalities, and others for which iTunes File Sharing is mandatory.

For Apple’s own iWork suite the situation is a bit confusing.
If you use iCloud the documents are synced with iCloud and across all your other devices but not backed up in iTunes. And unfortunately there is no option to copy them to iTunes in total.


You may think that this blog article is a bit confusing with all its If’s and Then’s and Else’s and But’s. But I don’t bare the blame. If there is no consistent concept there is no consistent description.

My personal recommendations …

Turn on Syncing via iCloud

Your benefit:
Data of iCloud capable apps are accessible on all of your devices
and are also available as local copies if you currently don’t have an internet connection.
But keep in mind that if you delete a file on one device it’s immediately deleted across all other devices using the same Apple ID.

Use an additional storage

Your benefit:
There is an extra level of copies of files which can be separately restored whatever happens on iCloud or on your device.
For iWork you may use the available WebDAV connection to a cloud provider (e.g. iDriveSync). If you install the related client application on your computer you will also have access from your computer to those files without using file sharing of iTunes.
Use ‘Copy to WebDAV’ every time you worked on a single document.

Useful links …

Apple How to transfer or sync content to your computer

Apple iOS: About File Sharing

Apple iWork for iOS: About File Sharing

Apple iOS: Syncing with iTunes

Apple iTunes: About iOS backups

iNotes4You iWork and iCloud

Cloud Providers for iOS Devices

22 02 2013

There is a rapidly increasing number of Cloud-Providers. You have to decide which fits best. Otherwise your data will be spread over the world and its hard to find out where they are.

I checked free accounts of 12 providers and their usability on Apple’s iOS-Devices as well as their PC-Client versions since more than one year. This article describes my experiences with all the free offers.

Summary of the main test criteria:

1 iOS-Client-Software available

  • to display the frequently used file formats like PDF, TXT, CSV, XLSX, DOCX, iWork-Format (.numbers, .keynote, .pages)
  • to manage files and folders
  • to get links for sharing files
  • to share multiple files via a single link

2 PC-Client-Software available

  • to permanently sync local folders on Mac/PC with cloud folders
  • to set up the sync direction (two way or one way syncing)

3 Encrypted transfer of data between local device and cloud storage

  • to avoid the usage of special apps for encryption like BoxCryptor for Dropbox
  • to securely manage data in transit (while transmitted between the provider and the device) and at rest on the cloud storage

4 Amount of free space

  • should not be less than 5 GB
  • reasonable prices for account updates to higher capacities

5 WebDAV-Support

  • to set up an additional connection other than the native provider’s native app via administrative tools like USB Drive, GoodReader, ReaddleDocs, …
  • to assign shares to a drive letter on a PC and work with this ressources within any application (e.g. saving documents from iWork directly to the cloud

6 Performance, Activity, Usability

  • immediate syncing with high performance
  • plain activity indicators on Mac/PC for sending and receiving files on Mac/PC
  • available context menu on the Mac/PC icon with all necessary functions for accessing local sync folders, preferences, recently updated files, etc.

7 History

  • availability of a file history
  • availability of restoring deleted files from the trash within a reasonable timeframe

Main facts …

Cloud Free WebDAV Encrypt Syncing
iDrive 10 GB yes no multiple, selectable folders
Dropbox 2 GB no no one folder+subfolders

iDriveSync and Dropbox provide powerful apps for Mac/PC as well as iOS devices.

Dropbox and iDriveSync sharing options on iOS devices are:
E-Mail, Message, Facebook Message, Post to Facebook, Tweet

A special functionality of Dropbox is the ‘Camera Upload’ which uploads every photo you made with your camera on an iOS device.

Both providers do not support encryption in transit.
If the provider is compromised your data will be unsafe.
Except WUALA (CH) no provider fulfills the necessary requirements for safe transfer and storage.
Admittedly cloud providers ensure encryption but the Terms and Conditions of nearly all providers authorize them to review the data or pass them to authorities on demand.

Dropbox currently does not support WebDAV whereas iDrive does. That must not be a disadvantage because the PC-Clients support convenient syncing with local folders and most of the iOS-Tools (like USB Disk, GoodReader, Documents, …) support direct access to the storage of well-known providers.

If using the iWork suite intensively Dropbox is not the best candidate as there is no support for WebDAV. If iCloud syncing for iWork is turned on (Settings – iCloud – Documents + Data) they are admittedly transferred to other iOS devices but only those using the same Apple ID. So sharing is only supported by mailing the document as an attachment.

iDriveSync supports WebDAV and therefore can be configured in iWork using the ‘Copy to WebDAV’ feature. What you have to do is to enter the server address (, your credentials and to share the iDriveSync folder with your colleagues.

Both iOS apps support the display of the above mentioned file types except CSV files.

Another benefit of iDriveSync vs. Dropbox is the pricing (1.38 $ /50 GB/y vs. 3.75 $ /50 GB/y).

So the overall winner is iDriveSync.

Useful links …

Sharing Multiple Files on iDriveSync

Costs of Cloud Storages

Risky Free Clouds

Which Cloud Provider fits best

Some impressions of the UI …


iWork and iThoughts

20 02 2013

iWork is Apple’s offer to create spreadsheets (with Numbers), presentations (with Keynote), and write letters (with Pages). The components of iWork are specially developed for iOS devices, easy to use and nevertheless powerful. I see lacks in the missing connection to cloud services without WebDAV support and to network attached storages.
If you ever used these apps you will never change back to other apps which are more likely to Microsoft’s Office Suite.

There is another app which should be in the portfolio of all users working on an iPad.
It’s the mind mapping app iThoughts for iPad developed by Craig Scott, UK.
Mind mapping is a perfect way to save all the ideas you have on your device.

See my blogs

Mind Mapping (1)
Mind Mapping (2)
Mind Mapping (3)

In Jan 2013 iThoughts got an update with some interesting features regarding Apple’s iWork suite.

The Workaround …

This is a mind map about a recommended home configuration when using iOS devices.

You may download this mind map from, The Mind Map Library.

Apple iPhone+iPad Home Configuration


Look at the branch ‘Software – iWork – Numbers’ on the right side of the mind map. You can see a small green at the top right corner of the branch. It represents a globe and points to a website link.
Tap and Hold to open the website with the integrated browser of iThoughts.

The essential new feature of iThoughts …

You can now connect iWork documents to mind map branches to breathe life into your mind map by assigning additional detailed information to that branch.



Attached documents are stored in the mind map file in their native format.
So you can delete the source file located in the documents folder of Keynote.
You can also share the mind map. The recipient can then work on the mind map as well as on the attached iWork documents and send them back.

The marked branch contains the Keynote document icon as well as the note icon of iThoughts (left lower corner of the branch) which shows that there is additional information available. By ‘Tap and Hold’ the Keynote document can be opened to display the contents or to move over to Apple’s Keynote app to further work on it.


That’s what I call SUBTLE PROGRAMMING. Congratulations, Craig.

Apple on

19 02 2013

A mind map is a diagram used to visually outline information. A mind map is often created around a single word or text, placed in the center, to which associated ideas, words and concepts are added. Major categories radiate from a central node, and lesser categories are sub-branches of larger branches. Categories can represent words, ideas, tasks, or other items related to a central key word or idea.

The website


is the world’s largest free mind map library founded by Liam Hughes, UK.

On January 1, 2013 I created a new group on named APPLE.

The Apple group offers free mind maps about Apple products, the operating system iOS for mobile devices, and apps from Apple’s App Store.

To download mind maps from Biggerplate you have to register first. Just enter your E-Mail address and a password and you will become a member. The membership is totally free.

You can download any mind map created by more than 40,000 members for free.

For the Apple group it’s recommended to use the app iThoughts by Craig Scott available at Apple’s App Store. It’s the only app supporting about 20 different formats especially .mmap files (Mindmanager), .xmind files (XMind), and .cdmz files (ConceptDraw) which are supported by Biggerplate.

The latest mind map uploaded to Biggerplate within the Apple group is a full feature description of the database app Tap Forms HD by Tap Zap Software Inc., Canada.
It’s an autonomous app for database creation that means, you don’t need a Mac/PC to create your own database. Tap Forms supports iCloud and Dropbox as well as Backup+Restore using a ZIP file format.


Go to

Apple group on Biggerplate

to download the mind maps you are interested in.

Liam and Thomas would highly appreciate if you upload your own mind maps related to Apple products.

Associated links …

DBMS on iOS-Devices (1)

DBMS on iOS-Devices (2)

Mind Mapping (1)

Mind Mapping (2)

Mind Mapping (3)

If you have any questions about the app iThoughts or the platform Biggerplate don’t hesitate to contact me via the contact form on my About page.

Importing Data

17 02 2013

The workaround …

Accounting data are to be imported on an iOS-Device.

The data source is a CSV file exported from Microsoft Excel or Microsoft Access.

If you want to check out same results or need data for tests download the file here


It contains accounting data with account numbers, account names, and accounting values over 6 years and look like this:


As you can see CSV files are readable files with single lines where the data are separated by a delimiter (a semi-colon or a tabulator) and thus ordered in columns.
Nearly every application is capable of importing data from those files as it is a received standard all over the world.

The data receiving applications are Tap Forms HD for the iPad (Tap Zapp Software Inc., Canada) and Numbers (the spreadsheet part of Apple’s iWork-Suite).

The device is an Apple iPad 3 with 64 GB storage capacity.

If you want to import data to Tap Forms HD or Numbers you should know something about the formatting options for numbers and the encoding of text.

Formatting of numbers in Microsoft Excel, Access …


Format cells with numerical content as numbers (not as currency).
Adjust the decimal places and set the 1000-separator.

There are lots of options when exporting data from Microsoft Access to a CSV file. Use ‘Export to Textfile’ to set up the appropriate values. The settings can be saved for further exports.

Encoding …

Differences between Ansi and UTF-8

1. UTF-8 is a widely used encoding while ANSI is an obsolete encoding scheme
2. ANSI uses a single byte while UTF-8 is a multibyte encoding scheme
3. UTF-8 can represent a wide variety of characters while ANSI is pretty limited
4. UTF-8 code points are standardized while ANSI has many different versions

The import …

Just importing data is unprofitable arts. So in both applications the mean value of the 6-years accounting data is calculated as an example. For Year6 all values are zero so the mean value is taken just from the first 5 years.

Numbers (Apple)

As it is not possible to directly access data in iCloud you must use the Numbers functionality ‘Copy from WebDAV‘ to get the import file. Unfortunately Dropbox does not support WebDAV access while Tap Forms HD does. If you have the file elsewhere you may use the ‘Open in‘ command. It works also in the iOS Dropbox app. What you should know is that the Dropbox app does not show you the contents of a CSV file (App version 2.0.2).

If the file is downloaded the import starts directly and you don’t have to set any options.
It took 12.5 sec to scrape the CSV plate. It took another 15 sec to kick it into iCloud.
And it was a bit crazy to drag the yellow ‘Fill’ rectangle over 389 rows.


Tap Forms HD (Tap Zapp Software Inc., Canada)

There is an easy way to prepare for an import by letting Tap Forms HD automatically create a table. In this case all fields are imported with field type TEXT and thus cannot be included in calculations. Tap Forms HD does not first analyze the data and then set the correct field type.

Also Apple’s Numbers cannot identify field types. After importing into Numbers the relating columns have to be formatted as numbers before including them in formulas.

As an alternative you do this automatic import and after its finished change the field type for numeric values from Text into Number, delete all records and restart the import.

Here are the steps to do the import with Tap Forms HD.


Summary …

There are not many rows imported in Numbers nevertheless Numbers reacts a bit spastic when adjusting the column width, setting any formatting or adjusting the column width.

See my blog

To the limits

A benefit of Numbers is the free-style formatting, printing all data and a large number of built-in functions for more complicated calculations. Import options are not available following Apple’s KISS principle. Usability problems already come up with more than 300 records. Numerical values can be compared in charts.

Importing into the Tap Forms HD database (SQLite based) is recommended for a larger amount of data and usual operations on numerical values. The SQLite database working in the background does not have any performance problems even with the 65535 records I imported in my test-environment (Performance: 2 min/1000 records). As i wrote in my blog ‘To the limits’ Apple’s Numbers crashed long before reaching this limit.

In Tap Forms HD queries (respectively Searches) can be executed and saved for further usage. This feature is not available in Numbers but often needed to reduce the total contents to the relevant records.
Printing of records is available but currently just for a single record. You might say printing is old-fashioned but if you extracted relevant records (e.g. all records starting with 8 in the account number (these are accounts related to items like Sales in the Profit and Loss Account) or account values greater than 500.000) you usually want to print them out as a spreadsheet and review the data without the need of any device.


Tap Zapp Software, the developer of Tap Forms HD, is highly innovative and its just a question of time until app updates bridge some current gaps.

Can both applications work hand in hand?

Yes, they can. Use Tap Forms HD to define a search rule (query), export the subset as CSV file, and import it in Numbers for further processing.

Technical Note …

There is one feature of Tap Forms that allows to include field-type tags in the header row to tell Tap Forms which fields are numbers and which are text or dates or other field types.

For example if the first header row was as follows, Tap Forms would correctly create the form with the correct types:


(WordPress deletes all pointed brackets from blogs so I used square brackets; the square brackets must be replaced by pointed brackets)

Although [text] is the default if it’s not specified in the column. When importing dates the Tap Forms date import format must match the format of the date in the CSV file.

Here is a list of all field-type tags for Tap Forms HD.
It can be used when migrating from a previous database app to Tap Forms HD.

Text… [text]
Number… [number]
Date… [date]
Time… [time]
Date + Time… [date_time]
Audio Recording…
Calculation… [calc]
Check Mark… [check_mark]
Contact… [contact]
Drawing… [draw]
Email… [email]
File Attachment… [file]
Link to Form… [form]
Location… [location_address]
Location… [location_latitude]
Location… [location_longitude]
Location… [location]
Note… [note]
Phone… Number[phone]
Photo… [photo]
Rating… [rating]
Section Heading… [section]
Web Site… [web_site]

Related Links …

DBMS on iOS devices (1)

DBMS on iOS devices (2)

DBMS on iOS devices (3)

DBMS on iOS devices (4)

DBMS on iOS devices (5)

Form Access To Tap Forms

Databases and Mind Maps

Thanks for visiting

Curious stuff

15 02 2013

Some curious stuff I found on iPhone, iPad, App Store and in the internet.
Even developers are human beings and therefore do cloudy things.

That wouldn’t be a problem for users if there is a well-functioning internal control system.
Let’s be sympathetically with all the developers. I know they are always flat out like a lizard drinking.

If you are a proud owner of an iPad or iPhone mark the following text, tap on Speach and listen what R. Niebuhr tells us

God grant us the serenity to accept the things we cannot change, the courage to change the things we can, and the wisdom to know the difference.

Not related to Apple’s devices …

I found this in a German forum for bikes:

My torque-limiting-wrench is only good for 100 Nm.
I have to fix the screw with 115.
Can I first fix it with 100 and after that with additional 15?

If you have to drill a hole with 8mm diameter
you can do it with one 3mm and one 5mm drill or even better, you take two 4mm drills than you must not change from 3 to 5.

Poor programming …

An application should delete following blanks. If it does not you may get a problem.


The E-Mail address was entered as a shortcut in
Settings – General – Keyboard – Shortcuts
with the phrase and the shortcut ‘aid’.
If you want to use the shortcut you have to tap on the space bar to overtake the phrase. So a blank is appended, 1Password saves it and Apple’s website informs you about wrong credentials.

This is not always the case. Some apps and websites ignore following blanks as anybody would expect. What should a blank character be for? Nobody can see it and applications therefore should ignore it at least for usernames and even for passwords.

Mostly unknown features …

A mostly unknown feature which additionally makes no real sense.
But it follows the wisdom ‘Time is money’. So if you have an appointment at 10:32 you are able to set your calendar event on your iPhone to 10:31.


Tapping and Holding …

Safari and Home Screen …


Safari’s automatic website shrinking …

Look at this curious behavior of SAFARI on an iPhone 4S. After 30 secs the website begins to shrink and no other website can be opened afterwards.
The phenomenon did not appear on an iPad and it did not appear on the iPhone when using Google Chrome or Mercury browser.

(Video recorded in Jan 2013 by iNotes4You)

Apple’s Mail app …


An accurate description …

This is a very accurate description of an iOS-App-Update in November 2012.
But there are still intensifications:
The app has changed or Nothing.
Sorry developers. This was the reason why you didn’t get the pole position.


The Pareto Principle …

The Pareto principle (also known as the 80–20 rule, the law of the vital few, and the principle of factor sparsity) states that, for many events, roughly 80% of the effects come from 20% of the causes.

80-20 Rule Applies To Bugs, Not Just Features by P. Rooney, Microsoft CEO

80-20 Mind Map by Liam Hughes, UK at

If this is true Apple should change 20% of code in iOS 7 to satisfy 80% of it’s customers.

I tried several times to validate this principle by working 20% of my time in the office, drinking coffee the 80% remaining time to settle 80% of the tasks. I tell you all, I did not work.

The WiFi problem …

Royce Eddington
Sometimes my iPhone will refuse to “see” any WiFi connections.
There are some times on the iPhone when I can go to GENERAL, then SETTINGS, then RESET and then choose RESET NETWORK SETTINGS. After the iPhone reboots, sometimes the WiFi comes back. Sometimes. But when that doesn’t work, there’s one trick that always does.

I power off my iPhone. Put it in a Ziploc bag. And put the bag on the top shelf in the freezer. About an hour or two later, I take it out and let it sit at room temperature for about 20 minutes. Then power it on … and WiFi is back.

The first post …


Updated intelligence …

This new iPhone automatically adjusts to the length of a website.
Apple’s knowledge and innovation skills led to a unique new feature which prevents expanding of the device if the website’s content is bullshit. And with a new sensor technology it automatically resizes if a jacket pocket is coming closer.


The good news for iPad owners: Automatic form factor resizing up to 52″ on iPad 48.

Databases and Mind Maps

13 02 2013

The strong benefit of a database is the synopsis of otherwise widely spread informations. Apple’s App Store offers a lot of apps suitable for productive operations but all the informations saved by these apps are cut into pieces saved in app-specific folders. You can use Safari for saving links, Pages for saving text documents, etc. but you cannot connect the information as a whole.

A well designed database is an appropriate approach to the problem. There are a lot of ways to design a database and there is no rigorous right or wrong with creating them relying on the arbitrariness of human thoughts. It’s largely a matter of personal preference.

Tony Buzan, who invented mind mapping, describes a mind map as

a powerful graphic technique which provides a universal key to unlock the potential of the brain. It harnesses the full range of cortical skills-word, image, number, logic, rhythm, color and spatial awareness-in a single, uniquely powerful manner

with flexibility
As you think of new aspects of your subject, you can type them in anywhere and then move them around to fit. You can think of a mind map as a sort of two-dimensional outline; rather than organizing ideas into a linear list, you spread them around the page and connect them.

and no limits
You’re not limited to plain text on a mind map. In fact, you almost certainly want to use fonts, icons, bitmaps, colors, and so on to dress up a mind map. It’s been my experience that the more playful you make these things, the more likely you are to come up with interesting ideas.
A good mind map will both record your ideas and provoke them.

So the decision is to use a mind map for the creation process.

You might ask why the different researches are not saved in different mind maps instead of a database. There is a simple answer. If you have a few researches take the mind mapping tool. Take a database for a large number of researches.

The benefits of a database compared to a great number of mind maps are the compact format, the ability to search, to print special data in a non-graphical format and group them by tags, categories etc.. Visualization is a perfect way to show a limited number of informations while it is confusing to look at large data volumes presented graphically.

The creation process …

To get started we need to come up with an idea like
I want to manage all results of my researches about a topic.
Now it’s brainstorming time and so it’s mind mapping time.

The contents of the mind map

A mind map reflects all the ideas you had about your topic.
It can be used as the framework of our database.

Level 1 subtopics of the mind map correspond to the tables of your database and further levels to fields or further tables. All subtopics contain data of one specific research so you have to create a so-called Master-Table with which all the other tables are connected to.

If you plan to use a database on your iPad it’s highly recommended to do mind mapping before creating the database, entering all the data, and then flush it to the toilet and start new.

Let’s put some stuff on the map …

The idea was to manage all results of researches about specific topics.
So here is a simple mind map created with iThoughts (by Craig Scott, UK).


To keep it simple this mind map in a first step does not contain functionalities of the database application. In a professional environment the design process has to consider the database structure as well as the requirements of its users.

The database …

Now we have to transform the mind map into a database structure.
We use Tap Forms HD (by Tap Zapp Software Inc., Canada).


See my blogs

for clearing up the basics
DBMS on iOS-Devices (1)

for further information about Tap Forms HD
DBMS on iOS-Devices (2)

Summary …

Users don’t want to think about the appropriate file management for the data they have to work with. Developers usually don’t like to deeply engage in the specific fields of activity of the users.

So how can developers be paired up with the users. Mind maps may help as they reflect the requirements of users as well as the more structured thoughts of developers.
The result may be a more efficient software application and the mind maps may serve as a common knowledge base for both sides, developers and users, for future updates and improvements.

Thanks for reading my blog.
Comments and shares are highly appreciated.


Get every new post delivered to your Inbox.

Join 148 other followers

%d bloggers like this: