Collin Consulting Ltdhttps://www.joellipman.com/component/content/article/collin-consulting-ltd.html?catid=33

29 June 2014 did a really superb job for me on this. My website crashed and I had no idea how to fix it. My hosting service were no help at all. Worse, I hadn't backed up my website for 18 months so even if Joe managed to retrieve it I expected most of my data to...

• Type: Article
• Author: Webmaster
• Category: Portfolio
• Language: *

Privacy Policyhttps://www.joellipman.com/static-items/privacy-policy.html

30 May 2009 we do with the information we gather We require this information to understand your needs and provide you with a better service, and in particular for the following reasons: Internal record keeping. We may use the information to improve our products and...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: en-GB

Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

20 January 2010 The reason I did this is because AEC is now a commercial package and it is somewhat limited in terms of good customer service. It only really manages the payment side and the complicated tasks of invoicing, but Community Builder provides more options...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 Registration This is so that you as the client retain overall control of the website. If you are dissatisfied with our services or need another developer to take over, you can at any point control which server your website visitors will go to when they...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 Value file. CHANGELOG: Version 1.0 + This is version 1.0 unless people have suggestions I don't see the need to release service packs and updates. OTHER NOTES: This program does not install other files nor is a setup. It was created in AutoHotkey and...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 technical knowledge/skills) Availability via Phone/Email/In person? (not relying on this but it can save time... sometimes) Service Transition Security rights/roles in the system (reasons for different accesses) Get all known logins (database, ftp,...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 need screenshots of these. Whatever the reason, I needed a FREE option and everything available had a limit to its "FREE" services. There are websites that do this for me? Yay! for free as well, as long as my page isn't loaded more than 100,000 times a...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 error when trying to add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error ORA-00911: invalid character ORA-06512: at "SYS.DBMS_UTILITY", line 114 ORA-06512: at line 1...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 had this? Your colleagues are connecting fine and your IT service desk say everything is functioning normally and it's just YOU! Script Function If you are on a network that frequently loses connection or simply forgets what intranet site you were...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Split a row into multiple rows based on a column valuehttps://www.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 1999-02-26 Some thing(s) to consider: User running the SQL query needs permission to read the master database. If run by a service account, ask a DBA to emulate the user for testing. the Items column may vary from 1 and 10+. Not sure on why this is but...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 have to raise and log a formal change request and follow a workflow process in order to make a change on a live system to a service user account... Especially one used by the scripts to access the database-driven website. How? I'm first going to...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 code or any value that is understood by the api.openweathermap.org website. There are plans to shift this to using Google Services as they are more likely to find locations that openweathermap.org cannot. Add a comma and the two letter country code...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 you have a static IP address (most home broadband users are now assigned these by ISPs so that they can identify their service users). The below also only allows 1 IP address (ie. one location from where an admin user can log in). Create a .htaccess...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 in CRM: Login to Zoho CRM as an administrator and go to Setup Under Developer Space click on "Connections" Under Pick your Service click on "Zoho OAuth" (NOT "Zoho" - there are 2 Zoho options) Give the connection a name such as "myZohoConnector" Tick...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 to: Microsoft Windows 7 Professional - Service Pack 1 AutoHotkey v1.1.33.02 What? So this is the documentation for a snippet of code that will list files of a directory using an AutoHotkey GUI and display what it will name them. The app needs to rename...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 are mostly allowed but JavaScript automatically gets removed from any of your code. How? As someone who's been using Zoho services and programming in Zoho Deluge for a few years now, even I thought of Zoho Widgets as a daunting task. But after doing...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 creator.cs.zohohost.com depending on your datacenter: 2. Setup your Domain/Subdomain The process here is dependent on your service provider or domain registrar (website where you registered your domain). I've listed some third-party providers'...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 a function At the top of the IDE there will be a "Connections" link to click on. Click on "Create Connection". Pick the service (eg. "Zoho OAuth"). Enter the connection details and scope. Error(s) Encountered: {"code":"4401","message":"Unable to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 Function IDE (page where you enter the deluge code): Click on "Manage Connections" Click on Create Connection Select Service "Zoho OAuth" Give it a name, I'm calling mine "ChatGPT CRM" Untick "Use Credentials of Login User" Under Scopes, click on the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Google Event Ilustrations aka Flairshttps://www.joellipman.com/articles/google/google-event-ilustrations-aka-flairs.html

05 December 2024 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...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: *