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 // m_UpsertCrmInvoice = Map(); m_UpsertCrmInvoice.put("Subject",m_ThisInvoice.get("InvoiceNumber")); // // some standard CRM invoice fields we can populate v_CrmInvoiceStatus = m_TranslateStatuses.get(m_ThisInvoice.get("Status"));...

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

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

13 October 2025 m_UpsertCrmQuote.put("Terms_and_Conditions",m_ThisQuote.get("Terms")); // // some standard CRM Quote fields we can populate v_CrmQuoteStatus = m_TranslateStatuses.get(m_ThisQuote.get("Status")); m_UpsertCrmQuote.put("Quote_Stage",v_CrmQuoteStatus);...

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

ZohoBooks: Broken UK Banking Feedhttps://www.joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 Resolution Confirm permissions. Sign in as the Super Admin in Zoho Books. Feed management options can be hidden for standard admins. Check the current feed. Go to Banking > Selet the active account (click into it) and click the gear icon in the top...

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

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

17 September 2009 to be using the European date format so DD/MM/YYYY. The Solution This is what I use to convert a given SQL date to the standard European format: $this_date=mysql_result(mysql_query("SELECT my_date_field FROM my_table WHERE my_id='$this_id'"), 0,...

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

CSV Chart Generatorhttps://www.joellipman.com/component/content/article/csv-chart-generator.html?catid=40

04 September 2015 Chart Generator. As the name suggests, I was looking for a free program that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all the data into a...

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

Zoho Deluge: Push a value to a datetime field in CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-push-a-value-to-a-datetime-field-in-crm.html

10 September 2021 2021-09-10T12:49:31-07:00 and vice-versa CRM to Creator Depends on the format of the datetime in your Creator field but standard would be: v_CrmTime = "2021-01-01T01:23:45+01:00"; v_CreatorTime = v_CrmTime.getPrefix("T") + " " +...

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