Storage method and location of files attached to change requests

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)

Parents Reply Children
  • 0 in reply to 

     Thanks for your reply  .
    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)?