SQLFAQ Portal Instructions

Pretty much everything needs to be done through the WordPress dashboard which is accessible through “Site Admin” on the SQLFAQ “Home” page or this URL: https://sqlserverfaq.com/wp-admin/

Group Forums

By default I add a forum for each group I create, there is a plugin I can install that redirects that to your own forum located elsewhere.

I’d suggest you don’t post event details in the forums because it won’t interact with the site – up to you though as whatever you do in the groups is up to you!

Conference Events

SQLBits, SQL Saturday and SQL Relay and other “conferences”: I will create a specific category Conferences that has child categories of SQLBits, SQLSaturday and SQLRelay; I will then make those specific key events come out on the right side bar rather than the complete (now duplicated) list of events. So when you add a SQL Saturday make sure you tag the category with your own GRPID{n} and also the SQLSaturday and Conference categories.

Adding Events

On “Events”…”Add New”

Set the event name to {your group name} {DDth Mmm YYYY} eg, PASS London 12th Jan 2016 – that way all events have a standard format and shows good information on the event list on the frontpage side bar, you’ll also find it easier to manage multiple events in the “Pages” area. Alternatively give it a name – but remember the site will truncate the name in places like the front page.

Please fill in the venues and as much info as you can – you can save venues for repeat use; if it is a free event enter “0” in the event cost.

It’s critical you get the event categories correct because that is how the event appears linked under your group on the other pages on the site, each group has an id of the form GRPID{n} – the categories show each GRPID under the parent of your group name for instance the category Edinburgh has a child category of GRPID13 – make sure GRPID13 is checked otherwise it won’t appear. Only click other groups GRPID category with their permission because it’s listing the event under their group! To give more meta about your event rather than use categories use Tags – add what you like, try and repeat a tag so if there is a similar tag then use that – just keeps the site neat.

So you don’t have to re-enter and maintain a separate events detail enter the following as the event details, it will suck the data out of EventBrite or MeetUp using their API. Do not change the token= bit unless you have your own – that is required.

It uses a plugin that adds the json shortcode, the fragments in the JSON document are accessed by specifying their names in {}.

EventBrite


<hr />
<div><h3>Registration : <a href='’></a> </h3></div>
<hr />

MeetUp


<hr />
<div><h3>Registration : <a href='’></a> </h3></div>
<hr />

The plan in a couple of months time is to start a monthly email / page summary that pulls in details for all the events.

Scraping HTML from external websites

If you are using an external website to host your event page such as SQLSaturday then you can use the remote_content shortcode. The URL is self-explanatory, this should be to your event page, the selector is a tad more fiddly, selector=”#name” will find the first occurrence of the DIV block with the ID of “name”. SQLSaturday look like they are using Dot Net Nuke, their content block is found if you search for “Welcome” the DIV block you want has the “content-area” class and will have a name something like¬†dnn_ctr53312_ContentPane – use that name in the selector e.g. selector=”#dnn_ctr53312_ContentPane”. The remote_content plugin works for any site you want.