Hi! StarTeam server 15.0.0.203 I am wondering about attached files for change requests since I am looking to extract them all in batch. As far as I can understand these files are stored in a generic folder Changes_Attachments in the repository. I can see that I have a bunch of files there names 00000, 00001 etc. Now for questions: Are these files stored in their native format or is it in some other binary format. i.e. would it be possible to simply copy a file to another location and open in e,g, Word if I knew that it is a MS Word file? If they are not stored in their native format is there some other way to extract all attached files from change requests, using SDK, stcmd or other method. I see that it is possible to query the ST database to determine what file that are attached to which change reuest. Retrieve Change Request attachment information using SQL Server - StarTeam Tips & Information - OpenText StarTeam (microfocus.com)

Attachments are stored in vault since StarTeam 11 or 12 for command line, use select command , see https://admhelp.microfocus.com/starteam/en/17.3/online/Content/Command-Line/Select%20select.htm

StarTeam Discussions

Storage method and location of files attached to change requests

Fredrik Vestin 6 months ago

Hi!

StarTeam server 15.0.0.203

I am wondering about attached files for change requests since I am looking to extract them all in batch.

As far as I can understand these files are stored in a generic folder Changes_Attachments in the repository. I can see that I have a bunch of files there names 00000, 00001 etc.

Now for questions:

Are these files stored in their native format or is it in some other binary format. i.e. would it be possible to simply copy a file to another location and open in e,g, Word if I knew that it is a MS Word file?
If they are not stored in their native format is there some other way to extract all attached files from change requests, using SDK, stcmd or other method.

I see that it is possible to query the ST database to determine what file that are attached to which change reuest. Retrieve Change Request attachment information using SQL Server - StarTeam Tips & Information - OpenText StarTeam (microfocus.com)

Suggested Answer

0 Danielle Gutfinger 6 months ago

Attachments are stored in vault since StarTeam 11 or 12
for command line, use select command , see https://admhelp.microfocus.com/starteam/en/17.3/online/Content/Command-Line/Select%20select.htm
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 Fredrik Vestin 6 months ago in reply to Danielle Gutfinger

Thanks for your reply Danielle Gutfinger .
Am I to understand that attachments for change requests are stored in the vault and there is no way to e.g. files from the vault other than going through the starteam server. From that I can read in the documentation files are either stored in the archive in theor native format or if they are considered suitable for compression compressed to .gz.
"When you check in a file from a working folder on your computer, the application stores it by the MD5 value of its contents. If the file is identified as one that compresses well, it is compressed and placed in the hive's archive with a .gz extension. Otherwise, the uncompressed version is placed in the hive's archive." This is from Check-in and Check-out Overview (microfocus.com)
I cannot see any way to check out attached files using the stcmd select statement. How would it be possible to extract all attached files for change requests (and determine what change request they are attached to)?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Menu

StarTeam Discussions

Verified Answers

Storage method and location of files attached to change requests

Suggested Answer

Resources