User talk:Mpaa

From Wikisource
Jump to: navigation, search

(Archives index, Last archive) Welcome

Hello, Mpaa, and welcome to Wikisource! Thank you for joining the project. I hope you like the place and decide to stay. Here are a few good links for newcomers:

Carl Spitzweg 021-detail.jpg

You may be interested in participating in

Add the code {{active projects}}, {{PotM}} or {{CotW}} to your page for current wikisource projects.

You can put a brief description of your interests on your user page and contributions to another Wikimedia project, such as Wikipedia and Commons.

I hope you enjoy contributing to Wikisource, the library that is free for everyone to use! In discussions, please "sign" your comments using four tildes (~~~~); this will automatically produce your IP address (or username if you're logged in) and the date. If you need help, ask me on my talk page, or ask your question here (click edit) and place {{helpme}} before your question.

Again, welcome! — billinghurst sDrewth 12:00, 7 April 2011 (UTC)

PSM Volume 17[edit]

Many thanks for your help in cleaning up this and the previous volumes.— Ineuw talk

Hi, I've just finished proofreading Volume 25. So much easier with your clean-up, compared to Volume 24. Is there any chance you could do your wizardry on further volumes? Cheers, Zoeannl (talk) 11:47, 27 October 2014 (UTC)

Thanks, happy to know it was useful. I'll try. Not in the short term though.--Mpaa (talk) 14:27, 27 October 2014 (UTC)
BTW, Vol 28 is cleaned up already, if you are interested.--Mpaa (talk) 19:36, 28 October 2014 (UTC)
And Vol 29 on its way.--Mpaa (talk) 21:08, 28 October 2014 (UTC)

Output of archiving[edit]

Processing [[en:User talk:Mpaa]]
36 Threads found on [[en:User talk:Mpaa]]
Looking for: {{User:Wikisource-bot/config}} in [[en:User talk:Mpaa]]
Processing 36 threads
Archiving 31 thread(s).
Page [[User talk:Mpaa/Archives/2013]] saved
Page [[User talk:Mpaa/Archives/2014]] saved
Page [[User talk:Mpaa]] saved

billinghurst sDrewth 16:02, 1 September 2014 (UTC)

Thanks for help on Creole Sketches![edit]

Hi, as you may or may not have noticed, Creole Sketches is my first wikisource project, so I'm learning on the job, and any help and advice is welcome. My understanding of where it's at: it looks to me like pages 88-89, 106, and 168-9 are missing from the deja-vu file I imported from the Internet archive. In addition pp. 38-39 and 16-17 are scanned twice in the source file. If you can point me at the procedure for fixing errors in the underlying source file that would be appreciated, in particular for how to insert the missing pages (I think someone has modified the page index file to fix the duplicates problems). Any other advice about learning as I go is of course appreciated. Also, if this kind of help isn't your kind of thing, just let me know. Thanks, Dictioneer (talk) 03:02, 11 September 2014 (UTC)

Hi. You need to highlight the errors present in the pagination of the djvu file (in the Index page is a good place). And look for a replacement of missing pages from a scan of the same edition (possibly). Then, you need to ask in Scriptorium/Help for someone to fix the underlying djvu file for you. If we do not fix/swap the djvu, there is not much we can do.--Mpaa (talk) 11:54, 11 September 2014 (UTC)
Thanks for the advice on fixing the index, and from what I can tell from the index page, thanks for doing some of it too! Your summary of the errors is close to mine, however I note that you shift between numbering schemes in specifying duplicate pages (djvu file names) versus missing pages (page number from the book). To clarify, I believe page 107 from the book is missing from the djvu file, as are book pages 88-89 and 168-169. Since I think one has to redo the whole numbering scheme when you insert / delete pages, I just wanted to make sure we agree that I'm tracking down the right page images from the book to insert into the file.
Another user, ShakespeareFan00, put me on the trail of the djvulibre tools, and it looks like I can run a script that will (attempt to) convert a jpg image into a djvu page. Once I've got those individual djvu files (107, 88-89, and 168-169), if I understand you correctly, at that point I go to the village scriptorium and ask for help in fixing the file itself. If you think I'm doing this in the right order, let me know, or warn me before I go creating unnecessary work for myself and innocent bystanders. In any case, thanks for what you've already done, I greatly appreciate it. Dictioneer (talk) 18:23, 11 September 2014 (UTC)
OK, you are one step ahead. If you will use djvulibre, you can use it to delete duplicate pages and insert new pages in the djvu file. At that point, no need to ask for extra help, you can reupload to Commons the new djvu file version.
Note that Pages/xx can be moved, so you will not lose work already done. You need to tell me what will change from the old numbering to the new.
Example: assume that you will delete Page/48 and Page/49 -> Page/50 and following will have to be moved down by 2.
Example (fake): assume that you will insert 2 before Page/90 -> Page/90 and following will have to be moved up by 2.
But you are performing several changes at the same time, insertion and deletion, you need to be careful and tell me the net effect on a given range, as it might be that in the end one page is not moved at all. In my example: Page/50 to Page/89 will be moved down by 2 becoming Page/48 ... Page/87, 2 new pages will be inserted as Page/88 and Page /89, and Page/90 will stay as it is now.
All I need is: range [x:y] to be moved +/- N pages.
A bit complex, hope I explained myself clearly enough ... but easier done than said :-)--Mpaa (talk) 20:21, 11 September 2014 (UTC)
All right, I think we are ready to go. I have created a new djvu file using the utilities, deleting the duplicated pages 16-17 (book numbering) and 38-39 (book) in the original file, and inserting missing pages 88-89, 107, and 168-169 (all book numbering). If I understand you correctly, you need to know the djvu file numbering, using the file numbers appearing for each indexed page. So, for example, the (first) page 16 points at djvu file number 46, 17 at 47; then the second index page 16 points at file number 48, second 17 points at file number 49 -- these two files (48 & 49) are what need to be deleted and replaced with the renumbered file names.
Assuming the above assumption is correct, here goes: djvu file pages 1-47 are unchanged, 48-49 are deleted, and range [50:71] are moved -2 pages; next, pages 72-73 are deleted, and file range [74:121] are moved -4 pages. Then, insert two pages after (new) 117, so that range [122:138] is moved -2 pages. Now, insert a page after (new) 136, and range [139:198] is moved -1 page. Finally, insert two pages after (new) 197, and range [198:230] is moved +1 page. Now, buy yourself a drink, you deserve it!
Assuming the above makes sense, a chicken / egg question: do I upload the revised djvu file to Commons before or after you make these changes? I will upload the corrected file whenever you specify. I hope I've understood your instructions correctly, and thanks for your help on this. Dictioneer (talk) 21:42, 12 September 2014 (UTC)
Before. So I can check that my moves are consistent with the new file. Bye--Mpaa (talk) 22:59, 12 September 2014 (UTC)
Ok, it's uploaded to Commons. Let me know if you need anything else or find a problem. Thanks, Dictioneer (talk) 00:04, 13 September 2014 (UTC)
Done. One thing.Next time, if available, do not forget the text layer in the djvu file. Now they are empty. So you need to copy&paste from somewhere (the text of the scan from where you toook the pages should have them) or type the manually. Bye--Mpaa (talk) 09:59, 13 September 2014 (UTC)
Great, the new file syncs up perfectly! ShakespeareFan00 was kind enough to type in the missing text on the inserted pages, so I believe I'm getting quite a way along to getting this book ready for... well, whatever happens next! :) Thanks for helping a newbie, I would have been stuck without you. Dictioneer (talk) 19:05, 13 September 2014 (UTC)
Welcome. BTW, mark your ages as Proofread once done. See what ShakFan and myself have done, esp. on headings, etc.Bye--Mpaa (talk) 20:42, 13 September 2014 (UTC)

