ZohoDeluge: Inserting a new line character in a CSVhttp://www.joellipman.com/articles/crm/zoho/zohodeluge-inserting-a-new-line-character-in-a-csv.html

01 March 2023 Adding to a screen output: eg. a button response or response of info: try holding down the ALT key and pressing 255, then releasing the ALT key and save the change to your code. This will not display a character but is a new line... Used in certain...

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

ZohoAnalytics: Pivot Campaigns vs Contactshttp://www.joellipman.com/articles/crm/zoho/zohoanalytics-pivot-campaigns-vs-contacts.html

20 March 2023 (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers on each row and then the campaigns as columns. What we want: Contact Name Lead Source Campaign 1 Campaign 2 Campaign 3 ----------------...

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

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

21 March 2023 order was delivered. How? So first I'll give some brief instructions on how to get an API key from DHL as a developer and then I'll include the code to query the shipment status based on a tracking number. Becoming a DHL Developer Browse to...

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

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

28 March 2023 update a time field with a string is a no go. Set it to an atom time or nice SQL date/time (eg. "yyyy-MM-dd HH:mm:ss") and then apply the function .toTime() Source(s) Zoho CRM v3 Organization API Zoho Community Forums - CRM Business Hours through the...

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

Zoho Inventory: Enable Tracking using the APIhttp://www.joellipman.com/articles/crm/zoho/zoho-inventory-enable-tracking-using-the-api.html

04 May 2023 be deleted, set the opening stock to zero: Guess who's going to have their opening stock set to zero, save the record, then delete it. Source(s) Stack Overflow - Using the Zoho Inventory API can you set the item to Track Inventory and Track Serial Number

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

Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttp://www.joellipman.com/articles/crm/zoho/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

12 July 2023 at time of print. Things can change though and if the function is changed to remove every instance of the "distinct" list, then I'll have to come up with a different solution. Maybe Zoho could introduce a removeFirst() if they change removeAll().. The...

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

Zoho Deluge: Proper Case for Nameshttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 without any completion in mind; to set the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions. Why? Some of the Zoho Apps are incredibly case-sensitive and consider some records containing people's...

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

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

04 October 2023 period/dot character... Some might suggest it's an authorization error but if you do a getRecordById and it works then the 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...

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

Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Departmenthttp://www.joellipman.com/articles/crm/zoho/zoho-crm-zdk-client-script-auto-select-pipeline-based-on-user-department.html

16 October 2023 is automatically pre-selected based on the user. How? So there's a bit of a pre-amble for setting up the fields, we'll then use a client script to automatically read the user's record, retrieve the department, and set the correct pipeline option. Setup:...

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

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

07 November 2023 generate a dynamic map of system values held in a ZohoBooks instance. Why? Rather than hard-coding and having a ton of if..then statements, I can feed these maps a textual value and it returns the ID to use. Some of these can be found elsewhere in my...

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

What can MAGA’s do to stop Biden from cheating again?http://www.joellipman.com/articles/_other-misc/jokes/what-can-maga’s-do-to-stop-biden-from-cheating-again.html

28 August 2024 guy goes to a bar and is served by a robot bartender. The robot says, "What'll you have?" and the guy says, "A martini." He then gets the best martini he's ever tasted. The robot says, "What's your IQ?" The guy says, "167." The robot proceeds to chat...

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

Zoho CRM: Remove Duplicate Product Recordshttp://www.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 but if the duplicate is the one used in a transactional module record (eg. quotes, sales orders, invoices, purchase orders), then it will delete the older one (referred to as keep ID). Another point is that this is using COQL to sort the records and...

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

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

13 March 2025 Method section. Enter a required email address to receive alerts if your Notification Endpoint URL becomes unreachable, then click Save. Enter your Notification Endpoint URL, which must use 'https' and be accessible to you, and ensure it can respond to...

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

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

20 March 2025 adjustments, we'll run a check after the invoice is created/updated and check that the total matches the CRM grand total and then add the difference as an adjustment with the description "Rounding Off": v_TotalAdjustments = 0.00; for each...

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

Zoho Deluge: Connect to Shopifyhttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-connect-to-shopify.html

15 July 2025 was an absolute waste of time with regards to what I was attempting to do. How? Let me show you how we used to connect and then what the new code will be. The preamble to both of these is how to get the values to include in the invokeURL headers and...

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

Converting SQL date in PHP to European date format and vice-versahttp://www.joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 Issue If you've ever made PHP scripts to process data within a LAMP environment (Linux, Apache, MySQL, PHP) then this happens a lot. In the following example, our HTML form will allow the user to specify a date (so excludes hours, minutes and seconds)....

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

Cranberry flapjackhttp://www.joellipman.com/articles/_other-misc/cranberry-flapjack.html

07 July 2009 on each side until golden. 4. For the caramel sauce, in a hot pan, add the butter and sugar and cook for 3-4 minutes. Then add the cream and orange segments. 5. Serve the flapjacks with the caramel sauce.

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

Peanut Butter Milkshake Recipehttp://www.joellipman.com/articles/_other-misc/peanut-butter-milkshake-recipe.html

05 September 2009 wish (I use 1 cup); pour into blender, and add the vanilla and peanut butter. Whirl for 1 minute; add 2 scoops ice cream, then whirl 1 minute more. Servings: 1 Source: http://www.recipes-4u.co.uk/drink/Peanut-Butter-Milkshake.html

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

Can't play music after Firmware Update Version 3.0http://www.joellipman.com/hardware/cant-play-music-after-firmware-update-version-30.html

21 September 2009 sound goes from the Playstation to the Sound System via Optical Out. I found that if you do enable the multi-audio output then you can play music again. What a bummer you can't play music and use anything else anymore. I can still play some games and...

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

Migrate MediaWiki to another serverhttp://www.joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

23 September 2009 on wikidb.* to wiki@localhost identified by 'YourPassword' ; MediaWiki Upgrade copy all the new files to wiki folder and then run php update.php from maintenance folder after updating AdminSettings.php More Information...

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