Hi Ray,
Sorry, I was away for a couple of days. Yes, you can do a bulk move of folder
contents with sql:
1) Find the folder primary keys for the source and destination folders with the
user interface. For example, when the url says folder=123, then 123 is the
folder_pk. For this example, let's say your source folder key is 10 and your
destination folder key is 20.
2) Move ALL the uploads the source folder to the destination folder:
update foldercontents set parent_fk=20 where parent_fk=10 and
foldercontents_mode=2;
Bob Gobeille
On Jun 23, 2011, at 9:43 AM, Westphal, Raymond W wrote:
> Thanks Mary.
>
> Is there a bulk method? Something like a sql update to a table indicating the
> new folder?
>
> Thanks,
>
> Ray W.
>
> From: Laser, Mary [mailto:mary.la...@hp.com]
> Sent: Thursday, June 23, 2011 10:35 AM
> To: Westphal, Raymond W; 'fossology@fossology.org'
> Subject: RE: Move Folder Contents
>
> Oops! You’re right.
> I should have said “Organize -> Uploads -> Move”
>
> From: Westphal, Raymond W [mailto:raymond.w.westp...@ehi.com]
> Sent: Thursday, June 23, 2011 9:34 AM
> To: Laser, Mary; 'fossology@fossology.org'
> Subject: RE: Move Folder Contents
>
> Oh - I thought that moved the entire folder.
>
> Thanks,
>
> Ray W.
>
> From: Laser, Mary [mailto:mary.la...@hp.com]
> Sent: Thursday, June 23, 2011 10:29 AM
> To: Westphal, Raymond W; 'fossology@fossology.org'
> Subject: RE: Move Folder Contents
>
> Yes, use the “Organize -> Folders -> Move” menu.
>
> Mary
>
> From: fossology-boun...@fossology.org
> [mailto:fossology-boun...@fossology.org] On Behalf OfWestphal, Raymond W
> Sent: Thursday, June 23, 2011 5:30 AM
> To: 'fossology@fossology.org'
> Subject: [FOSSology] Move Folder Contents
> Importance: High
>
> Good Morning Everyone.
>
> My users would like to know if folder contents can be moved into another
> folder. They recently created another folder in order to organize and prepare
> for cleanup of the repository. They now want the remaining uploads to be
> located in that single new folder.
>
> Thanks,
>
> Ray W.
>
>
>
> CONFIDENTIALITY NOTICE: This e-mail and any files transmitted with it are
> intended solely for the use of the individual or entity to whom they are
> addressed and may contain confidential and privileged information protected
> by law. If you received this e-mail in error, any review, use, dissemination,
> distribution, or copying of the e-mail is strictly prohibited. Please notify
> the sender immediately by return e-mail and delete all copies from your
> system.
>
> <ATT00001..txt>
_______________________________________________
fossology mailing list
fossology@fossology.org
http://fossology.org/mailman/listinfo/fossology
