{"id":4461,"date":"2020-03-21T06:19:30","date_gmt":"2020-03-21T06:19:30","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=4461"},"modified":"2020-03-21T06:19:30","modified_gmt":"2020-03-21T06:19:30","slug":"how-to-restore-a-deleted-imanage-folder","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/how-to-restore-a-deleted-imanage-folder","title":{"rendered":"How to restore a deleted iManage Folder"},"content":{"rendered":"<p class=\"x_MsoNormal\">Folders can\u2019t be recovered but the files are still present so you can manually recreate the folder and search for the files in iManage and move them back into it. If your not sure all the files you can restore the database to find the old PRJ_ID of the folder then search for the files with that Parent<\/p><p>A script below helps with restoring Subfolders etc :\u00a0<\/p><p>The first for the folders, the second for documents. You will also need to run something similar for folder profiles and security, but that should be straight forward.<\/p><p>@prjid would the first folder you wish to restore, the query will pull all of the children.<\/p><p>Replace &#8220;PRODUCTION&#8221; and &#8220;RESTORE&#8221; with your own db names.<\/p><p>[pastacode lang=&#8221;sql&#8221; manual=&#8221;!!Of%20course%20use%20at%20your%20own%20risk%2C%20this%20works%20on%20my%20environment%2C%20and%20should%20work%20on%20yours%20too.%20!!%0A%0A&#8211;%20Folders%20%2F%20Workspace%0ADECLARE%20%40prjID%20BIGINT%3B%0Aselect%20%40prjid%20%3D%20&#8211;PARENT%20FOLDER%20ID%0A%0A%0AWITH%20tblChild%20AS%0A(%0A%20%20%20%20SELECT%20*%20FROM%20%20RESTORE.mhgroup.projects%20WHERE%20prj_pid%20%3D%20%40prjID%0A%20%20%20%20UNION%20ALL%0A%20%20%20%20SELECT%20p.*%20%20FROM%20RESTORE.mhgroup.projects%20p%20JOIN%20tblChild%20c%20%20ON%20p.prj_pid%20%3D%20c.prj_id%0A)%0Ainsert%20into%20PRODUCTION.mhgroup.projects%0ASELECT%20*%20FROM%20tblChild%20where%20prj_id%20not%20in%20(select%20prj_id%20from%20PRODUCTION.mhgroup.projects)%0AOPTION(MAXRECURSION%2032767)%0A%0A%0A&#8211;%20Documents%0ADECLARE%20%40prjID%20BIGINT%3B%0Aselect%20%40prjid%20%3D%20&#8211;PARENT%20FOLDER%20ID%0A%0AWITH%20tblChild%20AS%0A(%0A%20%20%20%20SELECT%20*%20FROM%20%20mhgroup.projects%20WHERE%20prj_pid%20%3D%20%40prjID%0A%20%20%20%20UNION%20ALL%0A%20%20%20%20SELECT%20p.*%20%20FROM%20mhgroup.projects%20p%20JOIN%20tblChild%20c%20%20ON%20p.prj_pid%20%3D%20c.prj_id%0A)%0A%0Ainsert%20into%20PRODUCTION.mhgroup.project_items%0ASELECT%20s.*%20FROM%20tblChild%20p%0A%20inner%20join%20RESTORE.mhgroup.project_items%20s%20on%20s.prj_id%20%3D%20p.prj_id%0Awhere%20sid%20not%20in%20(select%20sid%20from%20PRODUCTION.mhgroup.project_items)%0AOPTION(MAXRECURSION%2032767)&#8221; message=&#8221;&#8221; highlight=&#8221;&#8221; provider=&#8221;manual&#8221;\/]<\/p>","protected":false},"excerpt":{"rendered":"<p>Folders can\u2019t be recovered but the files are still present so you can manually recreate the folder and search for the files in iManage and move them [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4461","post","type-post","status-publish","format-standard","hentry","category-research"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Folders can\u2019t be recovered but the files are still present so you can manually recreate the folder and search for the files in iManage and move them back into it. If your not sure all the files you can restore the database to find the old PRJ_ID of the folder then search for the files\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"paris\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/pariswells.com\/blog\/research\/how-to-restore-a-deleted-imanage-folder\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Welcome to Pariswells.com |\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"How to restore a deleted iManage Folder | Welcome to Pariswells.com\" \/>\n\t\t<meta property=\"og:description\" content=\"Folders can\u2019t be recovered but the files are still present so you can manually recreate the folder and search for the files in iManage and move them back into it. If your not sure all the files you can restore the database to find the old PRJ_ID of the folder then search for the files\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/pariswells.com\/blog\/research\/how-to-restore-a-deleted-imanage-folder\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-03-21T06:19:30+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-03-21T06:19:30+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"How to restore a deleted iManage Folder | Welcome to Pariswells.com\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Folders can\u2019t be recovered but the files are still present so you can manually recreate the folder and search for the files in iManage and move them back into it. If your not sure all the files you can restore the database to find the old PRJ_ID of the folder then search for the files\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/how-to-restore-a-deleted-imanage-folder#article\",\"name\":\"How to restore a deleted iManage Folder | Welcome to Pariswells.com\",\"headline\":\"How to restore a deleted iManage Folder\",\"author\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#organization\"},\"datePublished\":\"2020-03-21T06:19:30+00:00\",\"dateModified\":\"2020-03-21T06:19:30+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/how-to-restore-a-deleted-imanage-folder#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/how-to-restore-a-deleted-imanage-folder#webpage\"},\"articleSection\":\"Research\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/how-to-restore-a-deleted-imanage-folder#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pariswells.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/category\\\/research#listItem\",\"name\":\"Research\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/category\\\/research#listItem\",\"position\":2,\"name\":\"Research\",\"item\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/category\\\/research\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/how-to-restore-a-deleted-imanage-folder#listItem\",\"name\":\"How to restore a deleted iManage Folder\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/how-to-restore-a-deleted-imanage-folder#listItem\",\"position\":3,\"name\":\"How to restore a deleted iManage Folder\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/category\\\/research#listItem\",\"name\":\"Research\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#organization\",\"name\":\"Welcome to Pariswells.com\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris#author\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris\",\"name\":\"paris\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/how-to-restore-a-deleted-imanage-folder#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/93b8ee3f592ac401167f870452bd82d43de80152cd3524e2853403658ada9984?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"paris\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/how-to-restore-a-deleted-imanage-folder#webpage\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/how-to-restore-a-deleted-imanage-folder\",\"name\":\"How to restore a deleted iManage Folder | Welcome to Pariswells.com\",\"description\":\"Folders can\\u2019t be recovered but the files are still present so you can manually recreate the folder and search for the files in iManage and move them back into it. If your not sure all the files you can restore the database to find the old PRJ_ID of the folder then search for the files\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/how-to-restore-a-deleted-imanage-folder#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris#author\"},\"datePublished\":\"2020-03-21T06:19:30+00:00\",\"dateModified\":\"2020-03-21T06:19:30+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/\",\"name\":\"Welcome to Pariswells.com\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"How to restore a deleted iManage Folder | Welcome to Pariswells.com","description":"Folders can\u2019t be recovered but the files are still present so you can manually recreate the folder and search for the files in iManage and move them back into it. If your not sure all the files you can restore the database to find the old PRJ_ID of the folder then search for the files","canonical_url":"https:\/\/pariswells.com\/blog\/research\/how-to-restore-a-deleted-imanage-folder","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pariswells.com\/blog\/research\/how-to-restore-a-deleted-imanage-folder#article","name":"How to restore a deleted iManage Folder | Welcome to Pariswells.com","headline":"How to restore a deleted iManage Folder","author":{"@id":"https:\/\/pariswells.com\/blog\/author\/paris#author"},"publisher":{"@id":"https:\/\/pariswells.com\/blog\/#organization"},"datePublished":"2020-03-21T06:19:30+00:00","dateModified":"2020-03-21T06:19:30+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/pariswells.com\/blog\/research\/how-to-restore-a-deleted-imanage-folder#webpage"},"isPartOf":{"@id":"https:\/\/pariswells.com\/blog\/research\/how-to-restore-a-deleted-imanage-folder#webpage"},"articleSection":"Research"},{"@type":"BreadcrumbList","@id":"https:\/\/pariswells.com\/blog\/research\/how-to-restore-a-deleted-imanage-folder#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/pariswells.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/category\/research#listItem","name":"Research"}},{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/category\/research#listItem","position":2,"name":"Research","item":"https:\/\/pariswells.com\/blog\/category\/research","nextItem":{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/research\/how-to-restore-a-deleted-imanage-folder#listItem","name":"How to restore a deleted iManage Folder"},"previousItem":{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/research\/how-to-restore-a-deleted-imanage-folder#listItem","position":3,"name":"How to restore a deleted iManage Folder","previousItem":{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/category\/research#listItem","name":"Research"}}]},{"@type":"Organization","@id":"https:\/\/pariswells.com\/blog\/#organization","name":"Welcome to Pariswells.com","url":"https:\/\/pariswells.com\/blog\/"},{"@type":"Person","@id":"https:\/\/pariswells.com\/blog\/author\/paris#author","url":"https:\/\/pariswells.com\/blog\/author\/paris","name":"paris","image":{"@type":"ImageObject","@id":"https:\/\/pariswells.com\/blog\/research\/how-to-restore-a-deleted-imanage-folder#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/93b8ee3f592ac401167f870452bd82d43de80152cd3524e2853403658ada9984?s=96&d=mm&r=g","width":96,"height":96,"caption":"paris"}},{"@type":"WebPage","@id":"https:\/\/pariswells.com\/blog\/research\/how-to-restore-a-deleted-imanage-folder#webpage","url":"https:\/\/pariswells.com\/blog\/research\/how-to-restore-a-deleted-imanage-folder","name":"How to restore a deleted iManage Folder | Welcome to Pariswells.com","description":"Folders can\u2019t be recovered but the files are still present so you can manually recreate the folder and search for the files in iManage and move them back into it. If your not sure all the files you can restore the database to find the old PRJ_ID of the folder then search for the files","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/pariswells.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/pariswells.com\/blog\/research\/how-to-restore-a-deleted-imanage-folder#breadcrumblist"},"author":{"@id":"https:\/\/pariswells.com\/blog\/author\/paris#author"},"creator":{"@id":"https:\/\/pariswells.com\/blog\/author\/paris#author"},"datePublished":"2020-03-21T06:19:30+00:00","dateModified":"2020-03-21T06:19:30+00:00"},{"@type":"WebSite","@id":"https:\/\/pariswells.com\/blog\/#website","url":"https:\/\/pariswells.com\/blog\/","name":"Welcome to Pariswells.com","inLanguage":"en-US","publisher":{"@id":"https:\/\/pariswells.com\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"Welcome to Pariswells.com |","og:type":"article","og:title":"How to restore a deleted iManage Folder | Welcome to Pariswells.com","og:description":"Folders can\u2019t be recovered but the files are still present so you can manually recreate the folder and search for the files in iManage and move them back into it. If your not sure all the files you can restore the database to find the old PRJ_ID of the folder then search for the files","og:url":"https:\/\/pariswells.com\/blog\/research\/how-to-restore-a-deleted-imanage-folder","article:published_time":"2020-03-21T06:19:30+00:00","article:modified_time":"2020-03-21T06:19:30+00:00","twitter:card":"summary","twitter:title":"How to restore a deleted iManage Folder | Welcome to Pariswells.com","twitter:description":"Folders can\u2019t be recovered but the files are still present so you can manually recreate the folder and search for the files in iManage and move them back into it. If your not sure all the files you can restore the database to find the old PRJ_ID of the folder then search for the files"},"aioseo_meta_data":{"post_id":"4461","title":null,"description":null,"keywords":null,"keyphrases":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-21 05:28:51","updated":"2022-09-16 18:30:09","primary_term":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/pariswells.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/pariswells.com\/blog\/category\/research\" title=\"Research\">Research<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tHow to restore a deleted iManage Folder\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/pariswells.com\/blog"},{"label":"Research","link":"https:\/\/pariswells.com\/blog\/category\/research"},{"label":"How to restore a deleted iManage Folder","link":"https:\/\/pariswells.com\/blog\/research\/how-to-restore-a-deleted-imanage-folder"}],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/4461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=4461"}],"version-history":[{"count":1,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/4461\/revisions"}],"predecessor-version":[{"id":4462,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/4461\/revisions\/4462"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=4461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=4461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=4461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}