echef - All Comments

Gadgetty.co.uk: For gadgets, technology and cyber-ramblings » Blog Archive » Connecting to SQL EE

Tue, 30 Sep 2008 11:40:38 GMT

Pingback from Gadgetty.co.uk: For gadgets, technology and cyber-ramblings » Blog Archive » Connecting to SQL EE

re: Pre-populating Form Fields for a New Item

spykew — Mon, 04 Aug 2008 17:43:10 GMT

Thanks, it worked :)

In the mean time I found on this post a script to get the element that we want to populate: blogs.msdn.com/.../using-javascript-to-manipulate-a-list-form-field.aspx

Cheers,

Roger

Posted on SharePoint Blogs

re: Pre-populating Form Fields for a New Item

josef.nielsen — Mon, 04 Aug 2008 17:14:40 GMT

The only way to get it is to view source on the form page you want to add the script to, ie newform.aspx... You will not find it in SharePoint Designer, as it is internal to the webpart. Look for the INPUT tag with the correct "Title", and grab the "id" value from that tag.

Posted on SharePoint Blogs

re: Pre-populating Form Fields for a New Item

spykew — Mon, 04 Aug 2008 16:52:57 GMT

Hi,

How do you get the id for that specific field?

Thanks, it is a very usefull script

Posted on SharePoint Blogs

re: Those dang System Screens...

josef.nielsen — Tue, 22 Jul 2008 13:35:56 GMT

As these are system (Application) pages, I do not think you can make this accessible. Even if you made a custom copy of the page and were able to set permissions so a non-site admin could access it, they would require site admin permissions to actually change settings for the Search Keywords. As I understand it, this page makes changes to meta-data for the Site Collection, which is available for user access to read, but requires site-admin access to write. Best thing to hope for would be to write a Web Service and associated system (Application) page in layouts to set this programatically using the web app identity... but be careful with that kind of access :)

Posted on SharePoint Blogs

re: Those dang System Screens...

Jacob Egholm — Tue, 22 Jul 2008 10:53:01 GMT

Do you know if it is possible for a user, which is not a Site Collection Administrator, to access "Search Keywords" admin page?

Maybe by creating a new Permission Level or......

Posted on SharePoint Blogs

re: Excel Calculation Services (ECS) Invalid Handle error

Tom — Sat, 19 Jul 2008 15:23:35 GMT

Even after adding the Network Service, (Local) Administrators, and Everyone groups to the blasted folder at the "Full Control" level, and doing an IISRESET afterwards, it still would not work for me. I had to go Napoleon on it and apply that not just to the folder, but make all the contents inherit the bloody permissions.

In the Security tab of the folder's Properties:

Click Advanced

Click the Owner tab

Ensure the current owner says Administrators, if not, click it in the "Change owner to" box

Check the checkbox that says "Replace owner on subcontainers and objects"

Hit Apply

Click the Permissions tab

Add the Everyone group (if you haven't already) by using the Add button, type Everyone, and click OK

Highlight the Everyone group and click Edit

Ensure "Allow" is checked for all the boxes and click OK

Check the box that says "Replace permission entries on all child objects with entries shown here that apply to child objects"

Click Apply, then Yes on the warning to continue

Click OK

Then click Apply & OK on the MachineKeys Properties window.

This all did the trick for me. :-)

-Tom

Posted on SharePoint Blogs

re: Excel Calculation Services (ECS) Invalid Handle error

Tom — Sat, 19 Jul 2008 15:03:37 GMT

Didn't work for me, though I had the same error. Had an Event ID of 6482 and plenty of "System.Security.Cryptography.CryptographicException: The handle is invalid." kind of messages in the logs. I would have thought your fix would've done it, but apparently there's a little bit more to my issues than yours. Even an IISRESET after changing the ACL didn't work to let me start the service.

Posted on SharePoint Blogs

re: Good bye Hard Drives... Hello ioDrive!

Gregory A Anderson — Mon, 14 Jul 2008 23:59:05 GMT

I build quad processor Servers using this technology.

It will become the life blood of the next Generation computer soon.

My servers start at 15,000, never had one returned!

Posted on SharePoint Blogs

re: Pulling site collections details via direct SQL query

Maxime Fortier — Mon, 16 Jun 2008 14:49:10 GMT

Posted on SharePoint Blogs

re: Scripting the "Connect to Outlook" function

josef.nielsen — Thu, 12 Jun 2008 12:38:07 GMT

Connect to Outlook is a client-side menu option. The javascript in init.js is a client side look-up to see if you support that function. If you do not, it does not appear.

The restrictions for "Connect to Outlook" (to my knowledge) are you must be using a supported list type (Doc Lib, Tasks, Calendar, Contacts), you must be using IE (v.6-8), and you must have the MS SharePoint Services Support Components loaded in your Office install. SharePoint Services Support Components are a part of the Office Suite, and are installed by default (look under Office Tools in your setup).

Posted on SharePoint Blogs

re: Scripting the "Connect to Outlook" function

Gary — Thu, 12 Jun 2008 02:29:44 GMT

Hey I am configuring Sharepoint 2007 and in my site too I do not see the Actions\Connect to Outlook

... can u explain me how I can add this feature

thanks

Posted on SharePoint Blogs

Links (6/8/2008) « Steve Pietrek - Everything SharePoint

