KACE Product Support

Kraneda0149,

I do think this is a good idea.

Replacing the " " with "_" will rename the files in the database ONLY, not in the file system.

After the udpdate you will lose the association with the files.

Here is how you can test.

select statement
select 1 from dual

update

UPDATE HD_ATTACHMENT
SET FILE_NAME = REPLACE(FILE_NAME," ","_")
WHERE HD_TICKET_CHANGE_ID = {ENTER 1 CHANGE ID HERE TO TEST}


Save the rule and run once.

After go into the ticket and look at the attachment. The file name will be updated but you can no longer select it.

Here is the update command to fix the now broken attachment.


UPDATE HD_ATTACHMENT
SET FILE_NAME = REPLACE(FILE_NAME,"_"," ")
WHERE HD_TICKET_CHANGE_ID = {ENTER 1 CHANGE ID HERE TO TEST}


Thanks, I'm going to test it out first and like you said if I lose the file association I might not want to change it. My purpose was to simply create SQL statement that will concatenate other items to the filename and send it in an email as a custom rule.

Here's a rule that we use that converts attachment descriptions to URLs. In that case you change the spaces to %20. There are probably others things that should be encoded for a perfect solution. But if you're interested see the attachment.

Created a new post so I could attach a file http://itninja.com/question/how-to-turns-attachments-in-tickets-into-urls&mpage=1&key=&#69095