That was the fun part.  After all, it’s Sunday.  Now read the story here:

(Cross-posted @ CloudAve )

Tags: , , , , , , ,

Picasa

My 4-year old how-to guide, Picasa Photo Sync on Multiple Computers has attracted tens of thousands of viewers, and is still quite popular.  In fact too popular, thanks to Google.  I can’t believe people actually read it today and try to follow the advice therein… it’s and OLD post with outdated information.  I’ve long struggled trying to find a better solution… and now that I have it … drumroll … but wait, first things first:

What’s the problem with Picasa?

Picasa is my favorite photo management program, and hey, it’s hard to beat free!  Yes, I believe SaaS is the future of computing, and I do keep many photos online (just canceled Flickr Pro in favor of PicasaWeb), but quick-and-dirty manipulation of large image files en masse is still easier, faster on a local PC.  Or one of the computers I use – if only I could.  It’s hard to believe that Google, an undeniably Web-centric company would create an application that’s designed to be used by one single user and one single computer – that’s stone-age vision, and again, is very antagonistic to being a visionary Web company. 

Picasa does not save your edits in the image file itself, rather it uses a set of system files: picasa.ini files in every photo folder and a bunch of proprietary databases in two hidden system directories.  This is actually a good concept, you can experiment and safely revert back to the original –  trouble starts when you want to move to a new computer, or God forbid access your photos from multiple computers – some of the associated changes will come through, others won’t.  You will soon have multiple versions of the databases and sometimes of the images themselves, and that leads to chaos. 

Early Solutions

The original concept in my previous guide was based on syncing the hidden Picasa databases between all computers involved. It worked for a while… then I started to see corrupted databases, so I abandoned synchronization.  In the meantime wireless home networks became more robust, so instead of redundant chaos, the next best option was maintaining once central Picasa home-base, and accessing it from other computers via the network.  This could quite easily be done by mapping the main computer’s drive as a network drive, say P: (for Photos or Picasa), setting Picasa on all the satellite computers to forget the local Pictures folders and only scan the new P: drive. 

In this setup Picasa still had to index all images it read from the network and recreate a local database on the individual computers, so the solution was quite redundant – but worked relatively well.  Through a succession of new releases Google moved more information on user edits into the per-folder Picasa.ini files, so the system was able to rebuild the database almost completely.  Cropping and some other information was still missing, so you could never be 100% certain you were looking at identical version of your images.  The safest way to avoid confusion and different views of the same photos was to make a policy of only editing images on the “main computer” where they were stored, thus rendering all other networked computers to passive viewers only. 

There has to be a better solution.. one that allows any member of the family (and any user account) using any computer on a network to share the one and only Picasa database – view and edit all the same, with any changes, tagging, editing immediately saved no matter which computer is being used.   Yes, there is one – keep on reading :-)   But first some disclaimers:

  • I’ve tested the solutions below in Windows 7
  • They should work on Vista, too, and I believe there is a logical equivalent under XP, but I’ve never checked it
  • These solutions work for me, but I can not guarantee they will work for you – experiment at your own risk
  • Before making any changes, do back up your Picasa database (both photos and the system data)
  • Even if everything works, there’s no way knowing if a future Picasa release will change it all…
  • I’m not a Windows Guru, and make no claims that this is the best or most elegant solution – just one that works for me
  • I cannot provide individual support – you are welcome to comment / contribute below, and may get a response from another reader, but I can not make promises.

Now, we’re ready to rock and roll …

Sharing Picasa Between Multiple User Accounts on the Same Computer

You may only be interested in the multi-computer setup, but please read this chapter anyway, as we will build on the logic outlined here when we expand to a network setup.

Move your photo library to a public location

By default most photos are stored at user account specific image libraries, with a default path similar to this in Windows 7 and Vista:

C:\Users\username\Pictures  

You could fiddle around with sharing / security properties to enable other user accounts access this image folder, but moving your photos to the public folder is a much cleaner solution.  The new destination is:

C:\Users\public\Pictures

