Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-error-code-2945-extra_key_found_in_json.html

04 October 2023 connection string is fine. What I was doing?: I'm not saying this is the solution to whenever you get the above error; I'm just saying this what I was doing and this is what fixed it when I ran into this error: // initialize m_QuoteRecord = Map(); // //...

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

Zoho Books: System Values Mapshttps://www.joellipman.com/articles/crm/zoho/zoho-books-system-values-maps.html

07 November 2023 textual value and it returns the ID to use. Some of these can be found elsewhere in my site but I'm putting all of them here just for quick reference. How? Note that for the below, I recently updated this article (2024-05-21) due to the API domain name...

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

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 connection to ZohoBooks from ZohoCreator called "zbooks". It has fullaccess as a scope but I'm sure you can lock it down to just the scopes you need. void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID) { v_OrderID = ifnull(input.p_OrderID,0).toLong();...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 the crmAPIRequest variable will hold the payload. Same with responding with the variable crmAPIResponse. Don't overthink it, just accept it. Less headaches for everyone. Source(s): Shopify Dev - REST API - Retrieves a list of webhooks Shopify Dev - REST...

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

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

22 July 2024 events for this month from ZohoProjects. How? The bit that stumped me was making a call to the Events endpoint as it would just come back with a blank response... The reason it was blank was due to my parameters; the key item to remember is that status...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 = r_UpdateBooksInvoice.get("invoice").get("invoice_number") + ": " + r_UpdateBooksInvoice.get("message"); // // adjustments if(r_UpdateBooksInvoice.get("invoice").get("total") != v_Crm_Invoice_GrandTotal) { v_TotalAdjustments = v_Crm_Invoice_GrandTotal...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 Line Items re-written successfully', { type: 'success' }); } } } catch (e) { // return error (don't display it, just show it in the logs) console.log(e); //ZDK.Client.showMessage("Client Script error"); } standalone.fn_Quotes_GetQuotedItems If you...

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

MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 Just noted this down in case I need to do it again. This article documents how to take a 5.5 hour video (MP4) and have it transcribed by a locally installed AI on a MacOS (running Sequoia 15.1.1). Why? Needed for training videos as a follow-on from my...

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

Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 How? First, we'll setup a client script specifying what triggers it (on load of the page when creating an invoice) then I'll just put the client script I used to map over all the applicable field values from the quote to the invoice within ZohoCRM. Set...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 v_DiscountAmount = ifnull(m_XeroLineItem.get("DiscountAmount"),0.0); if(v_DiscountPercent != 0) { // just qty vs unit excluding discount and tax v_LineItemTotal = m_XeroLineItem.get("Quantity") * m_XeroLineItem.get("UnitAmount"); v_DiscountFactor =...

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

Hide Menu Item from Registered and Special https://www.joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

06 September 2009 at this date/time. Can't simply hide an item but can hide a menu (of course the menu could have been created with just one item with no title and positioned at the bottom of another menu; this would look like it was all part of one menu). toubkal wrote:...

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

Restoring your WYSIWYG editor after upgrading Joomlahttps://www.joellipman.com/articles/cms/joomla/restoring-your-wysiwyg-editor-after-upgrading-joomla.html

15 September 2009 WYSIWYG (What-you-see-is-what-you-get) editor halved its number of buttons and I couldn't add code snippets... The Fix Just installed JoomlaFCK WYSIWYG Editor, an editor I use with my day job's MediaWiki software and it's pretty amazing. Incredibly...

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

How to run a .RUN filehttps://www.joellipman.com/articles/linux/how-to-run-a-run-file.html

19 September 2009 Open a terminal by going to Application > Accessories > Terminal Type 'CD Desktop' to go to your desktop folder Type 'LS' just to check the .RUN file is in this one Type 'sudo sh nameoffile.run' Through the Gnome GUI Right-click on the file you...

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

Does Google Chrome Frame really improve performancehttps://www.joellipman.com/articles/google/does-google-chrome-frame-really-improve-performance.html

23 September 2009 Manager Select the template and click on 'Edit' Click on 'Edit HTML' Look for the beginning tag Insert the code above just after the tag Click on 'Save' and you're done More Information: http://code.google.com/chrome/chromeframe/

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

Joomla banners not rotatinghttps://www.joellipman.com/articles/cms/joomla/joomla-banners-not-rotating.html

20 October 2009 same category. The setting is in your Joomla > Module Manager > Banner... What I do is I don't select a client but instead just select a category. Set it to only display 1 banner at a time. If you want other categories to display, consider setting...

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

Clicking on a weblink returns a 404 errorhttps://www.joellipman.com/articles/cms/joomla/clicking-on-a-weblink-returns-a-404-error.html

06 November 2009 weblinks and you come across this error: "404 - An error has occurred. Joomla! was unable to locate the stated resource." Just check that the category the link is in is published.

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

On Gui Resize Eventhttps://www.joellipman.com/articles/automation/autohotkey/on-gui-resize-event.html

09 November 2009 when you resize the app. Syntax: GuiSize: GuiControl, MoveDraw, MainRedBackground, w%A_GuiWidth% h%A_GuiHeight% Return If I just used GuiControl, Move,... then this would be as above but if you are using images, then you will get problems with the...

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

Outputting PHP files into different file formatshttps://www.joellipman.com/articles/web-development/php/outputting-php-files-into-different-file-formats.html

12 February 2010 I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do that instead. PHP to TXT header('Content-Type:...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/database/mysql/search-and-replace-in-a-mysql-database.html

17 March 2010 Ok is it just me who does everything slowly and badly until someone comes along and says why are you doing it like that? My justification is that the job has to be done no matter what. If you've ever sat there with phpMyAdmin or a MySQL Administration...

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

SSRS Report Builder 2.0 - Error during processinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

06 May 2010 Properties' Select 'Parameters' and click on the duplicated field Click on the 'Delete' button and you should be left with just: Test and run your report :c)

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