On Thu, Mar 15, 2012 at 8:59 PM, Roberto Galoppini <[email protected]> wrote: > On Thu, Mar 15, 2012 at 8:40 PM, Rob Weir <[email protected]> wrote: >> On Thu, Mar 15, 2012 at 3:21 PM, TJ Frazier <[email protected]> wrote: >>> On 3/15/2012 15:10, Rob Weir wrote: >>>> >>>> On Thu, Mar 15, 2012 at 3:07 PM, Roberto Galoppini<[email protected]> >>>> wrote: >>>>> >>>>> On Thu, Mar 15, 2012 at 5:08 PM, Rob Weir<[email protected]> wrote: >>>>>> >>>>>> On Thu, Mar 15, 2012 at 11:33 AM, Roberto Galoppini<[email protected]> >>>>>> wrote: >>>>>>> >>>>>>> On Wed, Mar 14, 2012 at 10:09 PM, Rob Weir<[email protected]> wrote: >>>>>> >>>>>> >>>>>> <snip> >>>>>> >>>>>>>> >>>>>>>> Sure.. What do you want me to add to that post? Are there some >>>>>>>> specific instructions? >>>>>>>> >>>>>>>> -Rob >>>>>>> >>>>>>> >>>>>>> >>>>>>> We might instruct users that to convert their accounts they just need >>>>>>> to enter their openoffice.org username and password and ask them to >>>>>>> read the messages shown. If they do not remember the password, the >>>>>>> link "Request new password" pages >>>>>>> http://extensions.services.openoffice.org/user >>>>>>> http://templates.services.openoffice.org/user >>>>>>> allows them to receive a link to change e-mail address and password >>>>>>> (note that the two websites use different logins). >>>>>>> >>>>>>> Note that the "request new password" will work until the >>>>>>> @openoffice.org alias will be active. >>>>>>> Last but not least, the possibility to use the old password will work >>>>>>> until the Oracle authentication server is operational. >>>>>>> >>>>>>> VERY IMPORTANT: Consider that both kiling the alias forwarding and >>>>>>> shutting down the Oracle authentication server will prevent users to >>>>>>> login. I hope we can keep alive at least one of those services at >>>>>>> least until we'll get from Oracle all necessary information to migrate >>>>>>> users. >>>>>>> >>>>>> >>>>>> OK. I updated the blog post here: >>>>>> https://blogs.apache.org/OOo/entry/retirement_of_openoffice_org_email >>>>>> >>>>>> But note that there is no guarantee that the announcement list reaches >>>>>> all of those people who have accounts on the extensions or templates >>>>>> website. >>>>>> >>>>>> Is there another list that can be used to contact them? Or is it >>>>>> possible to extract the names of the extension/template owners from >>>>>> the DB and send them an administrative note about the migration? >>>>> >>>>> >>>>> Of course we can do that, but maybe the PPMC doesn't want to send out >>>>> a message to 40k persons while actually only a tiny fraction of them >>>>> are or have been active users of the Extensions or Templates website. >>>>> What do you think? >>>>> >>>> >>>> Right. I was hoping there was a way to send an email to only those >>>> users who have published an extension or template. >>>> >>>> -Rob >>> >>> >>> Fortunately, the extension publishers usually have a website listing in >>> their descriptions. If any of those have an oo.o address, we can deal with >>> them slowly and individually. >>> >> >> So there is no way to navigate, using DB queries, temporary tables, >> etc., from extensions artifacts to the owning account to the email >> address for the owning account? > > Yes, we can definitely do that, but if we work out the right queries > to find the active ones do we have time to contact them via their > @openoffice.org accounts? If not the only available option seems to be > to wait for the email list, as mentioned by Andrew below.
We have been working on some queries, see below for results: Extensions: - Members: 11,717 (actual 11406, the others are some blocked and excluded because of previous spam activities) - Users with content: 504 (188 local, 316 to be migrated) - Members with comments: 1541 (881 local, 660 to be migrated) - Users that have migrated: 30 - Customer data: the set union of the 316 users with content and the 660 with comments Templates: - Members: 28020 (actual 27951, the others are blocked and excluded because of previous spam activities) - Users with content: 635 (4 rooms, 631 to be migrated) - Members with comments: 506 (0 local, 506 to be migrated) - Users that have migrated: 5 - Customer data: the set union of the 631 users with content and the 506 with comments We plan to send them in the very next hours a message like the following, if you have any feedback or suggestion please send them asap, since Oracle will kill the alias forwarding within today. Subject: Instructions about how to retain access to the OpenOffice Extensions/Templates website Dear OpenOffice.org Extensions/Templates user, As you may have heard, Oracle contributed the OpenOffice.org (OOo) code to Apache in June 2011. As part of this move, we are about to loose access to the servers that formerly hosted the OpenOffice.org website and various other online services associated with the project, included the Extensions/Templates websites. Since SourceForge is currently hosting the Extensions/Templates website, in collaboration with the Apache OpenOffice community we are working to help you to smoothly retain full control over your existing Extensions/Templates credentials. Below you'll find a temporary unique link you can use to access your account at the Extensions/Templates website. If you want to be sure this is not a phishing attack, we suggest you to read all the news about the Retirement of OpenOffice.org emails at the Apache blog <https://blogs.apache.org/OOo/entry/retirement_of_openoffice_org_email>. <UNIQUE LINK> Whatever was your role at the OpenOffice.org community, we'd like to say thank you for your past contributions, and we look forward to see you help also the Apache OpenOffice community to succeed. The SourceForge Team > Roberto > >> >>> /tj/ >>> >>>> >>>>>> Do you have any metrics on what % of accounts have converted? >>>>> >>>>> >>>>> Extensions: about 12k users, few hundreds have a published content, a >>>>> dozen or two have converted. >>>>> Templates: about 28k users, few hundreds have a published content, a >>>>> dozen or two have converted. >>>>> >>>>> Roberto >>>>> >>>>>> -Rob >>>>>> >>>>>>> Roberto ==== This e- mail message is intended only for the named recipient(s) above. It may contain confidential and privileged information. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying of this e-mail and any attachment(s) is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by replying to this e-mail and delete the message and any attachment(s) from your system. Thank you.
