Quickr Connector: Maximum allowed file name length

If you are working with files in the Quickr connector you might sometimes not be able to open a file in a Quickr place. This could be because the maximum allowed path length of the locally stored copy of the file has ben exceeded.quickr

The Quickr connector is using a cache area on the local file system to store temporary copies of the file being worked on. By default, this directory is found in Window XP at

C:\Documents and Settings\<username>\Libraries\quickr85\<placename>\

or with a German Windows XP

C:\Dokumente und Einstellungen\<username>\Libraries\quickr85\<placename>\

Below of that directory Quick creates different subdirectories for Folder and Rooms. In the worst case (document is located in a room and in a sub folder in that room; it does not matter how deep the level of nested rooms and folders is) the path length will be:

47 Characters (German: 52)

+ Windows Username

+ Place Title (without special characters)

+ Place-ID (like: @P<placeURL>)

+ 33 character Room ID (like: @RPageLibraryC125788F002A2846.nsf)

+ 14 character Folder ID of a subfolder (like: @Fm0NLJXiPKlSR)

+ 34 character Document ID (like: @D32FB5E1F4D38DA9AC125788F002A5A78)

That means the path length is at least 130 (47+2+33+14+34) (German: 135) characters plus number of characters of user name and 2x the number of characters of the place URL.

Example:

Username:                  Administrator (13 characters)

Place Title:                  acmeteamplacetest (17 Zeichen)

For the cache directory 177 (130 + 13 + 17 + 17) (German: 182) characters are needed.

Windows has a maximum allowed path length of 260 characters (one character is an end marker so effective only 259 characters)..

For the file name of a file, which should be opened by the Quickr connector, only 259 – 177 = 82 (German: 77) characters remain.

If you want to work with files in MS Office the maximum allowed path length is shorter than Windows allows. It is for

MS Word:       242 characters (including one end marker; effective: 241))
MS Excel:       218 Zeichen (including one end marker; effective: 217))

In the example above the maximum allowed length of the file name would be in

MS Word:                  241 – 177 =    64 (German: 59) characters
MS Excel:                   217 – 177 =    40 (German: 35) characters

As you can see, the maximum length of a filename which can be opened by the Quickr connector is depending on several things factors and you cannot exactly say where the upper limit will be.

In general you should try to keep the file name as short as possible. Using a shorter place title will also increase the maximum allowed file name length.

Lotus Quickr Connectors HF 7 installation

In the package of the Lotus Quickr Connector HF7 you will find several files which were not existing in earlie versions. These files are not needed for the connectos but have been included unintentionally.

To update the connectors on the Quickr server you just neeed to copy the file QKRCONN.EXE to the path “<Domino data>\domino\html” and replace the existing one. You can delete the “buildinfo.txt” in the same directory as it is no longer needed.

To install the connectors only the QKRCONN.EXE is needed from te ZIP file. You can safely ignore the other files (except the readme file 😉

 

unintentionally unintentionally

iPhone and iPad are now printing on my Windows printer

I do not have an Airprint-ready printer at home. But with the help of a little free tool I managed to configure  my Canon MG8150 as a device which will be recognized by both iPhone and iPad.

Just download the AirPrint activator for Windows and run it one time. You need to make sure to use “Run as administrator” as a service needs to be installed.

If you have activated the local Windows firewall you need to add a rule to allow incoming traffic for “c:\airprint\airprint.exe”. Although it was not described in the help I needed also to add a rule to allow incoming UDP traffic on port 5353.

Now you can just select “Print” in iOS and your shared Windows printer will available for selection. Just enter your Windows user / password one time and you are able to print from your iOS devices.

[Update  02.03.2012]

As the above software is no longer working for me and I did not find out the reason, I have changed to “Fingerprint” now. It does cost a little bit but it is working like a charm even with iOS 5.1.

WiFi Travel Router

Several times I had only wired Internet access in my hotel room and I was unable to connect my iPhone and iPad to the Internet. From now on this should no longer be a problem.

My new Trendnet TEW-654TR just arrived. It is a very small (60x80x18,5 mm) Wifi router / access point. You connect it to an Ethernet port (Router/DSL modem…) and you can then connect your WiFi devices and use the wired Internet connection.

It was very easy to set up and it works very well at least here at home. So I am curious how it will work the next time in a hotel room.

If your iPad does not want to charge while connected to an USB port …

… then there could be a solution if your PC has a motherboard from Asus or Gigabyte. As the iPad does need more power than the 500 mA which a standard USB port provides, the iPad does only charge while in suspend mode if it is connected to a standard USB port and then only very slowly..

I found a software for my Asus motherboard and also for motherboards from Gigabyte which provides a solution for that. I just tried it with my PC and it really works. No experience yet if it does charge as fast as with the Apple charger but at least it charges while beeing used.

Quickr 8.2: Re-create Welcome Page

If  a user deletes the Welcome page in a Quickr 8.2 place the “What’s new” section is also lost. Although there is no possibility for a user to re-create it, an administrator can do so. Here are the steps:

  1. Create a new page and call it “Welcome” (or whatever you like).
  2. Open the MAIN.NSF of the place with a Notes client.
  3. Switch to the QDK view,  search the new document and open it for editing.
  4. Set the value of the field “h_SystemName” to “h_Welcome”  (case sensitive!)
  5. Save the document and close MAIN.NSF

Now your newly created document should contain the “What’s new” section again.

Upgrade to VirtualBox 4.0.4 (Ubuntu Host): Issues solved

As almost everytime after upgrading Virtualbox to a major version I had trouble to get it up and running on my Ubuntu host. This time I upgraded from 3.2 to 4.0.4 and had the following issues:

Vboxtool no longer working:

I am using Vboxtool to manage my virtual machines from the command line. This tool stopped working because a major redesign of the VBoxManage command. I found a hacked version here. This version works for me.

No access to the virtual machines via RDP:

I was able to start my virtual machines but I could no longer connect to them via the RDP protocol. There were two issues here:

First I neeeded to start the VirtualBox Manager and go to “File -> Preferences -> General”. Choose “Reset” in the field “RDP Authentication Library”. Afterwards it should read “VBoxAuth” instead of “VRDPAuth” which was here before.

In addition you need to install the Oracle VirtualBox Extension Pack as this seems to provide the RDP functionality. You can download it from here. You need to be root to install it (or run Virtualbox Manager with sudo).

After completeing the steps above Virtualbox now seems to run again …

BTW: A step by step instruction to install Virtualbox 4.0.4 on an Ubuntu host can be found here.