A list request - if possible[edit]

Would it be possible to get a list of the last date when these works were last proofread/validated? I am cleaning up the list, and would like to append the YYYY-MM of the these dates. Perhaps this would help move the works. There may be some works that have been validated, two were found already and moved off the list. Please ignore the PSM volumes. They are being proofread (mostly) in volume order. — Ineuw talk 20:33, 12 September 2014 (UTC)


Is it possible to set up archiving on this for completed requests? ShakespeareFan00 (talk) 18:47, 14 September 2014 (UTC)

No, archive is based on timestamp only. It can't differentiate on anything else. If something stays unanswered for long, it will be archived anyhow.--Mpaa (talk) 22:48, 14 September 2014 (UTC)
That's fine, Next question, can archiving be set up for this page?ShakespeareFan00 (talk) 00:26, 15 September 2014 (UTC)
Yes, copy the template from top of this page and adjust settings as needed.--Mpaa (talk) 07:36, 15 September 2014 (UTC)
Done, I think.ShakespeareFan00 (talk) 17:11, 15 September 2014 (UTC)

Index:Hillsborough Taylor Interim Report Cm765.pdf[edit]

Can I ask you to do one of two things ? (i) do some legwork to find-out the (C) status of the included images (marked as problematic)

(ii) Redact the scans of the relevant pages

