Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 Links XML parsing in PHP convert xml to json php curl utf16_decode PHP Manual: curl-setopt Well this is my stop. It's being several hours that for others could have taken a several minutes if you knew where to look. My aim was to convert UTF-16 received...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Recruit: Rollup Number of Recruit Candidates to CRM Accounthttps://www.joellipman.com/articles/crm/zoho/zoho-recruit-rollup-number-of-recruit-candidates-to-crm-account.html

19 October 2022 it was helpful on the CRM record to see how many candidates had been placed at this particular CRM Account. We added several fields which get populated when a candidate was modified in ZohoRecruit. How? As mentioned, we're going to update several fields...

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

Zoho Analytics: Determine profits from invoices and purchase ordershttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 took into account "Delivery" as a separate line item on the purchase order. I'm writing this article as it had gone through several partners before us and even Zoho themselves without a solution. This took my team the best part of two months to find a...

• 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 ideas from my previous article for ZohoCliq; let's use what we know to develop a ZohoZIA for a demo system. There are several steps, so first we will set up the ZIA action "Ask ChatGPT" using the GUI, then we will capture the question using Deluge code...

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

Change div height to fit contenthttps://www.joellipman.com/articles/web-development/css/change-div-height-to-fit-content.html

19 December 2016 on how a heading fits on a page. What? I have a heading like this: The code of this is: A long heading that wraps over several lines When I shrink the browser, I get a heading like this: I want this to happen: The code of this is the addedn...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

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

31 May 2009 Breaking rules result in punishments. There are several types of punishments: Warning - This is where a public announcement is made that mentions your name and that you have broken a rule. I will determine whether you knew what you were doing was wrong...

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

Community Builder in Joomla Vulnerabilityhttps://www.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 picked up on and so I'll be posting solutions for those who need to keep Community Builder as their user manager. There are several things I have picked up which I will go into more detail as I test each one (11.11.09):...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 -- Yeh well you've been warned BACKUP BACKUP BACKUP! -- I have several databases and websites setup with exact copies of the -- data so I can risk this one not working. You need as a minimum, at -- least 2 databases to use the queries in this script...

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

Checklist for the local computer repairshttps://www.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 – while recovering from the backup I’d made silently. I guess it’s part of the “underpromise/overdeliver” thing… but several customers were intensely relieved when I was able to “work my magic” and save their business/thesis/whatever.″ Rates: Charge...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 testing). Options/Features Source Browser Size: Sets what the original picture dimensions are. Output Thumbnail Size: Only several presets but there are free image editors out there that will batch convert your images: 150x100, 200x150, 300x200, and 1:1...

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

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

03 July 2011 thumbnails? The authorized group to generate new thumbnails USED TO BE Administrators or Super Admins/Users. Due to several requests, the module has been modified to accommodate any Joomla! group (specified in the parameters). It is NOT RECOMMENDED to...

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

Before and After, Highs and Lowshttps://www.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 will be category field: So is this doing what I wanted? Well NO. I have a table with the same report mentioned several times but just in a different week. I want a returned table structured as follows: Report Name Run Last Week Run This Week...

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

SSRS Redirect after a report is runhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

12 August 2011 This article serves to describe several workarounds or proofs of concept. Why? We have a first report which acts like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then...

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

Excel PivotTable Filter List Orderinghttps://www.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 We have an Excel report which summarizes for our guys at the top, all the activities and time spent by staff. There are several filters available on the report (only a few to keep it simple silly). When you click on the filter, a dropdown appears with...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 upload the photos. These images are provided via a website address (http) or network share (file). Before you ask, we have several MS Sharepoint sites but we didn't go down the route of uploading 10000+ images into a Sharepoint database though we are...

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

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 Consider adding a drop of the temporary table to the start of this script if you plan on running this successively against several databases: DROP TABLE #CountRecordsPerTablePerCol or equally IF OBJECT_ID(N'tempdb..#CountRecordsPerTablePerCol', N'U') IS...

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

Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 on their customer-facing website and in most cases, they are paying for a hosting package which would allow them to have several copies of their website. Why? In my job, it is important that we have a development environment for the website/application...

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

Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 for product=NETWORK, facility=TNSMessage 3509 not foun d; No message file for product=NETWORK, facility=TNS Why? We NEED several instances of Oracle installed as we have different products/services and these run off various instances of Oracle 9i, 10g,...

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

Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 (2a) to specify the closing position of the extract. NeedleMarker is the offset and means when this function is used for several tables, the Needlemarker tells the function to start from where it last found a table and to find the next: ExtractText(...

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

DJI Phantom FC40 - Fun at the raceshttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 cars at the Torch Racing, UK event last Sunday. The FPV latency isn't good on this camera so it was no use here, so several challenges: No FPV: Keep the quadcopter pointed at the car. I treat it like a First-Person-Shooter game where I strafe right...

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