For #1833656: Move content moderation queues out of Webmasters to separate project and #1706492: Cleaning up list of Components in Webmasters project we need an sql script to move part of issues out of Webmasters queue and rename some Webmasters queue components.
Example of similar script can be found here: #1666886: Please help with renaming components of existing issues

Issues to be moved:

1. From Webmasters to Content

http://drupal.org/project/webmasters
http://drupal.org/project/content
components
Content moderation -> Other
Drupal books -> Books listing
Front page promotion -> Front page promotion
Planet Drupal -> Planet Drupal
Marketplace listing -> Services listing
Drupal training list -> Training listing

2. From Webmasters to L.d.o

http://drupal.org/project/webmasters
http://drupal.org/project/localizedrupalorg
components:
Localize.drupal.org -> Miscellaneous

3. Webmasters to Webmasters

components:
Project problem -> Project/Git problem

4. Orphaned issues in Webmasters (which have components different from the current):

Drupal services, Drupal service list -> Content: Services listing
User account problem -> User account
Drupal Planet -> Planet Drupal
Webmasters: Groups.drupal.org -> Groups.drupal.org: Other
Webmasters: Project applications -> Project applications: other
The rest of orphaned issues -> Other

TO-DOs after script run:
1. Delete components from Webmasters: Content moderation, Drupal books, Front page promotion, Planet Drupal, Marketplace listing, Drupal training list, Localize.drupal.org
2. Rename Webmasters component Project problem to Project/Git problem

Postponed: Webmasters to Assoc.d.o

http://drupal.org/project/webmasters
http://drupal.org/project/association_drupalorg
components:
Association.drupal.org -> Other

CommentFileSizeAuthor
#2 1848862-issues.zip738 bytestvn

Comments

tvn’s picture

Assigned: Unassigned » tvn

Working on this

tvn’s picture

Issue summary: View changes

.

tvn’s picture

Issue summary: View changes

.

tvn’s picture

Issue summary: View changes

.

tvn’s picture

Status: Active » Needs review
StatusFileSize
new738 bytes

Script attached. It moves issues as listed in the steps 1-4 of the issue summary. Tested on d.o dev site and it worked fine. (Though dev site does not display all the issues in project/issues/x lists, which is probably supposed to be so).

tvn’s picture

Component: Project problem » Project/Git problem
Status: Needs review » Fixed

The script was also tested on the staging site, and killes ran it just now on Drupal.org

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Anonymous’s picture

Issue summary: View changes

.