Update a Sharepoint list using VBSCRIPT via Web Se

[jvierra]

Here is the easiest method for upadting lists on a Sharepoint site. It uses PowerShell as this is the most relaible method for all sharepoint server installations and bypasses configuration issues with customdeployments and Small Business Server url redirection.

Code: Select all

[System.Reflection.Assembly]::LoadWithPartialName(

[ismailc]

Thank You for helping.

It does not like the code in a vbscript file:

Code: Select all

	[System.Reflection.Assembly]::LoadWithPartialName(

[ismailc]

Thank You - i'm struggling to long.

Any ideas on how to query the Sharepoint DB & update the column


Thanks

[jvierra]

Code: Select all

	
	[System.Reflection.Assembly]::LoadWithPartialName(

[jvierra]

You cannot use vbscrip to update teh server due to numerous issues. The code poted is for PowerShell and will work to update lists.

[ismailc]

how do i create the Powershell file

and then perhaps in vbscript call a command to execute the file.

possible steps?

please

[ismailc]

aplogies my friend, really not on the same page.
I'm trying to create simple powershell file.

new txt file
text = "New-Item -ItemType file freespace.txt "

save file as test.ps1

not workingismailc2010-01-05 04:33:12

[ismailc]

I tried the foll from a start - run

powershell.exe c:test.ps1
but error: Windows cannot find Powershell.exe

[jvierra]

You have to install PowerShell before you can run it.

Use notepad to create text files.

You have to either run this on Sharepoint server or install the SharePoint SDK as I noted in my earlier post.

jvierra2010-01-05 07:47:10

[ismailc]

Help, How can I remotely execute the SSIS package passing var defined in the package with VBScript