Re: Add a file to attachments in contacts table (241 Views)
Reply
Trusted Contributor
ALARMus
Posts: 985
Registered: ‎10-06-2009
Message 1 of 7 (330 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.

Please use plain text.
Trusted Contributor
ALARMus
Posts: 985
Registered: ‎10-06-2009
Message 2 of 7 (268 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

Please use plain text.
HP Expert
lisajo
Posts: 480
Registered: ‎02-15-2010
Message 3 of 7 (266 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."
Please use plain text.
HP Expert
lisajo
Posts: 480
Registered: ‎02-15-2010
Message 4 of 7 (265 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."
Please use plain text.
HP Expert
lisajo
Posts: 480
Registered: ‎02-15-2010
Message 5 of 7 (264 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."
Please use plain text.
Trusted Contributor
ALARMus
Posts: 985
Registered: ‎10-06-2009
Message 6 of 7 (241 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.

Please use plain text.
Honored Contributor
Piku
Posts: 3,911
Registered: ‎06-17-2010
Message 7 of 7 (209 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
Please use plain text.
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