I've marked the relevant pages as problematic.


BTW The following may contain other material that could help trace the status :

ShakespeareFan00 (talk) 21:31, 15 September 2014 (UTC)

I am no expert in (c) status. If you have questions, post them at Wikisource:Copyright violations.
Regarding images, I do not have the right tools installed on my current laptop. Post a request at Scriptorium/Help.--Mpaa (talk) 22:41, 15 September 2014 (UTC)

Index:Hutton, William Holden - Hampton Court (1897).djvu[edit]

Hi, can I leave the contents page and book "index" of this work with you?

I should have the text of the mian work finsihed over the weekend and then need to move to other projects.ShakespeareFan00 (talk) 21:31, 19 September 2014 (UTC)

Hi ShakespeareFan00. No I will not take it. If you do not want to finish, leave it there, hoping that someone will pick it sooner or later.--Mpaa (talk) 08:27, 20 September 2014 (UTC)

Need some guidance[edit]

I've spotted you making some gerrit patches for .py stuff and was wondering if you might be able to steer me in the right direction.

Long story short - All I'd like do to "help" move things along is create a "patch" that inserts this single line...

                                                        'filters': [ 'body:not(.ns-0)' ],

... between Lines #186 & #187 of THIS .js file.

I've been studying the Gerrit-Patch-Uploader and find myself second guessing what at first appeared to be rather straight forward. Is it really nothing more than downloading & modifying the .js file in question and then just a matter of pointing to the revised local version for upload? How does "it" know which file in the extension's folders & file paths I'm trying to amend?

Any advice you might have is greatly appreciated either way. -- George Orwell III (talk) 21:52, 21 September 2014 (UTC)

I have never used it, I use another workflow with git. I think you need to identify in which "project" the file you want to modify is in. You do not have to upload the new file but a "patch" in one of the specified formats, where basically it is defined which lines of the old version are replaced and with which new lines. See [1] here an example of a "diff -u" command.--Mpaa (talk) 15:24, 22 September 2014 (UTC)
This is an example of what you will see in the review tool [2]. You will have to respond in this forum to reviewers' comments and upload new revisions, if needed.--Mpaa (talk) 15:36, 22 September 2014 (UTC)

Retitled works[edit]

Did some followups to some requested moves , by making requests at Commons. Nothing broke this end, but it would be nice to complete the Wikisource side of the re-title process. ShakespeareFan00 (talk) 14:45, 28 September 2014 (UTC)

