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
    16
  • Subscribers subscribers
    9
  • Views views
    2304
  • Users 0 members are here
  • Locked Locked
Related
Options
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How can I extract attachments out of CM tickets?

MigrationDeletedUser
I have been trying multiple ways to extract attachments our of Service Manager using Web Services (which I read many forum post many have been unsuccessful) and directly through the SQL table SYSATTACHMEM1. Pulling directly from the table seem unreadable and web services seem difficult.

Does anyone know how (if) this can be done? Ultimately, we want to send the attachment out of SM via email to a vendor for processing after the change ticket has been approved.

Tags:

  • 0 in reply to 

    Hello.

    Tommy, unfortunately your urls does not work:

     

    Invalid Page URL. If this is an error and the page should exist, please contact the system administrator and tell them how you got this message.

  • 0 in reply to 

    Hello.

    Tommy, unfortunately your urls does not work:

     

    Invalid Page URL. If this is an error and the page should exist, please contact the system administrator and tell them how you got this message.

  • 0 in reply to 

    Hi Tommy, 

    The link is no longer available and we are trying to achieve a similar functionality. 
    Can you please help provide inputs ? 
    Thank you.

  • 0 in reply to 

    Hi Tommy, 

    The link mentioned in the post is no longer available. 

    Can you please help provide updated links ? 

    Thank you.

  • 0 in reply to 

    That's my code to save attachments from table to disk

    This forum link

  • 0 in reply to 

    Thank you for the script  . I was able to modify script and copy attachments from a specific ticket table; for example, imTask. Instead of the files stored in the directory I stated, I noticed the files were copied into the RUN directory of SM. the line "var ParentFolder = "c:\\temp\\imTask\\";" was appended in front of the file name. For example, a file named "test.png" was saved into the RUN directory as c:\temp\imTask\IM12008-001\test.png.

    From the RUN directory, I was able to move the files to /tmp directory.

    Within the /tmp directory, I changed file permission to all moved files.

    Using Filezilla, I was able to copy files to a shared drive.

    Joe

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.