Quickly export multiple Projects November 17, 2008Posted by Duncan in PeopleTools.
It can be a good idea to frequently take flat-file backups of your App Designer Projects, depending upon how reliable the infrastructure is at your site, and how frequently environments get refreshed from Production. I’ve often thought “I wish that there was a shortcut for this procedure”, but have never done anything about it.
Now I’m not awfully keen on automating migration between environments (I like to run the compare reports and set the flags myself immediately before migration) but the exporting of projects caught my eye.
Using the same command line we can create a batch file that’ll loop through a list of projects and export them – one at a time – into a directory of your choosing.
Create a file in the same directory as the batch file with a list of the projects you wish to export (one on each line) named project_list.txt. Then run the following batch file:
FOR /F %%a IN (project_list.txt) DO %pside% -HIDE -PJTF %%a -FP %export_path% -CT %dbtype% -CO %user% -CP %pwd% -CD %srcdb% -QUIET -AF 0 -DDL 1 -PPL 0 -CFD 0 -CFF 0 -LF %export_path%%%a.log
Update: 2nd Feb
Anyone having the same issue as Jeff in the comments (where your project flags are set incorrectly and as a result the project gets copied, but not the objects) can set the flags via SQL.
SET COPYDONE = 0, TAKEACTION = 1
WHERE PROJECTNAME = ”;
One extra note, when you run the above SQL the results aren’t always immediately visible in App Designer. Sometimes I’ve had to shut it and re-open, and sometimes I’ve had to clear the cache also.