JDatabase: using the Joomla database with exampleshttps://joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source: http://docs.joomla.org/ for v1.5.x and for v2.5.x This article applies to Joomla 1.5.x, 2.5.x...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 use this script in many packages, we can change just this script instead of the ones for every package). Here is the near enough final version of my script (or more like an experienced colleague's comprehensive script to which I have merely added my...

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

SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 We would not offer the feature to browse to the second set of 100 results. The end-user should be able to refine the search enough to get the records they need. Granted this may not be a viable solution for your case, but this did what we were asking...

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

SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 a database table. We could add each file as a separate connection manager but this is inefficient and not versatile enough to accommodate files that get added later. Why? I am creating an extract SSIS package intended to take a text file as its source...

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

Joes Google Map for Joomla (JGM)https://joellipman.com/component/content/article/joes-google-map-for-joomla-jgm.html?catid=40

13 April 2015 v3 in JavaScript is a doddle... And incredible fun! I've added the options to style the map while trying to keep it simple enough for my clients. Why am I giving it away for free? Could be malicious or could be that I made this for a website, got paid,...

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

Convert foreign characters to English alphabethttps://joellipman.com/articles/database/mysql/convert-foreign-characters-to-english-alphabet.html

13 June 2016 kind of words will return results of similarly typed/sounding words. How? Here's just a splurge of SQL but I use this often enough: UPDATE `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`, 'À', 'A'); UPDATE `myTable` t SET...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 to Zoho CRM and vice-versa. Annoyingly the attachment does not appear to be included in any sync... This method would be enough if the action was instantaneous and the attachments were also attached to the Sales Order in Books... but it isn't and...

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

Zoho Deluge: Search Records with Special Characters (COQL)https://joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 Contact Name: O'Reilly How? Well I've tried various replace methods with regular expressions but the only method reliable enough I have found to work each time is using the CRM Object Query Language or Zoho's COQL. Similar to SQL but subject to similar...

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

Zoho Creator: Add a subform while creating a recordhttps://joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 but it can be done all in one go. How? Here's a use case example which you will need to adapt to your own but It should do enough (spacing has been added for demo purposes and to make it clearer). In the below example, my form is called "Quotes" and my...

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

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 first, I need a function to get me a Session ID. Once I've used this and signed in once, it will last a few seconds, long enough for me to do my Fetch Auth'n'auth token process: string API.fn_eBayConnect_AuthToken_GetSessionUrl() { /* Function:...

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

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 Sales Order in Zoho Books. Why? You might think the following request to create a Sales Order in Zoho Books would be enough: { "date": "2021-09-08", "zcrm_potential_id": "123456789012345678", "currency_code": "GBP", "reference_number": "Salespersons...

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

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 can set up 2 schedules: one that runs on even hours and one that runs on odd hours to change this to every hour. It's not enough for some, so the below details on how you can get Xero to tell Zoho when a contact or invoice has been updated immediately....

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 of mine (see my pinterest) to build a nicer looking computer and I was given £1000 towards a new computer... It's more than enough to get a running White Snow Edition PC but I put in some more to get the Graphics Card, more RAM, more fans, more... What...

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

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

28 March 2023 them in the settings; so check that your connection has the scope to access both Organization details (ZohoCRM.org.READ is enough - perhaps optional) and access to Settings (ZohoCRM.settings.READ). I'm calling mine "mycrmconnection". r_OrgDetails =...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 on customer payment. Date Modified: 2023-03-21 (Joel Lipman) - Added if conditions to not adjust stock level if item has enough quantity then that purchased - Adds tracking number and carrier to shipment record on either creation or modification. - Only...

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

Zoho Deluge: Determine if Daylight Savings are in effecthttps://joellipman.com/articles/crm/zoho/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

03 July 2023 If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait about 4 months until I can confirm this works. Why? I've...

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

ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

09 July 2024 by simply going through the comments but this only shows Purchase Orders raised from a Sales Order which was not accurate enough... but here's the snippet: r_CommentsHistory = Map(); l_Comments = ifnull(r_CommentsHistory.get("comments"),List()); for...

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

Zoho Analytics: Create a Monitoring System with Imageshttps://joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 doesn't matter which one here, as long as I can get to the 3rd tab of the widget (it becomes enabled once you've completed enough on the 1st tab): I'll click on the 3rd tab called "Settings" then on the sub-tab "Image", and click on the button labeled...

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