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 and
yes, this seems to be the right way.
On Sep 16, 10:40 am, Emily Stange <[email protected]> wrote:
> Hi Kim/Kelly,
>
> I think this would be a great conversation to get feedback from R&D. Posting
> a topic in the SolEx forum would ensure that you get feedback from OpenText
> employees who don't regularly visit this group (Jian =).
>
> -Emily
>
> On Fri, Sep 16, 2011 at 2:39 AM, Markus Giesen <[email protected]>wrote:
>
>
>
>
>
>
>
> > I like shortcuts and this is certainly a time saver if you know
> > exactly what you're doing, thanks Kelly!
>
> > However, from what I know this would make your RedDot installation
> > warranty invalid.
> > In other words: Touch the database and you'll lose the warranty for
> > OpenText CMS.
>
> > I can understand that it may seem like a good idea doing this but you
> > never know what happens in the background in other columns in the DB
> > and I've seen projects disintegrate over time because they have been
> > changed in the database directly.
>
> > Hearing the opinion of an RedDot engineer from the R&D team would be
> > good on this.
>
> > On Sep 13, 8:45 am, Jian Huang <[email protected]> wrote:
> > > 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 fromhttp://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.
--
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.
