I am using TD 7.6. I can see the list of users that have been set up to access certain projects, via site admin, under the project and then users. But I cannot find any way of copying or exporting this information. Can anyone help?
This little script uses the TDAPI and will generate a csv file in the C:/ directory, which will run in Excel. Put in your own data and give it a try:
Set client = CreateObject("SAClient80MP.SAapi")
server = "your server address for the site admin page]"
saPassword = "Site Admin PW"
client.Connect server, saPassword
response = client.GetAllUsers()
Set xmldoc = CreateObject("Microsoft.XMLDOM")
Set lst = xmldoc.getElementsByTagName("USER_NAME")
Set lst1 = xmldoc.getElementsByTagName("FULL_NAME")
Set lst2 = xmldoc.getElementsByTagName("EMAIL")
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.OpenTextFile("C:\users.csv", 2, True)
f.WriteLine("TD User Name, TD Full Name, User E-Mail")
For i = 0 To lst.length - 1
Set node = lst.Item(i)
Set node1 = lst1.Item(i)
Set node2 = lst2.Item(i)
f.WriteLine Trim(node.Text+", "+node1.Text+", "+node2.Text)
If you do not have access to a VBS editor, then try copying it and pasting it into NotePad. Then save it as Names.vbs or your own file name and exit notepad find the saved script and run it from Windows XP.
But don't forget to make the changes for your server and password in NotePad.