@ShakespeareFan00: I noticed that you are driven by some higher power to instruct others to make everything neat and tidy on all English language wikis (are you proficient in other languages?). I noticed that you did it on Wikipedia, by tagging a lot of images to be moved to the commons, a gallery which myself put to good use by moving some 19th century B&W images. Nevertheless, for the past weeks I was wondering, how come you don't do it yourself? After all, no one seems to be objecting to your efforts. Have you considered that we are occupied with own projects, and your unending stream of missives are somewhat annoying? Based on your past contributions, I am convinced that you are very capable to do the tasks by yourself. Finally I must ask, do you do windows? — Ineuw talk 15:38, 28 September 2014 (UTC)
In respect of re-titles, I posted here, because it was my understanding that Mpaa had access to a re-title script (which needed some permissions he has and I don't) which relocated pages as well as the index. My reasons for the requests on Scriptorium first was to give time for objections. ShakespeareFan00 (talk) 15:51, 28 September 2014 (UTC)
Also I as a normal contributor don't have deletion or AWB rights.ShakespeareFan00 (talk) 16:09, 28 September 2014 (UTC)
Only move (possibly w/o redirect) is needed. So in principle, everyone could do it. Even if automated it is much faster ...
Bot request is anyhow the right entry place for future requests. A larger crowd can take the task.--Mpaa (talk) 17:37, 28 September 2014 (UTC)
Thanks, It isn't so much a bot request that was needed, but a script request, as I did want to possible review what it was intending to move, I.E a tool-assisted edit script would be better than a bot. ShakespeareFan00 (talk) 17:51, 28 September 2014 (UTC)
I lost you ... You do not need an 'edit script', you just need a Move action on the Indexxxx.yyy: and Page:xxx.yyy/n.
Anyhow, if you are not more specific on what needs to be checked, I wouldn't know how to help you. You cannot expect me to track your work at Commons or here. Highlight somewhere at what stage all your requests are, and it will be easier for everyone to support.--Mpaa (talk) 18:30, 28 September 2014 (UTC)
That's why I was updating the Rebinding entries, but someone seemingly said the cleanup should just happen. ShakespeareFan00 (talk) 20:13, 28 September 2014 (UTC)
I've now re-aligned all but 2 of the works whose files moved at Commons. (on one I had to also realign a transclusion which is something I noted would need to be done on the bot request I made.)
In respect of the "windows", please clarify on my talk page :) ShakespeareFan00 (talk) 15:51, 28 September 2014 (UTC)
In respect of remaining issues. Please refer to my talk page ShakespeareFan00 (talk) 22:30, 28 September 2014 (UTC)

Thank you for the redirect cleanups.ShakespeareFan00 (talk) 22:38, 28 September 2014 (UTC)

Welcome. But do not expect any commitment on this task from me. Especially regarding the script you requested.--Mpaa (talk) 07:53, 29 September 2014 (UTC)
I'm not expecting anything, I've added the script to my wish list in hope. ShakespeareFan00 (talk) 11:35, 29 September 2014 (UTC)


Question is there a way to tell MpaaBot to re-title a work that a normal user like myself could add to the index page? (This would save a lot of hassle longterm).ShakespeareFan00 (talk) 20:29, 30 September 2014 (UTC)

I am not sure I got you. Do you mean run-time when you create an Index, to validate the name? If so, no. I guess some js script could though.--Mpaa (talk) 20:46, 30 September 2014 (UTC)
I meant a tag like {{newindex|newname}} on the old Index which Mpaabot can look for and which tells the bot that the extant Page:'s for that index need to be relocated before the Index itself can be moved. (For example the page transfers done on the Treatise On a Steam Engine work.
I think I need to go read the API notes. ShakespeareFan00 (talk) 09:51, 1 October 2014 (UTC)

Some js to do a sanity-check for creating an Index on a file that doesn't exist would also be useful, but some index are created by manual page list construiction from jpg/tiff etc, so don't obviously have an associated file in that sense. ShakespeareFan00 (talk) 22:42, 30 September 2014 (UTC)

TOC err[edit]

Hello, Mpaa. I noticed that the poems listed from Part I on Page:Love Songs.djvu/16 do not show up in the Mainspace. I was going to validate, but I'm not sure how to fix the problem. Thanks! Londonjackbooks (talk) 05:07, 12 November 2014 (UTC)

Similar issue with Helen of Troy and Other Poems. Londonjackbooks (talk) 15:08, 12 November 2014 (UTC)

Pasted on Help page as I cannot figure it out.--Mpaa (talk) 19:33, 12 November 2014 (UTC)
Find out the fix (after many attempts ...). Thanks for pointing out.--Mpaa (talk) 20:20, 12 November 2014 (UTC)

The Tsar's Window Four Leaf Clover[edit]

