sharepoint and vbscript

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

sharepoint and vbscript

Logged in as: Guest

arrSession:exec spGetSession 2,2,35051

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> sharepoint and vbscript
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

sharepoint and vbscript - 6/1/2006 5:19:36 AM

ylnwwd

Posts: 15
Score: 0
Joined: 2/28/2006
Status: offline

I am not sure if this is the correct place for this....

I would like to know if it is possible to use vbscript to update sharepoint components such as sharepoint list. I need to periodically update a sharepoint list using data from an excel/text file. I was suggested to use a vbscript agent and schedule it to run periodically.

If someone has any idea regarding this, please direct me to a sample code/method for this task.

thanks

ylnwwdj

< Message edited by ylnwwd -- 6/1/2006 5:32:18 AM >

Post #: 1

RE: sharepoint and vbscript - 6/1/2006 5:33:10 AM

ebgreen

Posts: 4970
Score: 31
Joined: 7/12/2005
Status: offline

I believe that you would need ODBC access to the SQL database that is backending the sharepoint. Then I think you would be able to do it.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to ylnwwd)

Post #: 2

RE: sharepoint and vbscript - 6/1/2006 5:39:19 AM

ehvbs

Posts: 2172
Score: 50
Joined: 6/22/2005
From: Germany
Status: online

Hi ylnwwd,

in German, but I hope the code will help you:

http://ts38507801.teamtreff.de/public/Lists/InfoPathCodebeispiele/Allitemsg.aspx

something to see the principles:

http://msd2d.com/Content/Tip_viewitem_03NoAuth.aspx?section=Sharepoint&id=3FFD5471-1244-4E61-9136-AAC37CC5FBB0

(in reply to ylnwwd)

Post #: 3

RE: sharepoint and vbscript - 6/1/2006 5:41:08 AM

ylnwwd

Posts: 15
Score: 0
Joined: 2/28/2006
Status: offline

Unfortunately I dont have access to the database/windows server....i am attempting to simulate the process that takes place when you manually go to the sharepoint site and add items to a particular list, only this needs to be done by some script. Is this possible?

(in reply to ebgreen)

Post #: 4

RE: sharepoint and vbscript - 6/1/2006 5:42:30 AM

ebgreen

Posts: 4970
Score: 31
Joined: 7/12/2005
Status: offline

To be honest with you, I think the answer is no if you don't have DB access. I'd be happy to be proven wrong however.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to ylnwwd)

Post #: 5

RE: sharepoint and vbscript - 6/1/2006 5:43:55 AM

ylnwwd

Posts: 15
Score: 0
Joined: 2/28/2006
Status: offline

ehvbs

Thank you, it does look like something I am looking for. I shall investigate further and most likely I would come back with more questions...

thanks again