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

30 January 2011 Re-associate correct parent ids and start rebuilding paths in J30 -- 4) Complete hierarchical paths in J30 -- 5) Correct internal Joomla links to sections -- 6) Correct internal Joomla links to categories -- 7) Update com_user (J15) as com_users (J30)...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKL"; v_FileInternalName = row.Upload_File; // looping through rows here but it wants the internal name here eg. "1234567890123_temp.pdf" // // build the...

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

Proposed Budget i3 PC under £200https://joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 Instant Boot) - ASrock £37.58 Hard Drive Western Digital Caviar Blue 160 GB (7200 rpm) SATA 8 MB 3.5 inch Hard Drive (Internal) - Western Digital £24.95 Memory Corsair CMX4GX3M1A1333C9 XMS3 Desktop Memory 4GB - Corsair £20.05 Optical Drive Sony...

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

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

16 January 2023 the Contact in the 3rd-party database and column B contains the filename as downloaded from the 3rd-party database. And an internal file where column A is the ZCRM Record ID (eg. if Contacts module then the CRM Contact ID) and column B contains the...

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

SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL query would take to recover the data and present it in a report, which would average...

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

GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 information to understand your needs and provide you with a better service, and in particular for the following reasons: Internal record keeping. To improve our products and services. To periodically send promotional emails about new products, special...

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

Privacy Policyhttps://joellipman.com/static-items/privacy-policy.html

30 May 2009 information to understand your needs and provide you with a better service, and in particular for the following reasons: Internal record keeping. We may use the information to improve our products and services. We may periodically send promotional...

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

Change the login link in MediaWikihttps://joellipman.com/articles/cms/mediawiki/change-the-login-link-in-mediawiki.html

22 September 2010 the WWW but I obviously don't how to use Google because I couldn't find an answer. My situation is this: We have an internal wiki knowledge base using MediaWiki version 1.14. Some articles are available for public, some are restricted to staff and...

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

PHP & MySQL Search Enginehttps://joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 $search = array ( '@ @si', // Strip out javascript '@ @si', // Strip out Inline Stylesheets '@[{].*?[}]@si', // Strip out Internal Joomla Curly Brackets commands? '@@si', // Strip out HTML tags '@([\r\n])[\s]+@', // Strip out white space '@&#(\d+);@e'...

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

Win32 Constantshttps://joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = $00000100 Const DT_EXTERNALLEADING = $00000200 Const DT_CALCRECT = $00000400 Const DT_NOPREFIX = $00000800 Const DT_INTERNAL = $00001000 Const DT_EDITCONTROL = $00002000 Const DT_PATH_ELLIPSIS = $00004000 Const DT_END_ELLIPSIS = $00008000 Const...

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

Joes DNS Correction (JDC)https://joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 2) Run the EXE (there is no install process, it should just start) 3) Done! ChangeLog: v1.0 (22/11/2011) - Display internal and external IP address - Display flushdns errorlevel - Display registerdns errorlevel - Change color to green if successful, red...

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

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

19 January 2012 > "query parameter values" under "Parameter Name" and then the SSRS parameter value (eg. "[@my_ssrs_parameter]"). Internal .Net Framework Data Provider error 30 - Wrong datatypes I was told but found this is just how I was calling the parameter. I...

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

Data Randomization Function in Oracle PL/SQLhttps://joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 IN VARCHAR2 DEFAULT NULL -- no effect on strings ) RETURN VARCHAR2 IS v_char_at NUMBER := 0; -- v_char_at : internal variable for string indexing v_rand_param1 VARCHAR2(50) := ''; -- v_rand_param1 : parameter 1 for dbms_random function v_rand_param2...

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

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

23 February 2014 existing files. It's easy to say "Yes" and replace all files. What I need is something that synchronizes files on an internal hard drive to an external one. I wanted it to copy only the files that were new in the original folder and only copy those over...

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

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

24 October 2014 are being developed to write to a mounted external SD card so they can share data but for the time being they are on the internal storage (like most apps). If you want to backup the files for the hangar, they are stored in this apps files folder:...

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

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

28 March 2015 XML is encoded in UTF-8. // set headers for JSON file // header('Content-Type: application/json'); // seems to cause 500 Internal Server Error header('Content-Type: text/javascript'); header('Access-Control-Allow-Origin: http://api.joellipman.com/');...

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

Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 on the web? I have tried adding the following to my headers: This does nothing: // add these to the header: DOESNT WORK mb_internal_encoding('UTF-8'); mb_http_output('UTF-8'); mb_http_input('UTF-8'); This does nothing: // add the following to your...

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

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 = if(r_HoldInCreator.trim()!="", r_HoldInCreator.toLong(), 0); if(v_NewCreatorID != 0) { // re-get this record (to get the internal file name) r_NewCreatorFile = Download_File[Owner_Email == v_ResultEmail && File_Ref == v_ThisFileCrmID];...

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

Zoho Creator: Change Radio into Tabshttps://joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 horizontally v_Css = v_Css + ".zc-Tabs-group .choice-table-row{display:inline-block !important;padding:0;}"; // fix internal padding ("Quote" was higher then other radio options) v_Css = v_Css + ".zc-Tabs-group .choice-table-cell{padding:0...

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

ZohoCRM: Get All eBay Active Listingshttps://joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 to eBay Listings The megafunction So I'm going to call this function "Fn - eBay - Get Active Products" and give it the internal name as "fn_GetEbayActiveProducts" without any arguments. Something to note in the below is that it asks you to set an...

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