Help:Adding images mentions Imagemagick, which could be used to get rid of the paper texture of the four leaf clover and the horseshoe that ate illustrations used in the No Name series novel The Tsar's Window. By the way, how good are you with images? --Lo Ximiendo (talk) 12:27, 15 November 2014 (UTC)

I can do that single image for you, if you wish.— Ineuw talk 15:47, 15 November 2014 (UTC)
Yes please. I need to reinstall tools as I changed PC.--Mpaa (talk) 21:33, 15 November 2014 (UTC)
Hi. I did that and everything else on the volume, and placed it in the queue for validation. — Ineuw talk 21:39, 15 November 2014 (UTC)
Thanks.--Mpaa (talk) 18:34, 16 November 2014 (UTC)

Bot fixes[edit]

Thank you for the bot header fixes to Ninety-three. Londonjackbooks (talk) 22:37, 5 December 2014 (UTC)

You're Welcome.--Mpaa (talk) 10:24, 6 December 2014 (UTC)

Database reports[edit]

Hello again,

I could not think of anyone better to ask since most of it seems to be .py based -- is there any way we can start our own centralized Database reporting like Wikipedia has? Having such a repository would go a long way in selecting maintenance tasks to completion.

If that is too big of a deal to start-up -- either without group discussion taking place first or is just too labor intensive & the like -- can you just get one database up and running?

I'm interested in the Gadget usage section in particular (note that the first half of results are faux deviations of the true results found in the bottom half of the same table). Thanks for any input/reply in advance. -- George Orwell III (talk) 00:06, 7 December 2014 (UTC)

