Accessing Apimo WebService APIhttps://www.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 via method GET: FAIL $header = array( "Content-Type: text/xml;charset=UTF-8", "Accept: gzip,deflate", "User-Agent: WWPC uAPI Test", "Cache-Control: no-cache", "Pragma: no-cache", "Connection: Keep-Alive", "Host: api.apimo.com", "Content-length: "....

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 of a button in a report row) but I've also used this on the submission of a stateless form, in deluge: v_nTitle = encodeUrl("Test"); v_nText = encodeUrl("Test Content"); openUrl( "#Page:Notify?p_NotifyTitle="+v_nTitle+"&p_NotifyContent="+v_nText+"",...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 say this will take between 24-48 hours but I have often found that after a few hours, the effects have been propagated. A test I like to do is open the command-line in MS-Windows or the terminal on MacOS, and ping both creator.cs.zohohost.com and the...

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

Xero API: Send Multiple Invoiceshttps://www.joellipman.com/articles/crm/xero/xero-send-multiple-invoices.html

15 August 2021 like: { "Invoices": [ { "Type": "ACCREC", "Contact": { "ContactID": "abcdef01-2345-6789-abcd-ef012345678" }, "Reference": "TEST Invoice (DO NOT ACTION) 1", "DueDate": "2021-09-13", "Date": "2021-08-13", "LineItems": [ { "Description": "My expensive...

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

Zoho CRM: Schedule a Meeting using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-meeting-using-deluge.html

02 March 2022 kind of record) m_ScheduleMeeting.put("What_Id",98765432109876543); // // the subject m_ScheduleMeeting.put("Event_Title","TEST Consultation: Call with TEST LEAD"); // // the description m_ScheduleMeeting.put("Description","More info / agenda"); // //...

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

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

01 March 2023 on most systems: l_CsvFileRows = List(); l_CsvFileRows.add("Me,Myself,I"); l_CsvFileRows.add("a,b,c"); // v_CSVFilename = "Test.csv"; f_CSVFile = l_CsvFileRows.toString("\n").toFile(v_CSVFilename); // // sometimes works but sometimes yields: //...

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

ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 - If custom field "Amount To Be Taken" is not greater than zero, then defaults to balance due of invoice. More Information: TEST PAYMENT SCENARIOS WITH PHYSICAL TEST CARD // Send in as payment endings: eg. $100.00 == payment approved 00 Payment Approved...

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

Zoho Workdrive: Getting Team Folder IDhttps://www.joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 ====================== // upload the file to this folder if(v_WorkdriveFolderID != "") { v_PermaLink = ""; // // generate a test CSV v_NewLineChar = hextoText("0A"); l_Csv_File = {"Header1,Header2","Row1_Data1,Row1_Data2","Row2_Data1,Row2_Data2"};...

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

Zoho Deluge: Nested Catch Statementshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 2 fail for whatever reason. How? Admittedly, perhaps this maybe wasn't possible but as of February 2024; I have been able to test and implement this. Consider the following code: try { v_Test1 = "Foo"; info v_Test1.toLong(); } catch(e) { info "Couldn't...

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

Counting the occurence of a word within a string: Benchmarkhttps://www.joellipman.com/articles/web-development/php/counting-the-occurence-of-a-word-within-a-string-benchmark.html

06 September 2009 because when I was only trying to look up how to do this, this nut "the Storyteller" went and carried out a benchmark test on the most popular ways of counting the occurrence of a specific word within a string of text. Source:...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Pancakeshttps://www.joellipman.com/articles/_other-misc/pancakes.html

07 July 2009 round before you make each pancake. Now get the pan really hot, then turn the heat down to medium and, to start with, do a test pancake to see if you're using the correct amount of batter. I find 2 tbsp is about right for an 18cm/7in pan. It's also...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 Hopefully you already have a working Joomla website set up. Go to the phpBB website (www.phpbb.com) and download their latest stable release. At the time of this article, this was version 3.0.5, but RocketTheme are fully aware of this and seem to be...

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

Community Builder in Joomla Vulnerabilityhttps://www.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 diagnostic page for this address I understand that visiting this site may harm my computer. Continue? Even if you use the latest versions of Community Builder (v1.2) and Joomla (v1.0.14) then you're vulnerable to a hack. Watch for users signing up with...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 2013 - How to use this migration script: Make a backup copy of your old Joomla website (1.5.x) Download and install the latest Joomla CMS Go through the Joomla Web-based Installation GUI until the process deletes the Installation folder. Avoid...

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

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 in settings) --- Impact (free-text message by developers -> who does this affect?) --- Progress Status (acknowledged, testing, qa [=awaiting customer], resolved, postponed) --- Progress Indicator (red, green, orange) --- Create Date / Modified Date /...

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

Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 required, have fun! What's it detecting? Currently it just reads the size of packets sent and received. This allows me to test websites for example and compare page loads. It's more fun on a networked computer which is constantly writing back and forth...

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

Migrate Joomla Users to WordPresshttps://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 available. Here's code to top off the user migration, save it to an empty PHP file and upload/run it on your server: please test before using!

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

How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 to the SSRS Run the report from MS Internet Explorer Check results using Microsoft SQL Server Management Studio (SSMS) My test results showed that in fact my time was closer to the "TimeProcessing" field of the ReportServer database, but good enough for...

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

Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 solutions out there, this is just how I did it. This may look like a horrible report which would fail an accessibility test but visually it says straight away which is the better report; and when comparing to the previous runs (using a second dataset)...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 Thought I'd add the migration script I've been using to test my JComments migration from my Joomla CMS site version 1.5.20 to Joomla CMS site version 2.5.6. DISCLAIMER I do not work for either Joomla or JoomlaTune (Jcomments) This script is provided as...

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