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

31 March 2022 is an article documenting the process of publishing a Zoho Inventory image to eBay's Picture Hosting Services (EPS). Why? Because I couldn't find any other article in the whole world wide web that had a working solution. My use-case here is that I have...

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

Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 to PDF. But when you download the PDF and view this outside of the Zoho instances, the photos don't display. This is because the photos were just links in the Zoho Creator image field, links to another Zoho app that is behind a user wall (ie. login and...

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

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 null. How? We are using an API action called "Add_Tags". I'm going to get the tags of the contact record using an invokeurl because shortcode only gives me name and ID; but I want the color code field as well which I only seem to get with an InvokeURL....

• 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 to Zoho the Client doesn't use the Items module in Xero and instead puts the product name in the description field How? Because my head is a little fried, I'm putting the two functions I used here and I'll document further if I remember. Note that the...

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

Border settings not saving in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/border-settings-not-saving-in-ssrs.html

24 March 2011 may sound silly to some but I've written a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that a...

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

Error 404 Component Not Found when enabling SEF URLshttps://www.joellipman.com/articles/cms/joomla/404-component-not-found-sef.html

02 September 2015 requested page can't be found. An error has occurred while processing your request. You may not be able to visit this page because of: - an out-of-date bookmark/favourite - a mistyped address - a search engine that has an out-of-date listing for this...

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

Zoho Deluge - Hide Reset Button on Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-hide-reset-button-on-form.html

15 November 2018 the reset button on a non-stateless form (state form?). I have posted this on the Zoho forums as well but here goes: Why? Because I can. And because as someone said, a "reset" button is so 1990. I have a confirmation page and don't want the button to...

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

Zoho Deluge: Generate and Send a CSV via Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 A super quick article to remind me how to generate and send a CSV as an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me every month"... How? Rather than just babble on about it, here's...

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

Zoho CRM: Make Upload File Field Mandatoryhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-make-upload-file-field-mandatory.html

18 December 2024 What? A quick article on making an "upload file" field mandatory. Why? Because for some reason, it wouldn't appear as selectable when I tried using a layout rule. Probably everyone else has figured this out and I'm just late to the party. How? Through...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 have to keep finding a function that gives me the syntax of how to either create or update a record using invokeUrl. Why? Because my designers keep including custom fields in their transactional modules line items (quotes, sales orders, invoices,...

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

How to redirect the visitor after the contact pagehttps://www.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 the frontend you will see the menu item for the page you created. Click on that link to view your page. We are doing this because you need to find out the exact URL of the page you created. Make sure to copy the URL as we will need some of it in step 3....

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 I added this article 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: *

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 and when I only had one Joomla site with them, they still would block me thinking I was trying to hack into their servers because of the number of queries Joomla does and the number of times I refresh the page and upload files. Why they think that...

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

Using K2 with jezReCaptcha plugin causing errorshttps://www.joellipman.com/articles/cms/joomla/using-k2-with-jezrecaptcha-plugin-causing-errors.html

25 September 2009 ) in /public_html/components/com_k2/lib/recaptchalib.php on line 67 I've managed to fix this in my site. Because you already force the recaptcha feature in your registration form and contact form (on this website I just went recaptcha-happy), then there...

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

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 and 'hits' in descending (so most hit first) For specific categories For my website, I've shoved all my links into one page because I didn't like how weblink categories display on the weblinks page. I could modify the page for categories (by default...

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

Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

20 January 2010 The reason I did this is because AEC is now a commercial package and it is somewhat limited in terms of good customer service. It only really manages the payment side and the complicated tasks of invoicing, but Community Builder provides more options...

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

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 in Windows Vista (and originally from Linux variants). Sometimes you may only have partial Aero effects. This can be because Windows may not think your machine is powerful enough to run these effects without affecting performance. If this is happening...

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

Report Builder 2.0 - Hide Series1https://www.joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 WHERE _SMDBA_.Incident.[Group Name] LIKE @GroupName Based on the assumption that "Series1" displays on my chart because of values that are not matched (not assigned to a current individual) in the joining tables: Return to the Design interface (F8)...

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

Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 name for a program and I might be infringing on copyright... Basically this is the third time I wrote this program, simply because I reghost all my computers (Home & Work) each year and can't be bothered to retrieve accidentally deleted programs from my...

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

Crystal Reports: Exporting to Excel omits column headershttps://www.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 results. One solution was to untick "Simplify page headers" on the Excel Format Options when you export the report. Because our report is exported via a web-based system, this extra dialog doesn't appear when our users export their reports. Not that it...

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