Hi. I guess I would need an access on tool labs to start with or we could use User:Wikisource-bot (@John Vandenberg:, what do you say?). I am not familiar with the libraries used in the .py example, I am checking if I can use pywikibot instead. I would need help with SQL queries (or I could copy them from wikipedia reports) . Parsing the outcome, generating the reports and updating the pages should not be an issue.--Mpaa (talk) 19:22, 7 December 2014 (UTC)
This might be of interest in the meantime:
Bye--Mpaa (talk) 20:20, 7 December 2014 (UTC)
Requested access in the meantime.--Mpaa (talk) 22:56, 7 December 2014 (UTC)
Happy to have you onboard with wikisource-bot. Do you have an account on toollabs? FWIW, that is exactly the sorts of purpose that I see for WS-bot. — billinghurst sDrewth 02:43, 8 December 2014 (UTC)
Just made one. I am understanding what to do next ... :-) --Mpaa (talk) 08:14, 8 December 2014 (UTC)
@George Orwell III:, I have now access to the database. I tried to run that query but it gives me errors (ERROR 1146 (42S02): Table 'enwiki_p.user_properties_anonym' doesn't exist). Maybe something has changed somewhere.--Mpaa (talk) 12:40, 8 December 2014 (UTC)
Pointing at enwiki_p.user_properties does not yield any result, even though up_property='gadget-xxx' should be OK according to the docs.--Mpaa (talk) 17:43, 8 December 2014 (UTC)

You know this stuff is beyond my skill set but the only thing that leaps out at me is read_default_file='~/.my.cnf' ; looks like some sort of configuration file. Otherwise, we need to hunt down User:MZMcBride and ask him what might be wrong with his .py script. -- George Orwell III (talk) 01:07, 9 December 2014 (UTC)

We can ping the delightful @MZMcBride: otherwise mpaa or I can grab him in IRC. — billinghurst sDrewth 04:04, 9 December 2014 (UTC)
Please pardon my throwing another oar into this boat but for what it is worth '~/.my.cnf' normally only carries items like default mySQL login id, database, host (and optionally password) to use for a connection. As the filename format is "UNIX" I imagine it might have to be remapped for queries launched from a Windows host.

Second thought: might the table you are looking for be enwikisource_p.user_properties, rather than enwiki_p.user_properties*?

Bear in mind these suggestions are coming from even less background than any of you guys. 04:42, 9 December 2014 (UTC) (Bugger. Trying to be neat and logging out of Quarry clearly logs you out of all WMF projects. Anyway, was me. AuFCL (talk) 04:50, 9 December 2014 (UTC)

my.cnf (yes, it is the info on dB/login) is not an issue, I can access the dB. Both enwiki_p and enwikisource_p show consistent results, but "gadget-xxx" properties are not there.--Mpaa (talk) 12:32, 9 December 2014 (UTC)
I am afraid none of the following is necessarily useful to you but in hopes it might prompt a line of enquiry…

I tried installing the Gadgets extension on a private mediawiki installation and then further imported the pilcrowMarkers gadget (on the basis of its extreme simplicity.) To nobody's surprise a new up_property now appears in user_properties, viz:

mysql> SELECT * FROM user_properties WHERE (up_property LIKE 'gadget-%') AND (up_user IN (SELECT user_id FROM USER WHERE user_name='WikiSysop'));
| up_user | up_property           | up_value |
|       2 | gadget-pilcrowMarkers | 1        |
1 ROW IN SET (0.00 sec)
Now this of course is using an operator set with unlimited local access, and of course as you already know performing an equivalent operation on enwikisource_p.user_properties reveals no gadget-* up_properties whatsoever.
Could your problems be a consequence of well-meant access restrictions on enwikisource/enwikisource_p (after all these are in fact real-world user attribute tables)? Just a thought.
Regrettably apart from offering sympathy I am not sure any of this will be of the slightest use to you. AuFCL (talk) 08:30, 11 December 2014 (UTC)
Long story short: privacy concerns make the info not available after the migration from toolserver. Still pending but not likely to be closed shortly. Details in phabricator report T60196 .--Mpaa (talk) 21:17, 11 December 2014 (UTC)
Ah, I see. What a load of nonsense at any rate. Thanks for looking into it nevertheless. -- George Orwell III (talk) 22:24, 11 December 2014 (UTC)
Oh, my, giddy, aunt that Phabricator report makes depressing reading. Nobody even seems to comprehend which parts survive the existing filter and which parts (if any!) have been sighted (I am betting none) by legal. Oh, well roll on mediawiki++. At least I now know I got my SQL experiments at least as right as the "experts" did. AuFCL (talk) 04:23, 12 December 2014 (UTC)
Yes, your help was appreciated, it shed some light.--Mpaa (talk) 10:49, 12 December 2014 (UTC)

Any useful reports at all[edit]

Hi again,

Along the same line of investigation as in the above section (where security concerns trump report generation apparently) I'm assuming User: preference settings other than Gadget selections can't be "polled" either?

Assuming "yes" - can we move on and at least run something like this grep script claims to detect (i.e. any instance of the usage of deprecated javascript)? -- George Orwell III (talk) 00:30, 20 December 2014 (UTC)

What I can see is the following:
[enwikisource_p]> SELECT up_property, COUNT(*) FROM user_properties GROUP BY up_property;
| up_property    | COUNT(*) |
| disablemail    |     1864 |
| fancysig       |      850 |
| gender         |     1819 |
| LANGUAGE       |     1478 |
| nickname       |     2165 |
| skin           |   124924 |
| timecorrection |     7423 |
| variant        |     3438 |
but it is not clear to me what would you like me to grep and where.
Should I grep for instances of deprecated javascript in here?--Mpaa (talk) 17:58, 20 December 2014 (UTC)
If that is what you needed, I got this:
USER@pc:~/python/core {master}$ grep -n -f deprecated.ids *.js
Common.js:277:	a.onclick=FUNCTION(){insertTags('', this.title, '');RETURN FALSE;};
Common.js:353:	importScriptURI( mw.config.get( 'wgScript' ) + '?title=MediaWiki:Geonotice.js&action=raw&ctype=text/javascript&maxage=3600&ver=2');
Common.js_watchlist.js:55:	importScriptURI( mw.config.get( 'wgScript' ) + '?title=MediaWiki:Geonotice.js&action=raw&ctype=text/javascript&maxage=3600&ver=2');
Dictionary.js:62:	var api=sajax_init_object();
Gadget-LongEditSummaries.js:37:	addHandler(wpSummary, "keyup", adjustMaxLength)
Gadget-LongEditSummaries.js:38:	addHandler(wpSummary, "change", adjustMaxLength)
Gadget-TemplatePreloader.js:4:	/*global mw, $, sajax_init_object */
Gadget-TemplatePreloader.js:223:	// FIXME: USE OF "sajax_init_object" IS deprecated. Sajax IS deprecated, USE jQuery.ajax OR mediawiki.api instead.
Gadget-TemplatePreloader.js:224:	var request = sajax_init_object();
Gadget-UserMessages.js:87:	//akeytt IS deprected AND does nothing. who cares about access KEYS anyhow.
Gadget-UserMessages.js:94:	akeytt();*/

Let me backup a bit & clarify -- after the above quest for gadget usage per User: preference settings went nowhere (section above this one), I was hoping to at least gather User: preference settings just for the Preferences/Edit tab. After looking "around" a bit on that particular note, it seemed safe to surmise the same security roadblock for Gadgets would make further inquiries for building 'Edit' tab stat report(s) a moot point as well (am I wrong?)

Moving on, I switched to seeing what -- if any -- deprecated javascript functions I could find in a.) local site scripts, b.) imported site scripts, and finally c.) User scripts.

