Parameters not being used in report processinghttps://joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 Once again I've spent a whole morning going in the wrong direction with a convincing SQL script. This article is just a note on when using Business Intelligence Development Studio (BIDS) or Report Builder 2.0 and when previewing the report, the...

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

Things to Check if Joomla Password Reminder email not being senthttps://joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 What? A quick article on a frequent question I get asked. This refers to an issue within the Joomla CMS (version 2.5.x) where it fails to email users who reset their password. How? A few things to check: Check the email message even exists: Login to...

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

ZohoCRM: Template: not being able to edit a text boxhttps://joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 What? This is a bit of an odd article with not 100% certainty on what the cause/outcome would be for your case but worked for us. This documents the steps taken to edit/modify the header on a sales order inventory template. Why? A client raised an issue...

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

Forum Ruleshttps://joellipman.com/static-items/forum-rules.html

31 May 2009 Flaming harms the nice atmosphere of TEU. It also causes thread's to go off topic, and most importantly, it hurts the person being flamed. The victom may defend themselves against any accusations made to them, but may not make any additional accusations...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 row, see my original data file here (sample data): And this is what a Data Viewer returned when executed: My columns were being pushed out of alignment (something about {CR}{LF} being displayed for the blank rows and inserted in the next line) and...

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

Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 aerial surveillance system (less than 20kg equipped with a camera). Regulations different to the UK and US are still being reviewed prior to being added to the database but each country's aviation authority has been added. Earthquake Feed for the past...

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

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 own Job Opening Ref m_Create.put("Vacancy Ref",r_Data.get("Job_Opening_ID")); // // update the record (note the API name being used here) r_Create = zoho.recruit.addRecord("CustomModule6",m_Create,0,false,"my_connection"); //info r_Create; } } } } For...

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

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

06 March 2023 Login/Reload ZohoCRM Click on "Ask Zia" Type the "Ask ChatGPT" and it should popup with...things you can ask me... with one being "Ask ChatGPT" Click on it and then ask away:... Keeping a Conversation So annoyingly, the variable broadcast was...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 since go live and simply specified "All Leads". I'm calling my function fn_Leads_FollowUpNonConverted with the parameter being the Lead Record ID: /* ******************************************************************************* Function: void...

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttps://joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 user tries to save the record, they will get a validation error on the decimal field even if that's not the field that is being changed: Decimal places for the Unit Price field should be less than or equal to 6 . How? The workaround for staff is to...

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

Passwords: Did-you-knowhttps://joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 to include on password checker pages: A program called LC4 (formerly L0phtCrack) used by governments and the military boasts being able to crack 90% of user passwords in under 48 hours on a Pentium II/300. Additionally, it claims that it can crack 18%...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 peer-to-peer transmission, provided you inform other peers where the object code and Corresponding Source of the work are being offered to the general public at no charge under subsection 6d. A separable portion of the object code, whose source code is...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Generate a Timesheet in MySQL https://joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more. Similar systems have popped out that support...

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

MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 to an external one. I wanted it to copy only the files that were new in the original folder and only copy those over (reason being, the archive is 4 terabytes and backing up only the changed files would speed things up). Applies to: Microsoft Windows XP...

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

A quick run through of setting up an export process in SITShttps://joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 "process for new record" and "for update" are set to "Before Store" We weren't doing anything with the deletes for the time being Store/save your TUP Setting up the monitors Log in to your application server and create the shortcuts to run the monitors...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 and not in the order of left to right. So the above code tries to determine the leftmost monitor and rightmost with the last being in the centre. First of all here's the code to open a windows application on a non-default monitor: ; Get full screen...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 (Joel Lipman) - Enhanced debug messages as function not auto-triggering on receipt of Order - Resolved: SO ID was not being returned when created. - Forced re-upload of photo for item on any modification Date Modified: 2023-03-20 (Joel Lipman) - Check...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 The Code Snippets: The Shopify Webhook Check and Restore If you notice your webhooks automatically being removed. It's often because you have it processing data rather than responding straight away (less than 1 second requirement) to Shopify with "yes...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttps://joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 go through a few thousand records and to update the related records. I was getting the error INVALID_DATA with the details being api_name:'data'... But this is shortcode, not an invokeURL. { "code":"INVALID_DATA", "details":{ "api_name":"data" },...

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

Zoho Deluge: Nested Catch Statementshttps://joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 severaly instances of an API which accepts HTML and returns a PDF file. Nothing complex but issues with one of the servers being down, or inaccessible due to certificate expirys, means that the Cx business halts. In order to add a bit of clustering, we...

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