Hello, my name is Michael Nemtsev and I welcome you on my blog about SharePoint Infrastructure, ECM systems and Information Management I'm Microsoft MVP, Web Developer and SharePoint Consultant based in Sydney, Australia. If you have any questions about SharePoint, then you are in the right place :) Feel free to ask via Contact Form page
Hi Michael,
Sounds like you are taking it in your stride!
Do I have any alternatives? Neville and Chris will tell you about my everydays whimpering and WTFing to SharePoint :)
Thanks to Rob and Adam for gettin' me into this gamble ;)
I can also recommend Bill English's Sharepoint Administrator's companion book from an infrastructure point of view. It was a vital resource for me getting up to speed with it all.
www.amazon.com/.../0735622825
Hi, Nice list, I am new to Sharepoint dev and have been using VS 2008 since it came out and I aint going back to 2005 just for SP. I have been seriously peed off by the lack of support for tools in VS2008 from MS. Your list sweetens the taste a little.
Thx
Congrats :) and welcome to the club!
Thanks for posting this. It saved me what probably would have been hours. :-)
Thanks for posting this, but i have a scriptmanager for ajax and this script fail. Do you know how can i slove it?
Do you have SP1 installed?
Did you change the web.config to add all AJAX specific stuff, like httphandlers?
If everything done and and you put ScriptManager, then what exception do u have?
Nice tip... thanks for sharing Michael!
Thank God this is a bug. I thought I was simply going mad. :)
also dont forget to mention the prescan tool!
Hi,
I converted a List view to an XSLT data view in SP Designer and lost "Edit in Datasheet" from the Actions bar.
Do you know how I can resolve this issue?
Thanks
Regards
Chris
sammutchris@gmail.com
Hi there Michael,
Thanks for your post, it's interesting and very useful to me.
Could you please send me some templates or smaple of documentation for SharePoint projects. As you its mnetioned above that "SharePoint SDLC differs from standard development".
Besides, I have done some researches on the Internet and I found plenty of templates such as RUP (www.ts.mah.se/.../index.htm) and others stuff, but I believe that they are not compatible with SharePoint projects and they do not fit together.
The list mentioned above (Those 14 points) are really comprehensive methodology to create full SharePoint project from A to Z, I will owe you for life if you could provide me templates of documents or some samples of documentations which applies those 14 points in the list above.
I truly need this help from you because it's very urgent and so important to me and I will never ever forget this favor, I beg your understanding!
My email is: alex9spain@gmail.com
I very much look forward to hearing from you soon!
Thank you in advance.
Sincerely,
--Alex
Superb It work ....Thanks Man
Great, Many of my previous students did not know this. I have taught quite a few the same thing.
If any of the readers of this informative blog would like to learn more please visit us at www.aivea.com/sharepoint-training.htm
Thanks for this... helped with another deployment
Great Article.
How do you delete a Site collection that has no Database? I've tried from stsadm and CA .. neither works.
Also, apparently stsadm -o deletesite does not delete the Database of healthy sites either.. and apparently deleting the dataabase from SQL creates problems like the one I'm having... the site shows up in CA, but has no DB.
please email me at jc_pineiro(at)yahoo(dot)com
man mvp is good.
goo information ,, i downloaded some of the whitepapers ,,
thanks
Balaji
www.manyforyou.com
Thank you, step 6 about correctly pointing the Central Administration the new name is what I had been missing. I appreciate the help.
Hi Micheal,
I have created a subclass of CBQ web part and enable my CBQ's subclass with the ability of using custom CAML. Recently, I want to use a custom CAML which filters all the list item of created by the current user. The CAML is like
"<Eq><FieldRef Name='Author' LookupID='True' /><Value Type='User'><UserID /></Value></Eq>"
The problem is, when the page is in edit mode, the CAML works perfectly. But when I exit the edit mode, it cannot returieve any item out.
What probably is the problem? Can you give me any help?
Where is your root <Query> element for CAML?
My root CAML element is <Where>. So, the complete CAML is: "<Where><Eq><FieldRef Name='Author' LookupID='True' /><Value Type='User'><UserID /></Value></Eq></Where>".
I used this CAML in a SPQuery object. Then I tried to get items from a custom list with this SPQuery object. The fact is that this CAML works perfectly to filter all the items created by the current user in both edit mode and normal mode. So, I guess this problem is something related to CQWP only.
I googled lots of pages and found one post saying that the caching infrastructure of the CQWP does not cache checked-out items of individual users and we disable cache in edit mode. By following his suggestion, I set the UseCache property of the CQWP to false. This way, it works :)
Now, the problem is disabling the cache of CQWP because I don't think this is the right way of doing things. Do you have any ideas on this? Is there is another way of writting the CAML so that we can work around the cache issue?
Nope. You need either to disable the cache or don't use checkout items.
Actually, it's not only checkout items, but items which are not published yet, are out of the CQWP results in standard mode. We had such issue before :)
I found this behavior very logical. Because checked items and not published items are private items, which are in work now, and you should not expose those data in most of cases.
So, just disable cache or revise your approach for shown data in CQWP
Hey that's cool didn't know that tnx for sharing!
You can also change the document template for the content type after it's created by entering the advanced settings page for the content type.
M
Michael
I have the problem you mention in your troubleshooting, but I am not doing any mirroring. I have restored a backup of our ContentDB to a test environment and then tried to add the contentdb to my test sharepoint site using 'stsadm –o addcontentdb....' but get the error you mention (Cannot open database "<…>" requested by the login. The login failed. Login failed for user '….'.) in the update log.
Why would this happen? I have done this process several time and it has always worked - any help would be greatly appreciated
Are you sure that your called "stsadm -o preparetomove"? before detaching? missing this call gives 90% of all problems
Try to follow this blogs.technet.com/.../detaching-databases-in-moss-2007-environments.aspx guideline how to detach and re-attach db.
I LOVE THIS TIP!
So when you say that the solution is simple :) I'm at my wits end with this error and still cannot get it resolved. Any additional insight would be greatly appreciated. Thanks.
Hi Michael
We are having a strage issue for content deployment.
We deploy content from Authoring to QA and from QA to production.
Recently we noticed that when we deploy content from QA to production it is loosing navigaion. Means when I go to "_layouts/AreaNavigationSettings.aspx" it is not showing the navigation URL basically the last two boxes on this page are empty.
What do you think could be reason? Has anyone encountered this kind of issue?
Sree, check the ULS logs for "AreaNavigationSettings.aspx" file records in ContentDeployment category, if it was copied to destination server.
What could happens is that you already have this file there, or it is checked out there
Hai,
good article of yoú; I am MOSS 2006 certified admin; little question; how can I measure the latency to different SharePoint Server Role boxes ??
Do you have a personal website with more info about MOSS 2007??
Thanx in advance.
rgds,
Khyran
Hello,
I just published the answer on you question. Read it there msmvps.com/.../sharepoint-tip-17-do-you-know-why-to-measure-network-latency-of-sharepoint-farm.aspx
The site about sharePoint practices is only planning. I will inform when it will be ready on my blog
When testing with ping, the default packet sizes are very small. By watching typical traffic, you can shape test packets to the high, low, and average sizes. This can help alert designers to problem areas before they appear in production.
I appreciate your valuable tips. Since long I am searching for something similar.
Is it possible for you to give some more tips on the points to take care while migrating ASP.NET custome application to SharePoint?
Thanks,
Dhawal Mehta
I put comment to my tips which I'm planning to publish and will find good topics for this area
I did not succeed connecting a MOSS excel webpart to a querystringfilter webpart using this procedure.
Best regards,
Merijn
Great summary, Michael.
I'd love to see rows added to show how these products handle metadata, views, document templates and content types offline.
It would also be great to see some third party tools (like Colligo Contributor - admitted shameless self-promotion) added to the analysis.
Barry Jinks,
Colligo Networks.
I have also found that the drag and drop junctionality is broken. Although I have found this fix - neilmosafi.blogspot.com/.../sharepoint-dragging-webparts-causes.html it still does break now and again. Something that might be helpful though.
Sam Dolan
Hi Michael & Alex,
Do you guys have the Sharepoint SDLC documents and process that I could refer to since we are new in the SharePoint.
E: albertlaudia@gmail.com
Thanks!
-- Albert
There are not public templates for SharePoint SDLC, unfortunatelly. Few people tries to create them, but I can't find any good templates.
I would recommend to google:
Sample geekswithblogs.net/.../documenting-your-sharepoint-application-design-part-1.aspx and geekswithblogs.net/.../documenting-your-sharepoint-application-design-part-2-the-process.aspx
Hello
it will not show up if you have office 2003. you can get the service pack 3 for office 2003 which solves the problem partialy. you will be able to see the dataSheet in edit mode but some special columns will not appear they would only if you have access 2007 though most of the time lists don't have those special columns "holding media stuff and pictures"
cheers
Very nice article! Thanks for the in-depth info. Is there a way to also mirror custom DLLs in GAC and custom themes?
custom DLLs can be easily tracked by their location in the bin folder of IIS - just move them to new server and that's all.
GAC dlls are bit tricky to find. Actually, what you can do is to inspect the web.config section for all safecontrols dlls.
Just create a new site (and activate published features) to have the clear web.config. And then compare <safecontrols> section of the clear web.config with corresponded web.config you are migrating
Thanks Michael for the tip on AD. I am a newbie to sharepoint. I would like to ask you two questions:
1) How do you list current logon users to a sharepoint site?
2) I am planning to deploy sharepoint 2007/SQL 2005/Windows 2008 on a Hyper_V configuration:
i) SQL Server 2005 will be on separate physical server(single);
ii) Two Web Front End Servers on Hyper-V virtual machines (2G RAM) each;
iii) An index server on another virtual server (4GB RAM).
All virtual machines are running on the same physical server running windows 2008 core server (32GB intial RAM.
Will this configuration be feasible for production in a small company (400 users)?
Thanks for any help.
Nee
email: nokai@atcc.org
1) you just create a new AG group, where you put your "login" users together. The point is that all fine-grained groping happen on the level of AD, not SharePoint. There is nothing bad to put user-by-users inside the SharePoint, but this might be not ideal case for the large farms.
2) "Index on another virtual server" is what I'd be very careful about. It might be ok when you don't have a lot of contend and don't optimize your DB to the specific content. But it might cause you performance issues for the large content. Take into account that index usually takes 10%-30% of you actual content and propagated to the Query servers incrementally. To understand if Index server is suitable to be on the virtual server you need to perform some testing. The good index server crawls and propagates the new part of the index in 3-30 seconds. So, just add new document to the farm, and check if you are able to find this document via SharePoint Search in 30 secs. If not - you Index server hinders from the performance issue (consider using physical HDD first and then move index role to the physical server)
I really want to know "how to get the SharePoint Farm server's version programmatically",I try to get it user sql script but I got nothing.
What code did you use?! SQL or API?!
I believe its here:
msdn.microsoft.com/.../microsoft.sharepoint.administration.spfarm.buildversion.aspx
fzchen: It sounds like you didn't select the correct database. Try the following:
Replace with your ID (do exec sp_databases to figure out the name)
use "SharePoint_AdminContent_c2150d26-7bd4-4a06-9437-fde2496ccb02";
select Version,UserName from Versions where VersionID='00000000-0000-0000-0000-000000000000' order by id desc;
Neat tip. How did you put color on "feature"? looks like grep --color=auto to me, I would love to have it on Windows :)
I just paint the "feature" keyword it in MSPaint, to highlight the info :)
I have a specific user set to access a folder within a document library of a site. As a result, that user was granted 'limited access' on the 'site permissions.' When I login as that user, I can navigate almost any lists/document libraries on the site, so long as they have inherited the 'limited access' of the site permissions. One location that I cannot access as that user is the main default.aspx page. The site is not a published page, so it simply exists on the root of the site name. Is there something I am missing?
What are the permissions for the default.aspx page?! Do you have "Restricted Access" to be set on this page for the current user?!
liked the blog very much.
Ping back from codeforfuture.com/.../microsoftnet-tips-and-tracks-included-interview-questions
also following you on twitter now.
Please focus more on MOSS 2007
This section of .NET Tips will be moved to the new hosting soon.
Stay tuned
Hi Micheal, I tried your code; however, I got the error when I compile it, here is the errors:
The name 'providerValues' does not exist in the current context
The name '_filterProviders' does not exist in the current context
It seems that it does not recognize these variables:
providerValues
_filterProviders
Could you tell me what need to be fixed to eliminate these errors. Thanks for your help, here is my code:
[skipped]
I posted the code-snippet, what means that you need to write the additional code.
1) _filterProviders - please read a commends for the line 8. It says how to declare that variable
2) providerValues - check what filterProvider.ParameterValues returs, and create such field
Interesting post on how to find the versions of SharePoint installed in the farm.
home.dzeee.net/.../Post.aspx
Do you have any information on how to call a
SharePoint Web Service from SQL Server CLR Function (written in VB.NET)?
What I am trying to do is:
XYZ is a SQL Server Database 2005 and ABC is a SharePoint v3.
XYZ has aID, bname and cStatus columns
ABC has owsID, owsNameOwner
On SQL Reporting 2005, I am trying to query both XYZ and ABC like:-
Select aID, bName, cStatus,
(select owsID from ABC as ABC1 where ABC1.owsID=XYZ.aID) as IDCode,
(select owsNameOwner from ABC as ABC2 where ABC2.owsID=XYZ.aID) as NameOwner
from XZY
My SQL Report will look like this:
aID bName Cstatus IDCode NameOwner
1 aaaa Failed 1 John B
2 bbbb Successful 2 Mary V
.
..
...
Thanks.
Regards,
Mak
Hi Michael, can you tell me the limitations of this fix?
This also existed in applying Sp1 for me.
Not sure if there are any limitations. Just intallation trick
It's behavior by design - you can't edit converted to XSLT data view in datasheet
well done sir.hand soft to you
I am running into a similar problem. - My share point site works internally buy no external. After checking all settings I made this registry entry and I am able to authenticate locally on the machine but still unable to get the site to pull up authentication on the outside. Granted there could be other reasons for this but I have gone over the settings a dozen times. Would this reqistry entry effect the ability for users on the outside to connect to the share point site?
Who are the "externals" and how are they logging in?!
Did you extend you web app or you are in the same network?
The API was is the way that this should be done... STAY OUT OF THE DATABASES
Also, this isn't the template - it's the site definition.
Yep, right, the site definition from which the site template that was used to create the site is derived!
Thanks for noticing.
Btw, you might not have PowerShell installed to get site definition via API.
Database is the way to peek on that value
There is another since SP2. Using stsadm -o enumallwebs. This will show the site definition and can be a great one to check all sites.
Good work on the tops by the way.
Michael,
First, you really need to do more research before posting this kind of information. Microsoft explicitly states that reading directly from the database is unsupported. The recognized best practice, as Rob stated in the first comment, is to STAY OUT OF THE DATABASE. People are going to assume that your advice is valid because you don't include any sort of disclaimer, as in "if you absolutely have no other option you can do this but you should be aware that it is unsupported, could potentially damage your SharePoint installation, and could lead to a lack of support from Microsoft" or something to that effect. This advice is dangerous, to say the least; please be more responsible in the future.
it was nice topic..thank you so much
I could able to access the user account.
using pplPicker.Acounts[0] giving me domain\userid.
How can I access userEmailid, address etc details of an account.
thanks in advance.
vish
Did you use PickerEntity.EntityData property?!
Email should be there.
See these samples
1) mysharepointblog.com/.../How-to-use-the-PeoplePicker-in-SharePoint.aspx
2) social.technet.microsoft.com/.../1b828093-1e5e-42f7-b9d2-10c62df498a6
i want to display the items in CQWP based on logged in user region.
ex:
if logged in user belongs to Middel East, i want to display Middle East related news articals to the user.
user profile property holds the user Region and news artical has the field named as region.
i want to map these and display the related news articles.
Please help me out. thanks in advance.
What are the requirements to the "region" detection?
Do you want to detect it by IP - where user physically locates (but what to do in case of working over proxy or being in business trip),
or you want to detect the region based on the user's localizations settings?
See these links
1) www.west-wind.com/.../334.aspx
2) forums.asp.net/.../1052219.aspx
Our company employees located in Geographical areas(USA,UK,INDIA).
User profiles are dumped from AD to sharepoint.
that has a property named as Region holds the User Region. Ex: USA,UK,INDIA
I have news Document libray containing news articles and has one field named region, which indicated this artical related to that perticular region.
Ex: USA,UK,INDIA
i want to display the news articals based on loggedIN user region by pulling the region from user profile and map it with the field region of news artical located at news document librey.
i want to customize the CQWP. plese help me out.
Michael, i am really waiting for your answer. please help me out.
thanks..
Where exactly you stuck?
You just read the user's properties from AD and then construct you CAML query to include that country.
See this sample www.helloitsliam.com/.../moss2007-–-redirect-using-profile-property-and-sharepoint-list.aspx
First time i am working on CQWP customization.
One more question i have,
How to expose the new properties like grouping and sorting.. how to use the newly exposed property in CAML query..
Not able to open this link, please send the full URL.
please suggest me the approch that suits to my requirement. can you please send the sample code.
http://tinyurl.com/nuwzf4
i want to copy an agroup from one site to another but this group have limited access so an exception arise while running my application.
do you have any idea to copy this group with this limited access or any other idea will support me?
Matto:
answer was published on our "SharePoint Tips and Tricks Site" as a part of Q&A section sharepoint.devs-sandbox.com/index.php
You answer is #8
thank you sir for replay,
but these technique doesnot solve my problem, plz, let me display my problem with more details.
now, i want to copy groups only with thier permission leve from on site at a web application to another site at a different web application.
while running my own application to do that an error arise that report that " you cannot add users to limited access permission leve." this because there are groups have limited access permission.
thank you for your pateient with me, can you help me sir?or if you have another idea plz support me with it.
What do you use to copy groups + permissions?
guide me please into ways to connect sharepoint and an older application (BarScan)written in Visual foxpro
Do you use MOSS of WSS?
How do you want connect FoxPro? to the list?
See this office.microsoft.com/.../HP100931601033.aspx or alternatevely use BDC
I find SharePoint Analyzer slow to operate, where SharePoint Manager 2007 is fast. And I'm not saying this just because I made SharePoint Manager 2007. Just try it out yourself.
Do you know the specific scenarios when it fast or slow or it's generally slow?
thank you for your replay sir,
sir, my problem is afetr migrating sps2003 to moss2007 i found that groups that we use when we create new users is incomplete so i try to update and complete this groups with correct permissions.
so i develop an application that read site group of a web application that have complete group and copy this group with it's permission to web application that have in complete group but some error arise report that you can not " you cannot add users to limited access permission leve." this because there are groups have limited access permission.
sir, do you have any solution for my problem.
thanks®ards
why youк groups are incompleted after migration?!
Did you use STSADM -o export/import with -includesecurity parameter?!
did you consider creating security groups from scratch for your new site?
Once again, the installation of Office Applications is NOT required for any functionality on the server with SharePoint.
This was covered in the SharePoint magazine article which was meant to be a draft, but here is an article stating exactly the same.
Installing office on a Server is not supported or recommended nor is it needed in any shape or form on the server!
Thanks for this note. Updated this post
Is it because my publication was based on several blog posts and I forgot to update my post when found that error (post is dated Sep 2008, and error was found in March 2009 only)
i'm using content database migration to migrate sps2003 to moss2007 using stsadm command(addcontentdb)
but i discover that groups that exits in moss2007 is incomplete and limited access permission not exit in these groups so i try to read it from complete groups in another web application.and also there are groups which have only limited access so these groups without these limited access permission appears as the following (Style Resource Reader[No access]).
this all what i'm doing.
thank you sir for your pateient with me, can you help me sir?or if you have another idea plz support me with it.
thsnks & Regards
Awesome tip, it was exactly what we needed. Thanks.
I reckon that the best solution is to write down all existing groups and permissions in SPS2003 (for example in excel) and recreate them in MOSS2007.
Except missing groups you also can find that permission inheritance is broken.
It's better to review existing security and plan new one for you new site.
hi, i love your blog. can you please expand on: To plan you taxonomy and build good information structure you need to visualize all information on the single page, with direction where it flows. It helps you understand what happens with existing system).
Do you mean a single page - ie: a single Visio diagram. And would you do a single page for each information module, or just one single page for the entire site collection? (as a general rule of course)
can you please elaborate?
ta
paul@geidi.com
usually it's a single Visio diagram depicting all information that come in|come out, to get the whole picture quickly, but making accents on how it "flows"
"content location" will detalize it to the specific level (either site or site collection)
Hi
OK well i am having the reverse of this problem I can not stop "System Account" showing in the sharepoint history.
Any ideas
The Sharepoint DB did not exits.
If you see a Sharepoint DB, forget about: isn't real :-)
The Sharepoint DB exist only in the DBA universe!
I have a question regarding this Limited Access I've been trying to solve for a while ...
I have a site with several librairies with several documents per library.
I want to give a user access to one document in one of the libraries.
I give the user 'read' access to the document and he also gets Limited Access to the above library and site.
Now the user can enter the url for this library and will only see the document he has access to.
But some problems arise.
The user does not see the menu-item for the site.
And when he is in the site he sees all the other libraries too ...
So my question is, how can I give a user access to a document so that he will see the site in the above menu and when he cliks the site-item he only sees the library with his document ?
All discussion moved to sharepoint.devs-sandbox.com/index.php
I replied there
Good info!!!
Hi Joel- very impressive blog.
About backup, say I have a 3 server farm (2 WFEs and dbserver) and I take a vmware snapshot of the WFEs to use as a backup
There will be a time difference (very little maybe) between 2 snapshots of the WFEs.Wouldn't reverting back to those snapshots make the 2 WFEs out of sync with each other and the database server?
What do you think?
-Shah
Nope, there is no issues with WFE sync, because it gets all data from database and nothing will be lost.
WFE doesn't store data and nothing to lose.
There is a small issue with snapshots of database server - becase DB can be unsyncronized between snapshots
Can you give any guidance to setting up a central list within Sharepoint MOSS 2007. I want to create a list and share this list with other sites and teh document library, so I use a sinlge list for products and customers, instead of duplicating data.
You answer is there social.msdn.microsoft.com/.../7df6f5d9-c62f-42f4-9aca-b77721d6c1ed
or something like this (when I'm checking if SP2 is installed), which is a bit smaller:
Version version = SPFarm.Local.BuildVersion;
bool sp2 = (version.Major >= 12 && version.MinorRevision >= 6421);
how can i install sharepoint on windows xp?
No, you can't install SharePoint on Windows WP. You need Windows Server for this
I work for Jobserve in the UK and have been asked to take a look at the companys internal sharepoint site. It was a projected someone started a year ago and didnt do to much with so i have a free hand to start from scratch on a folder architecture etc. Do you have any examples i could use as pointers on this? any visio diagrams or documents? I haven't used Sharepoint before and need a bit of a kick start. Ive already re-designed the Active Directory for the company and ive only been here a month and a half.
Any help, pointers doco's would be great.
Will (william.leggett@jobserve.com)
Great overview mate.
Do you have any experience with ControlPoint from Axceler?
nope, will look at
bizzarrely, if you add a filter on checkoutUser Not eq to [Me] then the checked out items will appear in display mode regardless of cache settings
hmmm, interesting.
Can you say the exact version of SharePoint 2007 you are using.
I think it might be fixed in one of the SP or updates, but need to know you version number where you have such behavior
I also got some weird behavior with CQWP on discussion boards with content approval:
1. Without any filtering, I only got all the approved items.
2. As Kate mentionned, using the filter "CreatedBy=[Me]" lists all my items even the pending or rejected ones!
3. Using the filter "CreatedBy=[Me] OR CreatedBy!=[Me]" outputs all my items (including the pending or rejected ones) and, oddly some but not all the approved ones!
MOSS version is 2007 SP2 April'09 CU (Enterprise ed)
I would like to disagree with you.. well on just about all your points.
Requirement 1: You can store millions of documents, however having them in one folder and in deep nested folder structures is a horrible practice from an ECM point of view (or any other). That means that you didn't plan, conceptualise and set up your organisation's taxonomy (including search taxonomy) properly, or at all.
In fact those products that allow such bad practice should have a feature to prevent it from happening.
Requirement 2: DoD 5015.2 Add-On is a formal part of SharePoint 2007 Server, go to: www.microsoft.com/.../05-29SharePointDoDPR.mspx
While you're there note the date of the article!!!!
Requirement 3: Once again, since SharePoint 2007 is completely DoD 5015.2 compliant that makes it compliant for Records Management with majority of all the countries (the ones that subscribe to it). Some countries have specific requirements for Records Management, which require specific features, but no ECM platform covers them all, trust me I've had experience with another 5+ of them (leading ones, that include two OpenText ECM platforms).
Requirement 4: You can index anything for searching as long as you have an ifilter for it, no leading ECM platform has the ability to index everything and it pretty much has the same limitation, there is a number of free ifilters available for free, some you do have to pay for, and in all honesty you can create a custom ifilter yourself.
Rendering is a different story for that you need customisation or a product like www.sharepointreviews.com/.../583-Render-It-Content-Transformation-for-SharePoint.html
However in my experience I found that client's requirements around this are either very basic (where with SharePoint doesn't make a difference) or quite complex, most of the time requiring purchasing of a 3rd party product even with the ECM platform with most comprehensive rendering capabilities.
Requirements 3 and 4 are basically common issues on all platforms.
Only issue in my opinion is that other leading ECM products like Livelink, Documentum and Filenet are a lot more mature in ECM space than SharePoint. However SharePoint is very fluid and is progressing at pace at which the rest just can't keep up. It's also built on a better platform and frameworks allowing it to utilise latest technologies and concepts much easier and faster, and competition mentioned above will not be able to match that. (IMHO)
Great feedback. Thanks.
Let me provide some comments
1) Requirement1 - taxonomy
I agree that good taxonomy is one of the vital requirements. Albeit, it's not a technology issue, but organization one. What happens across many organizations I saw is is that organization uses existing struture with hundred thousands files in directory and don't want to change it. They use such strcusture last 10 years and strictly agains any changes. They only what to use the latest technology to improve their collaboration and discovery, but not taxonomy.
Utilizing SharePoint for such document management system is not ideal solution
2-3) Requirement 2 and 3 - DOD 5015.2
Yes, SharePoint 2007 is DOD compliant and passed DOD certicifation, but it it doesn't allow to build certified solutions without DOD Resouse Kit, as described in link I provided (2008 year actually).
You need that kit to provide officially certified DOD compliant solution
4) Agree
The reason of such post was gathering information how SharePoint differs from others ECM systems in terms of features support.
Can you provide any information regarding LiveLink, Documentum and others mature ECM spaces, comparing them to SharePoint?
Michael, good points and well noted. We've been providing DMS solutions for nearly 10 years and found tremendous success with our Laserfiche solution, which is DOD certified and addresses points 1,2,3 & 4 with simple and elegant solutions.
MOSS is not a DMS solution, but rather a complimentary resource that can lend itself to very good utility in the DMS world when combined with a good DMS package.
To achieve Orderby and where statment in content query web part
you have two ways :
static way writing query in the the actual webpart xml as follows:
<property name="QueryOverride" type="string"><![CDATA[<OrderBy><FieldRef Name='MomoOrder' Nullable='True' Type='Number' Ascending='True'/></OrderBy> <Where><Eq><FieldRef Name='Project'/><Value Type='LookupMulti'>Nelson</Value></Eq></Where>]]></property>
Dynamic Way, is done by creating class that inherits from sharepoint content query webpart, you override
protected override void CreateChildControls()
{
this.QueryOverride = customQueryOverride;
base.CreateChildControls();
this.QueryOverride = string.Empty;
this.CommonViewFields = string.Empty;
}
public override void ApplyChanges()
base.ApplyChanges();
// LabelValue is the value of the custom label
// that you added while constructing webpart
// to had ordering or filtering value
customQueryOverride= "<OrderBy><FieldRef Name='ListOrder' Nullable='True' Type='Number' Ascending='True'/></OrderBy><Where><Eq><FieldRef Name='Project' /><Value Type='LookupMulti'>" + LabelValue + "</Value></Eq></Where>";
Cheers
Your contract with SharePoint is always, always, always the API (whether through the Object Model or Web Services). It is *not* through the database. Direct queries (even read-only) against the database can quite easily lock up and cause nothing but trouble in a farm. Most operations inside SharePoint (when they eventually hit the db) are done through abstractions and stored procs. I do *not* recommend anyone doing what's proposed here and suggest doing it through the OM instead.
Thank you! UseCache property to False did the trick!
thx for this snippet :)
I hate IE ;)
greets SEO
Some of the comments on looking into the database are a bit harsh! Yes, it might be un-supported, but if you can't understand a simple select statement then maybe you shouldn't be using SharePoint altogether?
Michael, thanks for the tip - I'd recently wondered how you could find this information and now I know! I don't have SP2 installed either to enumallwebs, so this helps me a lot.
Btw - there are 3 values for publishing site - so you don't necessarily know which one exactly has been used.
much appreciated, this proved to be very helpful
I have a similar situation
I need the logged in user to be the user performing the actions and I simply cannot undelegate the System Account, simply because I am checking out a document and as some of us might know when a document gets checked out it is dumped in that users ..My Documents\SharePoint Drafts but now because the Visual Studio Workflow runs with System Account permissions, the .docx document upon checkout goes missing, if someone can locate it for me I would appreciate it, else is there a way to change delegation just-in-time to check with the currently logged user
Thanks :-)
I'm having a similar issue but it's happening on the server side. Server 2008 (not R2) and SharePoint SP2. I can't open the main intranet site from the server that is hosting the site. Interestingly enough, I can open the Central Admin site no problem. I just can't open the main intranet site without getting prompted for a login three times and then it goes to a white screen.
The site is opening fine on any machine other than the actual server hosting the site.
can you open "localhost" site?!
Check the records in hosts and lmhosts files and add localhost alias
I tried to open http://127.0.0.1 and that brings up the login prompt as well. I've also tried adding the "localhost" site to the lmhosts file. It's already configured in the hosts file. I still get the login prompt three times and then the screen goes white. Do you have any other ideas?
Thanks for your help!
@Shelly I had the exact same issue you were facing. Thankfully one of my colleagues knew of the fix:
www.sharepoint-tips.com/.../access-denied-in-win2008-with-custom.html
Thank you Merill! That did the trick! awesome...
Worked perfectly and very simple. Thanks.
David
Hi, I have a similar problem: I'm grouping the documents by a field (month). In anonymous navigation everything works fine (only approved items are shown), but if a contributor is logged and there are unapproved items, they aren't grouped together with the ones having the same month, but another grouping is created!
E.g.:
Doc Lib contains:
Doc 1 Month March Approved
Doc 2 Month March Approved
Doc 3 Month March Published
Doc 4 Month April Approved
Doc 5 Month April Approved
Doc 6 Month April Published
CQWP will show (with grouping field Month):
March
- Doc 1
- Doc 2
April
- Doc 4
- Doc 5
- Doc 3
- Doc 6
Any idea on this weird behaviour?
What's the version of Service Pack installed on SharePoint?! Is it SP2?!
SP1...
SP1 is definitely a reason of your issue, I reckon. SP1 is dated back to fall of 2007, but now is year 2009 - you are on the system without 2 years old updates.
My strongly recommendation is to update to SP2 and then test again. I bet the issue will be fixed.
WOAH! UseCache worked for me too!
Nice bro,
Its helps me a lot
I liked your blog. Definately I would like to see the templates. Can you please send the templates or give some india what all it should contain. Here's my e-mail id myownid3@yahoo.com
I'm going to publishing templates on my www.sharepoint-sandbox.com portal soon
Have you had the experience where a Admin user has already renamed the Sharepoint server, and the proper way to remove it?
Can you please elaborate what you want to remove - Admin user or SharePoint Server?
Thanks for the details. I'm in development but never did documentation due to timelimits. It would be a great help if you can update this page when u update your portal.
RK
What about Autonomy's ECM solutions. How do they compare to MOSS '07. Does sharepoint have any limitations with regard to the number of words it used to index a document, and what is the file size limit to allow a file to be found whilst crawling?
do u know how to dra and drop document library to desktop without using explorer view?
Great tips on doing a SharePoint farm migration. The imminent arrival is exciting but there are logistical issues when upgrading, you addressed some of these here. Have you thought about joining the SharePoint conversation on Facebook? Check it out at http://www.facebook.com/office
Keep up the great posts!
Cheers,
Andy
MSFT Office Outreach Team
I will join. But wonder to hear the logical issues I missed
Thanks for this writeup! It should be helpful to some of our users; I'll be sure to share around.
- Jenny
This is great blog. Can you please email me the more clear picture in the email
Pramod
Increased the picture size
I didn't express myself as well as I could have, I didn't mean to imply that you missed anything. Sorry about that! Thanks again for the great (and thorough) post and for joining on Facebook.
Best,
MSFT Office Outreach