Slashdot Mirror


Cracking Open the SharePoint Fortress

dreemteem writes with this excerpt from ComputerWorld UK:"SharePoint is a brilliant success, for a couple of reasons. In a way, it's Microsoft's answer to GNU/Linux: cheap and simple enough for departments to install without needing to ask permission, it has proliferated almost unnoticed through enterprises to such an extent that last year SharePoint Sales were $1.3 billion. But as well as being one of Microsoft's few new billion-dollar hits, it has one other key characteristic, hinted at in the Wikipedia entry above: it offers an effortless way for people to put content into the system, but makes it very hard to get it out because of its proprietary lock-in. This makes it a very real threat to open source. For example, all of the gains made in the field of open document standards — notably with ODF — are nullified if a company's content is trapped inside SharePoint." The article offers a slice of hope for getting around that, though, in the form of a new API for Google Sites which can slurp the data back out.

28 of 275 comments (clear)

  1. Business do see the light by Necroloth · · Score: 4, Interesting
    I work for a well known automotive company and as you all know, this industry has been pretty well battered during the recession. Auto companies have looked at all sorts of possibilities to reduce costs and mine has decided to move to Google and migrate away from Exchange, Sharepoint etc.

    In times of financial troubles, companies look to alternatives but they need to be trusted known brands

  2. Re:Just wondering... by Akido37 · · Score: 5, Funny

    Can't you read? SharePoint is a FORTRESS.

  3. bah, sharepoint. by gbjbaanb · · Score: 5, Informative

    Its great news if *anything* can rescue us from the horror that is Sharepoint.

    I've never used a worse CMS system (which is what everyone pretends it is) when really its an online document repository. Don't even start me of Infopath documents being put in there to pretend to give it a forms engine. Its hell.

    Thing is, I'm not entirely sure why all the myriad sharepoint sites that have sprung up at our company are so useless, I think its because its so easy to drop another document into another list that you end up with a sprawl of almost-related data, that's then impossible to find. Our admin did try to say that he'd put the search functionality on so it should be easier to find things... but when I searched for one document I received several thousand hits back!

    Alternatively it could be because every department has their own sharepoint site, that no-one knows which one to look in for data, so they don't bother using it.

    In any case, all the sharepoints here are crap, even the one the admin spent a lot of time on to give it a good sense of organisation.

    1. Re:bah, sharepoint. by Anonymous Coward · · Score: 4, Interesting

      The Search is one of the biggest and most important features of SharePoint. If your admin had a clue, he/she would have set it up in the beginning with appropriate IFilters for all of the documents being uploaded. With that and proper meta tagging rules for document uploads, it really doesn't matter where it is inside SharePoint, as long as it's there. There are also 3rd party add-ins (BA Insight's Longitude, for example) that expand the capabilities of search.

      The problems at your organization sound like bad planning on the part of whoever oversaw the implementation. The tools are there (and believe it or not, they are good tools, which is one of the reasons why SP is so popular), it's just easy to end up with a mess when the people setting it up have no idea what they're doing.

    2. Re:bah, sharepoint. by nkh · · Score: 4, Funny

      I've never used a worse CMS system

      Me neither, but I kinda like the way SharePoint spits random pages in Italian sometimes, it's like I'm a member of the Cosa Nostra or something :D

    3. Re:bah, sharepoint. by Penguinisto · · Score: 5, Insightful

      Don't even start me of Infopath documents being put in there to pretend to give it a forms engine. Its hell.

      Worse than hell, really... and not very secure. Our purchase req's at work use it, and I doubt the doc author would know what I was talking about if I asked her whether she sanitized her inputs or not (for example, I can give my own PR's authorization all the way to the VP of finance if I wanted to... and they rely on the damned thing now).

      As for the rest? Dude, I'd give it every mod point I'd ever see for the next year if I could. I'm guessing it's your latter reason (too much diaspora, with little to hold it together) that explains why few people use it. A good web designer can overcome that very easily, but unfortunately? A good web designer and a good SharePoint developer are apparently almost never the same human being (hell, our SP "developer" gets lost in an Event Log... how am I supposed to help explain the basics of CSS to the guy?)

      PS: The search function is pure hell to get working right, if at all. The consultant who put ours together actually knew what he was doing, and SP search still works only half-assed, so don't feel too badly about it.

      --
      Quo usque tandem abutere, Nimbus, patientia nostra?
    4. Re:bah, sharepoint. by SenFo · · Score: 5, Interesting

      A good web designer and a good SharePoint developer are apparently almost never the same human being (hell, our SP "developer" gets lost in an Event Log... how am I supposed to help explain the basics of CSS to the guy?)

      PS: The search function is pure hell to get working right, if at all. The consultant who put ours together actually knew what he was doing, and SP search still works only half-assed, so don't feel too badly about it.

      You couldn't have been more accurate. 49 out of every 50 SharePoint "developers" I have talked to or interviewed are far from designers or software engineers. It's as if they were attracted to SharePoint because they were unable to make it in the real software development world. Not that this would necessarily be a problem, but SharePoint is one of the most difficult platforms I have ever had the unfortunate experience to program against. While these "developers" are busy building InfoPath forms and exposing tons of meaningless columns to interface with the workflow engine (they often use WF to overcome the fact that InfoPath is NOT a development platform), it's my job to interface the pile of mess with other COTS products by building convoluted ETL processes. The unfortunate truth of the whole situation is that the senior technical staff (e.g., CTO) fails to see the flaws that SharePoint brings. They focus their energy entirely on common CMS features, such as how easy it is to enable search and create a new page. If you dare suggest an alternative, you'll find yourself amongst the other outcasts --lonely, frustrated and unheard.

      SharePoint is, by far, the most hideous platform I know of. It makes me long for the days of hacking HTML to make it render correctly in IE6.

  4. Re:This is great news if by Nerdposeur · · Score: 4, Insightful

    It's also good news if you like competition. Now you've at least got an option to switch, which puts some pressure on Microsoft. And if Google can do this, someone else could, too.

    This isn't "good vs evil." It's "choice vs no choice." And it looks like choice just scored a point.

  5. Sharepoint is cheap? by Enderandrew · · Score: 5, Informative

    It requires considerably more iron to run it than Wiki software, and the software licenses are very expensive.

    We invested initially in Sharepoint, but can't afford to roll it out for the entire company.

    Cheap is the last word I'd use to describe Sharepoint.

    Depending on how and what you use Sharepoint for, companies should consider looking at MediaWiki and/or Alfresco for document storage, indexing, processing, sharing, etc.

    --
    http://blindscribblings.com - Tasty pop-culture in conceptual fashion.
    1. Re:Sharepoint is cheap? by cdrudge · · Score: 4, Insightful

      I think it depends on what flavor of SharePoint you are using. Windows Sharepoint Services (WSS) is licensed as part of Windows Server, so you aren't paying extra for something that you may already have. Microsoft Office Sharepoint Systems (MOSS) is licensed separately can the costs can very rapidly grow to very large numbers for larger enterprises depending on what features are desired or how the farm is laid out.

  6. Sharepoint makes me mad by hansamurai · · Score: 5, Interesting

    This is such an awful piece of software, especially for people who use a non-IE browser, essentially making this even more worthless for non Windows desktops.  I'm asked for my security credentials every other click or so, and even when it is correct, sometimes it will just keep asking and asking (and yes, in Firefox I added the url to my network.automatic-ntlm-auth.trusted-uris).  The wiki software is just atrocious with the syntax being completely unintuitive.  The only way to really use the wiki is... yep, to use IE and the built in rich text editor.  Just check out some of the code generated from it:

    <div class=ExternalClassD18714056AE54C4288E018C6231AEF4A>
    <div align=center><strong><font size=4>Welcome to&nbsp;My Group&nbsp;wiki site!</font></strong></div><strong><font size=3></font></strong></div>
    <div class=ExternalClassD18714056AE54C4288E018C6231AEF4A><strong><font size=3></font></strong>&nbsp;</div>
    <div class=ExternalClassD18714056AE54C4288E018C6231AEF4A>
    <div align=left><font size=3></font><font size=2>Welcome to the Department Wiki. Remember, this is your wiki, so please don't hesitate to add and/or enhance existing pages, and fix mistakes or errors.</font></div><font size=2></font></div><br>
    <h1><font size=5>Starting Points</font></h1>

  7. Uhm... by Richard_at_work · · Score: 5, Informative

    Getting content out of SharePoint is blindingly trivial - the web services provided allow you to access all saved versions of documents in document libraries (including wiki pages et al), all user information and all list items.

    Grab the information from the web services and do whatever you wish with the resulting data - its neither hard nor hidden, so this story is pointless.

    1. Re:Uhm... by Sylver+Dragon · · Score: 4, Insightful

      Thank you, I was beginning to think I was the only one here who had ever tried to pull data out of SharePoint. While I'll agree with many of the posters in this thread that SharePoint can be as much trouble as a help, the idea that it is some vendor lock-in fortress is just stupid.
      Hell, you can drag and drop your files out of a document library using Windows Explorer, this is hard? Or, for single items, left-click the down arrow, click Send To, click Download a copy, fuck this is hard! BTW, this even works in FireFox, though you do have to disable NoScript, which I guess can be hard if you have a room temperature IQ.

      Oh ya, and as someone else has already pointed out, you could always dig into the SDK and write programs against it to move data in and out.

      But yes, SharePoint is a fortress which eats your data, pollutes the environment, and kicks puppy dogs.



      Come on guys, MS's software has enough problems, without us making shit up.

      --
      Necessity is the mother of invention.
      Laziness is the father.
  8. Re:This is great news if by queazocotal · · Score: 4, Informative

    It's actually quite trivial - and getting more so to move your data out of google apps.

    See the recent 'data liberation' things they've been doing.

  9. CEO's point of view by Iamthecheese · · Score: 4, Insightful

    Even if google were only being proposed as a bridge to other formats it's just too much trust to ask for sensitive and classified documents to be moved through servers at a company we don't control.

    --
    If video games influenced behavior the Pac Man generation would be eating pills and running away from their problems.
  10. That would be surprising. by SanityInAnarchy · · Score: 5, Informative

    Gmail supports imap. Google Calender supports iCal. Google Docs exports natively to OpenDocument. GTalk uses Jabber and Jingle. Google Chrome is open source, as is Google Wave, Android, and plenty of other things I can't remember offhand.

    I haven't really seen that much in terms of lock-in from Google, beyond the fact that they often provide the best implementation -- for example, I don't see how you could lock someone into a search engine, yet Google Search remains dominant because it's actually good.

    Can you give me your reason for believing Google would lock people in? Any evidence to back that up?

    --
    Don't thank God, thank a doctor!
    1. Re:That would be surprising. by LizardKing · · Score: 4, Informative

      Remember, *parts* of each of these things are open source, not all, due to apache license.

      They are completely open source and Open Source - OSI certified, and GPLv3 compatible. They're just not completely "Free Software" (which is just a particularly restrictive form of open source and therefore less free in the dictionary sense than Apache licensed code).

  11. How hard is it? by mcmonkey · · Score: 4, Informative

    What is this lock in? I RTFA and skimmed the linked wikipedia article, and couldn't find any details.

    Everything in SharePoint is a list in the database. A calendar is just a list of events with start and end times. A address book is a list of contacts. All you need is some basic SQL, and your information is free.

    Documents are also in the database as binary objects. Pulling them out and saving to the local file system can be an exercise for your intern or first year programmer.

    The API for SharePoint is fairly well documented. If you wanted to migrate a site from SharePoint to another platform, recreating the look and feel may be a challenge--likely depending on your design skills--but getting your data out will not be.

  12. Re:This is great news if by packman · · Score: 4, Informative

    Can only say one thing to this: http://www.dataliberation.org/

  13. Re:Just wondering... by brainstem · · Score: 4, Informative

    It's an MS web based document management system with CMS capabilties (among other things). Most organizations use it for intranet type sites, but there are many companies that use it to manage their public facing websites as well.

  14. Reverse Engineer by the+eric+conspiracy · · Score: 4, Informative

    Not that hard to reverse engineer the schema.

    This fellow has open sourced a tool to crack it open:

    http://blog.dreamdevil.com/index.php/2007/03/13/sharepoint_2003_database_exporter/

  15. Back Before Sharepoint came along... (Geeklog) by Zombie+Ryushu · · Score: 4, Interesting

    Back in the day before Sharepoint, as a school assignment for one of my higher level CIS Classes I was tasked with making a CMS where as people could upload (Word) documents to the CMS in the form of Articles.

    The closest I was ever able to get is with an an application called GeekLog. But there was absolutely no automation. I tinkered with the HTML export aspect of Word, it was an absolute abortion. Useless with Geeklog.

    Now that we have linkable libraries for everything under the sun in Linux, I always wondered the following: Why could it not be setup such that so long as an Acceptable format was uploaded (DOC, ODT, WPD, etc) could be parsed into an XHTML 1.0 Compliant article.

    I never could lick that problem.

    Then another problem came up. I needed a way to Authenticate Geeklog against LDAP, and later single sign on with Kerberos.

    I was thinking this all the way back in 2003 and 2004.

    Then, low and behold, I start hearing about the abomination that is: Sharepoint.

    After I heard about I was like "oh damn it. They got write what all these LAMP Stack PHP applications couldn't think of: LDAP, Kerberos, and the ability to turn binary documents into readable searchable articles."

    It was like my worst nightmare come true. GeekLog was a prime example of how Linux developers could have stopped the sharepoint nightmare before it started.

  16. Re:Micro Google Lockin? by ElSupreme · · Score: 4, Insightful

    Yeah but google gets to read it after you extract it. I would rather have my company trade secrets in my company.

    --
    My addiction: Arguing with idiots. AKA Slashdot!
  17. Re:This is great news if by TheRaven64 · · Score: 4, Insightful

    Bottom line is: avoid proprietary lock-in.

    So then why are you using Google's proprietary products then?

    There's a difference between using proprietary products and being locked in to proprietary products. If you use a proprietary mail server (for example) that stores its spools in maildir format and implements IMAP and SMTP, then you are not locked in because you can replace it with an (open or proprietary) alternative easily.

    Google makes it easy to extract your data and put it somewhere else. Sharepoint does not. That means that you are not locked in to Google's products if you choose to use them, while you are if you use Sharepoint. It's not about Microsoft being intrinsically evil and Google being intrinsically good, it's about the relative difficulty in ditching either of them in the future.

    --
    I am TheRaven on Soylent News
  18. Not True--and how Sharepoint actually proliferates by Slicker · · Score: 5, Interesting

    Uhm.. Seriously? You are really kidding me.. I mean REALLY? It is not any of those things boasted--not remotely close. I worked with Sharepoint for the last two years, installing, administering, and using for a state university. It is absolutely the most unrecommendable software product I have EVER worked with. It has worked reasonably well (not great) only for one purpose for us: a document repository. Version control only really works when using Microsoft Office 2007. Otherwise, it'll wipe out your version histories.

    (1) Ease of installation -- It's highly complex. You really do need to read the 700 page book Microsoft has to know how to install it. This is because numerous options at install time cannot be changed later except by re-installation. And I mean many numerous options that are very difficult to understand how each relates to the other.. We reinstalled so many times, paid for expensive consulting both with Microsoft and with an outside firm. We still couldn't get it right. The nuances are many and hit you repeatedly often with the only fix being a reinstallation.... and usually rebuilding of content, along with it.

    AND users almost universally hate it. Management fights hard against the wishes of users to implement Sharepoint--not only at our organisation but also at every other organisation I've had to privilege to ask their sysadmins about. Management usually hails its success but on the ground, it's almost universally hated and a disaster. Oh, yes.. Our universities library system also had a successful use of a simple trouble ticket management system... so there were two exceptions. It's also easier to install and administer as a single server than as a farm, but still not so easy and no easier on users.

    I cannot stress enough--the problem with Sharepoint are the many many MANY critical nuances.

    (2) Inexpensive -- No. It's very expensive. The learning curve is quite high so training is really required. In our case, the expense was bundled in with a variety of other software licenses such as that for Exchange. Alone, the license is very expensive--particularly if you want to open it up to outside your organisation's intranet.

    But the real expense is in administration. Both training costs, immense amounts of time spent with it, and dealing with problems ongoing are the highest costs I've ever seen for a server application. Upgrades are also a huge difficulty. They present as opportunities to resolve some former configuration problems but taking advantage thereof often means your data is not restorable.

    Of all the alternative applications I've worked with, "Typo 3" is the most Sharepoint-like, functionally. It is, however, far easier to learn and it is reliable. Sharepoint is reliable only in the sense that its processes keep running--that doesn't mean it doesn't break regularly. The best general purpose CMS I have worked with is definitely Drupal. Drupal lacks some of the capabilities of Sharepoint (presuming those capabilities were actually usable in Sharepoint in any meaningful sense) but has many others.

    The problem is that Sharepoint is not exactly a CMS. It is (and I am speaking in theory--not practice in practical terms) a collaboration environment. There really is a difference. Drupal itself has a learning curve that I don't like. It's more administrator focused and not user focused, as manifested by the fact that you cannot edit things were they are seen by users but rather must work through a back panel. Drupal also lacks a WebDAV document repository and the ability to do things like email in documents and other kinds of content and get email notifications of content or documents modified.

    Drupal is about setting up a classical website for users to use and administrators to administer. Sharepoint (in theory) is about providing a service where users can create their own sites, document and data repositories and means of presenting and sharing the same (via tags and filters). It's about working together within an or

  19. Re:Just wondering... by ByOhTek · · Score: 4, Informative

    Sharepoint is a piece of collaboration based software that Microsoft developed. People can jointly work on documents or data stored on the server, and manage the security within their own niches. The design is primarily to give groups or projects their own space, and then give a lot of control over what happens there to the group leader.

    While CMS features were mentioned by another user, they are almost an afterthought or byproduct of the other features, rather than the main purpose of this software. It also happens to SUCK for content management, and it's recommended you get another back end content server to store your Sharepoint managed or created data long term.

    --
    Self proclaimed typo king, and inventor of the bear destroying coffee table (patent not pending).
  20. Re:Micro Google Lockin? by Jesus_666 · · Score: 4, Funny

    Don't worry. Your sensitive data is stricty a secret between you and Google's marketing division. And their shareholders and strategic partners.

    --
    USE HOT GRITS WITH STATUE OF NATALIE PORTMAN (NAKED AND PETRIFIED)
  21. No Lock In by WED+Fan · · Score: 4, Interesting

    Yes, SharePoint integrates with office. Surprise! But, you aren't locked in. No, SharePoint doesn't trap anything. SharePoint out-of-the-box, is o.k. To make it USEFUL, you extend it with features. Features can be purchased or developed. One such add on is StoragePoint that allows all the BLOB storage to be moved to the file system, other DB's, other CMS, etc.

    The common answer to the lack of a feature in an OSS project is, "Well, write it yourself." If you need a feature in SharePoint that isn't available OOTB, or COTS, you can...surprise, write it yourself.

    --
    Politics is the art of looking for trouble, finding it everywhere, diagnosing it incorrectly and applying the wrong fix.