Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 maybe your CSV contains multi-line fields; eg. where address street is on a different line to address city but in the same column... The following regex will replace new lines found in between 2 double-quotes and not at the end of the line:...

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

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

16 January 2023 no subfolders and only unique filenames herein. Perhaps if you were doing this over several imports, you could use the same filenames, I didn't try this, instead my program generates a unique MD5 for each file with the filename appended. Because of MS...

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

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 much affect on the above but it is recommended you do as it did work if the criteria were encoded... The criteria is in the same syntax format as the one used in the Search API call. Code-wise using the same criteria variable for both calls might offer...

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

PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 images are over 1Mb. So I needed a tool that every time a new product is added, a thumbnail gets generated and stored in the same application. Trawling through the first few pages of Google, all the online tools that did the same had a pricing page. I...

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

Splatter Logohttps://www.joellipman.com/graphic-design/splatter-logo.html

30 September 2009 I could just have it here for easy reference. It was written for Photoshop but I use Paint Shop Pro and felt I could do the same. It's just so complicated in Photoshop when web-developers need to be able to run several programs at the same time and...

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

SSRS Repeat Headers in PDF Reporthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-repeat-headers-in-pdf-report.html

26 October 2011 Problem I've set some tablix headers but when I request the same report in PDF format, the tablix headers only appear once on the first page. Every subsequent page simply displays the report header (which does not include the tablix header......

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

JComments errors in PHP 7: plgContentJComments and JCommentsACLhttps://www.joellipman.com/articles/cms/joomla/jcomments-errors-in-php-7.html

13 March 2020 what needed doing to fix the errors. How? First some errors: ERROR: plgContentJComments Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; plgContentJComments has a deprecated constructor in...

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

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

12 July 2010 in another folder. I needed a program to: Check the final folder for all the MP3 filenames Check the original folder for the same filename (BUT NOT necessarily with the same extension) Delete the original file if I have the MP3 version as well Why...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 someone else's complicated connection using SQL Server Management Studio and would not recommend anyone to go through the same rubbish. I just took a step back and thought this through and this is what I came up with! Additional The above will all work...

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 + '/01/2009 01:30:00 PM', Note = 'Event 6' ) SELECT -- Number the records based on the date, if multiple records have -- the same date then they will be numbered the same. Used in -- calculation to determine row record is to display on. [Order] =...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 hopefully make all rooms (even empty ones) display. Note the second select statement (to list all the rooms) has to have the same number of fields as the first statement. This is the final script for the events table (DO NOT USE THE BELOW: this works...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 Mac using Safari, and a third was using Mozilla Firefox. We told them to go back to the template providers and report the same problem to them...??? Staff member requiring access to a secure application "So that's all installed for you. I just need you...

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

Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 the updated one, and install as per usual. IMPORTANT NOTES: All images in the folder for the weblinks have to be of the same file type (eg. BMP, JPG, PNG, GIF, or TIF). The program I had made to take the screenshots made them all the same type which is...

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

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 not because "fields cannot be used in report parameter expressions". I tried this with "Default values" and got the same problems. Note: before you try, "Variable values cannot be used in report parameter expressions" either. I'm using an Oracle/PLSQL...

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

Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 understand how it works only that it does. I think this could get complicated if you had two dropdowns reading off the same list but needed to list elements in different orders. If you haven't made a dropdown list yet There's other instructions out...

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

MySQL last year week month day trend periodshttps://www.joellipman.com/articles/database/mysql/mysql-last-year-week-month-day-trend.html

31 October 2011 of being activated or not). It needs to pick up trends as well and compare for example todays, with yesterdays up to the same hour. How? I used to use a lot more PHP but since becoming an analyst, I do more at the database level now. What follows should...

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

How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 field1, field2, TO_CHAR(systimestamp, 'HH24:MI:SS.FF6') AS ReportStartTime FROM... Then add another dataset (using the same data source if you like): -- Oracle 10g: DataSet2 -- a quick dataset following the first (started before the first ends? hope...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 so that you can define the query parameters. 4c. Add a dataset: the "Parameter Names" Under "Parameter Name" type the exact same name for the input variable used in your Oracle stored procedure (in my example: p_STUDENT_ADNAME). Under "Parameter Value"...

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

No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 ID number, then the first query returns NO ROWS and then the second query errors and the whole stored procedure fails. The same problem happens when using these as a subquery which has an empty result set. Furthermore I am using this stored procedure in...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it DataJumble as opposed to my article on Data-Scrambling....

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *