Exporting Facebook events to Google Calendar

Here are the steps I had to take.

  1. On the Facebook account page I want the calendar from I select “…”, and go down to “Events”.
    facebook_event_1
  2. Select an event.
    facebook_event_2
  3. In the upper-right click the “…” and select “Export Event”.
    facebook_event_3
  4. Copy the URL.
    facebook_event_4
  5. Go to your Google calendar. Next to the “Other calendars” hit the drop-down arrow and select “Add by URL”.
    facebook_event_5
  6. Paste your URL and check “Make the calendar publicly accessible?” and hit Add calendar.
    facebook_event_6

I hope this helps someone else out there…

 

Drop Down menu items blocked by another div or element

Today I was struggling with a Joomla 3.5.1 site and reusing the Protostar template. I added a slide show component and BM Cool Menu module. The sub-menu items were showing behind the slide show.

I changed the z-indexes, but that wasn’t enough. Besides the z-indexes I needed to add “position: relative;” to each div’s style and it got it all working perfectly.

I hope this helps someone else out there….

 

Solved – Chronoforms V5 won’t add database entry because of duplicate id – 1062 – Duplicate entry ’28’ for key ‘PRIMARY’

I had to hard code a URL and pass some parameters to a Chronoform in an article. The form submitted to a database. The form submission was taking the article ID as the form’s unique ID, so I could only submit once.

Bob Janes with Chronoforms totally fixed my issue with unsetting the varible with custom PHP.

https://www.chronoengine.com/faqs/70-cfv5/5234-my-form-data-isnt-saving-to-the-database-correctly-2.html

I hope this helps someone else out there…

 

 

using Join with Joomla 3 select statement

I took a while to get this right.

$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query ->select(array(‘a.id’, ‘a.name’, ‘b.user_id’, ‘b.body’))
->from($db->quoteName(‘#__users’, ‘a’))
->join(‘INNER’, $db->quoteName(‘#__user_notes’, ‘b’) . ‘ ON (‘ . $db->quoteName(‘a.id’) . ‘ = ‘ . $db->quoteName(‘b.user_id’) . ‘)’)
->where($db->quoteName(‘b.body’) . ‘ = \'<p>anx001</p> \”);$db->setQuery($query);
$results = $db->loadObjectList();echo ‘<table border=”1″ cellpadding=”5″>’;
echo ‘<tr><td>ID</td><td>NAME</td></tr>’;foreach ($results as $row) {
echo “<tr><td>{$row->id}</td><td>{$row->name}</td></tr>”;
}
echo ‘</table>’;

The double quotes on the echo in the foreach loop was necessary. If I used single quotes it didn’t display the names I was looking for.

I hope this helps someone else out there….