Re: Add a file to attachments in contacts table (344 Views)
Reply
Trusted Contributor
ALARMus
Posts: 985
Registered: ‎10-06-2009
Message 1 of 7 (433 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 (371 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 (369 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 (368 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 (367 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 (344 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,137
Registered: ‎06-17-2010
Message 7 of 7 (312 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.
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.