ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 files to attach that needs some formatting as well: Note that any IDs used in the snippets of code or screenshots below are made up. the Attachments.csv A data backup or export of the Attachments from ZohoCRM will return to you a CSV of attachments....

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 Pet Photography Portrait Photography Sports Photography Street Photography Travel Photography Wedding Photography Manmade Objects Architecture Fine Art Photography Food Photography Product Photography Real Estate Photography Still Life Photography Tech...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

06 July 2023 to do the same thing but unnecessarily moved the pointer to the start of the week. It could also error eventually if Zoho made it possible to change the start of the week (this is in ZohoCreator; I'm aware that some of Zoho Apps do allow this) in the...

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 product categories so we'll just to page 1 but specifying 100 per page as the default is only 10. // // API keys (these are made up so enter your own in these 2 lines below v_MyWordPressSiteUrl = "https://mysite.com"; v_ConsumerKey =...

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

Zoho Deluge: Convert Hex to RGBhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-hex-to-rgb.html

11 October 2024 each character from the given string and convert it to its RGB value. Replace letters A to F with their numeric equivalents. Made up of 2 characters to convert to an RGB subset, the 1st value is to be multiplied by 16 and then added to the value of the...

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

Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://www.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 give it some text, I'm going to start with Accept Quote Then click on the link icon and give it the link noted from the URL made earlier (the one to the CRM REST API function): // should be something like...

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

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 # symbol to map it to "Deals.Deal Id" Save and close the function In the list of functions, hover over the function you just made and select "REST API" Enable both OAuth and REST API Click on "Save" to close the dialog box Client script to show/hide...

• 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 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

Joomla - How to preview module positions in a given templatehttps://www.joellipman.com/articles/cms/joomla/joomla-how-to-preview-module-positions-in-a-given-template.html

02 April 2010 template (without spaces). e.g. http://joellipman.com/index.php?tp=1&template=rt_affinity_j15 Or watch this boring video I made showing you how to do it: {youtube}VDEjI75zN3g{/youtube}

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

The Sandpithttps://www.joellipman.com/graphic-design/the-sandpit.html

26 September 2010 on BBC News Click and was really impressed. It's an effect called "time-lapse tilt shift photography" where everything is made to look smaller than it actually is. As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks like the...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Modifying columns in a tablehttps://www.joellipman.com/articles/database/modifying-columns-in-a-table.html

24 July 2013 in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools). All SQL -- Add a column to an existing table (giving it datatype char(2) and allowing NULL) ALTER TABLE...

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

PHP: First name and Initial of Surnamehttps://www.joellipman.com/articles/web-development/php/php-first-name-and-initial-of-surname.html

27 March 2014 A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first...

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

SSRS No Delay for First Report of the Dayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-no-delay-for-first-report-of-the-day.html

11 April 2014 Any subsequent running of the report loaded it almost immediately. How? There are a few options out there but this one made a noticeable difference. Applicable to the server, it will affect all reports on that server. Apply to each server that requires...

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

Joes Transmission Detector (JTD) Downloadshttps://www.joellipman.com/component/content/article/joes-transmission-detector-jtd-downloads.html?catid=92

07 September 2015 data packets without causing network traffic - Display program used to open port - Disallow program minimize - Background made transparent - Added received/sent data graph progress bars - Listview rolls messages (deletes first one and adds to last) -...

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

COVID-19: Working from Homehttps://www.joellipman.com/covid-19-work-from-home.html

05 July 2020 permanent solution. For fun, our office have posted what taking your work home, including the work computer, looks like... I made mine into a meme:

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