ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 An article to ensure I never spend this long on such a request again. The brief is: "Follow up when a lead is created and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to a specified user"....

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

Is it a scam? Gumtree.com's warning signshttps://joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 your money. Any requests by strangers to use these services in any way should sound off alarm bells and shouldn’t be followed. An email allegedly from «CompanyName» (or another company) asking for your personal details - logins/passwords/credit card...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 cannot be used to render the program non-free. The precise terms and conditions for copying, distribution and modification follow. TERMS AND CONDITIONS 0. Definitions. “This License” refers to version 3 of the GNU General Public License. “Copyright”...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

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

24 October 2020 environment. I aim to create a WindowsPC version of this document at some point for my colleagues. The below instructions follow a fresh install as if this is the first time this computer has created a Zoho Creator Widget. Software used: Zoho Creator v5...

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

Zoho CRM: Standard Setup for Tax Rateshttps://joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

02 September 2021 is official documentation on how to do this but I thought I'd write this article to make it simpler for new developers to follow and learn as a quick point of reference. Why? Some clients systems will presume that they don't need their sales or CRM...

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

Amazon Kindle: Send PDFs to your Kindlehttps://joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 send the files to your Kindle device) approved. Unless this is done, Kindle won’t download the files. Here are the steps to follow for getting your email address approved. Follow steps 1 – 5 as stated under Finding your Kindle email address. However,...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 done, navigate to http://www.mysite.com/phpBB3/install/ and you get a web installation setup GUI similar to Joomla's. Follow the instructions of the GUI on each page until it confirms you've installed phpBB3. Install RocketTheme Affinity phpBB3 Style...

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

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

20 January 2010 ever complete the CB Subscription component then there is no need for AEC anymore. For this we're basically going to follow the AEC installation instructions backwards. 1. Go to your admin panel (back-end) 2. Extensions > Plugin Manager 3. Go to the...

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

SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 the above text, click on query builder and "edit as text", then paste it into there. When you ok this you should be on the following screen: Select the Report Type: For this calendar we want matrix because we're going to group based on the rows: Design...

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

What's the problem? Amusing computer issueshttps://joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 a cable that directly connects the printer to your computer or does the printer plug into the wall? Ok could you please follow the cable from the computer to the printer and tell me.". "Hang on its on the other side of the room.". This was a remote...

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

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

28 June 2011 a browser of yours (it will look at it like MS Windows Internet Explorer) it should be ok. Output names for the thumbnails follow the same restrictions as the MS Windows filesystem (so no colons, back/forward slashes, etc). If there is nothing...

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

SSRS Redirect after a report is runhttps://joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

12 August 2011 warranted. My reports use a parameter for the connection string to specify which server and database to connect to and the follow on link was enough as a solution. My seniors advised that if we had time in the future we could expand on this further....

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

Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 this article focuses on getting an Oracle stored procedure to work with SSRS. Main Example: My stored procedure will do the following: Get a student ID number based on the student username Get a student's names and date-of-birth based on the student ID...

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

Generate Academic Calendar using MySQLhttps://joellipman.com/articles/database/mysql/generate-academic-calendar-using-mysql.html

27 November 2012 We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year for...

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

Upgrading a Joomla 1.5 module to Joomla 2.5https://joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 I don't think it actually exists in reality but you replace the name "moduletoupgrade" with whatever you're upgrading and follow the below instructions. I'm also going on the basis tha. Basic Checklist Download all J1.5 files to one folder:...

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 Joomla CMS v3.2.3 (Joomla.org) jComments v3.0.0 (JoomlaTune.com) PlayThru v1.1.8 (AreYouAHuman.com) What? This article is a follow on from my article JComments 2.3 with PlayThru (Joomla 2.5.x) but this is for a later version of the components using the...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://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 but this is a production database I want to export for offline backup. I 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...

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

Basic Android App using Google Maps and Current Locationhttps://joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 Google Android Maps API What? I am writing an app for a tablet running Android and wanted to include a Google Map. The following exercise focuses solely on creating an app which opens Google Maps at your current location. How? I couldn't find any...

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

MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 F5 to run the code. A separate file will be created for each sheet in the same folder. A combined all-in-one solution The following script is made of 4/5 subroutines. Follow the instructions above on how to execute a vbscript and then paste the below...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 bought a fixed price item. This uses the Trading API even though I'm aiming for the Platform Notifications API... Why? A follow on from my article Zoho Creator: Push to eBay Listings. I have a Creator app that needs to receive the orders from an eBay...

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