OS X: Create ZIP archives without hidden System files

ZIP from Mac to Windows

It’s a common problem between Mac and Windows users, when you create a ZIP archive under Mac OS X, that it will contain a bunch of unwanted files, which you don’t want to have included in the archive. In OS X’s Finder you won’t notice that, because the Finder is hiding them from you. But they will show up on the Windows side after unzipping the archive.

OS X Standard ZIP Archive with hidden Files

Fortunately there is quite a simple and straight-forward solution for Mac OS X to create so called “Clean Archives”, using a predesigned Automator action.

Continue reading

OS X: Delete single objects from Time Machine backups

OS X Time Machine IconI already posted a step-by-step guide on how to delete old backups from your Time Machine drive in order to free up space. What I did not mention in that article was how you can delete single files & folders from within backups, if you want to have even more free space available for future backups.

The steps to do so are slightly different – especially the fact that you do not navigate to your backup drive in Finder, but use the Time Machine application instead.

Here are the instructions, if you want to delete specific files & folders from existing Time Machine backups:
Continue reading

Hiking: traditional food & a short walk through the snow

Gallery

This gallery contains 9 photos.

I recently heard that there is an amusing restaurant named “Schnuggenbock” in the small town called “Waldegg” just above St. Gallen on the border to the canton of Appenzell. The nice part of this evening was to walk back to St. Gallen in the fresh snow which took us about 45 minutes. We took some flash lights with us and were surprised that there was a normal street leading down to St. Georgen, a part of St. Gallen city. Continue reading

Project Server 2010: Export Status Report Responses using Excel

ProjectServer2010 LogoMicrosoft didn’t spend too much time on the “Status Reports” module in Project Server 2010, leaving it with many disadvantages and even a somewhat not so intuitive handling. This affects especially the extraction of Responses to Status Reports – which you can only export to a non-editable Word template.

Having not found any better solution on the internet for improving the retrieval of Staus Report responses (except a scheme of the required tables), I decided to make my own SQL-Query to do so.

Continue reading

Project Server 2010: How-to add Notifications for your Users

ProjectServer2010 LogoUnfortunately Microsoft’s Project Server 2010 doesn’t allow an administrator to set default settings for Notifications for all Users. They basically would have to go into their “Personal Settings > Settings for my Alerts and Reminders” themself and set the notification settings for Tasks, Status Reports, etc.

And as we all know: the User’s won’t do it.

So I had to figure out a way how I can “force” my Users to receive certain Notifications. After various Google Search Queries I had to realize, that there is no other way than digging into the database directly (although NOT SUPPORTED BY MICROSOFT!) and add the reminders for my Users manually (if this is not true, please let me know!!).

  • Affected Database:
    • ProjectServer_Published
  • Required Tables:
    • dbo.MSP_REMINDER_SUBSCRIPTION
    • dbo.MSP_REMINDER_DEFINITION
    • dbo.MSP_RESOURCES

Step 1
Continue reading