Buzzsaw Developer

Reply
New Member
Timothy
Posts: 2
Registered: ‎08-02-2004
Message 1 of 7 (391 Views)

Login problem

391 Views, 6 Replies
08-02-2004 04:10 PM
Hello,

I am using the following code in Excel VBA to try to get the file name, create date and modify date for a folder on our site. I keep getting the error: "There was an unknown error." Any assistance would be greatly appreciated.

Sub ScanPPRevisions()
'**************************************************************************
'* Delcare Variables
'**************************************************************************

Dim oPPSession As New ppSession
Dim oPPFolder As PPFOLDER
Dim oPPFolders As PPResourceCollection
Dim oPPFolderItem As IPPResource
Dim sResourceUrl As String
Dim sResourceUrl2 As String
Dim sUserName As String
Dim sPassword As String

'*************************************************************************
'* Set Variables
'*************************************************************************

sResourceUrl = "https://webdav.buzzsaw.com/SiteName"
sResourceUrl2 = "Root/Folder"
sUserName = "xxxxx"
sPassword = "xxxxx"
On Error GoTo except
oPPSession.LogOut
oPPSession.LogIn sUserName, sPassword, sResourceUrl
Set oPPFolder = oPPSession.GetResource(sResourceUrl2)
Set oPPFolders = oPPFolder.SubFolders

'**************************************************************************
'* Insert Column Headers
'*************************************************************************

r = 1
Cells(r, 1) = "FileName"
Cells(r, 2) = "CreateDate"
Cells(r, 3) = "ModifiedDate"
Range("A1:C1").Font.Bold = True
r = r + 1

'**************************************************************************
'* Loop through all items and list the file name, create date and modified date
'**************************************************************************

For Each oPPFolderItem In oPPFolders

If oPPFolderItem.Type = PPFOLDER Then
Cells(r, 1) = oPPFolderItem.Name
Else:
Cells(r, 1) = oPPFolderItem.Name
Cells(r, 2) = oPPFolderItem.CreationDate
Cells(r, 3) = oPPFolderItem.LastModifiedDate
End If

Next oPPFolderItem

MsgBox "List Complete"

Exit Sub

except:
Dim sDec As String
sDec = oPPSession.GetPPErrorInfo(Err.Number)
MsgBox sDec, , "Login Failure"
oPPSession.LogOut
End Sub


Thank you

Tim
*Scott Sheppard
Message 2 of 7 (391 Views)

Re: Login problem

08-02-2004 05:24 PM in reply to: Timothy
Is it supposed to be webfolders.buzzsaw.com? "Timothy" wrote in message news:16391539.1091488281548.JavaMail.jive@jiveforum2.autodesk.com... > '************************************************************************* > '* Set Variables > '************************************************************************* > > sResourceUrl = "https://webdav.buzzsaw.com/SiteName" > sResourceUrl2 = "Root/Folder" > sUserName = "xxxxx" > sPassword = "xxxxx" > On Error GoTo except > oPPSession.LogOut > oPPSession.LogIn sUserName, sPassword, sResourceUrl > Set oPPFolder = oPPSession.GetResource(sResourceUrl2) > Set oPPFolders = oPPFolder.SubFolders
New Member
Timothy
Posts: 2
Registered: ‎08-02-2004
Message 3 of 7 (391 Views)

Re: Login problem

08-02-2004 07:44 PM in reply to: Timothy
I have tried all of the following:
https://webfolders.buzzsaw.com/Site
http://webfolders.buzzsaw.com/Site
https://webdav.buzzsaw.com/Site
http://webdav.buzzsaw.com/Site
https://folders.buzzsaw.com/Site
http://folders.buzzsaw.com/Site

All return an error.

Tim
*Scott Sheppard
Message 4 of 7 (391 Views)

Re: Login problem

08-03-2004 05:39 AM in reply to: Timothy
1. The two "normal" ways to access a site are: http://folders.buzzsaw.com/client/site http://projectpoint.buzsaw.com/client/site Yes you can use https instead of http. When http is used instead of https, it automatically redirects for user name/password transmission. 2. If you wish to access the site without using the ProjectPoint client, you remove "client" from the URL: http://folders.buzzsaw.com/site http://projectpoint.buzsaw.com/site 3. When I wish to access my site using WebDAV, I use "file open" in Internet Explorer, and I make sure to check the box for "open as web folder" and I use the URL: https://webfolders.buzzsaw.com The WebDAV protocol always uses https - even for file transfers. If you use http instead of https, I think it will redirect. I don't think webdav.buzzsaw.com is a valid URL. What happens when you try to open your site from the browser instead of the application. If you can get it to work from the browser, then we can look at what's going on in your application. Maybe its that "open as web folder" part that must be set somewhere in your code? "Timothy" wrote in message news:2533430.1091501125638.JavaMail.jive@jiveforum1.autodesk.com... > I have tried all of the following: > https://webfolders.buzzsaw.com/Site > http://webfolders.buzzsaw.com/Site > https://webdav.buzzsaw.com/Site > http://webdav.buzzsaw.com/Site > https://folders.buzzsaw.com/Site > http://folders.buzzsaw.com/Site > > All return an error. > > Tim
*john bartak
Message 5 of 7 (391 Views)

Re: Login problem

08-18-2004 02:12 PM in reply to: Timothy
Do you know that the error is caused by the login code? Could the error be somewhere else in the code? "Scott Sheppard" wrote in message news:410f8786$1_2@newsprd01... > 1. The two "normal" ways to access a site are: > http://folders.buzzsaw.com/client/site > http://projectpoint.buzsaw.com/client/site > Yes you can use https instead of http. When http is used instead of https, > it automatically redirects for user name/password transmission. > > 2. If you wish to access the site without using the ProjectPoint client, you > remove "client" from the URL: > http://folders.buzzsaw.com/site > http://projectpoint.buzsaw.com/site > > 3. When I wish to access my site using WebDAV, I use "file open" in Internet > Explorer, and I make sure to check the box for "open as web folder" and I > use the URL: > https://webfolders.buzzsaw.com > The WebDAV protocol always uses https - even for file transfers. If you use > http instead of https, I think it will redirect. I don't think > webdav.buzzsaw.com is a valid URL. What happens when you try to open your > site from the browser instead of the application. If you can get it to work > from the browser, then we can look at what's going on in your application. > Maybe its that "open as web folder" part that must be set somewhere in your > code? > > "Timothy" wrote in message > news:2533430.1091501125638.JavaMail.jive@jiveforum1.autodesk.com... > > I have tried all of the following: > > https://webfolders.buzzsaw.com/Site > > http://webfolders.buzzsaw.com/Site > > https://webdav.buzzsaw.com/Site > > http://webdav.buzzsaw.com/Site > > https://folders.buzzsaw.com/Site > > http://folders.buzzsaw.com/Site > > > > All return an error. > > > > Tim > >
*Scott Sheppard
Message 6 of 7 (391 Views)

Re: Login problem

08-19-2004 09:57 PM in reply to: Timothy
Sorry but I am not familiar with the API error code. "john bartak" wrote in message news:4123c5da_1@newsprd01... > Do you know that the error is caused by the login code? Could the error be > somewhere else in the code?
New Member
Viorel iosif
Posts: 1
Registered: ‎11-29-2004
Message 7 of 7 (391 Views)

Re: Login problem

11-29-2004 01:12 PM in reply to: Timothy
oPPFolder you are trying to access is actually a Buzzsaw project ? Declare oPPFolder as PPProject. It is most likely the case here.
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions to get help installing your software.

New Buzzsaw Category!

The Buzzsaw forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.