http://www.endusersharepoint.com/STP/ Paul Grenier, Lead Moderator en Sat, 04 Apr 2009 04:13:50 +0000 http://www.endusersharepoint.com/STP/topic/restrict-permissions-of-views#post-5696 Fri, 03 Apr 2009 22:39:28 +0000 laura67 5696@http://www.endusersharepoint.com/STP/ <p>Here's what I do to sort of make my own restricted views:<br /> Create web part pages, one for each view, then put your list on each of these pages, and set up the web part view as your "restricted view" on each.<br /> Then, create a set of links, one to each of these view pages. Restrict the security on each web part page and/or on the links to the web part pages.</p> <p>Laura Rogers<br /> <a href="http://spinsiders.com/laurar" rel="nofollow">http://spinsiders.com/laurar</a> </p> http://www.endusersharepoint.com/STP/topic/security-on-content-types#post-5695 Fri, 03 Apr 2009 22:30:49 +0000 laura67 5695@http://www.endusersharepoint.com/STP/ <p>Read my blog about displaying sharepoint fields by permission level:</p> <p><a href="http://spinsiders.com/laurar/2009/01/23/displaying-sharepoint-fields-by-permission-level/" rel="nofollow">http://spinsiders.com/laurar/2009/01/23/displaying-sharepoint-fields-by-permission-level/</a></p> <p>Laura Rogers </p> http://www.endusersharepoint.com/STP/topic/wiki-page-change-alert#post-5694 Fri, 03 Apr 2009 22:23:00 +0000 laura67 5694@http://www.endusersharepoint.com/STP/ <p>The only thing I've read personally about configuring alerts is a whitepaper by my friend, Brett Lonsdale.</p> <p><a href="http://www.brettlonsdale.com" rel="nofollow">http://www.brettlonsdale.com</a></p> <p>On his site, click on "Modify the Alert Notifications"</p> <p>Laura Rogers<br /> <a href="http://spinsiders.com/laurar" rel="nofollow">http://spinsiders.com/laurar</a> </p> http://www.endusersharepoint.com/STP/topic/default-view#post-5693 Fri, 03 Apr 2009 18:02:17 +0000 laura67 5693@http://www.endusersharepoint.com/STP/ <p>No, I don't know of a way to do this. </p> <p>There's a way around it... the user could customize their own view of the page (or any page), and insert a web part of the list, and then set that web part to display whatever kind of view they'd like.</p> <p>Laura </p> http://www.endusersharepoint.com/STP/topic/cannot-open-mdb-file-from-the-library#post-5692 Fri, 03 Apr 2009 18:00:06 +0000 laura67 5692@http://www.endusersharepoint.com/STP/ <p>Please don't put mdb files in a document library. It's just a very bad practice to put a database inside a database (sharepoint is in sql). If you must, must put it in there, zip it up first. That way, users have to download and extract before opening it on their hard drive.<br /> Instead of using an Access DB, put the stuff in sharepoint instead. For each table that exists in the database, create a list in sharepoint. Then, from Access you can connect to all of those lists as if they're tables. Then, you can still do all of your querying and reports from a DB (out on a network share somewhere), but users can input the table data from sharepoint.<br /> Just a thought.</p> <p>Laura Rogers<br /> <a href="http://spinsiders.com/laurar" rel="nofollow">http://spinsiders.com/laurar</a> </p> http://www.endusersharepoint.com/STP/topic/default-view#post-5691 Fri, 03 Apr 2009 17:12:41 +0000 jlschu1 5691@http://www.endusersharepoint.com/STP/ <p>As a contributor of a list can you select a specific view as your default opposed to the default assigned by the owner? </p> http://www.endusersharepoint.com/STP/topic/opening-a-spreadsheet-in-excel-from-a-cewp#post-5690 Fri, 03 Apr 2009 17:06:58 +0000 Lynley 5690@http://www.endusersharepoint.com/STP/ <p>Yes, Eric, that's what we're trying to do. </p> http://www.endusersharepoint.com/STP/topic/alerts-and-content-approval#post-5689 Fri, 03 Apr 2009 16:58:52 +0000 jlschu1 5689@http://www.endusersharepoint.com/STP/ <p>Since there is not connection to Content Approval and Alert Me - is it possible to hide or disable the "Alert Me" option from the the list? </p> http://www.endusersharepoint.com/STP/topic/global-navigation-bar-1#post-5688 Fri, 03 Apr 2009 16:54:29 +0000 Pelica 5688@http://www.endusersharepoint.com/STP/ <p>All of our bars use the same at the Top Site. Why is it that not everything shows up, even for a site admin? </p> <p>Thanks for your help... sometimes SharePoint can be really confusing. </p> http://www.endusersharepoint.com/STP/topic/email-settings-for-hosted-email#post-5687 Fri, 03 Apr 2009 16:50:59 +0000 remymaza 5687@http://www.endusersharepoint.com/STP/ <p>Did I "Stump the Panel"? This is really one of my last attempts at getting this to work, so if someone knows any possible way to get this done, I'm all ears.</p> <p>Thanks,<br /> Matt </p> http://www.endusersharepoint.com/STP/topic/alerts-and-content-approval#post-5686 Fri, 03 Apr 2009 16:49:37 +0000 bobmcl 5686@http://www.endusersharepoint.com/STP/ <p>I have a similar issue to the original poster and I don't think workflow is going to work for me.</p> <p>I have a blog where I create posts in "Pending" status and then approve them when I want them to "go live". I have a weekly summary alert set up for my end users. The problem is that their weekly summary includes the unapproved "Pending" items. Is there any way to only alert on approved items?</p> <p>Thanks,</p> <p>Bob </p> http://www.endusersharepoint.com/STP/topic/global-navigation-bar-1#post-5685 Fri, 03 Apr 2009 16:28:21 +0000 eric 5685@http://www.endusersharepoint.com/STP/ <p>I believe this is inherant behaviour when the publishing features are turned on to modify navigational items. When subsites are created below a top level site and added to the top link navigation, they are appropriately security trimmed as you would expect.</p> <p>When items are manually added to the top nav they are treated as a normal hyperlink when built through the modify navigation controls. This is why audiencing is available so you can tailor who should see what. </p> <p>Manually created navigational controls do not inherit from my experience so it would need to be created on the top level site as well. </p> http://www.endusersharepoint.com/STP/topic/add-a-button-to-a-page#post-5684 Fri, 03 Apr 2009 16:13:09 +0000 eric 5684@http://www.endusersharepoint.com/STP/ <p>Correct. It isn't using a content type, in the Training Site template, it's just a standard custom list. </p> http://www.endusersharepoint.com/STP/topic/explorer-view-up-functionality#post-5683 Fri, 03 Apr 2009 16:08:05 +0000 eric 5683@http://www.endusersharepoint.com/STP/ <p>The up a directory functionality is in the Other Places box on the left. Clicking on the folder takes you up, but yes, it is a bit confusing and should be added in some fashion. </p> http://www.endusersharepoint.com/STP/topic/calculated-column-doesnt-display-in-lookup#post-5682 Fri, 03 Apr 2009 16:02:44 +0000 cpoteet 5682@http://www.endusersharepoint.com/STP/ <p>Thanks Dessie. I guess this is another hidden SharePoint 'feature'. </p> http://www.endusersharepoint.com/STP/topic/jquery-open-link-in-new-window-for-view-using-groupings#post-5681 Fri, 03 Apr 2009 16:02:23 +0000 AutoSponge 5681@http://www.endusersharepoint.com/STP/ <p>I have written some articles that will help with this. One should come out in a day or two that uses AOP. However, the brute force method is to rewrite the SharePoint function that renders the new HTML from an expanded group like this:</p> <p>'function ExpGroupRenderData(htmlToRender, groupName, isLoaded) {<br /> $("#tbod"+groupName+"_").attr("isloaded",isLoaded)<br /> .html(htmlToRender)<br /> .show("fast",___callback___);'</p> <p>where callback is a call to your custom function. </p> <p>If you look at some of my code examples, I use that to call something like initPreview(group) so I can pass the groupName from ExpGroupRenderData into my function.</p> <p>'function initPreview(group){<br /> if (!group){group = "#MSO_ContentTable";}<br /> $(group+" a[href*='DispForm.aspx']").bindPreview();<br /> ...<br /> '</p> <p>When I run the init function, I don't put a group, and it defaults to the main content area. When the new version of the SP function runs it:</p> <p>'.show("fast",initPreview("#tbod"+groupName+"_"));'</p> <p>I pass the group so I can select the group by ID.</p> <p>I hope that helps. Like I said, if you're still stuck, my new AOP article should make it as simple as this can get. </p> http://www.endusersharepoint.com/STP/topic/calling-a-centrally-located-jquery-master-from-all-pages#post-5680 Fri, 03 Apr 2009 15:57:19 +0000 AutoSponge 5680@http://www.endusersharepoint.com/STP/ <p>27Palms,</p> <p>There's that method and there's also Christophe's method. See here: <a href="http://www.google.com/url?sa=U&#38;start=4&#38;q=http://pathtosharepoint.wordpress.com/2009/02/15/a-content-editor-web-part-for-every-home/&#38;ei=EmrWSbqqL8TMlQfrzNzcDA&#38;usg=AFQjCNEvlosM2xPOAu0mHcZrcyIbRjVHXQ" rel="nofollow">http://www.google.com/url?sa=U&#38;start=4&#38;q=http://pathtosharepoint.wordpress.com/2009/02/15/a-content-editor-web-part-for-every-home/&#38;ei=EmrWSbqqL8TMlQfrzNzcDA&#38;usg=AFQjCNEvlosM2xPOAu0mHcZrcyIbRjVHXQ</a> </p> http://www.endusersharepoint.com/STP/topic/add-a-button-to-a-page#post-5679 Fri, 03 Apr 2009 15:56:56 +0000 AutoSponge 5679@http://www.endusersharepoint.com/STP/ <p>Eric,</p> <p>You want to create a link that does the Export this Item functionality? I assume the list is using the Event content type (or a child thereof)? </p> http://www.endusersharepoint.com/STP/topic/embedding-ajaxphp-page-into-a-page-viewer-web-part#post-5678 Fri, 03 Apr 2009 15:53:53 +0000 AutoSponge 5678@http://www.endusersharepoint.com/STP/ <p>Is your SharePoint site on the same domain? If not, you may find that you have to create a compact privacy policy on the PHP server. That tells the browser it's ok to run certain scripts from the iframe window. By default, IE usually blocks a lot of script from an iframe to prevent XSS attacks. </p> http://www.endusersharepoint.com/STP/topic/explorer-view-up-functionality#post-5677 Fri, 03 Apr 2009 15:38:38 +0000 paltomonte 5677@http://www.endusersharepoint.com/STP/ <p>Hi - Is anyone else frustrated by Explorer View in SharePoint not having the Up icon or menu item? It would be great if someone has a way to make that appear or to provide a way to go up one level in a folder hierarchy.</p> <p>thanks<br /> Paul </p> http://www.endusersharepoint.com/STP/topic/global-navigation-bar-1#post-5675 Fri, 03 Apr 2009 14:56:03 +0000 Pelica 5675@http://www.endusersharepoint.com/STP/ <p>When I add a link to the top global navigation bar, it lets everyone see it on the tabs, even if they do not have access to it. Why aren't LINKS security-stripped on the top nav bar?</p> <p>I've used Audiencing to limit who can see it, but have had problems with that, too. For example, I have an internal project site that I've added a link to inside our "Projects" tab. Everyone can see it, but only a few have permission to access it. I went in and added the sharepoint groups in the Audiencing section, but now the link disappears for me (I am Site Collection Admin [scary, huh]). I went in and added my name directly to the SharePoint security group and I can see the link on the tab while I am on the internal project page, but if I go back to our top-level site, the link on the tab does not appear.</p> <p>Why? </p> http://www.endusersharepoint.com/STP/topic/opening-a-spreadsheet-in-excel-from-a-cewp#post-5674 Fri, 03 Apr 2009 12:18:52 +0000 eric 5674@http://www.endusersharepoint.com/STP/ <p>Are you just creating a hyperlink in the CEWP to link to the spreadsheet? </p> http://www.endusersharepoint.com/STP/topic/edit-datasheet-view-read-only#post-5673 Fri, 03 Apr 2009 12:12:13 +0000 jlschu1 5673@http://www.endusersharepoint.com/STP/ <p>Hello Everyone! I have a custom list that was imported from access and I am trying to edit in datasheet view and the view states it is a "Read Only" view and it will not let me make any edits. I have checked the permissions and I have full rights. Is there a setting that needs to be enabled? </p> http://www.endusersharepoint.com/STP/topic/opening-a-spreadsheet-in-excel-from-a-cewp#post-5672 Fri, 03 Apr 2009 11:39:52 +0000 Lynley 5672@http://www.endusersharepoint.com/STP/ <p>Thanks, Mark! This works great for opening the document from the Doc Library itself, but it doesn't seem to work if you're opening a link to the document from a Content Editor Web part (which happens to be in a totally separate site collection). The Doc Library is set to open in the client application, but the link to the document still opens in the Web browser. </p> <p>The only thing we've found is some VBscript that can do it, but it's very messy.</p> <p>Any ideas?</p> <p>Thank you so much! </p> http://www.endusersharepoint.com/STP/topic/restrict-permissions-of-views#post-5671 Fri, 03 Apr 2009 11:33:58 +0000 eric 5671@http://www.endusersharepoint.com/STP/ <p>It's under NDA at the moment. </p> http://www.endusersharepoint.com/STP/topic/alerts-and-content-approval#post-5670 Fri, 03 Apr 2009 11:33:14 +0000 eric 5670@http://www.endusersharepoint.com/STP/ <p>The workflow will send an email to the approvers sharepoint group to take action. </p> http://www.endusersharepoint.com/STP/topic/powerpoint-and-video-file-linking#post-5669 Fri, 03 Apr 2009 11:29:45 +0000 eric 5669@http://www.endusersharepoint.com/STP/ <p>There is a nice slide library to hold the PPT files as templates. I would then set up a video library with a meta data field linking to the PPT title as the applicable template.</p> <p>This way the user selects the video (and downloads a copy I presume). Once they have the video, they click the link to go to the appropriate PPT library file and download a copy. Then they can merge the PPT and video for their purposes.</p> <p>I may be over simplifying your process. </p> http://www.endusersharepoint.com/STP/topic/using-a-data-view-to-link-external-data-with-an-sp-list#post-5668 Fri, 03 Apr 2009 11:27:29 +0000 cupdike 5668@http://www.endusersharepoint.com/STP/ <p>A business system has a table with project info in it and I'd like to set up supplemental columns in an SP list, and then use a Data View to produce a combined view. The idea is to not have to push the data around, but rather just link to it. The part I'm not sure about is how to handle the lifecycle of the rows of supplemental items. I'd like to have it so that if a row of project info has no corresponding item of supplemental info, the user can create that item (link from the data view?) and the item will be linked to that external row. And if a row of project info is deleted, it doesn't show anything in the data view (even if the row of supplemental info still exists). I'm imagine that between workflow and web services, it can be done (not that I know how). But if it starts to have too many moving parts, maybe a data synchronization would be best. Does anyone have any ideas for doing the lifecycle in a clean way? Thanks, Clark </p> http://www.endusersharepoint.com/STP/topic/embedding-ajaxphp-page-into-a-page-viewer-web-part#post-5667 Fri, 03 Apr 2009 11:24:28 +0000 patrick.abel 5667@http://www.endusersharepoint.com/STP/ <p>P.S. jQuery is also present in order to make the fields style based on "inactive" or "active" selection. This is also what enables me to add notes in the entry boxes and have them disappear upon selection.</p> <p>Any help would be great! I hate this feeling of constantly dancing around Sharepoint's limitations. </p> http://www.endusersharepoint.com/STP/topic/embedding-ajaxphp-page-into-a-page-viewer-web-part#post-5666 Fri, 03 Apr 2009 11:21:49 +0000 patrick.abel 5666@http://www.endusersharepoint.com/STP/ <p>Hey guys,</p> <p>I have had quite alot of problems trying to figure out how to create effective form solutions for WSS 3.0. I have learned how to use workflows tied to lists, but getting some of the features of validation, redirect upon submission, and easy editing have led me away from what sharepoint has to offer.</p> <p>I have created a AJAX form that is driven by PHP you can see at:</p> <p><a href="http://spaceclub-hsv.org/contact_form/Copy%20of%20contact.html" rel="nofollow">http://spaceclub-hsv.org/contact_form/Copy%20of%20contact.html</a></p> <p>It validates on a field by field basis and reports errors and completion with AJAX without a need for a page refresh. My problem is that, when I try and tie this website into a Page Viewer web-part, it doesn't know how to handle it. I was under the impression that the Page Viewer web-part was merely a "viewer" and all the interaction was still taking place on the host site, but this may not be the case with using AJAX. Is there a solution for this? Thanks</p> <p>Patrick </p> http://www.endusersharepoint.com/STP/topic/calculated-column-doesnt-display-in-lookup#post-5665 Fri, 03 Apr 2009 10:58:54 +0000 Dessie Lunsford 5665@http://www.endusersharepoint.com/STP/ <p>Chris, from what I remember when playing around with this idea awhile back, lookups will only see columns that contain text values. Dates, Numbers, even Multi-line text fields all wouldn't show as an available column to choose. If using a calculated column in the source list, it must also have a return type of "Single line of text" in order to be seen from the lookup as well.</p> <p>- Dessie </p> http://www.endusersharepoint.com/STP/topic/calculated-column-doesnt-display-in-lookup#post-5664 Fri, 03 Apr 2009 10:37:14 +0000 cpoteet 5664@http://www.endusersharepoint.com/STP/ <p>Well all be that does work. I can add the text lookup but I can't see the numerical columns in there. I want if it's because it's a number and not text? </p> http://www.endusersharepoint.com/STP/topic/alerts-and-content-approval#post-5663 Fri, 03 Apr 2009 10:36:11 +0000 jlschu1 5663@http://www.endusersharepoint.com/STP/ <p>I dont see an option in the SP approval workflow to send out an alert to others when a new approved item is added. We are reviewing Nintex Workflows for additional workflow options. </p> http://www.endusersharepoint.com/STP/topic/restrict-permissions-of-views#post-5662 Fri, 03 Apr 2009 10:33:59 +0000 jlschu1 5662@http://www.endusersharepoint.com/STP/ <p>Thanks for the emails! I didnt think you could, but I wanted to check with the experts. Do you know when v14 will be announcing its upgrades or new enhancements? </p> http://www.endusersharepoint.com/STP/topic/powerpoint-and-video-file-linking#post-5661 Fri, 03 Apr 2009 10:31:24 +0000 paltomonte 5661@http://www.endusersharepoint.com/STP/ <p>Hello,</p> <p>I have a set of users who are not the most tech savy and prefer everything to be as simple as possible (almost goes without saying, yes?). Another group produces marketing presentations in PPT and links in video files (usually two in a ppt doc). </p> <p>The PPT docs are ultimately used off-site so they need to be downloaded, along with the videos, to the sales person's laptop. Before SP, each PPT file and its related videos were stored in their own folder. The salesperson would simply copy that folder to their desktop and they were good to go. Trying to avoid the folder structure in SharePoint, I can not find a way to make it obvious what video files need to be downloaded with each PPT file. To make it a little more complicated, a few of the video files are shared across most of the PPT's, so ideally we would only have one copy of them rather than having duplicates for each PPT. </p> <p>Any ideas on how to structure the library, meta data, or workflow to make it obvious which video files need to be downloaded along with a PPT file? Or do I just give in a use libraries and duplicate copies of the videos?</p> <p>thanks in advance,<br /> Paul </p>