CA Service Management

Expand all | Collapse all

Moving attachments between two different repositories

  • 1.  Moving attachments between two different repositories

    Posted 10-11-2016 03:56 PM

    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



  • 2.  Re: Moving attachments between two different repositories

    Posted 10-11-2016 04:29 PM

    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.



  • 3.  Re: Moving attachments between two different repositories

    Posted 10-11-2016 04:38 PM

    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



  • 4.  Re: Moving attachments between two different repositories

    Posted 10-13-2016 08:20 AM

    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.



  • 5.  Re: Moving attachments between two different repositories

    Posted 10-13-2016 09:54 AM

    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