HPE Service Manager / Service Center Support and News Forum
Showing results for 
Search instead for 
Do you mean 

Add a file to attachments in contacts table

Trusted Contributor Trusted Contributor

Add a file to attachments in contacts table

Hello.

How can i automatically add a file to attachments in contacts table where file name = opertor.id in contacts ?

There is about 400 files for 400 contacts records.

6 REPLIES
Trusted Contributor Trusted Contributor

Re: Add a file to attachments in contacts table

In fact the question is about SYSATTACHMENTS table and how can i load files into there

HPE Expert

Re: Add a file to attachments in contacts table

Hi

This is an old discussion but might point in direction

 

http://www.sc-resources.net/threads/4659-attachments-in-file-system-instead-of-DB

 

I am still researching your question also

Thank you

Lisa

"HP Support
If you find that this post or any post resolves your issue, please make sure to mark it as an accepted solution."
HPE Expert

Re: Add a file to attachments in contacts table

Hi

Also discussion here

http://h30499.www3.hp.com/t5/HP-Service-Manager-Service/Export-attachments-from-Service-Manager/td-p...

"HP Support
If you find that this post or any post resolves your issue, please make sure to mark it as an accepted solution."
HPE Expert

Re: Add a file to attachments in contacts table

Hi

http://www.sc-resources.net/threads/6307-Service-Manager-9-20-How-to-export-attachments-with-javascr...

"HP Support
If you find that this post or any post resolves your issue, please make sure to mark it as an accepted solution."
Trusted Contributor Trusted Contributor

Re: Add a file to attachments in contacts table

[ Edited ]

Thank you for answer.

 

But i need to do the opposite - Import files from file system TO attachments in SM.

 

Many files must be imported to SM each of them must be related to one of contact record.

Highlighted
Honored Contributor Honored Contributor

Re: Add a file to attachments in contacts table

HI,

I do not feels there is any such process which automate to load files in SM as during attach these files auto compressed and linked to master table via sysattachments table.
Attachments is different java applet panel which work on separate code of sm , not like regular structure as fc,ink etc.

hth,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.