Although the easiest way to move folders is from Windows, it’s always better to do it within Picasa, to allow it’s databases be updated properly.   If you use nested folders, you’re in luck, you can just right click on the top-level folder, select “Move Folder”, pick the new destination, and you’re done.  (If you have nested folders but don’t see them in Picasa, change from “Flat View” to “Tree View” in the main View menu.)  If you have a lot of flat folders, this may be a cumbersome process, but it’s one-time only.

This was easy … now close Picasa and let’s get really started :-)   Two reminders before we start:

  • you’ll need to do all this using an account with Admin privileges
  • backup, backup, backup (your photos and system folders / files)

Move Picasa’s internal databases to a public folder

The internal Picasa databases are originally in two system folders in Windows 7 / Vista:

C:\Users\username\AppData\Local\Google\Picasa2

C:\Users\username\AppData\Local\Google\Picasa2Albums

You’ll need to create a new home for these two folders, for example this:

C:\Users\Public\PicasaLib

Now move the Picasa2 and Picasa2Albums folders to the newly created PicasaLib folder, so their new locations are:

C:\Users\Public\PicasaLib\Picasa2

C:\Users\Public\PicasaLib\Picasa2Albums

Well done. Too bad Picasa is still looking for these databases in the old place…

Trick Picasa into finding the new database location

At this point you should no longer have a Picasa2 and Picasa2Albums folder in your C:\Users\username\AppData\Local\Google\ folder – if you do, you likely copied them to the new destination instead of moving.  If that’s the case, please delete them now – we can’t have real folders with those names here, since we are going to replace them with Symbolic Links that look just like the deleted folders but will actually redirect Picasa  to the new location.

For the next steps even though you’re logged into a user account with Admin rights,  you will need an elevated command prompt. If you’re like me and can’t remember hot-key combinations, here’s how to get it: Click the Start menu and type cmd in the run box, but do not hit enter. Instead, find cmd.exe at the top of the list, right-click on it, then left-click Run as Administrator.

Now you’re in a command box that reminds you of good old DOS.  Navigate to the original Appdata folder:

cd  \Users\username\AppData\Local\Google   

Now type these lines exactly as you see them:

mklink /d Picasa2  C:\Users\Public\PicasaLib\Picasa2

mklink /d Picasa2Albums C:\Users\Public\PicasaLib\Picasa2Albums

You have just created two entries that look like the Picasa2 and Picasa2Albums folders but actually point to their newly created location.

Update and verify Picasa for each user

Open Picasa, go to Tools > Folder Manager and make sure only the new public destination is selected, nothing else – certainly not user specific libraries.

Repeat the above relocation steps for all other users on the same computer, and check their Folder Manager setting in Picasa.

You’re all set!  All users now have shared access to all public photos, and edits, changes, thumbnails..etc are all maintained in a central database instantly available to all users.

Warning: I have not tested what happens if multiple users try to update the databases at the same time, but I assume it is not a very good idea.  Best practice is probably avoid using quick User switching all, rather log out of one user before logging into another one, but at a minimum, even if you do quick switch, don’t leave Picasa open in two user accounts at the same time.

Picasa on Multiple Computers

This is what you’ve been waiting for…  we’re actually very close, the logic is surprisingly simple: map the drive that has our Picasa library and databases as a network drive, say P, then apply the tricks we’ve just learned doing the multi-user setup on the same computer, but now the symbolic links will point to the public folders on the P: drive, and voila!

Well, almost…too bad there are a number of quirks that we have to deal with first.  Let’s take them up one by one.

Your network layout

If you have a NAS drive, which is for passive storage only, accessed by several computers on the network, than the above solution will work, since you can map the NAS drive to the same drive letter on all computers.  But if your network is like mine, i.e. there is no NAS,  Picasa resides on one of the actively used computers which all others access, then you run into all sorts of trouble.  Here’s why:  Picasa stores the result of your “watched folders” configuration in a plain text file named watchedfolders.txt in the Picasa2Albums folder.  But we’ve just moved that folder to our shiny new PicasaLib to be shared by all instances of Picasa – that means they can not have different “watched folders” set per instances.

