After my build has finished, I would like to be able to have FB copy the setup file to my SharePoint site. Anyone tried doing this before? I can’t figure out how to get it copied to the server.
Thanks
Hi Paul
We don’t currently have any built in support for sharepoint, however you should be able use some VBScript to do this, I found this script via google (should be able to create an action using ActionStudio too) :
Dim objCN 'As ADODB.Connection
Dim objRec 'As ADODB.Record
Dim objStream 'As ADODB.Stream
Dim strFileURL 'As String
Dim strFilePath 'As String
Dim strCC 'As String
Const adModeReadWrite = 3
Const adCreateNonCollection = 0
Const adCreateOverwrite = 67108864
Const adDefaultStream = -1
Const adTypeBinary = 1
'Replace these values with real paths
strFileURL = "http://servername/portalname/documents/documentname.doc"
strFilePath = “C:\Temp\documentname.doc”
'This is the default content class for documents
'However, different profiles use other content classes
strCC = "urn:content-classes:document"
Set objCN = CreateObject(“ADODB.Connection”)
objCN.Provider = "ExOLEDB.DataSource"
objCN.open strFileURL
Set objRec = CreateObject(“ADODB.Record”)
objRec.open strFileURL, objCN, adModeReadWrite, adCreateNonCollection + adCreateOverwrite
objRec.Fields(“DAV:contentclass”) = "urn:content-classes:document"
objRec.Fields(“urn:schemas:mailheader:content-type”) = "application/octet-stream"
objRec.Fields.Update
Set objStream = objRec.Fields(adDefaultStream).Value
With objStream
.Type = adTypeBinary
.SetEOS
.LoadFromFile strFilePath
.Flush
End With
objRec.Close
objCN.Close
Set objStream = Nothing
Set objRec = Nothing
Set objCN = Nothing
HTH