Links (6/8/2008) « Steve Pietrek - Everything SharePoint — Mon, 09 Jun 2008 00:06:41 GMT

Pingback from Links (6/8/2008) « Steve Pietrek - Everything SharePoint

Posted on SharePoint Blogs

re: Background on My SharePoint Links

josef.nielsen — Tue, 27 May 2008 16:40:46 GMT

Are you sure that the sites do not exist, vs. just being broken sites? Check the site collections list in Central admin to see if they really exist. Problems during site provisioning, or with master pages or the landing page can cause non-SharePoint erros that look like non-existing sites.

Posted on SharePoint Blogs

re: Background on My SharePoint Links

Nico — Thu, 22 May 2008 21:03:15 GMT

Hi, I have the same problem... and also I have a few links in My Links and the target of those links are delete sites.

How can I delete those broken links?

Great post.

Posted on SharePoint Blogs

excell calendar

excell calendar — Thu, 08 May 2008 23:16:51 GMT

Pingback from excell calendar

Posted on SharePoint Blogs

re: Scripting the "Connect to Outlook" function

josef.nielsen — Fri, 02 May 2008 14:52:47 GMT

If you are not getting the "Connect to Outlook" option on that particular list, it is probably because that list is not a child of a support type. A "task-like" list that is a custom list configured for specific purposes will not be able to connect to Outlook, as the required fields may be missing or labeled incorrectly. The only way around this is to either rewire the template to a standard list type, or to use workflows to push content from and to a standard list (which is definately a work around)...

Posted on SharePoint Blogs

re: Scripting the "Connect to Outlook" function

Nick — Tue, 22 Apr 2008 03:58:17 GMT

Hi, With this material I was able to track down the fact why a site template I use is not working. It does not have the 'connect to outlook' option under 'actions'. I got the template from the microsoft 40 template download. The template is 'change request management'. If I install a 'tasks' list the in the source I found the component:

<ie:menuitem id="zz18_OfflineButton" type="option" iconSrc="/_layouts/images/MenuPIM.gif" iconScript="BLOCKED SCRIPTofflineBtnImg" onMenuClick="BLOCKED SCRIPTExportHailStorm('tasks','http:\u002f\u002fessix\u002flpi\u002feplan','{5fd2a1eb-50a2-412d-884a-087da812bf60}','EPlan','Tasks','\u002flpi\u002feplan\u002fLists\u002fTasks','','\u002flpi\u002feplan\u002fLists\u002fTasks');" hidden="!offlineBtnText" textScript="BLOCKED SCRIPTofflineBtnText" description="Synchronize items and make them available offline." menuGroupId="400"></ie:menuitem>

In the site template, in the tasks section, this line does not appear. I am assuming this is why i don't get the 'connect to outlook option'. Now I am stuck.

Posted on SharePoint Blogs

wmi

wmi — Fri, 18 Apr 2008 02:57:06 GMT

Pingback from wmi

Posted on SharePoint Blogs

re: SQL 2005 Embedded Edition... What the heck is that?

manish — Fri, 11 Apr 2008 10:28:37 GMT

i dont know why Microsoft releases such versions but people like you save us from this mess..thanks alot.....great work

Posted on SharePoint Blogs

re: Pulling site collections details via direct SQL query

josef.nielsen — Mon, 17 Mar 2008 15:04:16 GMT

Danny, I left out that line (using the -- for comments) because it was unnecessary... I should have actually deleted it from the script. It is unnecessary, as it is the JOIN criteria for the "User" table in the lines above, so is already in effect.

As to Site Collections missing... Hmmm... Do you house your Content DB's on more than one server? If so, you ust make a linked server object (with credentials) for that server prior to executing this script, or the server will not be connected to.

Posted on SharePoint Blogs

re: Pulling site collections details via direct SQL query

Danny — Fri, 14 Mar 2008 23:55:04 GMT

Hello Josef,

Thank you for the script! I tried and it works

1) However - I am puzzed why some site collection are missing. For example /sites/ADS_xxx, /sites/DBS*

2) Why did you omitted this line

"AND [User].[tp_SiteID] = [Sites].[Id]" ?

[ConfigObjects].[Id]

WHERE

[Webs].[ParentWebId] IS NULL

--AND [User].[tp_SiteID] = [Sites].[Id]

AND [User].[tp_SiteAdmin] = 1

AND [User].[tp_id] = 1'

EXEC (@DBv1)

Posted on SharePoint Blogs

re: Getting Search Crawl Details from the DB

josef.nielsen — Tue, 11 Mar 2008 13:39:32 GMT

This should retrieve crawl times for all search content sources, including external URLs and Fileshares. I don't currently have any fileshares crawled, so I'm not sure how they will show up... When I get a chance I'll throw a few in and see how they record in the crawl history...

Posted on SharePoint Blogs

re: Getting Search Crawl Details from the DB

Mike — Fri, 07 Mar 2008 19:01:43 GMT

This is great, any ideas about how to get the file share crawl times?

Posted on SharePoint Blogs

re: MS-SPC2008 - Day 3

Rob Roach — Thu, 06 Mar 2008 23:20:02 GMT

Thanks so much!!! I could not attend the conference and am trying to follow along via blogs and other resources. This post was perhaps the best recap of a day I have read!

Posted on SharePoint Blogs