Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Verified Answer
  • Replies replies
    4
  • Answers answer
    1
  • Subscribers subscribers
    168
  • Views views
    330
  • Users 0 members are here
Related
Options

What is the format of the "TS_CONTENTS" field in TS_FILE_OBJS and TS_FILE_OBJS_TEMP tables?

PM Thompson

When using a File type field, the file added frequently a unique file name in the "TS_CONTENTS" field in the TS_FILE_OBJS_TEMP and TS_FILE_OBJS tables. The unique name seems to have the format "[original filename]_[Item Table ID]_[Item Record ID]_[Add File iteration]_[mysterious number #1]_[mysterious number #2].[original file extension]"

Question:

What are the values for "[mysterious number #1]" and "[mysterious number #2]" and how are they derived?

example:

TS_NAME:Default or user entered fname TS_CONTENTS:Unique fname TS_FILENAME:original fname
TIFF.tiff TIFF_1176_1_0_8940_5832.tiff TIFF.tiff
TIFF.tiff TIFF_1011_1376812_0_8940_5832.tiff TIFF.tiff
TIFF.tiff TIFF_1011_1376812_1_8940_5832.tiff TIFF.tiff
TIFF.tiff TIFF_1011_1376812_2_8940_5832.tiff TIFF.tiff
TIFF.tiff TIFF_1011_1376812_3_8940_5832.tiff TIFF.tiff
TIFF.tiff TIFF_1176_1_1_8940_5832.tiff TIFF.tiff
TIFF.tiff TIFF_1176_1_0_8940_7604.tiff TIFF.tiff
TIFF.tiff TIFF_1176_1_2_8940_7604.tiff TIFF.tiff
Name entered for TIFF.tiff TIFF_1176_1_3_8940_7604.tiff TIFF.tiff

Parents

  • Suggested Answer

    0  

    If a filename already exists, the additional numbers are added.  Your assessment of the values is correct. [mysterious number #1]_[mysterious number #2] represent the process id information.  The process id information will allow you to determine that the files were uploaded around the same time.  Resetting IIS will of course generate new process ids.

Reply

  • Suggested Answer

    0  

    If a filename already exists, the additional numbers are added.  Your assessment of the values is correct. [mysterious number #1]_[mysterious number #2] represent the process id information.  The process id information will allow you to determine that the files were uploaded around the same time.  Resetting IIS will of course generate new process ids.

Children

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.