Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 in stage 1? And this in stage 2? (There are over 100 stages)... Below is my template project initiation plan (project mandate?) for my freelance website development process. It may look clean, clear, obvious... it's just an outline of what I picture as...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 two words)) within the SQL query itself. We have a DEPT column that is an acronym of the departments so for example: SELECT Date, Reservation, Contact, JobTitle, Dept FROM my_imaginary_table WHERE Contact='Joe' Would become SELECT Date, Reservation,...

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

Joes Google Map (JGM) Downloadshttps://www.joellipman.com/component/content/article/joes-google-map-jgm-downloads.html?catid=92

07 September 2015 parameters: Style for Google Maps API v3 - road.arterial - Added parameters: Style for Google Maps API v3 - poi.business - Date Uploaded: Fri, 3rd Apr 2015 Download 1.0- Released for public use - Date Uploaded: Thu, 2nd Apr 2015

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

Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 file: [mysqldump] user=my_user password=my_password The one to rule them all: // everything: using external file, suffixing date and compressing: mysqldump --defaults-file=/full-path-to/.my.cnf my_db | gzip > /full-path-to/backups/my_db/backup_`date...

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

Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 by 26 (modulus)... This is NOT to be used for Booking Retrieval Codes as it is easy to determine what code if you have the date/time of the booking as well as the customer's surname (method #1 would not be guessed by date/time): string...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 Deluge code: input.Attached_Files_in_CRM = false; Setup a scheduled task in Creator Schedules > New Workflow Choose a Date Field Start Date: select form and choose Modified_Time Run this process on condition "Attached Files in CRM equals false" Execute...

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

AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 containing an underscore (eg. 01_23) ; and then add an increment to the file name if a file with the same name exists. ; ; Date (v1.0): 8 July 2020 ; - Initial Release ; Date (v1.1): 10 August 2020 ; - Checks for duplicates done by searching its own...

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

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

15 August 2021 "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 product #1", "Quantity": 1, "UnitAmount": 240,...

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

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 An article to note something I didn't realize I needed: How to address the above error and how to update a Shipping Address for a specific Sales Order in Zoho Books. Why? You might think the following request to create a Sales Order in Zoho Books would...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 } Create a workflow to tidy up the records daily in Zoho Creator Go to Workflow > Schedules > New Workflow Set the Start date and time to tomorrow's date at 2:00am Run Daily Name the workflow Daily Delete Record Click on Create Workflow Give it the...

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

Zoho Inventory: Mark a package slip as delivered and shippedhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

14 July 2022 // // if blank then create one if(v_ShipmentID == "") { m_Params = Map(); m_Params.put("date",zoho.currentdate.toString("yyyy-MM-dd")); m_Params.put("delivery_method","My_Own_Drivers"); m_Params.put("delivered_date",zoho.currentdate.toString("yyyy-MM-dd...

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

ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 what you might have thought it was. /* Function: fn_GetEbayActiveProducts() Purpose: Queries eBay for all active listings Date Created: 2023-03-01 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: - API Explorer Test Tool:...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 the OpenAI ChatGPT API but at the same time retain the context of ZohoCRM Inputs: string userInput Outputs: map m_Response Date Created: 2023-02-08 (Joel Lipman) - Initial release - Queries OpenAI ChatGPT Date Modified: 2023-03-11 (Joel Lipman) - Stores...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 despite never running into this issue before; but sending a billing/shipping address included in a request to create or update an estimate in ZohoBooks will fail... Why? I have a function to push a ZohoCRM quote to a ZohoBooks estimate and a client...

• 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 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 change from https://books.zoho.com to https://www.zohoapis.com/books...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 a ticket is created or modified Purpose: Pushes the tickets attachments to Zoho Analytics Inputs: - Outputs: - Scope(s): Date Created: 2023-11-29 (Joel Lipman) - Initial release Date Modified: ??? - ???...

• 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 Purpose: This will send a ZohoBooks invoice directly to its recipient Inputs: Zoho Creator record ID of the order Outputs: - Date Created: 2023-03-06 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Info: Error 7008: There are no contact...

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

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

07 March 2025 Duplicates Trigger: Standalone Purpose: Used to remove duplicate products from a ZohoCRM instance Inputs: - Outputs: - Date Created: 2025-03-07 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Info: -...

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

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

13 March 2025 account. This article explains the process third-party developers must follow to subscribe to, receive, respond to, and validate these notifications. Why? As quoted from the page: https://developer.ebay.com/marketplace-account-deletion "Existing...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 I need to quickly set up a JS widget: Open a MacOS Terminal sudo npm install -g zoho-extension-toolkit (this also updates existing install) sudo zet init select Zoho CRM enter a unique Project Name cd to the new project name To give permissions to write...

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