Nothing well thought out here I'm sorry to say -- George Orwell III (talk) 21:27, 20 December 2014 (UTC)

I think the above should be your point a) then, point b) I have no clue where to look for, point c) one could look for all *.js subpages in user namespace?--Mpaa (talk) 08:53, 21 December 2014 (UTC)
If you are interested I can send you the result of grep on (most of) point c).--Mpaa (talk) 20:43, 21 December 2014 (UTC)
Might as well -- better have it available for when the opportunity presents itself.

I just took a stab at refreshing MediaWiki:Gadget-LongEditSummaries.js (which was already deprecated/moot for anybody still using it) so I'm curious to see if anything changes. -- George Orwell III (talk) 22:20, 21 December 2014 (UTC)

Left it here: User:George_Orwell_III/sandbox_js.--Mpaa (talk) 21:04, 23 December 2014 (UTC)

Mining data from the quarry[edit]

Hi, and thanks for the link to the data query page and the link to the database schemas. Managed to modify and run my query (it was written for MySQL and the current database is dbMaria), but I got some unrelated categories and garbage, which means that the category links are incorrectly defined in the SQL statement. I'll keep at it which also means I have delve into the SQL of dbMaria which is a bit different that MySQL. Must assume that the switch to the new DBSM was because Oracle owns MySQL. — Ineuw talk 00:07, 7 January 2015 (UTC)

Welcome. I am no expert on databases but I use MySQL workbench to connect to dB (if this can be useful to you).--Mpaa (talk) 19:28, 7 January 2015 (UTC)
Yes it is useful and I will reinstall it. I used to use that a long time ago, (6 years) but that is not the problem.. . . I removed the relational constraints to the categorylinks, and ran a simple "SELECT" query to see if it can select just the titles. There are nearly 6000 titles in the PSM main namespace and it selected only about 2,200. When you have the chance, could you run this simple query for PSM article titles for the main namespace?
Like ('Popular_Science_Monthly%')
AND = 0

Ineuw talk 19:57, 7 January 2015 (UTC)

Same here, weird ...:
MariaDB [enwikisource_p]> SELECT COUNT(*) FROM WHERE  LIKE ('Popular_Science_Monthly/%s') AND = 0;
| COUNT(*) |
|     2206 |
1 ROW IN SET (0.01 sec)
OK, I got it. It should be something wrong in the LIKE specs. %s must discar something(apostrphes?, unicode? whatever ...?)
MariaDB [enwikisource_p]> SELECT COUNT(*)  FROM WHERE  LIKE ('Popular_Science_Monthly%') AND = 0;
| COUNT(*) |
|     8933 |
1 ROW IN SET (0.01 sec)

--Mpaa (talk) 21:08, 7 January 2015 (UTC)

Thanks. I will figure out what's going on from the 2nd recordset — Ineuw talk 21:12, 7 January 2015 (UTC)

