Articles

What?
A quick follow-on article to my previous article on Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo.

Why?
Connecting to OpenAI ChatGPT is all very well and good, but this forgets what you were talking about after each chat. So it's good for 1 question and 1 answer. What we need is to train it a little a bit like the standard OpenAI Chat website does in terms of context.

How?
Just a few changes to the previous code of connecting to OpenAI ChatGPT but the exception here is that there needs to be code to loop through all the messages of the chat/conversation thread so that we send the OpenAI ChatGPT bot the full conversation thread.

Zoho Cliq: Integrate OpenAI and soon ChatGPT

What?
A quick article on my adaptation of some code posted by Poorvik Palanikumar on the Zoho Community Forums to connect a ZohoCliq to the OpenAI API and ChatGPT... Note that I have another article for those who want to integrate ChatGPT with ZohoZIA.

Why?
Previously, I would edit the message handlers of a Cliq Bot I created but it would only understand the questions I have programmed it to and respond with the responses I programmed it to answer with. Any variations of the questions it did not understand, it would return a response similar to Siri or Ask Google where it includes the keywords in a "Search the web..." task.

ChatGPT by OpenAI is viral at the time of print and although the solution below only connects to the OpenAI API, it is not currently connected to ChatGPT. The plus side however is that it is connected to the Internet unlike ChatGPT which only has information up to 2021.

How?
The basics of setting this up would be to setup a bot in ZohoCliq and then to edit either a message handler or participation handler. As for the usage, simply ask the Cliq Bot a question and it will forward the query and respond with the response from the OpenAI API.
MacOs: Transcribe Training Video using OpenAI Whisper

What?
Just noted this down in case I need to do it again. This article documents how to take a 5.5 hour video (MP4) and have it transcribed by a locally installed AI on a MacOS (running Sequoia 15.1.1).

Why?
Needed for training videos as a follow-on from my article on how to download videos from a session on TrainerCentralSite.com.

How?
OpenAI's ChatGPT doesn't like more than a 500Mb file attachment; and no more than 10 files at a time. I have a 1.5 Gb video which has a duration of 5.5 hours. I struggled with this and ultimately used VOSK but I'm leaving the instructions here in case it works for you.
A conceptual image representing a constant drain on an Apple iPhone's battery

Event 1

A friend reported her phone was constantly being drained, wasn't lasting the day on a full charge and knew how to close apps running in the background (double-click "home" button and hold down app until red minus buttons appear, tap red button)...

I wouldn't usually take notice but I think this is a brilliant example where trying to fix the problem is the very cause of the problem in the first place:


The empty arrow next to the battery indicator tells you that location services is enabled but it is attached to a reminder that needs to constantly monitor your whereabouts in order to "remind you".

The reminder here was to charge the phone but it was the reminder which would drain a full charge in less than a day.

An image representing the process of transferring apps and purchases from an iPhone 4s to an iPhone 5s using a Windows PC

Applies to:
  • Apple iOS 7
  • Apple iTunes 11.1.3.8
  • Microsoft Windows 7 Professional

What?
Just so many articles out there that did not help me. This article is how I finally did mine.

Why?
I had paid for some apps on my old phone and realized that if I didn't do a "restore", then I would have to install and pay for them all again. My purchased music was in the cloud so those could be re-downloaded on to the new phone (not fun).

The Apple documentation iOS: Transferring information from your current iPhone, iPad, or iPod touch to a new device was as useful as a Microsoft KnowledgeBase article. In that, it restored all my photos and the default Apple apps, but missed out all my other apps (and audio).

How?
Note that the restore can be done when the new phone prompts you to set it up but you could do the below again at anytime (as I discovered). The steps below apply after having gone through the process of setting up the phone and finishing on the "Get Started" (including Touch ID).
Google Event Ilustrations aka Flairs