The problem is, the “main” computer will consider Picasa storage as its C: drive, while all others have to refer to it by another drive letter, since C: is reserved for their own hard disk.  If you have both P: and C: drives as “watched folders”, all hell breaks loose: Picasa will start copying the folders to the local computers, in the wrong folders, wrong labels, resulting in total chaos (I’ve been there…).  So once again, we’ll cheat: find a way to refer to the central PicasaLib under the same drive letter from all computers.

Re-mapping the “server”

Not a true server, but playing that role in this case: this is the computer that has all the Picasa files and that we’ve just set up for multi-user access in the previous exercise.  We want to use the P: designation, but can’t simply rename our main hard disk, nor can we map it as a network drive, so we’ll apply the symbolic link trick again: set up a link from the root folder to the public folder.  Steps:

Get an elevated cmd prompt (see details above)

cd \   (back to root folder)

mklink /d P  C:\Users\Public\   (create the symbolic link)

You now have what the system thinks is a P folder, and can use it in the Picasa “watched folders” definition.  Which means you need to start Picasa, then navigate to Tools > Folder Manager, and select \P\Pictures as the folder to watch – unselect everything else.  For a few minutes you’ll see heavy activity, and for a while Picasa may show duplicate folders, double the number of pictures you really have, but will eventually sort it all out. 

Setting up the “clients” or “satellite” computers

These are the computers that have no local Picasa information, we just use them to access our main libraries from the “server”.  Ideally we would just map the public drive on the server as a network drive under P: but we’ll run into a syntax problem.  On the main computer Picasa will prefix our watched folder setting, changes \P\Pictures to C:\P\Pictures, which works just fine on the main computer but not on the satellite ones.   Picasa’s watchedfolders.txt does not accept a \\Computername\Foldername designation, it has to look all local.

So we go back to our friend… yes, you guessed it right, symbolic links. But now even this old friend lets us down: we cannot define a symbolic link to a network folder, only a local one. Oh, well, we’ll outsmart the system again, by combining network mapping with symbolic linking: we’ll map the network drive to an interim name first, then link to this interim drive-name.  Steps:

From windows, map the \\MainComputername\Users\Public\ folder as drive O:

Make sure there is no Picasa2 or PicasaLib folder in \Users\username\AppData\Local\Google

Get an elevated cmd prompt

cd \  

mklink /d P  O

cd  \Users\username\AppData\Local\Google

mklink /d Picasa2  O:\PicasaLib\Picasa2

mklink /d Picasa2Albums O:\PicasaLib\Picasa2Albums

Repeat the last three steps for all user accounts that should access Picasa from this computer.  Logically now you would have to open Picasa and changed the watched folders to P\Pictures, but there’s no need: it’s already set up on the server machine and you’ve just told Picasa to pick all parameters and data from there.

In other words, you’re all set.  Needless to say, this only works as long as your “server” is turned on:-) but then all computers on your network will see the very same photos, and all editing, manipulation, face or geo-tags, albums… are immediately updated in the central database and reflected on all computers, no matter where you originate them.

Warning:  as stated before, I have not tested what happens when multiple users access / attempt to update Picasa data at the same time, but I assume it’s not a very good idea.  We’re ‘cheating’ here, Picasa was not designed to work in a multi-user environment, so let’s plat safe: only one computer and one user should access it any one time.

Conclusion

We’ve just turned a hopelessly single-user, single-computer product into a networked one. Sort of. :-)   It’s obviously just a workaround, and…well, read my disclaimers again.

Now, let’s remember, Google isn’t really a PC or local network software company. They are The Web Pioneers. I think the long term solution will be much stronger integration with Picasa Web Albums.  Currently you can mark your folders / albums to synchronize with the Web version, but it’s one way, from PC to Web only.  That’s not what I call full synchronization.  If you change anything in Web Albums, it’s not reflected back to your local Picasa library.  I believe the future is full two-way – actually multi-directional – synchronization, where Web Albums become the conduit between any number of client computers that access Picasa.  It’s not impossible, services like Syncplicity do similar synchronization – Google Picasa has to embed it in their Web capabilities.  It’s time for Google to create the seamless online / offline photo management environment.

