Generate a Timesheet in MySQL http://mail.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more. Similar systems have popped out that support some form of time recording and activity logging. The example below however is within a...

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

Export Joomla Users scripthttp://mail.joellipman.com/articles/cms/joomla/export-joomla-users-script.html

28 February 2014 Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which allows the passwords to be in MD5. All I want is a quick bit of...

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

SSIS Multiple Lookups in onehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 it in staging in the exact form it came through. Our transform package will convert the data and output it to the target system. For our package to decode what "M" means, it needs to look this up in a table on the original server. We had around 12...

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

Android: Keytool and Google Maps displaying greyhttp://mail.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 Right-click on the "Computer" icon/label (desktop / start menu) Select Properties Click on Change settings or Advanced system settings Select the Advanced tab Click on the Environment Variables... button Under "System variables" find the PATH variable...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttp://mail.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 $CLIENT_SECRET = ''; // expecting alphanumeric string $STORE_PATH = ''; // expecting *.json - needs to be writeable by system account $SCOPES = array($GAPIS_AUTH . 'userinfo.email', $GAPIS_AUTH . 'userinfo.profile'); // add in your other scopes as...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 you want to do after all quotes looped through // } Save your function and click on "Done" to ensure it's all saved in the system. Create the workflow Now go to a the "Design" mode of the report that contains the forms you want to be able to merge...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttp://mail.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 in the function because on application, the record doesn't properly exist in the system yet and the delay causes errors further down the line. Just add these parameters as per my above instructions for a more robust solution. [See below for full code]...

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

Zoho Projects: Add a Time Log to an Issue using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 you will need to have setup a Zoho Oauth Connection with the appropriate authorized scopes and have access to all related systems such as Zoho Projects and the originating app (in this example, Zoho Creator). 1. Setup up Zoho Oauth Connection: Go to...

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

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

06 March 2023 How? So taking ideas from my previous article for ZohoCliq; let's use what we know to develop a ZohoZIA for a demo system. There are several steps, so first we will set up the ZIA action "Ask ChatGPT" using the GUI, then we will capture the question...

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

ZohoDeluge: Check Shipment Status via DHL APIhttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

21 March 2023 order; as well as record any payments, inventory adjustments, status changes; all from an eBay Order coming into the system via a webhook... I would like to mark a shipment as delivered only if the courier, in this case DHL, confirms the tracked order...

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

ZohoCRM: Get Organization Business Hours using Deluge/APIhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 A super quick article on getting the business hours set in ZohoCRM. Why? When creating a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing or that has been added to the system based on the business...

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

Zoho Books: Generate Bank Text File for Downloadhttp://mail.joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 window"); } Delete the file We need to delete this file from the attachments as well as from the system as it contains bank details. You can skip this step if you're not bothered about storing this file on the system. Note that if you use the endpoint...

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

Zoho Projects: Get All Eventshttp://mail.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 = ifnull(r_FutureEvents.get("events"),List()); Additional: Code to get a single event: The above is great on a test system where you don't have many events, but what if this the system has far more than 50 events, past or upcoming? Here's the code to...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 eBay allows users to request the deletion of their personal data from eBay's own systems, as well as from the systems of all partners who store or display that data, including third-party developers integrated with eBay APIs through the eBay Developers...

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

Zoho People: Get Performance Records over APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 Objectives report under "Organization Reports" but would like some additional fields/columns added to it. Turns out, it's a system report you can't change. Enter Zoho Analytics... well almost, Analytics will sync with Zoho People but I wasn't able to...

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

ZohoBooks: Broken UK Banking Feedhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 Transactions" Bank Issue: Check with client which bank they use, type in the "Search" when connecting a bank on a demo system to see what comes up. If there are multiple options then note these; note it if there is just 1 as well. Zoho Issue: If you...

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

Invalid arguments passed in router.php on line 325http://mail.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 it the way I did is because I don't need a router.php. The router.php file supposedly holds the two functions to: convert a system URL to a SEF URL convert a SEF URL back to a system URL My site has been switched to SEF in the global configuration...

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

VBScript to retrieve Windows Product Keyhttp://mail.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 not valid. This article has a working example applicable to Windows 7 Professional. Why? With the Windows 10 operating system offered as a free upgrade (for Windows 7 or later at time of print), I needed the serial number / product key from my Windows 7...

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

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 see if we can have this functionality using the out-of-the-box ZohoCRM. Client Script Configuration: Login to ZohoCRM as a system administrator and go to the Setup page (cog icon in the top right next to the profile image) Under "Developer Hub" go to...

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttp://mail.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 below, you will need to setup a client script which runs when the product page is being modified: Login to ZohoCRM as a system administrator Give it a name, I'm calling mine "Products - Correct Decimals" Give it a description, I'm giving it the one I...

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