Source: http://www.internetbestsecrets.com/2019/09/google-calendar-event-images.html
art: painting, art workshop, sketching workshop, drawing workshop
badminton: badminton
baseball: baseball
basketball: basketball
bbq: bbq, barbecue, barbeque
beer: beer, beers, Oktoberfest, October Fest, Octoberfest
billiard: billiard
bookclub: book club, reading
bowling: bowling
breakfast: breakfast, breakfasts, brunch, brunches
camping: camping
chinesenewyear: chinese new year, chinese new years, chinese new year's
cinema: cinema, movies
clean: cleaning, clean the house, clean the apartment, clean house, tidy up, vacuum clean, vacuum cleaning
code: learn to code, coding time, hackathon, Rails Girls, Railsgirls, Hour of Code, Codecademy, Computer Science, Programming in Python, Web Programming, Programming in Java, Web Development
coffee: coffee, coffees
concert: concert, gig, concerts, gigs
cycling: bicycle, cycling, bike, bicycles, bikes, Biking
dancing: dance, dancing, dances
dentist: dentist, dentistry, dental
dinner: dinner, dinners, restaurant, restaurants, Family meal
drinks: cocktail, drinks, cocktails
golf: golf
graduation: graduation
gym: gym, workout, workouts
haircut: haircut, hair
halloween: halloween, helloween, hallowe'en, Allhalloween, All Hallows' Eve, All Saints' Eve
hiking: hiking, hike, hikes
kayaking: kayaking
learninstrument: piano, singing, music Class, choir practice, flute, orchestra, oboe, clarinet, saxophone, cornett, trumpet, contrabass, cello, trombone, tuba, music ensemble, string quartett, guitar lesson, classical music, choir
learnlanguage: French Course, German Course, English Course, …, French Class, German Class, English Class, …, Practice French, Practice German, Practice English, …
lunch: lunch, lunches, luncheon
manicure: manicure, pedicure, manicures, pedicures
massage: massage, back rub, backrub, massages
newyear: new year, new year's, new years
oilchange: oil change, car service
pingpong: ping pong, table tennis, ping-pong, pingpong
planmyday: plan week, plan quarter, plan day, plan vacation, week planning, vacation planning
pride: dyke march, christopher street day, gay parade, gay pride, gayglers, gaygler, lesbian march, lesbian parade, lesbian pride, euro pride, europride, world pride, worldpride
reachout: reach out to, write letter, send invitations
read: reading, newspaper
repair: fridge repair, handyman, electrician, DIY
running: jog, jogging, running, jogs, runs
sailing: sail, sailing, boat cruise, sailboat
santa: Santa Claus, Father Christmas
skiing: skiing, ski, skis, Snowboarding, snowshoeing, snow shoe, snow boarding
soccer: soccer
swimming: swim, swimming, swims
tennis: tennis
thanksgiving: thanksgiving
violin: violin, violins
walk: going for a walk, walking
wedding: wedding, wedding eve, wedding-eve party, weddings
xmas: christmas, xmas, x-mas
xmasmeal: christmas dinner, christmas lunch, christmas brunch, christmas luncheon, xmas lunch, xmas luncheon, x-mas dinner, x-mas lunch, x-mas brunch, x-mas luncheon, christmas eve dinner, christmas eve lunch, christmas eve brunch, christmas eve luncheon, xmas eve dinner, xmas eve lunch, xmas eve brunch, xmas eve luncheon, x-mas eve dinner, x-mas eve lunch, x-mas eve brunch, x-mas eve luncheon
xmasparty: christmas party, xmas party, x-mas party, christmas eve party, xmas eve party, x-mas eve party
yoga: yoga

What?
This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive.

This is very different to my code for OAuth when attended: Google Authentication - OAuth 2.0 using PHP/cURL... In that this one doesn't prompt for a user. Again this script doesn't need the client libraries, composer, vendor, etc.

Why?
This took me the best part of a month to get working. It is taken from Google's documentation as well as other forums and websites that try to explain it. Do not waste your time like I did on the public key, verifying a JWT signature, or including any third-party libraries. You can do it in pure PHP and all you need is the JSON key that you generated in your Google console.

Applies to:
  • Google Drive REST API v3
  • Google OAuth 2.0 v4
  • Google Cloud Platform IAM
  • Google Suite
  • PHP v5.6.35

How?
I'm going to go through each section of the code to go through the logic and highlight any changes you may need to make.

What?
A super quick article to show how to link to the thumbnail image of a Google Drive file, in this case a video file.

How?
The hardest part of this is to get the Google Drive File ID (which you need for the below). The image link (src) will be as below but then this is a redirect to the actual thumbnail stored by Google Drive:
https://drive.google.com/thumbnail?authuser=0&sz=w320&id=<GOOGLE_DRIVE_FILE_ID>

// where <GOOGLE_DRIVE_FILE_ID> is the file id