Assuming client is required, the following 114 results were found.
-
Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory level or stock check of all the products that are currently listed...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
!= null) { if(r_CreatePayment.get("message").contains("payment has been created")) { // // update the invoice (request by client to store last 4 digits on invoice) l_CustomFields = List(); m_CustomField = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
but at least a working example of an ANSI-SQL (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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
and changed the Top Level Domain (or Zoho DataCenter) from EU to COM as I was using this for a client on the US datacenter. I have a connection called "zbooks" and the v_BooksOrgID is the ID of the instance in ZohoBooks; so for multiple instances of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
an article to document how to produce a report which when exported to PDF will display images without a user wall. Why? Our client needs to send a report to suppliers that include photos of the faulty products. These display fine in a Zoho Creator...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
A quick article on retrieving all the products from a WooCommerce instance on a client's Wordpress website. Why? A client of ours wants the information entered against products in their WooCommerce to display on their estimates in Zoho Books; such as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
We then need to remove this task as it will transfer to the contact record on conversion. This has been applied for my client, but I'm awaiting feedback (UAT = User Acceptance Testing) to ensure this behaves as expected. So I found another function was...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Note that when I refer to pricebook, this is also referred to as the pricelist... and vice-versa. And in this use-case, my client has added an incredible number of price books/ price lists and then has in excess of 20k items. Previously, the function...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
list in ZohoBooks, and a reminder on how to read a table from ZohoAnalytics. Why? My use-case here is that we have a client who uses their purchase orders and sales orders as part of a logistics solution where items are purchased from a supplier, sent...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Zoho CRM. Why? To prove a point to ChatGPT who said this was not possible... and to deal with a scenario which exists for a client of mine. The use-case for my Cx is that they need documents converted from HTML to PDF — as in we send it a bit of code in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
2025-03-13 (Joel Lipman) - Initial release Date Modified: 2025-03-13 (Joel Lipman) - Validated Webhook - Send email to client More Info: https://developer.ebay.com/marketplace-account-deletion metadata.topic topic of the notification...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
figures. They're wrong in any case as they don't match the ZohoCRM... or both are just not matching... either way, your client will likely only accept the previous solution. I wanted to use a regex rather than treat the number as a string and truncate...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
your computer and then upload the resulting files to the http://www.mysite.com/phpBB3 folder you would create via your FTP client. When that's done, navigate to http://www.mysite.com/phpBB3/install/ and you get a web installation setup GUI similar to...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
K2 Items disappearhttps://www.joellipman.com/articles/cms/joomla/k2-items-disappear.html
Fix I managed to fix this with this SQL command . Note: you need to be able to run SQL commands against your database. My client had phpMyAdmin installed so I click on "jos_k2_items" table and then click on the "SQL" tab Type the following query: REPAIR...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
this would be easy to hard-code and override. However, the article below demonstrates how to make this an option that your client can switch off/on using the Joomla Admin Panel. How? For demo purposes, I'm going to add the background "Ambient...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
to Joomla CMS v2.5.14 What? This article is a note on how I fixed an issue on a client site. The website had a redirect on the login which would go to a page accessible by "registered" users but only "Super Users" could actually login. "Registered"...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
the following: SET DATEFORMAT dmy returns the date in European format irrespective of the regional settings of either the client or the reporting server. Removed @GivenDate datetime, from the SQL script Removed @GivenCampus varchar(100) from the SQL...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
To: MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
be that your computer is losing time because of a system clock problem. A workaround in this instance is to change the NTP client to update more often. Note: The following process requires administrator (installation) rights on your computer. Open...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
but as this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted any person visiting the old domain to be redirected to the new domain. Why?...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *