Saturday, January 7, 2012

[beasiswa] [BUTUH INFO] Beasiswa Penerbangan

 

Halo teman-teman semua,

Nama saya Krisma, sedang kuliah tingkat 2 di Universitas Indonesia Fakultas Psikologi. Rencananya setelah lulus S1 saya ingin sekali dapat sekolah penerbangan. Untuk itu apakah teman-teman punya info tentang beasiswa untuk sekolah penerbangan di dalam/luar negeri?

Mohon pencerahannya dan terimakasih.

__._,_.___
Recent Activity:
INFO, TIPS BEASISWA, FAQ - ADS:
http://id-scholarships.blogspot.com/

===============================

INFO LOWONGAN DI BIDANG MIGAS:
http://www.lowongan-kerja.info/lowongan/oil-jobs/

===============================

INGIN KELUAR DARI MILIS BEASISWA?
Kirim email kosong ke beasiswa-unsubscribe@yahoogroups.com
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___
Posted by at No comments:

[beasiswa] [butuh info]beasiswa postgraduate/ s2 bidang islamic finance

 

assalamualaikum, saya seorang mahasiwa s1 smt 3 ekonomi syariah di universitas airlangga, pengen banget suatu saat bisa ikut scholarship postgraduate/ s2 di bidang islamic finance atau islamic marketing atau yg berbau syariah-syariah di negara manapun.hehehe.. buat para sesepuh dan pencari beasiswa skalian, adakah di antara temen2 yang tau info beasiswa tersebut..mohon pencerahanya y, pengen prepare dari sekarang ttng apa2 yg diperlukan.
terimakasih,wassalamualaikum ;)

__._,_.___
Recent Activity:
INFO, TIPS BEASISWA, FAQ - ADS:
http://id-scholarships.blogspot.com/

===============================

INFO LOWONGAN DI BIDANG MIGAS:
http://www.lowongan-kerja.info/lowongan/oil-jobs/

===============================

INGIN KELUAR DARI MILIS BEASISWA?
Kirim email kosong ke beasiswa-unsubscribe@yahoogroups.com
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___
Posted by at No comments:

[sintesa-resourcing] Kapal Pesiar Direct User Walk In Interview Event

 

Dear all,

 

We cordially Invite you to our event. With details attach on this email attachment for your review and

a short introduction of our Cruise Ship Principal AIDA Cruises for your information.

 

 

  

AIDA Cruises is the leading German cruise operator and one of the leading cruise lines in Europe. With currently 8 ships, the most modern fleet in the world, AIDA is one of the fastest growing and most profitable touristic companies in Germany. With this continuous growth AIDA Cruises offers many interesting career opportunites for skilled personnel and managers at sea. Until 2016 AIDA will receive 4 (four) more ships, which operate according to the highest international quality, environmental and safety standards. AIDA Cruises distinguishes itself through innovative, cutting-edge technology in the areas of navigation and communications systems, the engine technologies as well as in the hotel operations.

The cruise line reflects the attitude towards active and open-minded Guests of all ages. AIDA Cruises offers more diversity and variety: from an active holiday to a relaxing vacation time.  At the same time Guests can enjoy all comforts of a floating hotel. They find a variety of offers on board and on land: culinary delicacies, fascinating entertainment, dreamlike possibilities in the area of fitness and wellness and the best childcare, on top fascinating routes, destinations and shore excursions in the most beautiful regions of this world. For more information please visit www.aida.de

We are inviting everyone to join our Recruitment Caravan 2012 that will also include Direct User Walk in Interview possibilities for everyone.

Details of the event you may found in this email attachment or you may also follow this link.

For Hotel Department

http://id.jobsdb.com/ID/ID/Search/JobAdSingleDetail?jobsIdList=200003000266603&sr=1

For Deck & Engine Department

http://id.jobsdb.com/ID/ID/Search/JobAdSingleDetail?jobsIdList=200003000266608&sr=1

Nevertheless, you may also feel free to contact us for any inquiries you may have for this event and thanking you in advance.

 

Kind Regards,

 

AIDA Cruises Recruitment Team

 

 

INDO SELECT RECRUITMENT & MANNING AGENCY

Office. Jl. Gunung Sanghyang 225X Kerobokan 80117 Bali Indonesia

Ph. +62 (0) 361 9656778 | Fax. +62 (0) 361 436102 | Email. aida@indoselect.com

Indo Select Recruitment & Manning Agency is a trading name of PT. Indo Seleksi Makmur Abadi

 

 

 

__._,_.___
Recent Activity:
Jika hendak unsubscribe/keluar dari Mailing list ini, dapat dilakukan dgn mengirimkan email kosong ke alamat: sintesa-resourcing-unsubscribe@yahoogroups.com

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___
Posted by at No comments:

Re: [sintesa-resourcing] ACCOUNTING

 

Kenapa saya g bs unsubcribe ya?

Sent from my BlackBerry®
powered by Sinyal Kuat INDOSAT
From: HRD EZY Relo <career@ezyrelo.com>
Sender: sintesa-resourcing@yahoogroups.com
Date: Sat, 7 Jan 2012 14:13:33 +0700
To: secretaries<secretaries@yahoogroups.com>; sintesa-resourcing<Sintesa-resourcing@yahoogroups.com>; job-vacancy<Job-Vacancy@yahoogroups.com>; <jakjobs@yahoogroups.com>; <dunia-kerja@yahoogroups.com>
ReplyTo: sintesa-resourcing@yahoogroups.com
Subject: [sintesa-resourcing] ACCOUNTING

 

 

An INTERNATIONAL MOVING & LOGISTICS COMPANY LOOKING FOR

 

ACCOUNTING

MustHave:

