Category Archives: Competitons

PGNS Competitions 2019-2020

TThe Guild will be using a new competition upload form this season that is easier to use and faster than the old form. This new form does require that you log in to a new competition account before you can use it. If you had a competition account previously it is no longer valid.

You can not create this new competition account yourself! Please email the webmaster, request an account, and one will be created for you. Please tell the webmaster what you would like to use as a user ID. That should be something simple and often just your first name or some abbreviation is sufficient. Once the account has been created you will receive an email (from WordPress) with a link that will allow you to enter a new password. Make sure to check your spam folder if you don’t see this email.

When you go to the “Competition Uploads” page from the link at the top of the website sidebar, you will be asked to log in first. Use your new user ID and password. Once you are logged in you can go to your account profile from the “Howdy” menu in the top right corner of the page. There you can change anything you like, except your user ID.

A test competition upload form will be created fairly soon. You will receive a Guild email that will announce when the form is available. It is recommended that you try it out. Upload some of your competition compliant images. See how easy it is to use. Don’t wait until the first real competition to learn how to use this new form. If you do encounter any difficulties please let the webmaster know. All the images that you upload to try out the new upload form will be deleted prior to the first real Guild competition.

Darryl Robertson
PGNS Webmaster

Excel and VBA

As you may know, on June 1st I had to upgrade the Guild’s website for security and compatibility reasons. This was not optional. I had no choice. One of the consequences of this upgrade is that all of our old custom competition code (100,000 lines of PHP code) no longer works. If we try to use it, it will crash, hard.

I realized that it would probably take me most of the summer to try to redesign and rewrite this code to make it usable again. I was not happy about this. Joyce Chew said “why don’t we use the plugin that CAPA uses?” I said “what plugin? !!!”. Well, what I actually said was a bit more colourful. As it turns out, this plugin is very nice, it will actually work for our competition uploads, it is better and faster than our old code and my summer has been saved. Thank you Joyce.

There is, however, one little catch. Our old code was written to make ClubViewer happy. ClubViewer is the PC-only app that we use during our competition judging. It has some very specific, and rather bizarre, requirements. This new upload plugin knows nothing about ClubViewer and it can not be modified to be compliant with what ClubViewer demands.

I have written a spreadsheet text parsing function and a short AppleScript automation that can convert what the plugin provides into the format that ClubViewer requires. These functions are Mac-only. However, I am sure that Windows Excel can duplicate these functions.

So here is the point, I am looking for a Guild member who has a PC, has Excel, and is comfortable with a bit of Visual Basic programming. I don’t have a PC, I don’t have Excel and I don’t program in VBA. I suspect that my text parsing function will run as is in Excel, or nearly so. Translating my little AppleScript into VBA should be relatively easy. If you would like to give this a try please email me.

Darryl Robertson
PGNS Webmaster

Trophy Competition Night

Hello and Happy St Paddy’s day 2019 !
The Guild Schedule reminds us that we need to get our images ready for upload this week (deadline is Sunday the 24th) and the competition is on the 31st.
Good luck choosing images for each of these ‘once a year’ categories. You never know….you might be the winner of a special award for your efforts !

Viki Gaul