Moving attachments between two different repositories

[Legacy User]

Hi everyone,

 

I needed to create a second repository for some attachments in Service Desk Manager. I wanted to change the current repository of some attachments which are already uploaded. Since it's possible changing a physical folder of a exisisting repository (TEC481388), is there a way to change the repository of an existing attachment?

 

PS: I've already tried changing this through pdm_load, and after moving to the new folder. The attachment seems to retain the right repository and the right physical path (as highlighted below), but it not worked.

 

 

Thanks,

 

Diogo

[Jon_Israel]

Hi Diogo,

It can be done by manual data manipulation, however it is not recommended and is not supported.  It would be very high risk, and is outside the scope of support.

Jon I.

[Legacy User]

Hi Jon,

 

In pdm_load, I just changed the "repository" field to new repository (as you see in the code below) - the default was doc_rep:1002. Do you mean it needs more data manipulation than this?

 

TABLE Attachment
 attmnt_name attmnt_uuid created_by created_dt del description exec_cmd file_date
 file_name file_size file_type folder_id folder_path_ids id inherit_permission_id
 last_mod_by last_mod_dt link_only link_type orig_file_name persid read_pgroup
 rel_file_path repository sec_uuid status tenant write_pgroup zip_flag
 { "291597 - Validação.pdf" ,"4ADB8D4069C39E4E9645EA341344DE4D",
 "B6E496DD9059544A9713B828BFBBC711" ,"10/10/2016 17:05:27" ,"0" ,"" ,"",
 "10/10/2016 17:05:27",
 "25179ED3DC1A454F9BFD3502AFA2CDA8_417378_291597%20%2D%20Validação.pdf.gz",
 "1233558" ,"pdf" ,"0" ,"0" ,"417378" ,"" ,"B6E496DD9059544A9713B828BFBBC711",
 "10/10/2016 17:05:33" ,"0" ,"" ,"291597 - Validação.pdf" ,"attmnt:417378",
 "0" ,"rep_folder_00001" ,"doc_rep:400001" ,"9DC040155B875D4FB8938F3E63485B57",
 "INSTALLED" ,"E024718EB87A1F42A7CB120C607E5262" ,"0" ,"1" }

 

Thanks,

 

Diogo

[Jon_Israel]

That looks like it would work, but again, from a support standpoint, we cannot support it - so my best advice would be to test it on a test system first

Also take a backup of the repository directories and the database prior to doing this just in case.

 

Jon I.

[Legacy User]

Hi Jon,

 

Well, I tested here, but it didn't work. Looks like Service Desk tracks attachments using other ways too.

Guess I have to suggest an idea for that then.

 

Anyway, thanks for your response!

 

Diogo