(This how-to guide was originally posted as Part 1: the Problem and Part 2: the Solution @ CloudAve)

Tags: , , , , , , , , , , , ,

I’m used to Skype Spam, but not a malvare-attack.  Here’s what just popped up on my Skype screen:

Registry Online: URGENT SYSTEM SCAN NOTIFICATION ! PLEASE READ CAREFULLY !!

http://www.updategt.org/

For the link to become active, please click on ‘Add to contacts’ skype button or type it in manually into your web browser !

FULL DETAILS OF SCAN RESULT BELOW
****************************************

WINDOWS REQUIRES IMMEDIATE ATTENTION

ATTENTION ! Security Center has detected
malware on your computer !

Affected Software:

Microsoft Windows Vista
Microsoft Windows XP
Microsoft Windows 2000
Microsoft Windows Server 2003

Impact of Vulnerability: Remote Code Execution / Virus Infection /
Unexpected shutdowns

Recommendation: Users running vulnerable version should install a repair utility immediately

Your system IS affected, download the patch from the address below !
Failure to do so may result in severe computer malfunction.

http://www.updategt.org/

For the link to become active, please click on ‘Add to contacts’ skype button or type it in manually into your web browser!

Now, I don’t ever click on suspicious links (I bet this is a rogue one) from unknown sources, but I’m afraid people might fall for it.  Also, how come Skype allows strande IM’s through when my security setting is “Contacts only” ?   And of course if you’re not careful enough and follow the request to add the scammer as a contact, then they will get through even easier next time.   Beware: don’t click, Block and Report the sender!

(Cross-posted @ CloudAve )

Tags: , , , , ,

googtwitWhy bother with an intermediary when we can now have FeedBurner send our blog post to Twitter directly?

- I wrote in Startup Bloodbath in Social Media and I meant it.  But for now, we’re switching back to TwitterFeed.

The new Feedburner service that pushes blog posts to Twitter directly isn’t quite ready. Let’s just say it’s a bit too trigger-happy: it pushes an update after every “save”, even minor updates to already published posts.

This is so crappy, we’re switching CloudAve back to TwitterFeed – for now.  Because it is crappy enough for Google to fix it soon – and then we’re back to the original formula: no need for intermediaries.

Reblog this post [with Zemanta]

(Cross-posted @ CloudAve )

Tags: , , , , , ,

RubberDuck

Two SAP-related conferences will run literally next door to each other in Boston next week.  One, which I am attending is the SAP Influencer Summit where analysts and the media get to meet SAP execs – the other is what some of us quickly dubbed the Anti-SAP Conference.

The Sapience conference  is focused on “Alternatives for leveraging  your investment in SAP”.  Fellow Enterprise Irregulars Vinnie Mirchandani and Ray Wang will both be presenting – no surprise there. Vinnie has long earned the nickname Vinnie Maintenance (well, when he’s not Vinnie Merchantsmile_wink) for his crusade against bloated integration and maintenance costs, which “can make up 70 to 90% of TCO in an SAP shop” and Ray also has a track record of taking the customer side.  No wonder the two are now working together as Enterprise Advocates.

Are enterprise software fees outrageously high?  Probably… see my old post on how SaaS subscription can be half of only the maintenance component of traditional software’s TCO.  Do System Integrators, Consultants overcharge?  Probably … although let’s be real, they charge whatever they can get away with, i.e. whatever the market allows. Hence alternatives are good – SaaS, nimble, less expensive third party providers and even strategic client-side consultants like Vinnie and Ray who can make a decent living on advising customers on how to reduce their ERP TCO.  The market is all about competition and and market players have to take sides, no shame in that.