Hi again, using the 2nd SQL statement, I extracted all the titles and everything matches up to my Access database (8016). The additional entries are all redirects pointing to Obituaries and Articles - but without the {{ROOTPAGENAME}}. of PSM.
The issue is to check the link to the categories by testing some records of "categorylink" layout because my original copy of the SQL statement from 2 years ago mentions a fieldname link which no longer exists, or rather it has been renamed. It is just a matter of some detective work.
The lazy way is to print the field lists of each table in question from MariaDB, extract a few complete records from each, recreate the structures in MSAccess and see what I get. I have used MSAccess as a query design tool (very sophisticated, the best I've ever come across) and as a graphical front end to connect to MySQL. The two basic SQL differences that I remember is that MSAccess uses '*' instead of '%' to indicate everything, and 'constant strings' in a MYSQL statement can only be enclosed with single quotes, while MSAccess accepts both single or double qutes. P.S.: I always wondered who is/was Maria. — Ineuw talk 04:12, 11 January 2015 (UTC)
I think the issue is in the search pattern. This should do the trick.
    enwikisource_p.categorylinks ON = enwikisource_p.categorylinks.cl_from
WHERE REGEXP 'Popular_Science_Monthly/Volume_.*'
        AND = 0;
Bye--Mpaa (talk) 09:40, 11 January 2015 (UTC)
Thanks. I created and executed a similar statement successfully which resulted in an accurate list of the titles, but no categories. After studying the schema, I concluded that the categories table is missing from the SQL. The original of this query created a temporary table with the article titles and the link # and then linked this to the categories.
USE enwikisource_p;
SELECT, categorylinks.cl_to
 FROM categorylinks INNER JOIN
  ON = categorylinks.cl_from WHERE categorylinks.cl_to LIKE
  ('Popular_Science_Monthly_Volume%') AND page.page_namespace = 0;

Ineuw talk 20:17, 11 January 2015 (UTC)

Finally got it[edit]

Extracted the structure of each table and then extracted a couple of 100 records from each table and figured out what is happening and how the info is stored. Below is the correct SQL statement - yielded some 27,000 records. :-). Thanks again for your guidance. BTW, SQL is easier than it looks, only the table JOINs are a bit tricky.

USE enwikisource_p;
SELECT page.page_title, categorylinks.cl_to
 FROM categorylinks INNER JOIN page
  ON page.page_id = categorylinks.cl_from WHERE page.page_title LIKE
  ('Popular_Science_Monthly_Volume%') AND page.page_namespace = 0;

Ineuw talk 16:43, 21 January 2015 (UTC)

Good. I think the JOIN statement is in this case symmetric, so it should be equivalent to the above. I also got 27000+ pages.
The syntax for asymmetric JOIN is where I am a bit weak but if you really want to get comfortable, use the MSAccess query designer to create asymmetric JOIN. It's the best visual designer I've seen anywhere, and the SQL is easy to convert to MariaDB. — Ineuw talk 05:45, 22 January 2015 (UTC)

New Proposal Notification - Replacement of common main-space header template[edit]

Announcing the listing of a new formal proposal recently added to the Scriptorium community-discussion page, Proposals section, titled:

Switch header template foundation from table-based to division-based

The proposal entails the replacement of the current Header template familiar to most with a structurally redesigned new Header template. Replacement is a needed first step in series of steps needed to properly address the long time deficiencies behind several issues as well as enhance our mobile device presence.

There should be no significant operational or visual differences between the existing and proposed Header templates under normal usage (i.e. Desktop view). The change is entirely structural -- moving away from the existing HTML all Table make-up to an all Div[ision] based one.

Please examine the testcases where the current template is compared to the proposed replacement. Don't forget to also check Mobile Mode from the testcases page -- which is where the differences between current header template & proposed header template will be hard to miss.

For those who are concerned over the possible impact replacement might have on specific works, you can test the replacement on your own by entering edit mode, substituting the header tag {{header with {{header/sandbox and then previewing the work with the change in place. Saving the page with the change in place should not be needed but if you opt to save the page instead of just previewing it, please remember to revert the change soon after your done inspecting the results.

Your questions or comments are welcomed. At the same time I personally urge participants to support this proposed change. -- George Orwell III (talk) 02:04, 13 January 2015 (UTC)