·         Male/Female between 25 - 35 years old

·         Possess minimum a Bachelor Degree from a reputable University (local/overseas) majoring in Accounting

·         Having Brevet A & B will be an advantage

·         Having at least 1 years experience in Accounting, Finance

·         Communication skills in English both oral and written is a mandatory   (Computer literate especially in Microsoft Excel, Word & Able to operate Accounting Program



General

·         Self-driven, autonomous, analytic and creative attitudes,

·         Have excellence Administration and Filling skill

·         Committed to continuous improvement, keen on accuracy, number and detail aspects

·         Able to work as an individual and as a team. And have a strong self determined personality.  

·         Ability to handle high workload, can tolerate stress, good organizational skills

 

Should you meet the above qualification, we invite you to submit your credential

CV with CURRENT PHOTOGRAPH and EXPECTED SALARY to:

NB: Please write name and the position on e-mail subject.

HR DEPARTMENT 

EZY Relo (PT. RELINGTON TRELOG)
Jl. Adhyaksa II D95 Lebak Bulus
Jakarta 12440
INDONESIA
Email       : hrd@ezyrelo.com
Website : www.ezyrelo.com

 

 

__._,_.___
Recent Activity:
Jika hendak unsubscribe/keluar dari Mailing list ini, dapat dilakukan dgn mengirimkan email kosong ke alamat: sintesa-resourcing-unsubscribe@yahoogroups.com

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___
Posted by at No comments:

[sharepointdiscussions] Digest Number 4369

SharePoint 2003, 2007, &2010 Discussions

Messages In This Digest (16 Messages)

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-developers.html> is SharePoint we
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-custom-web-parts.html> shows what
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]

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
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-developers.html> is SharePoint we
> 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-custom-web-parts.html> shows what
> 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]

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
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

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
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

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
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]

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
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.microsoft.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.com] On Behalf Of ShaneS
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]

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
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.com] On Behalf Of Paul Stork
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.microsoft.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%40ShareSquared.com> >
Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSquared.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]

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
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.com/kb/841057/en-us. Did you ever try to get
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.com] On Behalf Of Tara Santmire
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.microsoft.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%40ShareSquared.com>
<mailto:Paul.Stork%40ShareSquared.com> >
Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSquared.com>
<mailto:Paul.Stork%40ShareSquared.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]

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
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.microsoft.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.com] On Behalf Of Sander
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.com/kb/841057/en-us. Did you ever try to get
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.microsoft.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%40ShareSquared.com>
<mailto:Paul.Stork%40ShareSquared.com>
<mailto:Paul.Stork%40ShareSquared.com> >
Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSquared.com>
<mailto:Paul.Stork%40ShareSquared.com>
<mailto:Paul.Stork%40ShareSquared.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]

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
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.com/kb/841057/en-us. Did you ever try to get
> 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.com] On Behalf Of Tara Santmire
> 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.microsoft.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%40ShareSquared.com>
> <mailto:Paul.Stork%40ShareSquared.com> >
> Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSquared.com>
> <mailto:Paul.Stork%40ShareSquared.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]

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
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.com] On Behalf Of Paul Stork
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.microsoft.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%40ShareSquared.com> >
Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSquared.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.com/kb/841057/en-us. Did you ever try to get
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.microsoft.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%40ShareSquared.com>
<mailto:Paul.Stork%40ShareSquared.com>
<mailto:Paul.Stork%40ShareSquared.com>
<mailto:Paul.Stork%40ShareSquared.com> >
Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSquared.com>
<mailto:Paul.Stork%40ShareSquared.com>
<mailto:Paul.Stork%40ShareSquared.com>
<mailto:Paul.Stork%40ShareSquared.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]

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
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.com [mailto:sharepointdiscussions@yahoogroups.com] On Behalf Of Daniel A. Galant
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.com/kb/841057/en-us. Did you ever try to get
> 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.microsoft.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%40ShareSquared.com> <mailto:Paul.Stork%40ShareSquared.com>
> <mailto:Paul.Stork%40ShareSquared.com> >
> Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSquared.com> <mailto:Paul.Stork%40ShareSquared.com>
> <mailto:Paul.Stork%40ShareSquared.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]

[Non-text portions of this message have been removed]

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
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.com [mailto:sharepointdiscussions@yahoogroups.com] On Behalf Of Daniel A. Galant
> 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.com/kb/841057/en-us. Did you ever try to get
> > 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.microsoft.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%40ShareSquared.com> <mailto:Paul.Stork%40ShareSquared.com>
> > <mailto:Paul.Stork%40ShareSquared.com> >
> > Paul.Stork@ShareSquared.com <mailto:Paul.Stork%40ShareSquared.com> <mailto:Paul.Stork%40ShareSquared.com>
> > <mailto:Paul.Stork%40ShareSquared.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]
>
> [Non-text portions of this message have been removed]
>
>

[Non-text portions of this message have been removed]

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
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.com/2010/12/08/sharepoint-2010-usage-and-health-data-collection-service-application/ is the post I followed to start the service(s).
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?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
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.com [mailto:sharepointdiscussions@yahoogroups.com] On Behalf Of Peter Brunone
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>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
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.com" <sharepointdiscussions@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/test1.htm, 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:

<!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.microsoft.com/profile=6D05CC8D-32ED-4626-A29E-142DC7A680E0> 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.com] On Behalf Of Kevin Lai
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\VirtualDirectories\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]

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
Recent Activity
Visit Your Group
Yahoo! Groups

Parenting Zone

Tips for family,

kids and living

Y! Messenger

Want a quick chat?

Chat over IM with

group members.

Need traffic?

Drive customers

With search ads

on Yahoo!

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Posted by at No comments:
Subscribe to: Posts (Atom)