Two external add questions

[tom.mcmanus]

Hi Sourcegear -

First - is there a good/easy way to get a list of all projects w/external add enabled, and the corresponding URLs, without just going through each project and hitting the External Add page and cut-n-pasting the URL?

Second - is there a good/easy way to change what fields are presented on the external add page? Or is there a good way to customize what's presented? For example, maybe I don't need want to bother displaying the version filed or platform field on the external add page, or perhaps I would like to display a fields that's not visible currently.

Thanks!

Tom McManus
thomas.mcmanus@cobham.com

[lbauer]

You can run this query on your SQL Server database, which will give you a list of your projects and will show a "1" in the allowexternalsubmission column if external add is enabled.

Code: Select all

use sgdragnet
go
select * from dbo.projects
go

There's no way to get a list of URLs; however, the query results will also give you the project ID number, and that ID number is part of the External Add link. For example

Code: Select all

http://<Fortress_servername>/Fortress/External/AddItemExternal.aspx?pid=101

So you can extrapolate the URL if you know the project ID number.

[tom.mcmanus]

Linda -

Thanks for the pointers w/r/t external add - I fiddled a bit with the query and came up with

Code: Select all

use sgdragnet
go
select projectid, name from dbo.projects
where allowexternalsubmission = 1
go

which gives me a nice list.

Do you have any input on the ability to customize the external add page?

Thanks

Tom McManus

[lbauer]

You can change the look of the External Add page by editing the AddItemExternal.aspx file in C:\Inetpub\wwwroot\Fortress\External on the Fortress Server machine. However this is just to change the color scheme or logo, etc.

But you can't change the functionality, like fields or labels, since these are dynamically generated pages. The fields and labels are in the source code itself, not just on a static page.

You might be able to generate something yourself with the Fortress API.

We have a forum specifically for Vault/Fortress API issues.You can get a lot of questions answered here:

http://support.sourcegear.com/viewforum.php?f=39

You can download the Fortress API from our Downloads page:
http://sourcegear.com/fortress/downloads.html