But then I don’t understand why Vinnie and Dennis Howlett are vehemently denying the anti-SAP nature of Sapience. I prefer to call it what it is – just take a look at the sponsor list:

It’s a who is who of SAP’s competitors – now let’s look at some of the Conference Speakers:

  • Craig Conway, PeopleSoft’s last CEO before getting swallowed by Oracle
  • Jan Baan, Founder of Baan, a “hot” SAP competitor in the 90’s
  • Paul Wahl who left SAP for Siebel, and took the creme of SAP’s leadership at the time with him

golden oldiesThey share one thing in common: all former SAP competitors but also representative of the very same “fat” business model they will no doubt speak out against.  They are joined by several former SAP Execs and current service providers.

Zach Nelson, CEO of NetSuite is a great competitor and one who does not miss a chance SAP’s fumbling with their own SMB SaaS offering, BYD offers him.

It’s hard to not see what the conference organizer, Helmuth Gumbel assembled here: the Anti-SAP All Star Band.  Oh, and let’s not forget how Dennis Howlett had introduced Helmuth: SAP’s feet put to the fire.

How about the timing?  If you believe it’s pure coincidence that Sapience coincides with the SAP Influencer Summit both in time and location, I have a bridge to sell you.  It’s just as “accidental” as Netsuite’s SAP for the Rest of Us Party was during SAPPHIRE 2006, right across the Convention Center.   Nothing wrong about guerilla marketing, but why be shy about it?

A conference designed to steal some thunder from SAP’s Summit, at the same time and place, sponsored and keynoted by SAP’s competitors, and it’s not “anti-SAP”?  C’mon… you know the quacks and all.smile_wink But don’t get me wrong: Sapience may very well be a healthy contribution to the SAP ecosystem – it just does not need any whitewashing.

You may also want to read the healthy debate that developed in the comments to Vinnie’s post.

Reblog this post [with Zemanta]

(Cross-posted @ CloudAve )

Tags: , , , , , , , , , , , , , , , ,

Tags: , , , , , ,

What tax-time, you may ask.  It’s April 15th, at least in the US. Wrong:  Anyone can get an automatic 6-month extension, which means the real tax deadline is October 15th… closing in on me … ahhhh. No, I am not a procrastinator,  my tax forms are always almost done by April 15th and I pay my dues, but there is this one ugly thing I hate to do every year: calculating business mileage deduction.

The IRS requires proper documentation and I do have it .. well, almost: it’s in my electronic calendar, with dates, locations, purpose of meeting..etc, except for one thing: the actual mileage.   So every year the ugly process that takes several hour is:

  • export my calendar entries to csv format
  • massage them in a spreadsheet (fill missing data, delete non-business ones..etc)
  • manually look up trip mileage for every single line using Google Maps
  • plug in mileage, let spreadsheet calculate claimable $ amount.

It takes several hours, is the only reason why I wait till the last minute and then some.  But this year, it just dawned on me: this is so bad, someone must have come up with a way to automate the process (and if not, I’ll find a developer). That’s basically the mantra of Web 2.0: whatever your (productivity) problem is, likely millions share it, so someone must have come up with the solution.

In this case the magic comes from a very simple site: Mileage Calculator. It does not look like a fashionable app, in fact it does not look like an application at all – you might think it’s just a blog post writing about the real thing.  That’s because it was not created with the mindset of bringing it to market:

It was created by Ade Olonoh who used Google Calendar heavily to track meetings, but neglected to record his mileage for tax purposes. Sure, it would’ve taken him less time to figure out the mileage than create this tool, but that wouldn’t have been any fun.

So yes, it lacks the bells and whistles, pastel colors and rounded corners.  Here’s the one-and-only entry screen:

Yes, no more list, export /import, data lookup:  Mileage Calculator will look up your trips from Google Calendar, fetch the mileage information from Google Maps, presents you with a list and total, then finally saves it as a CSV file to be used in a spreadsheet.   Simple, yet a life-saver – a free one.

