Messages In This Digest (16 Messages)
- 1a.
- Gaining Importance From Sharepoint Web Parts From: aegisisclinks
- 1b.
- Re: Gaining Importance From Sharepoint Web Parts From: Peter Brunone
- 1c.
- Re: Gaining Importance From Sharepoint Web Parts From: onewisegeek
- 2a.
- Mass Edit to a Single Column of Library using SQL From: ShaneS
- 2b.
- Re: Mass Edit to a Single Column of Library using SQL From: Peter Brunone
- 2c.
- Re: Mass Edit to a Single Column of Library using SQL From: Paul Stork
- 2d.
- Re: Mass Edit to a Single Column of Library using SQL From: Tara Santmire
- 2e.
- Re: Mass Edit to a Single Column of Library using SQL From: Sander
- 2f.
- Re: Mass Edit to a Single Column of Library using SQL From: Paul Stork
- 2g.
- Re: Mass Edit to a Single Column of Library using SQL From: Daniel A. Galant
- 2h.
- Re: Mass Edit to a Single Column of Library using SQL From: Sander
- 2i.
- Re: Mass Edit to a Single Column of Library using SQL From: Sander
- 2j.
- Re: Mass Edit to a Single Column of Library using SQL From: Daniel A. Galant
- 3.
- Usage and Health Data Collection Proxy and Web Analytics Issue--sp20 From: hmspiegs
- 4.
- Re: Gaining Importance From SharePoint Web Parts From: Todd Bleeker
- 5a.
- Re: Need help with Managed Path From: Kevin Lai
Messages
- 1a.
-
Gaining Importance From Sharepoint Web Parts
Posted by: "aegisisclinks" aegisisclinks@yahoo.com aegisisclinks
Fri Jan 6, 2012 8:20 am (PST)
SharePoint is gaining importance these days with the various advantages
that it is able to give to the business. One of the main components of
the SharePoint Business Intelligence
<http://www.aegisisc.com/sharepoint- > is SharePoint wedevelopers. html
parts, which are very useful for those who are involved with the
SharePoint Business Intelligence tools. The web parts that are normally
available in the server are default SharePoint web parts. There are
five types of web parts. These web parts have a lot of advantages like
* There is no need for coding when there are web parts
* The web parts are very general
* The web parts are re usable and can be used for different
SharePoint business intelligence tools
* Master detail applications can be written without any coding
because of web parts
* It is possible to customize because of the SharePoint web parts
* Now that we know the advantages let us see what each web part
offers in detail.
* This business data list web part will show the list of the instance
that is registered with the Business data catalog. Say for example one
need it's of the executable orders of the organization you can get it
easily gets it with the help of the business data list web part.
* The Business data Item web part will show details of the
instances of the entity from applications of the business. For example
if you need more details about a particular order instead of just the
list then you need to get it with the help of this part.
* With the help of Business Data Related List web part one can see
instances which are related to the business application. For example to
know all the transactions done by a particular customer this web part
can be used to get the needed details.
* The Business Data Actions SharePoint web parts
<http://www.aegisisc.com/sharepoint- > shows whatcustom-web- parts.html
all actions that can be performed by the users who are using the
portal. Say for instance a customer entity will be able to perform
actions like send mails to the customers, edit their mailing information
etc.
* Business Data Item Builder web part will be able to create the data
item having in mind a variety of parameters and will provide to the
other web parts important SharePoint business intelligence information.
[Non-text portions of this message have been removed]
- 1b.
-
Re: Gaining Importance From Sharepoint Web Parts
Posted by: "Peter Brunone" peter.brunone@gmail.com peter_brunone
Fri Jan 6, 2012 8:23 am (PST)
Is anyone moderating this list?
On Fri, Jan 6, 2012 at 4:20 AM, aegisisclinks <aegisisclinks@yahoo.com >wrote:
> SharePoint is gaining importance these days with the various advantages
> that it is able to give to the business. One of the main components of
> the SharePoint Business Intelligence
> <http://www.aegisisc.com/sharepoint- > is SharePoint wedevelopers. html
> parts, which are very useful for those who are involved with the
> SharePoint Business Intelligence tools. The web parts that are normally
> available in the server are default SharePoint web parts. There are
> five types of web parts. These web parts have a lot of advantages like
> * There is no need for coding when there are web parts
> * The web parts are very general
> * The web parts are re usable and can be used for different
> SharePoint business intelligence tools
> * Master detail applications can be written without any coding
> because of web parts
> * It is possible to customize because of the SharePoint web parts
> * Now that we know the advantages let us see what each web part
> offers in detail.
> * This business data list web part will show the list of the instance
> that is registered with the Business data catalog. Say for example one
> need it's of the executable orders of the organization you can get it
> easily gets it with the help of the business data list web part.
> * The Business data Item web part will show details of the
> instances of the entity from applications of the business. For example
> if you need more details about a particular order instead of just the
> list then you need to get it with the help of this part.
> * With the help of Business Data Related List web part one can see
> instances which are related to the business application. For example to
> know all the transactions done by a particular customer this web part
> can be used to get the needed details.
> * The Business Data Actions SharePoint web parts
> <http://www.aegisisc.com/sharepoint- > shows whatcustom-web- parts.html
> all actions that can be performed by the users who are using the
> portal. Say for instance a customer entity will be able to perform
> actions like send mails to the customers, edit their mailing information
> etc.
> * Business Data Item Builder web part will be able to create the data
> item having in mind a variety of parameters and will provide to the
> other web parts important SharePoint business intelligence information.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> --------------------- --------- ------
>
> Yahoo! Groups Links
>
>
>
>
[Non-text portions of this message have been removed]
- 1c.
-
Re: Gaining Importance From Sharepoint Web Parts
Posted by: "onewisegeek" 1wisegeek@gmail.com onewisegeek
Fri Jan 6, 2012 11:43 am (PST)
You got have bravado advertising a product/company with a free email service
- 2a.
-
Mass Edit to a Single Column of Library using SQL
Posted by: "ShaneS" sstenhjem@midstateelectric.coop sstenhjem
Fri Jan 6, 2012 8:20 am (PST)
I am wondering if anyone has found an easy way to use SQL and SharePoint together. I want to create a selection of documents in a SP library that meet certain criteria in the "Modified Date", then change all of the information in the "Approved Date" column that I created using one script in SQL. I know if this were an Access DB I could make thousands of edits in a matter of minutes, but as of now I can't seem to get into SP using SQL. If there is another way of doing mass edits in SP I would like to hear people's ideas.
Thanks,
Shane Stenhjem
Midstate Electric Cooperative
IT Tech/GIS Tech
- 2b.
-
Re: Mass Edit to a Single Column of Library using SQL
Posted by: "Peter Brunone" peter.brunone@gmail.com peter_brunone
Fri Jan 6, 2012 8:22 am (PST)
Which version of SharePoint? You might consider using LINQ (I think
there's a codeplex project for 2007).
http://msdn.microsoft. com/en-us/ library/ee535491 .aspx
On Fri, Jan 6, 2012 at 10:19 AM, ShaneS <sstenhjem@midstateelectric.coop >wrote:
> I am wondering if anyone has found an easy way to use SQL and SharePoint
> together. I want to create a selection of documents in a SP library that
> meet certain criteria in the "Modified Date", then change all of the
> information in the "Approved Date" column that I created using one script
> in SQL. I know if this were an Access DB I could make thousands of edits in
> a matter of minutes, but as of now I can't seem to get into SP using SQL.
> If there is another way of doing mass edits in SP I would like to hear
> people's ideas.
>
> Thanks,
> Shane Stenhjem
> Midstate Electric Cooperative
> IT Tech/GIS Tech
>
>
>
> --------------------- --------- ------
>
> Yahoo! Groups Links
>
>
>
>
[Non-text portions of this message have been removed]
- 2c.
-
Re: Mass Edit to a Single Column of Library using SQL
Posted by: "Paul Stork" pstork@att.net pstorkoh
Fri Jan 6, 2012 9:22 am (PST)
Making editing changes directly to the SharePoint content databases is very
dangerous and unsupported. Creating your own databases in the same SQL
instance is possible (although I don't recommend it), but you should never
make changes in SQL to SharePoint databases. Doing so voids your warranty
with Microsoft and usually leads to trouble in the long run. It will
definitely break any chance you have to update to the next version and will
probably cause errors the next time you apply a service pack or cumulative
update. In short, "Don't go there".
Paul Papanek Stork
Chief Architect . ShareSquared, Inc. . <http://www.sharesquared.com/ >
http://www.ShareSquared.com
The SharePoint Solution Experts!
<https://mvp.support.microsof t.com/profile= 6D05CC8D- 32ED-4626- A29E-142DC7A68
0E0> SharePoint MVP, MBA, MCT, MCSE+I, MCSA, MCSD, MCDBA, MCITP, MCPD
<mailto:Paul.Stork@ShareSquared.com > Paul.Stork@ShareSquared.com .
800.445.1279 x404
blog: <http://dontpapanic.com/blog > http://dontpapanic.com/blog . twitter:
<http://twitter.com/pstork > @pstork
From: sharepointdiscussions@yahoogroups. com
[mailto:sharepointdiscussions@yahoogroups. ] On Behalf Of ShaneScom
Sent: Friday, January 06, 2012 11:19 AM
To: sharepointdiscussions@yahoogroups. com
Subject: [sharepointdiscussions] Mass Edit to a Single Column of Library
using SQL
I am wondering if anyone has found an easy way to use SQL and SharePoint
together. I want to create a selection of documents in a SP library that
meet certain criteria in the "Modified Date", then change all of the
information in the "Approved Date" column that I created using one script in
SQL. I know if this were an Access DB I could make thousands of edits in a
matter of minutes, but as of now I can't seem to get into SP using SQL. If
there is another way of doing mass edits in SP I would like to hear people's
ideas.
Thanks,
Shane Stenhjem
Midstate Electric Cooperative
IT Tech/GIS Tech
[Non-text portions of this message have been removed]
- 2d.
-
Re: Mass Edit to a Single Column of Library using SQL
Posted by: "Tara Santmire" tara@maresreach.net tsantmire
Fri Jan 6, 2012 11:45 am (PST)
You could probably do this pretty simply using the datasheet view.
If we were doing this in my team, we would probably use a .Net/C# solution.
Regards,
Tara
From: sharepointdiscussions@yahoogroups. com
[mailto:sharepointdiscussions@yahoogroups. ] On Behalf Of Paul Storkcom
Sent: Friday, January 06, 2012 12:22 PM
To: sharepointdiscussions@yahoogroups. com
Subject: RE: [sharepointdiscussions] Mass Edit to a Single Column of Library
using SQL
Making editing changes directly to the SharePoint content databases is very
dangerous and unsupported. Creating your own databases in the same SQL
instance is possible (although I don't recommend it), but you should never
make changes in SQL to SharePoint databases. Doing so voids your warranty
with Microsoft and usually leads to trouble in the long run. It will
definitely break any chance you have to update to the next version and will
probably cause errors the next time you apply a service pack or cumulative
update. In short, "Don't go there".
Paul Papanek Stork
Chief Architect . ShareSquared, Inc. . <http://www.sharesquared.com/ >
http://www.ShareSquared.com
The SharePoint Solution Experts!
<https://mvp.support.microsof t.com/profile= 6D05CC8D- 32ED-4626- A29E-142DC7A68
0E0> SharePoint MVP, MBA, MCT, MCSE+I, MCSA, MCSD, MCDBA, MCITP, MCPD
<mailto:Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSqu ared.com> >
Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSqu ared.com> .
800.445.1279 x404
blog: <http://dontpapanic.com/blog > http://dontpapanic.com/blog . twitter:
<http://twitter.com/pstork > @pstork
From: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
[mailto:sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com> ] On Behalf Of ShaneS
Sent: Friday, January 06, 2012 11:19 AM
To: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
Subject: [sharepointdiscussions] Mass Edit to a Single Column of Library
using SQL
I am wondering if anyone has found an easy way to use SQL and SharePoint
together. I want to create a selection of documents in a SP library that
meet certain criteria in the "Modified Date", then change all of the
information in the "Approved Date" column that I created using one script in
SQL. I know if this were an Access DB I could make thousands of edits in a
matter of minutes, but as of now I can't seem to get into SP using SQL. If
there is another way of doing mass edits in SP I would like to hear people's
ideas.
Thanks,
Shane Stenhjem
Midstate Electric Cooperative
IT Tech/GIS Tech
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
- 2e.
-
Re: Mass Edit to a Single Column of Library using SQL
Posted by: "Sander" tillebuorren@zonnet.nl saaffy
Fri Jan 6, 2012 1:12 pm (PST)
Very dangerous? Swimming in a bay full of sharks is very dangerous. I have
made numerous modifications to the alluserdata table. Please make sure you
understand exactly what you are doing (whatch for duplicate rows/deleted
rows). Backup your database before you try anything. Save the backup for
some days so you'd be sure you have a recover scenario. Make sure you know
which rows are to be updated. Do every update/delete in a transaction and if
possible out of office hours. Use the with nolock hint
Here is the link to the unsupported story:
http://support.microsoft. Did you ever try to getcom/kb/841057/ en-us.
support? I have, many times and none were very pleasant.
So if you have budget/c# knowledge, build a nice console app that loops
through the right splistitems and alter the metadata. If you have only SQL
knowledge/little time, do as I do and tell no-one ;-)
Sander
From: sharepointdiscussions@yahoogroups. com
[mailto:sharepointdiscussions@yahoogroups. ] On Behalf Of Tara Santmirecom
Sent: vrijdag 6 januari 2012 18:31
To: sharepointdiscussions@yahoogroups. com
Subject: RE: [sharepointdiscussions] Mass Edit to a Single Column of Library
using SQL
You could probably do this pretty simply using the datasheet view.
If we were doing this in my team, we would probably use a .Net/C# solution.
Regards,
Tara
From: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
[mailto:sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com> ] On Behalf Of Paul Stork
Sent: Friday, January 06, 2012 12:22 PM
To: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
Subject: RE: [sharepointdiscussions] Mass Edit to a Single Column of Library
using SQL
Making editing changes directly to the SharePoint content databases is very
dangerous and unsupported. Creating your own databases in the same SQL
instance is possible (although I don't recommend it), but you should never
make changes in SQL to SharePoint databases. Doing so voids your warranty
with Microsoft and usually leads to trouble in the long run. It will
definitely break any chance you have to update to the next version and will
probably cause errors the next time you apply a service pack or cumulative
update. In short, "Don't go there".
Paul Papanek Stork
Chief Architect . ShareSquared, Inc. . <http://www.sharesquared.com/ >
http://www.ShareSquared.com
The SharePoint Solution Experts!
<https://mvp.support.microsof t.com/profile= 6D05CC8D- 32ED-4626- A29E-142DC7A68
0E0> SharePoint MVP, MBA, MCT, MCSE+I, MCSA, MCSD, MCDBA, MCITP, MCPD
<mailto:Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSqu ared.com>
<mailto:Paul.Stork%40ShareSqu ared.com> >
Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSqu ared.com>
<mailto:Paul.Stork%40ShareSqu ared.com> .
800.445.1279 x404
blog: <http://dontpapanic.com/blog > http://dontpapanic.com/blog . twitter:
<http://twitter.com/pstork > @pstork
From: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
[mailto:sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com> ] On Behalf Of ShaneS
Sent: Friday, January 06, 2012 11:19 AM
To: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
Subject: [sharepointdiscussions] Mass Edit to a Single Column of Library
using SQL
I am wondering if anyone has found an easy way to use SQL and SharePoint
together. I want to create a selection of documents in a SP library that
meet certain criteria in the "Modified Date", then change all of the
information in the "Approved Date" column that I created using one script in
SQL. I know if this were an Access DB I could make thousands of edits in a
matter of minutes, but as of now I can't seem to get into SP using SQL. If
there is another way of doing mass edits in SP I would like to hear people's
ideas.
Thanks,
Shane Stenhjem
Midstate Electric Cooperative
IT Tech/GIS Tech
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
- 2f.
-
Re: Mass Edit to a Single Column of Library using SQL
Posted by: "Paul Stork" pstork@att.net pstorkoh
Fri Jan 6, 2012 1:47 pm (PST)
In this case its worse than dangerous, its Russian roulette. He's not just
talking about editing record values. He's talking about making a direct
change to the Schema of the database. ".the "Approved Date" column that I
created using one script in SQL." You might get away with editing some
records in the database if you know exactly what you are doing. But making
changes to the schema will eventually make it impossible to patch or upgrade
your system. That's more than just dangerous and should NEVER be attempted.
BTW the link you provided is broken. Here's a working one.
http://support.microsoft. com/kb/841057
Paul Papanek Stork
Chief Architect . ShareSquared, Inc. . <http://www.sharesquared.com/ >
http://www.ShareSquared.com
The SharePoint Solution Experts!
<https://mvp.support.microsof t.com/profile= 6D05CC8D- 32ED-4626- A29E-142DC7A68
0E0> SharePoint MVP, MBA, MCT, MCSE+I, MCSA, MCSD, MCDBA, MCITP, MCPD
<mailto:Paul.Stork@ShareSquared.com > Paul.Stork@ShareSquared.com .
800.445.1279 x404
blog: <http://dontpapanic.com/blog > http://dontpapanic.com/blog . twitter:
<http://twitter.com/pstork > @pstork
From: sharepointdiscussions@yahoogroups. com
[mailto:sharepointdiscussions@yahoogroups. ] On Behalf Of Sandercom
Sent: Friday, January 06, 2012 4:12 PM
To: sharepointdiscussions@yahoogroups. com
Subject: RE: [sharepointdiscussions] Mass Edit to a Single Column of Library
using SQL
Very dangerous? Swimming in a bay full of sharks is very dangerous. I have
made numerous modifications to the alluserdata table. Please make sure you
understand exactly what you are doing (whatch for duplicate rows/deleted
rows). Backup your database before you try anything. Save the backup for
some days so you'd be sure you have a recover scenario. Make sure you know
which rows are to be updated. Do every update/delete in a transaction and if
possible out of office hours. Use the with nolock hint
Here is the link to the unsupported story:
http://support.microsoft. Did you ever try to getcom/kb/841057/ en-us.
support? I have, many times and none were very pleasant.
So if you have budget/c# knowledge, build a nice console app that loops
through the right splistitems and alter the metadata. If you have only SQL
knowledge/little time, do as I do and tell no-one ;-)
Sander
From: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
[mailto:sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com> ] On Behalf Of Tara
Santmire
Sent: vrijdag 6 januari 2012 18:31
To: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
Subject: RE: [sharepointdiscussions] Mass Edit to a Single Column of Library
using SQL
You could probably do this pretty simply using the datasheet view.
If we were doing this in my team, we would probably use a .Net/C# solution.
Regards,
Tara
From: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
[mailto:sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com> ] On Behalf Of Paul Stork
Sent: Friday, January 06, 2012 12:22 PM
To: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
Subject: RE: [sharepointdiscussions] Mass Edit to a Single Column of Library
using SQL
Making editing changes directly to the SharePoint content databases is very
dangerous and unsupported. Creating your own databases in the same SQL
instance is possible (although I don't recommend it), but you should never
make changes in SQL to SharePoint databases. Doing so voids your warranty
with Microsoft and usually leads to trouble in the long run. It will
definitely break any chance you have to update to the next version and will
probably cause errors the next time you apply a service pack or cumulative
update. In short, "Don't go there".
Paul Papanek Stork
Chief Architect . ShareSquared, Inc. . <http://www.sharesquared.com/ >
http://www.ShareSquared.com
The SharePoint Solution Experts!
<https://mvp.support.microsof t.com/profile= 6D05CC8D- 32ED-4626- A29E-142DC7A68
0E0> SharePoint MVP, MBA, MCT, MCSE+I, MCSA, MCSD, MCDBA, MCITP, MCPD
<mailto:Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSqu ared.com>
<mailto:Paul.Stork%40ShareSqu ared.com>
<mailto:Paul.Stork%40ShareSqu ared.com> >
Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSqu ared.com>
<mailto:Paul.Stork%40ShareSqu ared.com>
<mailto:Paul.Stork%40ShareSqu ared.com> .
800.445.1279 x404
blog: <http://dontpapanic.com/blog > http://dontpapanic.com/blog . twitter:
<http://twitter.com/pstork > @pstork
From: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
[mailto:sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com> ] On Behalf Of ShaneS
Sent: Friday, January 06, 2012 11:19 AM
To: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
Subject: [sharepointdiscussions] Mass Edit to a Single Column of Library
using SQL
I am wondering if anyone has found an easy way to use SQL and SharePoint
together. I want to create a selection of documents in a SP library that
meet certain criteria in the "Modified Date", then change all of the
information in the "Approved Date" column that I created using one script in
SQL. I know if this were an Access DB I could make thousands of edits in a
matter of minutes, but as of now I can't seem to get into SP using SQL. If
there is another way of doing mass edits in SP I would like to hear people's
ideas.
Thanks,
Shane Stenhjem
Midstate Electric Cooperative
IT Tech/GIS Tech
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
- 2g.
-
Re: Mass Edit to a Single Column of Library using SQL
Posted by: "Daniel A. Galant" daniel@netdesignit.com figment16@att.net
Fri Jan 6, 2012 2:03 pm (PST)
Sander,
All I can say is that I'm glad you're not on my SharePoint team.
Daniel A. Galant
Sent from my iPhone
(636)448-3240
On Jan 6, 2012, at 4:12 PM, "Sander" <tillebuorren@zonnet.nl > wrote:
> Very dangerous? Swimming in a bay full of sharks is very dangerous. I have
> made numerous modifications to the alluserdata table. Please make sure you
> understand exactly what you are doing (whatch for duplicate rows/deleted
> rows). Backup your database before you try anything. Save the backup for
> some days so you'd be sure you have a recover scenario. Make sure you know
> which rows are to be updated. Do every update/delete in a transaction and if
> possible out of office hours. Use the with nolock hint
>
> Here is the link to the unsupported story:
> http://support.microsoft. Did you ever try to getcom/kb/841057/ en-us.
> support? I have, many times and none were very pleasant.
>
> So if you have budget/c# knowledge, build a nice console app that loops
> through the right splistitems and alter the metadata. If you have only SQL
> knowledge/little time, do as I do and tell no-one ;-)
>
> Sander
>
> From: sharepointdiscussions@yahoogroups. com
> [mailto:sharepointdiscussions@yahoogroups. ] On Behalf Of Tara Santmirecom
> Sent: vrijdag 6 januari 2012 18:31
> To: sharepointdiscussions@yahoogroups. com
> Subject: RE: [sharepointdiscussions] Mass Edit to a Single Column of Library
> using SQL
>
> You could probably do this pretty simply using the datasheet view.
>
> If we were doing this in my team, we would probably use a .Net/C# solution.
>
> Regards,
>
> Tara
>
> From: sharepointdiscussions@yahoogroups. com
> <mailto:sharepointdiscussions% 40yahoogroups. com>
> [mailto:sharepointdiscussions@yahoogroups. com
> <mailto:sharepointdiscussions% 40yahoogroups. com> ] On Behalf Of Paul Stork
> Sent: Friday, January 06, 2012 12:22 PM
> To: sharepointdiscussions@yahoogroups. com
> <mailto:sharepointdiscussions% 40yahoogroups. com>
> Subject: RE: [sharepointdiscussions] Mass Edit to a Single Column of Library
> using SQL
>
> Making editing changes directly to the SharePoint content databases is very
> dangerous and unsupported. Creating your own databases in the same SQL
> instance is possible (although I don't recommend it), but you should never
> make changes in SQL to SharePoint databases. Doing so voids your warranty
> with Microsoft and usually leads to trouble in the long run. It will
> definitely break any chance you have to update to the next version and will
> probably cause errors the next time you apply a service pack or cumulative
> update. In short, "Don't go there".
>
> Paul Papanek Stork
>
> Chief Architect . ShareSquared, Inc. . <http://www.sharesquared.com/ >
> http://www.ShareSquared.com
>
> The SharePoint Solution Experts!
>
> <https://mvp.support.microsof t.com/profile= 6D05CC8D- 32ED-4626- A29E-142DC7A68
> 0E0> SharePoint MVP, MBA, MCT, MCSE+I, MCSA, MCSD, MCDBA, MCITP, MCPD
>
> <mailto:Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSqu ared.com>
> <mailto:Paul.Stork%40ShareSqu ared.com> >
> Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSqu ared.com>
> <mailto:Paul.Stork%40ShareSqu ared.com> .
> 800.445.1279 x404
>
> blog: <http://dontpapanic.com/blog > http://dontpapanic.com/blog . twitter:
> <http://twitter.com/pstork > @pstork
>
> From: sharepointdiscussions@yahoogroups. com
> <mailto:sharepointdiscussions% 40yahoogroups. com>
> <mailto:sharepointdiscussions% 40yahoogroups. com>
> [mailto:sharepointdiscussions@yahoogroups. com
> <mailto:sharepointdiscussions% 40yahoogroups. com>
> <mailto:sharepointdiscussions% 40yahoogroups. com> ] On Behalf Of ShaneS
> Sent: Friday, January 06, 2012 11:19 AM
> To: sharepointdiscussions@yahoogroups. com
> <mailto:sharepointdiscussions% 40yahoogroups. com>
> <mailto:sharepointdiscussions% 40yahoogroups. com>
> Subject: [sharepointdiscussions] Mass Edit to a Single Column of Library
> using SQL
>
> I am wondering if anyone has found an easy way to use SQL and SharePoint
> together. I want to create a selection of documents in a SP library that
> meet certain criteria in the "Modified Date", then change all of the
> information in the "Approved Date" column that I created using one script in
> SQL. I know if this were an Access DB I could make thousands of edits in a
> matter of minutes, but as of now I can't seem to get into SP using SQL. If
> there is another way of doing mass edits in SP I would like to hear people's
> ideas.
>
> Thanks,
> Shane Stenhjem
> Midstate Electric Cooperative
> IT Tech/GIS Tech
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
[Non-text portions of this message have been removed]
- 2h.
-
Re: Mass Edit to a Single Column of Library using SQL
Posted by: "Sander" tillebuorren@zonnet.nl saaffy
Fri Jan 6, 2012 2:13 pm (PST)
I do indeed agree changing schema is definitely a no-go; but I interpreted
Shane's wish to be able to edit values in a column based on values in
another column. His mail is a bit difficult to read.
Sorry for the broken link; thanx for fixing.
Sander
From: sharepointdiscussions@yahoogroups. com
[mailto:sharepointdiscussions@yahoogroups. ] On Behalf Of Paul Storkcom
Sent: vrijdag 6 januari 2012 22:47
To: sharepointdiscussions@yahoogroups. com
Subject: RE: [sharepointdiscussions] Mass Edit to a Single Column of Library
using SQL
In this case its worse than dangerous, its Russian roulette. He's not just
talking about editing record values. He's talking about making a direct
change to the Schema of the database. ".the "Approved Date" column that I
created using one script in SQL." You might get away with editing some
records in the database if you know exactly what you are doing. But making
changes to the schema will eventually make it impossible to patch or upgrade
your system. That's more than just dangerous and should NEVER be attempted.
BTW the link you provided is broken. Here's a working one.
http://support.microsoft. com/kb/841057
Paul Papanek Stork
Chief Architect . ShareSquared, Inc. . <http://www.sharesquared.com/ >
http://www.ShareSquared.com
The SharePoint Solution Experts!
<https://mvp.support.microsof t.com/profile= 6D05CC8D- 32ED-4626- A29E-142DC7A68
0E0> SharePoint MVP, MBA, MCT, MCSE+I, MCSA, MCSD, MCDBA, MCITP, MCPD
<mailto:Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSqu ared.com> >
Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSqu ared.com> .
800.445.1279 x404
blog: <http://dontpapanic.com/blog > http://dontpapanic.com/blog . twitter:
<http://twitter.com/pstork > @pstork
From: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
[mailto:sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com> ] On Behalf Of Sander
Sent: Friday, January 06, 2012 4:12 PM
To: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
Subject: RE: [sharepointdiscussions] Mass Edit to a Single Column of Library
using SQL
Very dangerous? Swimming in a bay full of sharks is very dangerous. I have
made numerous modifications to the alluserdata table. Please make sure you
understand exactly what you are doing (whatch for duplicate rows/deleted
rows). Backup your database before you try anything. Save the backup for
some days so you'd be sure you have a recover scenario. Make sure you know
which rows are to be updated. Do every update/delete in a transaction and if
possible out of office hours. Use the with nolock hint
Here is the link to the unsupported story:
http://support.microsoft. Did you ever try to getcom/kb/841057/ en-us.
support? I have, many times and none were very pleasant.
So if you have budget/c# knowledge, build a nice console app that loops
through the right splistitems and alter the metadata. If you have only SQL
knowledge/little time, do as I do and tell no-one ;-)
Sander
From: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
[mailto:sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com> ] On Behalf Of Tara
Santmire
Sent: vrijdag 6 januari 2012 18:31
To: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
Subject: RE: [sharepointdiscussions] Mass Edit to a Single Column of Library
using SQL
You could probably do this pretty simply using the datasheet view.
If we were doing this in my team, we would probably use a .Net/C# solution.
Regards,
Tara
From: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
[mailto:sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com> ] On Behalf Of Paul Stork
Sent: Friday, January 06, 2012 12:22 PM
To: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
Subject: RE: [sharepointdiscussions] Mass Edit to a Single Column of Library
using SQL
Making editing changes directly to the SharePoint content databases is very
dangerous and unsupported. Creating your own databases in the same SQL
instance is possible (although I don't recommend it), but you should never
make changes in SQL to SharePoint databases. Doing so voids your warranty
with Microsoft and usually leads to trouble in the long run. It will
definitely break any chance you have to update to the next version and will
probably cause errors the next time you apply a service pack or cumulative
update. In short, "Don't go there".
Paul Papanek Stork
Chief Architect . ShareSquared, Inc. . <http://www.sharesquared.com/ >
http://www.ShareSquared.com
The SharePoint Solution Experts!
<https://mvp.support.microsof t.com/profile= 6D05CC8D- 32ED-4626- A29E-142DC7A68
0E0> SharePoint MVP, MBA, MCT, MCSE+I, MCSA, MCSD, MCDBA, MCITP, MCPD
<mailto:Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSqu ared.com>
<mailto:Paul.Stork%40ShareSqu ared.com>
<mailto:Paul.Stork%40ShareSqu ared.com>
<mailto:Paul.Stork%40ShareSqu ared.com> >
Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSqu ared.com>
<mailto:Paul.Stork%40ShareSqu ared.com>
<mailto:Paul.Stork%40ShareSqu ared.com>
<mailto:Paul.Stork%40ShareSqu ared.com> .
800.445.1279 x404
blog: <http://dontpapanic.com/blog > http://dontpapanic.com/blog . twitter:
<http://twitter.com/pstork > @pstork
From: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
[mailto:sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com> ] On Behalf Of ShaneS
Sent: Friday, January 06, 2012 11:19 AM
To: sharepointdiscussions@yahoogroups. com
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
<mailto:sharepointdiscussions% 40yahoogroups. com>
Subject: [sharepointdiscussions] Mass Edit to a Single Column of Library
using SQL
I am wondering if anyone has found an easy way to use SQL and SharePoint
together. I want to create a selection of documents in a SP library that
meet certain criteria in the "Modified Date", then change all of the
information in the "Approved Date" column that I created using one script in
SQL. I know if this were an Access DB I could make thousands of edits in a
matter of minutes, but as of now I can't seem to get into SP using SQL. If
there is another way of doing mass edits in SP I would like to hear people's
ideas.
Thanks,
Shane Stenhjem
Midstate Electric Cooperative
IT Tech/GIS Tech
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
- 2i.
-
Re: Mass Edit to a Single Column of Library using SQL
Posted by: "Sander" tillebuorren@zonnet.nl saaffy
Fri Jan 6, 2012 2:15 pm (PST)
Ok thanx for this well argumented response.
From: sharepointdiscussions@yahoogroups. [mailto:sharepointdiscussiocom ns@yahoogroups. ] On Behalf Of Daniel A. Galantcom
Sent: vrijdag 6 januari 2012 23:04
To: sharepointdiscussions@yahoogroups. com
Subject: Re: [sharepointdiscussions] Mass Edit to a Single Column of Library using SQL
Sander,
All I can say is that I'm glad you're not on my SharePoint team.
Daniel A. Galant
Sent from my iPhone
(636)448-3240
On Jan 6, 2012, at 4:12 PM, "Sander" <tillebuorren@zonnet.nl <mailto:tillebuorren%40zonnet. nl> > wrote:
> Very dangerous? Swimming in a bay full of sharks is very dangerous. I have
> made numerous modifications to the alluserdata table. Please make sure you
> understand exactly what you are doing (whatch for duplicate rows/deleted
> rows). Backup your database before you try anything. Save the backup for
> some days so you'd be sure you have a recover scenario. Make sure you know
> which rows are to be updated. Do every update/delete in a transaction and if
> possible out of office hours. Use the with nolock hint
>
> Here is the link to the unsupported story:
> http://support.microsoft. Did you ever try to getcom/kb/841057/ en-us.
> support? I have, many times and none were very pleasant.
>
> So if you have budget/c# knowledge, build a nice console app that loops
> through the right splistitems and alter the metadata. If you have only SQL
> knowledge/little time, do as I do and tell no-one ;-)
>
> Sander
>
> From: sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com>
> [mailto:sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com> ] On Behalf Of Tara Santmire
> Sent: vrijdag 6 januari 2012 18:31
> To: sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com>
> Subject: RE: [sharepointdiscussions] Mass Edit to a Single Column of Library
> using SQL
>
> You could probably do this pretty simply using the datasheet view.
>
> If we were doing this in my team, we would probably use a .Net/C# solution.
>
> Regards,
>
> Tara
>
> From: sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com>
> <mailto:sharepointdiscussions% 40yahoogroups. com>
> [mailto:sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com>
> <mailto:sharepointdiscussions% 40yahoogroups. com> ] On Behalf Of Paul Stork
> Sent: Friday, January 06, 2012 12:22 PM
> To: sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com>
> <mailto:sharepointdiscussions% 40yahoogroups. com>
> Subject: RE: [sharepointdiscussions] Mass Edit to a Single Column of Library
> using SQL
>
> Making editing changes directly to the SharePoint content databases is very
> dangerous and unsupported. Creating your own databases in the same SQL
> instance is possible (although I don't recommend it), but you should never
> make changes in SQL to SharePoint databases. Doing so voids your warranty
> with Microsoft and usually leads to trouble in the long run. It will
> definitely break any chance you have to update to the next version and will
> probably cause errors the next time you apply a service pack or cumulative
> update. In short, "Don't go there".
>
> Paul Papanek Stork
>
> Chief Architect . ShareSquared, Inc. . <http://www.sharesquared.com/ >
> http://www.ShareSquared.com
>
> The SharePoint Solution Experts!
>
> <https://mvp.support.microsof t.com/profile= 6D05CC8D- 32ED-4626- A29E-142DC7A68
> 0E0> SharePoint MVP, MBA, MCT, MCSE+I, MCSA, MCSD, MCDBA, MCITP, MCPD
>
> <mailto:Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSqu ared.com> <mailto:Paul. Stork%40ShareSqu ared.com>
> <mailto:Paul.Stork%40ShareSqu ared.com> >
> Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSqu ared.com> <mailto:Paul. Stork%40ShareSqu ared.com>
> <mailto:Paul.Stork%40ShareSqu ared.com> .
> 800.445.1279 x404
>
> blog: <http://dontpapanic.com/blog > http://dontpapanic.com/blog . twitter:
> <http://twitter.com/pstork > @pstork
>
> From: sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com>
> <mailto:sharepointdiscussions% 40yahoogroups. com>
> <mailto:sharepointdiscussions% 40yahoogroups. com>
> [mailto:sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com>
> <mailto:sharepointdiscussions% 40yahoogroups. com>
> <mailto:sharepointdiscussions% 40yahoogroups. com> ] On Behalf Of ShaneS
> Sent: Friday, January 06, 2012 11:19 AM
> To: sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com>
> <mailto:sharepointdiscussions% 40yahoogroups. com>
> <mailto:sharepointdiscussions% 40yahoogroups. com>
> Subject: [sharepointdiscussions] Mass Edit to a Single Column of Library
> using SQL
>
> I am wondering if anyone has found an easy way to use SQL and SharePoint
> together. I want to create a selection of documents in a SP library that
> meet certain criteria in the "Modified Date", then change all of the
> information in the "Approved Date" column that I created using one script in
> SQL. I know if this were an Access DB I could make thousands of edits in a
> matter of minutes, but as of now I can't seem to get into SP using SQL. If
> there is another way of doing mass edits in SP I would like to hear people's
> ideas.
>
> Thanks,
> Shane Stenhjem
> Midstate Electric Cooperative
> IT Tech/GIS Tech
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
- 2j.
-
Re: Mass Edit to a Single Column of Library using SQL
Posted by: "Daniel A. Galant" daniel@netdesignit.com figment16@att.net
Fri Jan 6, 2012 3:23 pm (PST)
I wasn't arguing. Simply stating my opinion based upon your comments. "I've made numerous changes", "do as I do and tell no-one" and such, yes. I would not want someone like that working on a SharePoint deployment I had anything to do with. But then I believe in following the rules and not going places I shouldn't.
Daniel A. Galant
Sent from my iPhone
(636)448-3240
On Jan 6, 2012, at 5:15 PM, "Sander" <tillebuorren@zonnet.nl > wrote:
> Ok thanx for this well argumented response.
>
> From: sharepointdiscussions@yahoogroups. [mailto:sharepointdiscussiocom ns@yahoogroups. ] On Behalf Of Daniel A. Galantcom
> Sent: vrijdag 6 januari 2012 23:04
> To: sharepointdiscussions@yahoogroups. com
> Subject: Re: [sharepointdiscussions] Mass Edit to a Single Column of Library using SQL
>
> Sander,
>
> All I can say is that I'm glad you're not on my SharePoint team.
>
> Daniel A. Galant
> Sent from my iPhone
> (636)448-3240
>
> On Jan 6, 2012, at 4:12 PM, "Sander" <tillebuorren@zonnet.nl <mailto:tillebuorren%40zonnet. nl> > wrote:
>
> > Very dangerous? Swimming in a bay full of sharks is very dangerous. I have
> > made numerous modifications to the alluserdata table. Please make sure you
> > understand exactly what you are doing (whatch for duplicate rows/deleted
> > rows). Backup your database before you try anything. Save the backup for
> > some days so you'd be sure you have a recover scenario. Make sure you know
> > which rows are to be updated. Do every update/delete in a transaction and if
> > possible out of office hours. Use the with nolock hint
> >
> > Here is the link to the unsupported story:
> > http://support.microsoft. Did you ever try to getcom/kb/841057/ en-us.
> > support? I have, many times and none were very pleasant.
> >
> > So if you have budget/c# knowledge, build a nice console app that loops
> > through the right splistitems and alter the metadata. If you have only SQL
> > knowledge/little time, do as I do and tell no-one ;-)
> >
> > Sander
> >
> > From: sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com>
> > [mailto:sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com> ] On Behalf Of Tara Santmire
> > Sent: vrijdag 6 januari 2012 18:31
> > To: sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com>
> > Subject: RE: [sharepointdiscussions] Mass Edit to a Single Column of Library
> > using SQL
> >
> > You could probably do this pretty simply using the datasheet view.
> >
> > If we were doing this in my team, we would probably use a .Net/C# solution.
> >
> > Regards,
> >
> > Tara
> >
> > From: sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com>
> > <mailto:sharepointdiscussions% 40yahoogroups. com>
> > [mailto:sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com>
> > <mailto:sharepointdiscussions% 40yahoogroups. com> ] On Behalf Of Paul Stork
> > Sent: Friday, January 06, 2012 12:22 PM
> > To: sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com>
> > <mailto:sharepointdiscussions% 40yahoogroups. com>
> > Subject: RE: [sharepointdiscussions] Mass Edit to a Single Column of Library
> > using SQL
> >
> > Making editing changes directly to the SharePoint content databases is very
> > dangerous and unsupported. Creating your own databases in the same SQL
> > instance is possible (although I don't recommend it), but you should never
> > make changes in SQL to SharePoint databases. Doing so voids your warranty
> > with Microsoft and usually leads to trouble in the long run. It will
> > definitely break any chance you have to update to the next version and will
> > probably cause errors the next time you apply a service pack or cumulative
> > update. In short, "Don't go there".
> >
> > Paul Papanek Stork
> >
> > Chief Architect . ShareSquared, Inc. . <http://www.sharesquared.com/ >
> > http://www.ShareSquared.com
> >
> > The SharePoint Solution Experts!
> >
> > <https://mvp.support.microsof t.com/profile= 6D05CC8D- 32ED-4626- A29E-142DC7A68
> > 0E0> SharePoint MVP, MBA, MCT, MCSE+I, MCSA, MCSD, MCDBA, MCITP, MCPD
> >
> > <mailto:Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSqu ared.com> <mailto:Paul. Stork%40ShareSqu ared.com>
> > <mailto:Paul.Stork%40ShareSqu ared.com> >
> > Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSqu ared.com> <mailto:Paul. Stork%40ShareSqu ared.com>
> > <mailto:Paul.Stork%40ShareSqu ared.com> .
> > 800.445.1279 x404
> >
> > blog: <http://dontpapanic.com/blog > http://dontpapanic.com/blog . twitter:
> > <http://twitter.com/pstork > @pstork
> >
> > From: sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com>
> > <mailto:sharepointdiscussions% 40yahoogroups. com>
> > <mailto:sharepointdiscussions% 40yahoogroups. com>
> > [mailto:sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com>
> > <mailto:sharepointdiscussions% 40yahoogroups. com>
> > <mailto:sharepointdiscussions% 40yahoogroups. com> ] On Behalf Of ShaneS
> > Sent: Friday, January 06, 2012 11:19 AM
> > To: sharepointdiscussions@yahoogroups. <mailto:sharepointdcom iscussions% 40yahoogroups. com>
> > <mailto:sharepointdiscussions% 40yahoogroups. com>
> > <mailto:sharepointdiscussions% 40yahoogroups. com>
> > Subject: [sharepointdiscussions] Mass Edit to a Single Column of Library
> > using SQL
> >
> > I am wondering if anyone has found an easy way to use SQL and SharePoint
> > together. I want to create a selection of documents in a SP library that
> > meet certain criteria in the "Modified Date", then change all of the
> > information in the "Approved Date" column that I created using one script in
> > SQL. I know if this were an Access DB I could make thousands of edits in a
> > matter of minutes, but as of now I can't seem to get into SP using SQL. If
> > there is another way of doing mass edits in SP I would like to hear people's
> > ideas.
> >
> > Thanks,
> > Shane Stenhjem
> > Midstate Electric Cooperative
> > IT Tech/GIS Tech
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> >
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
[Non-text portions of this message have been removed]
- 3.
-
Usage and Health Data Collection Proxy and Web Analytics Issue--sp20
Posted by: "hmspiegs" hspiegelman@askcts.com hmspiegs
Fri Jan 6, 2012 10:18 am (PST)
Hello all and Happy New Year,
I have a question regarding the SPUsageService (the usage and health logging service).
I have been running the web analytics service app for several days and didn't see any results when attempting to view web analytics reports.
I saw a blog post that explained that the Usage and Health Data Collection service had to be running and of course isn't by default.
http://sharepointreporter.wordpress is the post I followed to start the service(s)..com/2010/ 12/08/sharepoint -2010-usage- and-health- data-collection- service-applicat ion/
I got the service running and I am starting to get data in some of the analytics reports..
Now..the real issue.
When the SPUsage service is set to log, it seems to spike CPU on the web servers…these servers have 8 cpus per web server.
The web analytics services have been running long before that so I am wondering if the usage service is "catching up" with the amount of data needing to be logged and analyzed by the web analytics services.
Does that sound right? Am I completely off?
- 4.
-
Re: Gaining Importance From SharePoint Web Parts
Posted by: "Todd Bleeker" tbleeker@mindsharp.com tbleeker
Fri Jan 6, 2012 1:18 pm (PST)
Yes. We try to moderate the list. People must go thru a process by which they are initially moderated. However, after a number of respectable posts we allow them to post unhindered.
This account has been removed.
<Todd />
-----Original Message-----
From: sharepointdiscussions@yahoogroups. [mailto:sharepointdiscussiocom ns@yahoogroups. ] On Behalf Of Peter Brunonecom
Sent: Friday, January 06, 2012 10:23 AM
To: sharepointdiscussions@yahoogroups. com
Subject: Re: [sharepointdiscussions] Gaining Importance From Sharepoint Web Parts
Is anyone moderating this list?
On Fri, Jan 6, 2012 at 4:20 AM, aegisisclinks wrote:
> SharePoint is gaining importance these days with the various
> advantages that it is able to give to the business. One of the main
> components of the SharePoint Business Intelligence
<snip>
- 5a.
-
Re: Need help with Managed Path
Posted by: "Kevin Lai" kclai66@yahoo.com kclai66
Fri Jan 6, 2012 2:48 pm (PST)
FYI: The problem is resolved. The culprit was an incorrect web.config
Thanks those who help!
Kevin
_____________________ _________ __
From: Kevin Lai <kclai66@yahoo.com >
To: "sharepointdiscussions@yahoogroups. " <sharepointdiscussiocom ns@yahoogroups. >com
Sent: Thursday, January 5, 2012 10:40 AM
Subject: Re: [sharepointdiscussions] Need help with Managed Path
Thanks Paul!
I removed the Managed Path from the Central Adminstration, and refresh the web site from the IIS.
One super simple html file test1.htm was created with this content
<html>
Test1
</html>
Then in this URL https://mysite/virtualpath/ nothing shows up. (Note that it I try a non-existence path such as mysite/none, HTTP 404 is shown - this somehow proves that "virtualpath" was indeed available). Right-click to View Source, I saw:test1.htm,
<!DOCTYPEHTML PUBLIC "-//W3C//DTD
HTML 4.0 Transitional//EN">
<HTML><HEAD>
<METAcontent="text/html; charset=windows- 1252" http-equiv=Content- Type></HEAD>
<BODY></BODY></HTML>
Looks like generated code, not the above simple htm file I typed.
Any idea?
Thank you very much!
Kevin
_____________________ _________ __
From: Paul Stork <pstork@att.net>
To: sharepointdiscussions@yahoogroups. com
Sent: Thursday, January 5, 2012 9:47 AM
Subject: RE: [sharepointdiscussions] Need help with Managed Path
Just skip step 5 and it should work. The blog mentions that creating a Wildcard EXCLUSION Managed path was required in SharePoint 2003 but is no longer needed in 2007. You wouldn̢۪t use a Wildcard inclusion managed path in either version for this.
Paul Papanek Stork
Chief Architect ̢ۢ ShareSquared, Inc. ̢ۢ <http://www.sharesquared.com/ > http://www.ShareSquared.com
The SharePoint Solution Experts!
<https://mvp.support.microsof > SharePoint MVP, MBA, MCT, MCSE+I, MCSA, MCSD, MCDBA, MCITP, MCPDt.com/profile= 6D05CC8D- 32ED-4626- A29E-142DC7A680E 0
<mailto:Paul.Stork@ShareSquared.com > Paul.Stork@ShareSquared.com ̢ۢ 800.445.1279 x404
blog: <http://dontpapanic.com/blog > http://dontpapanic.com/blog ̢ۢ twitter: <http://twitter.com/pstork > @pstork
From: sharepointdiscussions@yahoogroups. [mailto:sharepointdiscussiocom ns@yahoogroups. ] On Behalf Of Kevin Laicom
Sent: Thursday, January 05, 2012 10:57 AM
To: sharepointdiscussions@yahoogroups. com
Subject: [sharepointdiscussions] Need help with Managed Path
Hello SharePoint experts,
I was trying to setup a virtual directory to our MOSS site
but ran into difficulties.
1. From the IIS Manager, I created a virtual
directory name “virtualpathâ€, linked to the physical path: “C:\inetpub\wwwroot\wss\VirtualDirec tories\80\ virtualpathâ€.
2. As suggested by the post http://www.knowsharepoint.com/ 2007/08/exclude- managed-path. html,
I added “Network Service†with read & execute permission.
3. I added read and execute permission to the
folder as well for “Network Serviceâ€.
4. I copied a very simple index.htm to the directory
5. In Central Administration page, I added “virtualpathâ€
as a wildcard inclusion Managed Path.
6. When I try the URL https://mysite/virtualpath/ index.htm,
nothing shows up.
Are the above procedures right? What have I missed?
Thank you for your help!
Kevin
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
No comments:
Post a Comment