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 eBay for information about an order and then creates item/contact/sales order/package slip/invoice (if not exist) Date Created: 2022-05-05 (Joel Lipman) - Initial release Date Modified: 2023-01-23 (Joel Lipman) - Revamp of code - Only generate invoice...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 CRM enter a unique Project Name cd to the new project name To give permissions to write sudo chmod -R 777 . open the newly created widget.html file in your code editor add the code as per the below generic script when done, save 'widget.html' then...

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

How to redirect the visitor after the contact pagehttps://joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 to, you will create a menu item in the Joomla 1.5 admin interface that points specifically to the redirect page you created in step one and make sure it is published. Now when you visit your page in the frontend you will see the menu item for the page...

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

Setup a copy of your Joomla websitehttps://joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 available to my client: Copy all files of your main website to another folder. Setup an FTP account to the new folder created in the previous step. Copy the database of your main site to another database. Setup a database user account that can access...

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

Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 anything that documents how to bring it into line with other search systems. So here we go, hope this helps you. Why? I've created search systems for a plethora of other systems. The aim of this article is to enhance the Joomla search into par with...

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 This is an article because there was no documentation that I could find that describes how to do this. When an invoice is created, not by clicking on the "convert sales order to invoice" button, I needed a way to programmatically link the sales order to...

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

Zoho Creator: Change Radio into Tabshttps://joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 your form Click on New Workflow Choose form (the one your radio tabs group exists on) (Record Event) Run when a record is Created or Edited (Form Event) When to trigger workflow Load of the form Name the workflow, I'm calling mine OnLoad Add New Action...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 from additional apps installed on the Shopify store. Why upgrade to the latest version for Shopify when private apps created before February 2022 won't be deprecated? Because the previous version was limited by our ability to search by product SKU. The...

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

Zoho Inventory: Mark a package slip as delivered and shippedhttps://joellipman.com/articles/crm/zoho/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

14 July 2022 r_CreateShipment = invokeurl [ url :v_Url type :POST parameters:m_Params.toString() connection:"jl_inventory" ]; info "Created Shipment: "; info r_CreateShipment; if(r_CreateShipment.get("shipment_order") != null) {...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 to hold the attachments Create an Excel spreadsheet or CSV file with the headers: Ticket ID, Attachment ID, Image URL, Created Time, Modified Time Add a dummy row with data that is expected to be in the rows (ZohoAnalytics may have issues loading a file...

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

Zoho Creator: Get Images in Report to be Exported to PDFhttps://joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 Image=c_ImageRow.Image File_field=f_DownloadFile Subform_Row_ID=c_ImageRow.ID ]; } // // store this after the record is created/updated (was getting error if included in record creation - if in same row). // c_ImageRow.File_field = f_DownloadFile; // //...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttps://joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 Trigger: Standalone Purpose: For any deal which is cancelled, cancel its related sales orders. Inputs: - Outputs: - Date Created: 2025-01-30 (Joel Lipman) - Initial release Date Modified: ??? ??? More Information: Custom View ID: 123456000012345678...

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

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

13 December 2023 from saving a record without changing this. This script will round up decimal fields onload. Inputs: - Outputs: - Date Created: 2023-12-13 (Joel Lipman) - Initial release - Correctly rounds any decimal fields to their maximum decimal place. Date...

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

Using MetaMod to hide buttons from logged in usershttps://joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 Edit your original menu module and select everything you want your registered users to see and then copy over to the newly created 'regmenu' module or what ever you called yours.) Make sure both menu modules are enabled. 2. Set the "Access Level" to...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 Click on "Change..." Select "Microsoft ODBC Data Source" > OK Select the data source from the dropdown (the one you just created earlier should be listed) Enter credentials if necessary and click on "Test Connection" Expand the data connection you just...

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

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

01 March 2011 a little); but seriously, I needed a checklist that works for me. Most Difficult? My hardest project was (still is) one created by a PhD student who graduated and left the institution. It was a custom-built site written from scratch, and it's purpose...

• 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 "Tools > Options". When it's done it will popup an alert and then try to open the folder containing all the images it just created. Take a picture Go to Tools > then select "Take a picture". Wait a few seconds (default is 15) for the program to do it's...

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

Joes Quicklist Weblinks (JQW)https://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 Go to "Extensions" > "Module Manager" > Click on module to publish/customize it. Specify the images folder as the one you created in step 2. Switch "STOP Thumbnail Service" to "NO" Specify a group which can generate thumbnails and use the service. Login...

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

Importing Joomla articles to WordPress postshttps://joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

16 August 2011 INSERT INTO my_wordpress_db.wp_posts SELECT id 'ID', 1 'post_author', created 'post_date', created 'post_date_gmt', CONCAT(introtext, ' ', `fulltext`) 'post_content', title 'post_title', '' post_excerpt, CASE state WHEN '1' THEN 'publish' ELSE 'draft'...

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

Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 ** Author: Joel Lipman ** ** Created On: 12 October 2012 ** ** Revision: v1.2 ** ** Description: Script to create a SQL query which searches a database with SOUNDEX (detects typos). ** ** ** ** Usage: ** ** Step #1: EXEC...

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