Now, after all the praise, let’s be a bit critical: what would it take to turn this into a product?  Fix two weaknesses:

  • It’s not particularly smart parsing address data: i.e. it does not understand “Moscone Center, 747 Howard St, San Francisco, CA‎”, it has to be strictly in the format of “747 Howard St, San Francisco, CA‎”
  • The ugly UI

With those two fixes Mileage Calculator could become a nifty little service, or perhaps a feature that SaaS accounting and tax providers might want to pick up.  In the meantime, it’s a useful little productivity tool.

(Cross-posted @ CloudAve)

(Cross-posted @ CloudAve )

Tags: , , , , , , , , , ,

SAP and Zoho Come Together

SaaS September 28th, 2009

At least on screen… Zoho CEO Sridhar Vembu delivers his keynote @ NASSCOM, and what’s the background?  SAP Business ByDesign.

 

Business ByDesign: probably the best All-in-One SaaS suite NOT (quite) on the market today. smile_omg

Tags: , , , , , , ,

Here we go again: Ed Bott points out how outrageous it is for Apple to install so-called “updates” to the iPhone Configuration Utility on a Windows computer that does not have this software installed, in fact one that has never had an iPhone or iPod connected to.

He is right, this is obviously not an update, but installing new, and in his case obviously unnecessarily software.   It’s also not the first time, I described my  similar experience early last year. Back then I also wrote:

Apple fans are a religious cult who came in hordes to defend Holy Apple. (before you chastise me, just look at how often I point to Apple as a better choice, without becoming blindly faithful)

And boy, did I prove right on that …

Read more here.

Tags: , , , , , , , ,

Zoho is mostly known for their Web-based productivity and business software, but sometimes they venture into … hmm… unproductivity.   In the past year or so close to a million cartoons were created @ ToonDoo, and that number grows by 3-4 thousand every day.  (Hey, even I contributed onesmile_wink)

Today they have announced  ToonDooSpaces, private comics-based collaborative space for classrooms, be it school or kindergarten level.  (Remember when FaceBook – actually TheFacebook at the time – was strictly limit to the confines of actual colleges?)   What can you do @ ToonDooSpaces?  Here’s how the kids at one of the pilot schools explain:

toondoo

Even before this launch, ToonDoo has been used at hundreds of schools including Auburn High School, US, Totino-Grace High School, US, Leawood Middle School, US, Korea International School, Korea, Mount Scopus Memorial College, Australia, Lake Superior College, US and many others -  apparently all the way to college level.  That said I think ToonDooSpaces will be most favored by the younger ones.  Here’s a detailed review by Kevin Hodgson who has been using ToonDooSpaces in his class for months:

All spring, my sixth graders (11 and 12 year olds) were fully engaged in the use of our ToonDoo Spaces site. They would walk in the door and immediately ask: Are we going to make comics today, Mr. H? And they give a little shout of “Yeah!” with a fist pump when I say “yes” (after we do whatever other work we have planned).

Here’s an interactive video showing off more of ToonDoo’s features:

 

But hey, I’m writing a business / technology blog, so let’s get serious here. smile_wink   I often talk about Freemium (more here), and I think this is a perfect showcase.

toondoomatrix

Remember, Freemium takes patience – in this case ToonDoo has been available for over a year, attracting hundreds of thousands of users before the launch of the “premium” version, Spaces.

And here’s something else: I guess the inner child must have died in me a long time ago, how else do I have the most fun on the Pricing Page?  The fact is, we often talk about the need for transparency, and how SaaS should be easy not only to learn, use, but to buy, which includes price information, without having to endure lousy sales calls.  Well, it doesn’t get any easier:

 

Move the cursor along the users / months axis, click anywhere, and voila! – there’s your price quote.   SaaS companies, take notice: you can get rid of the kiddie appearance, but should offer a pricing tool this easy.

Now I am off to create a cartoon(doo). smile_shades

(Disclaimer:  I am Editor of CloudAve, a Zoho-sponsored group blog.)

Tags: , , , , , , , , , , , , , ,