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 over 14 years ago

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:

attachments

Top Replies

Parents

Verified Answer

0 Tommy Jensen over 14 years ago

Do you want to extract the files out of SM to a network drive before sending it in an email ?

That can be done in 2 ways.

1. Using a connect.It scenario. I built one many years ago. It needs updating but you can find it here: http://www.sc-resources.net/threads/2256-Save-all-attachments-from-SC-to-local-folder

2. Depending on the version you run you may be able to use this javascript&colon; http://www.sc-resources.net/threads/6307-Service-Manager-9.20-How-to-export-attachments-with-javascript
Cancel
Vote Up +1 Vote Down

Cancel

Reply

Verified Answer

0 Tommy Jensen over 14 years ago

Do you want to extract the files out of SM to a network drive before sending it in an email ?

That can be done in 2 ways.

1. Using a connect.It scenario. I built one many years ago. It needs updating but you can find it here: http://www.sc-resources.net/threads/2256-Save-all-attachments-from-SC-to-local-folder

2. Depending on the version you run you may be able to use this javascript&colon; http://www.sc-resources.net/threads/6307-Service-Manager-9.20-How-to-export-attachments-with-javascript
Cancel
Vote Up +1 Vote Down

Cancel

Children

0 reach2sunil37 over 7 years ago in reply to Tommy Jensen

I'm unable to access these links. may I know the reason please?

thanks,
Sunil
Cancel
Vote Up 0 Vote Down

Cancel
0 ALARMus over 7 years ago in reply to Tommy Jensen

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.
Cancel
Vote Up 0 Vote Down

Cancel
0 ALARMus over 7 years ago in reply to Tommy Jensen

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.
Cancel
Vote Up 0 Vote Down

Cancel
0 Mithila over 3 years ago in reply to Tommy Jensen

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.
Cancel
Vote Up 0 Vote Down

Cancel
0 Mithila over 3 years ago in reply to Tommy Jensen

Hi Tommy,

The link mentioned in the post is no longer available.

Can you please help provide updated links ?

Thank you.
Cancel
Vote Up 0 Vote Down

Cancel

Menu

Service Manager Discussions

Verified Answers

How can I extract attachments out of CM tickets?

Tags:

Top Replies

Verified Answer

Verified Answer

Resources