Changing the folder names of all the files in my repository
Article ID: 371904
Updated On:
Products
Issue/Introduction
My project is moving to the cloud and we want the folder names in the project's repository in Harvest to reflect the new folder names in the project's new location. How can this be done?
Environment
Harvest Software Change Manager all versions
Resolution
There is no need to change anything with the folder structure inside the Harvest repository. The goal is to move the deployment locations (where files are checked out) to a new server and new network share name, which only affects the Check In process (From: field) and Check Out process (To: field) in Harvest, as well as any UDP scripts that perform checkins or checkouts.
You shoud review existing UDP scripts, making a plan for any changes needed to those, and communicate with the users about the new deployment server and mapped network share name so they can be using the right location after the switch.
I also recommended that before the switch, all users should have all files checked in. Then when the switch is done they can check out to the new location.
A database SQL query can be used to get a list of all files checked out across all projects. This can be used before the server move to confirm all files have been checked in.
SELECT ENVIRONMENTNAME, PACKAGENAME, PATHFULLNAME, ITEMNAME, MAPPEDVERSION, VERSIONSTATUS, REALNAME, USERNAME
FROM HARVERSIONS
INNER JOIN HARUSER ON HARVERSIONs.CREATORID = HARUSER.USROBJID
INNER JOIN HARITEMNAME ON HARVERSIONS.ITEMNAMEID = HARITEMNAME.NAMEOBJID
INNER JOIN HARPATHFULLNAME ON HARVERSIONS.PATHVERSIONID = HARPATHFULLNAME.VERSIONOBJID
INNER JOIN HARPACKAGE ON HARVERSIONS.PACKAGEOBJID = HARPACKAGE.PACKAGEOBJID
INNER JOIN HARENVIRONMENT ON HARPACKAGE.ENVOBJID = HARENVIRONMENT.ENVOBJID
WHERE PACKAGENAME != 'BASE' AND
VERSIONSTATUS = 'R'
Feedback
