Kelly, as usual, another quality post. Just want to mention an alternate solution using existing tool without DB access and possibly voiding warranty.
Download RQLConsole from http://www.solutionexchange.info/RQLConsole.htm Import, activate, and assign plugin to project. Use this RQL to list all File folders (File folders and Asset Manager). 530.htm from RQL Documentation has more information. <PROJECT> <FOLDERS action="list" foldertype="0" /> </PROJECT> Copy the RQL results into Notepad++ to extract folder GUIDs Repeat the following code for N folder GUIDs <PROJECT> <FOLDER action="save" guid="[!guid_folder!]" name="" path="[!path_folder!]" /> </PROJECT> Paste all of the code into RQLConsole. Yes, RQL can run in batch. On Sep 12, 6:02 pm, Kelly <[email protected]> wrote: > I should add this is in Management Server 10.1 SP2. > > On Sep 12, 5:00 pm, Kelly <[email protected]> wrote: > > > > > > > > > Just passing this on if helpful: the quickest way to update all your > > Asset Manager paths - globally across your project- is definitely to > > update the path within the database directly. I was able to update > > about 100+ asset manager folders in 10-15 minutes total. It would > > have taken me much much longer had I used the reddot smart tree > > interface. > > > To do so, you must have access to your database (I'd suggest backing > > it up first of course!). > > > Under your PROJECT_NAME database, look for the table called IO_FDR. > > > The column "FDR8" within IO_FDR table holds the asset manager path for > > every asset manager folder in that project. > > > A query like this will let you line up the FDR8 column neatly and do a > > quick copy/paste replace on each entry within SQL: > > > SELECT TOP (200) FDR0, FDR1, FDR2, FDR3, FDR4, FDR5, FDR6, FDR7, > > FDR8, FDR9, FDR10, FDR11, FDR12, FDR13, FDR14, FDR15, FDR16, FDR17 > > FROM IO_FDR > > ORDER BY FDR8 > > > I'm sure there's a query that would spare us the tedious manual copy/ > > paste replace job here but I was too lazy to write one :) > > > At any rate, it saved a good deal of time off updating every folder > > via the RedDot Interface. > > > HTH, > > Kelly -- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/reddot-cms-users?hl=en.
