Re: Add a file to attachments in contacts table (361 Views)
Reply
Trusted Contributor
ALARMus
Posts: 985
Registered: ‎10-06-2009
Message 1 of 7 (423 Views)

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.

Trusted Contributor
ALARMus
Posts: 985
Registered: ‎10-06-2009
Message 2 of 7 (361 Views)

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

HP Expert
lisajo
Posts: 480
Registered: ‎02-15-2010
Message 3 of 7 (359 Views)

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."
HP Expert
lisajo
Posts: 480
Registered: ‎02-15-2010
Message 4 of 7 (358 Views)

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."
HP Expert
lisajo
Posts: 480
Registered: ‎02-15-2010
Message 5 of 7 (357 Views)

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
ALARMus
Posts: 985
Registered: ‎10-06-2009
Message 6 of 7 (334 Views)

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.

Honored Contributor
Piku
Posts: 4,047
Registered: ‎06-17-2010
Message 7 of 7 (302 Views)

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.
http://h30499.www3.hp.com/t5/Tips-and-Tricks/Kudos-what-where-how-and-why/m-p/5677925#U5677925
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.