Category Archives: Competitons

CAPA Fall Round Competition Image Uploads

On Sunday, September 8, the CAPA Fall Round competition upload form will become active. The form will close at end of day Sunday, September 22. A few days after the form goes active I will be traveling and will not be available until after the form closes.

If you intend to submit images to this competition you must have a new competition account. Most of you already do. However, do you remember your user ID and password? You might want to try to log in before the upload competition form goes active (the upload page can be viewed) and before I am away, just in case. If you have forgotten your ID I can look it up. If you have forgotten your password I can NOT look that up (it is encrypted), so you will have to set up a new password from the login panel “Lost your password?” link. Any time you log in, please log out (top right Howdy menu) when you want to leave the page!

There are three PDF documents available from the members-only web page: “Competition Uploads”, “Upload Guidelines” and “Upload Login”. I strongly suggest you read all three before you begin uploading your images. You will be given the new members-only password when you renew your membership, but last season’s password will still work for a limited time. Every Guild member uses the same password to access the member-only web page. This is not your competition account password.

Both the Competition Uploads and the Members Only links are available from the top right sidebar of the website.

Darryl Robertson

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