Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming name is required, the following 277 results were found.

  1. Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    files) Get new brief from the Client (agree on maintenance & development costs/time -> custom timesheets!) Check domain name is registered/transferred to the client (quite a biggy - gives the client an exit strategy) Can the developer be contacted? No!...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  2. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/cms/website-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    10:37:24 PM Failure Incorrect Contact ID '; // Replace UTF-16 with UTF-8 $xml_string = preg_replace('/( urlencode($last_name), 'fname' => urlencode($first_name), 'title' => urlencode($title), 'company' => urlencode($institution), 'age' =>...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  3. Xero API: Send Multiple Invoiceshttps://www.joellipman.com/articles/else/fintech/xero/xero-send-multiple-invoices.html

    1, "UnitAmount": 240, "TaxType": "OUTPUT2", "TaxAmount": 48, "AccountCode": 3610, "DiscountAmount": 24, "Tracking": [ { "Name": "Activity", "Option": "ELEPHANT" } ] } ] }, { "Type": "ACCREC", "Contact": { "ContactID":...

    • Type: Article
    • Author: Joel Lipman
    • Category: Xero
    • Language: *
  4. MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

    = False Application.DisplayAlerts = False For Each xWs In ThisWorkbook.Sheets xWs.Copy Application.ActiveWorkbook.SaveAs Filename:=xPath & "\" & xWs.Name & ".xls", FileFormat:=-4143 Application.ActiveWorkbook.Close False Next Application.DisplayAlerts =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  5. GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

    this is how I do it along with screenshots: Login to your GoDaddy panel and expand the menu by clicking the caret by your name in the top right corner, then click on "My Products": Scroll down to SSL Certificates and click on the "Manage" button...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  6. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    the MidJourney Bot Signup to Discord.com Visit Midjourney.com Go to the Midjourney's discord channel Join a community room (named "Newbie"...) // or if you subscribe you can have a private conversation with the MidJourney Bot Type the word /imagine and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  7. Add a template to the dropdown in Kunenahttps://www.joellipman.com/articles/cms/joomla/add-a-template-to-the-dropdown-in-kunena.html

    Make sure that the \components\com_kunena\template folder is on your local disk Make a copy of the default folder inside Rename this to the name of your new template (avoid any spaces) Download the new template for the Kunena forum This is what the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  8. How to use download managers with Google Chromehttps://www.joellipman.com/component/content/article/how-to-use-download-managers-with-google-chrome.html?catid=61&Itemid=165

    http://www.youtube.com/watch?v= Using the bookmark feature: Right click on the bookmarks bar of Google Chrome. Type the name to what ever you want (eg. Download YouTube). Use the following code as the URL: javascript:window.location.href =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  9. SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issuehttps://www.joellipman.com/component/content/article/ssis-cannot-open-data-flow-task-dts-pipeline-2-issue.html?catid=74&Itemid=165

    I started getting this error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.2" is not registered for use on this computer Why? We use a combination of MS Visual Studio 2008, 2010 and 2012. VS2008 for our old SSIS packages...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  10. SSRS Use T-SQL Like with a Parameterhttps://www.joellipman.com/component/content/article/ssrs-use-t-sql-like-with-a-parameter.html?catid=75&Itemid=165

    Microsoft's SQL Server Reporting Services interface isn't the most fun to scroll endlessly down. Advanced users can type the name really fast for it to auto-scroll down to the desired name. Our advanced users are exceptions to the rule. Problem Consider...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  11. Oracle: order by subquery missing right parenthesishttps://www.joellipman.com/articles/else/database/oracle-pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

    ORDER BY clause in a subquery within an Oracle 11g environment. How? Consider the following: SELECT ps.person_id, ps.person_name, ( select pa.person_reference as personid, pa.person_text as txt from Person_Academia pa where pa.type = 'USER' AND pa.code...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *
  12. Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/else/database/mysql/search-and-replace-in-a-mysql-database.html

    well that's usually me. Found it a bit boring but here's a short bit of code to speed it up which I now use: update table_name set field_name=REPLACE(field_name,'string_to_find','string_to_replace'); Source:...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  13. MS Excel - Open CSV with Long Numbershttps://www.joellipman.com/component/content/article/ms-excel-open-csv-with-long-numbers.html?catid=110&Itemid=165

    but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID 1457102000000135533,Joel,00441234567890,1457102000000165989...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  14. Win32 Constantshttps://www.joellipman.com/component/content/article/win32-constants.html?catid=48&Itemid=165

    = $0308 Const WM_PAINTCLIPBOARD = $0309 Const WM_VSCROLLCLIPBOARD = $030A Const WM_SIZECLIPBOARD = $030B Const WM_ASKCBFORMATNAME = $030C Const WM_CHANGECBCHAIN = $030D Const WM_HSCROLLCLIPBOARD = $030E Const WM_QUERYNEWPALETTE = $030F Const...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  15. Fun with DllCall in AutoHotkeyhttps://www.joellipman.com/component/content/article/fun-with-dllcall-in-autohotkey.html?catid=48&Itemid=165

    a specified Dynamic Link Library (DLL) along with an inputbox for convenience: InputBox, FunctionToDo, DLL File, Enter the name of the DLL file you want to (suffix with .dll):,,500,120,,,,,shell32.dll If not ErrorLevel { ThisData:=PE_FunctionExports(...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  16. Terms & Conditionshttps://www.joellipman.com/component/content/article/terms-conditions.html?catid=50&Itemid=165

    REGISTRATION Joel Lipman .Com reserves the right to change the username you choose upon registration. This is to help other registered users to distinguish between official Joel Lipman .Com website administrators and other registered members. WEBSITE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  17. Privacy Policyhttps://www.joellipman.com/component/content/article/privacy-policy.html?catid=50&Itemid=165

    changes. This policy is effective from the 1st of January 2009. What we collect We may collect the following information: name and job title contact information including email address demographic information such as postcode, preferences and interests...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: en-GB
  18. MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/component/content/article/ms-dos-copy-folders-without-overwriting-files.html?catid=51&Itemid=165

    or \\server\share\path). destination :: Destination Dir (drive:\path or \\server\share\path). file :: File(s) to copy (names/wildcards: default is "*.*"). :: :: Copy options : :: /S :: copy Subdirectories, but not empty ones. /E :: copy subdirectories,...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  19. Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=53&Itemid=165

    updates/fixes. If you want more support/work done to it, you could consider a donation :c) BACKGROUND: OK, it's not the best name for a program and I might be infringing on copyright... Basically this is the third time I wrote this program, simply...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  20. Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=53&Itemid=165

    support/work done to it, you could consider a donation :c) BACKGROUND: Originally dubbed EventViewer Chart Generator. As the name suggests, I was looking for a free program that can take an exported CSV list from a standard MS Windows eventlog or...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
Results 181 - 200 of 277