Focal Point
Move Report to a different folder instead of copy?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5591049472

March 07, 2008, 07:07 AM
Jinx
Move Report to a different folder instead of copy?
Hi All,

Does anyone know of a way to move a report to a different folder within WebFOCUS Developer studio. Currently one has to copy the report to the new folder, this then changes the report ID etc and I therefore have alter each shedule in report caster to point at the new report location - and there are then two copies of the same report. It would be much easier if there was a way to actaully move the whole report...

Hope this makes sense! Any help would be most appreciated!

K.


7.6.11
Windows
HTML, PDF, Excel etc
DevStudio/Webfocus/Focus IBM
SQL Server 2000 / 2008
DB2
March 07, 2008, 09:23 AM
GinnyJakes
Not from Data Servers.

If you are local deployment, you can show the desktop on your explorer tree and do a cut and paste. Or you can go to an operating system prompt or explorer and do the cut-and-paste or move command.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
March 10, 2008, 12:14 PM
Darin Lee
In either case, you're going to have to change the location in ReportCaster. It internally keeps the location and procedure name. Even if the name were kept the same, if you move it to a new folder, ReportCaster would not find it until you manually update the schedule specifying the new location.

My method (which is manual) for moving fexes when I need the name to stay the same is to open the fex in the editor, Select all and copy (Ctrl+A, Ctrl+C), then go to your new folder, create a new procedure with giving it your specific name open it in text editor and paste. This way it gets named what you want. If you drag and drop or copy and paste a fex, it might get the same name, but not always, as you have discovered.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
March 10, 2008, 12:26 PM
Jinx
Thanks! No easy way out then, what a a pity. Smiler


7.6.11
Windows
HTML, PDF, Excel etc
DevStudio/Webfocus/Focus IBM
SQL Server 2000 / 2008
DB2
March 10, 2008, 04:33 PM
Trav
Are you talking about within the MRE? If so, then you can manually modify the html file for the domain you're working with. This will allow you to move items from one folder/group to another folder/group within MRE w/o losing the actual fex name. To find the html file, in Dev Studio, right click on the domain folder and click properties. You should see an 'HREF' line there that gives you a folder and HTML file name. The location of that folder/filename is on your server: c:\ibi\WebFOCUS71\basedir\xxxx\xxxx.htm

By the way, modify at your own risk!! And make a backup!! However, we just did this today with no ill effects. If you look in there you can probably figure out the structure. There will be an anchor tag for each folder and a line for each fex/html file in that folder. Cut the lines from the old folder's anchor tag and paste them into the new one. Save, and then go back and refresh dev studio. You should see the changes. Keep in mind that your HTML layouts in dev studio have the folder names embedded in the code -- you would have to do a search and replace on those to get the new folder name. This might seem like a lot of work too -- but there are times when I really want to avoid having new fex names and this is the way to do it.

If you have any views on the dashboard that point to those fexes/layouts, you'll have to fix those. There is probably a file for that, but I didn't bother to figure that out because fixing the view is relatively painless.

For ReportCaster, you may have to update your tasks/schedules too. I see in the BOTTASK table there is a FOLDERHREF column -- I'd be willing to bet you could just update that column too and probably be in good shape. That's untested though -- so again, modify at your own risk!

Good luck!



Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF