{"id":608,"date":"2020-10-28T09:13:26","date_gmt":"2020-10-28T16:13:26","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/?p=608"},"modified":"2020-10-28T10:16:24","modified_gmt":"2020-10-28T17:16:24","slug":"migrating-the-ephesoft-sharedfolders-location","status":"publish","type":"post","link":"https:\/\/ephesoft.com\/docs\/migrating-the-ephesoft-sharedfolders-location\/","title":{"rendered":"Migrating the Ephesoft SharedFolders Location"},"content":{"rendered":"
Applies to:\u00a0<\/strong>Ephesoft Transact 4.x and above<\/span><\/p>\n This page provides instructions on how to migrate your Ephesoft SharedFolders location to a different path, either Network or Local.<\/span><\/p>\n Update all batch classes listed in the “batch_class” Table. Use a similar SQL Statement as the one below to update each batch class record:<\/span><\/p>\n Note:<\/b>\u00a0You will need to update each record.<\/span><\/p>\n Use similar SQL Statements to the ones below to update each Batch Instance record:<\/span><\/p>\n Note:<\/b>\u00a0We have to run this query for all the UNC subfolders present inside the UNC folder. If you do not update this table, you must make sure that all batch instances are in the FINISHED or DELETED State.<\/span><\/p>\n Update HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\Temp\\Ephesoft Windows registry information with the new SharedFolders location. This will ensure future upgrades will be performed correctly.<\/span><\/p>\n Depending on your database application, you may also need to update the default DB property files, located at [Ephesoft_Directory]<\/em>\\Application\\WEB-INF\\classes\\META-INF\\dcma-data-access. This includes either the MSSQL <\/strong>or MYSQL <\/strong>folder.<\/span><\/p>\n For a local disk, you can use something like “C:\\\\Folder\\\\Path”<\/span><\/p>\n Note:<\/b>\u00a0Mapped network drives will not work with Ephesoft. For drive letter format, only local disks are supported.<\/span><\/p>\n You may also need to update the following settings and files:<\/span><\/p>\n
\nUpdate Property Files<\/strong><\/span><\/h2>\n
\n
Line 28: plugin_upload_folder_path=\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\/plugin-upload-folder\r\n<\/span><\/pre>\n
\n
Line 1: batch.base_folder=\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\r\n Line 2: batch.local_folder=\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\/ephesoft-system-folder\r\n Line 4: batch.export_folder=\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\/final-drop-folder\r\n Line 17: batch.export_import_folder=\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\/export-batch-folder\r\n Line 24: batch.test_folder=\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\/ephesoft-test-data\r\n<\/span><\/pre>\n
\n
Line 17: upgradePatch.folder=\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\/database-update\r\n<\/span><\/pre>\n
\n
Line 1: backup.local_folder=\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\/ephesoft-system-folder\r\n Line 8: backup.report_folder=\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\/report-data\r\n<\/span><\/pre>\n
\n
Line 15: newWorkflows.basePath=\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\/workflows\r\n<\/span><\/pre>\n
\n
Line 1: reportdata.path=\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\/report-data\r\n<\/span><\/pre>\n<\/div>\n
\n
Line 156: <Context path=\"\/dcma-batches\" docBase=\"\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\" debug=\"10\" privileged=\"false\"\/><\/span><\/pre>\n
\n
Line 23: SavedAnalysisGridFolder=\"\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\\SavedAnalysisGrid\"<\/span><\/pre>\n
Line 65: DashboardSaveFile=\"\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\\SavedDashboards\\Dashboard_User_@Session.userName~.xml\"<\/span><\/pre>\n
\n
Line 23: SavedAnalysisGridFolder=\"\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\\SavedAnalysisGrid\"<\/span><\/pre>\n
Line 62: DashboardSaveFile=\"\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\\SavedDashboards\\Dashboard_User_@Session.userName~.xml\"<\/span><\/pre>\n
\n
Line 19: SaveFile=\"\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\\SavedDashboards\\Dashboard_User_@Session.userName~.xml\"<\/span><\/pre>\n
\n
Line 140: XMLFile=\"\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\\SavedDashboards\\Dashboard_User_@Session.userName~.xml\" \/><\/span><\/pre>\n
\nUpdate the Ephesoft Application Database<\/b><\/span><\/h2>\n
UPDATE batch_class SET unc_folder = Replace(unc_folder, '\\\\\\\\OLD_UNC_PATH\\\\SharedFolders', '\\\\\\\\NEW_UNC_PATH\\\\SharedFolders')WHERE local_folder LIKE '%SharedFolders%';\r\n<\/span><\/pre>\n
\nUpdate the batch_instance table with the New SharedFolders Location.<\/b><\/span><\/h2>\n
UPDATE batch_instance SET local_folder='\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\\\\ephesoft-system-folder';\r\n UPDATE batch_instance SET unc_subfolder = Replace(unc_subfolder, '\\\\\\\\OLD_UNC_PATH\\\\SharedFolders', '\\\\\\\\NEW_UNC_PATH\\\\SharedFolders' WHERE local_folder LIKE '%SharedFolders%');\r\n<\/span><\/pre>\n
\nUpdate Windows Registry Information<\/span><\/h2>\n
\nAdditional Configurations<\/span><\/h2>\n
\n
Line 16: upgradePatch.folder=\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\/database-update\r\n<\/span><\/pre>\n
\n
Line 26: upgradePatch.folder=\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\/database-update\r\n<\/span><\/pre>\n
\n
Line 150: update batch_class set unc_folder='\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\\\\mailroom-import' where batch_class_name='MailroomAutomationTemplate';\r\n Line 151: update batch_class set unc_folder='\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\\\\searchablepdf-import' where batch_class_name='SearchablePDFTemplate';\r\n Line 152: update batch_class set unc_folder='\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\\\\grid-computing-import' where batch_class_name='GridComputingTemplate';\r\n Line 156: update batch_class_plugin_config set batch_class_plugin_config.plugin_config_value='\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\\\\final-drop-folder' \r\n Line 164: update batch_class_plugin_config set batch_class_plugin_config.plugin_config_value='\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\\\\csv-export-folder' \r\n Line 172: update batch_class_plugin_config set batch_class_plugin_config.plugin_config_value='\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\\\\ibm-cm-export-folder' \r\n Line 180: update batch_class_plugin_config set batch_class_plugin_config.plugin_config_value='\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\\\\export-script.properties' \r\n Line 188: update batch_class_plugin_config set batch_class_plugin_config.plugin_config_value='\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\\\\tabbed-pdf-export-folder' \r\n Line 196: update batch_class_plugin_config set batch_class_plugin_config.plugin_config_value='\\\\\\\\NEW_UNC_PATH\\\\SharedFolders\\\\NSI-export-folder' \r\n<\/span><\/pre>\n
\n
\n