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 import is required, the following 22 results were found.

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

    results. If you don't understand what this script is doing, you shouldn't be running it. Please ask someone who does. -- IMPORTANT NOTES (to be included in SQL script): -- -- The script below is to migrate your existing Joomla! 1.5 database -- -- to an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  2. ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    article for myself really as I couldn't find much online to address the errors I encountered below but also to document the import process of a bunch of files into a ZohoCRM system. Why? Our use-case here is a data migration for a client from a legacy...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Android OS: Add GoogleMap as fragmenthttps://www.joellipman.com/articles/else/app-dev/android-os/android-os-add-googlemap-as-fragment.html

    and can be run from any other activity: MapFragment.java package com.joellipman.mymapapp; // change to your own package import android.os.Bundle; import android.support.v4.app.Fragment; import android.view.LayoutInflater; import android.view.View;...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  4. Export/Import Database using MySQL Workbenchhttps://www.joellipman.com/articles/else/database/mysql/export-import-database-using-mysql-workbench.html

    are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? If you're confined to use this product then this is how to do it. Personally, even a web-based...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  5. ZohoBooks: Broken UK Banking Feedhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

    as findings from the research/investigation into the issue. Why? The workaround for a lot of our clients is to do a manual import (CSV) of the transactions for a particular account and then to reconcile these. This particular case covers where the Cx...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  6. Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/component/content/article/import-excel-csv-file-as-javascript-array.html?catid=110&Itemid=165

    What I have: A CSV file exported from Excel along with double-quotes label1,label2 item1a,item2a item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and convert to a JavaScript array of objects var my_object_array = [ {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  7. Zoho Analytics: Setup DataSource via FTP Connectionhttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-setup-datasource-via-ftp-connection.html

    how I setup a recurring data source in Zoho Analytics via FTP. Why? The use-case here is that I have a client who wants to import data via FTP (SFTP - to be precise) and have this available to their Zoho apps. My aim(s) are: Setup recurring FTP...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  8. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    Rename the Admin ID in the new v34 system to match your v25 system. Check your usergroups are the same in both systems. Import new ones. Copy all users except the v25 admin to your v34 database (with status=blocked) Copy over user group mappings Update...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  9. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    2025 folder. Visited the test.joellipman.com to run through the Joomla installation wizard. Data Migration using SQL files: Import Categories: export SQL file and amend the insert(s) into the new table `#_categories` where `id` > 7 Add column in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  10. MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    pip3 install --user --upgrade pip Install Numpy As user (safest): pip3 install --user numpy Check numpy version python3 -c "import numpy; print(numpy.__version__)" Use OpenAI Whisper Install Whisper using PIP: pip3 install -U openai-whisper Determine...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  11. Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-create-a-monitoring-system-with-images.html

    use but if the image is hosted elsewhere, then this step is completely optional. Click on "Create" and select "New Table / Import Data": One of the last options on the "Import Your Data" page is "Enter Data Right Away": You'll be presented with a table...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  12. Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/else/app-dev/android-os/basic-android-app-using-google-maps-and-current-location.html

    LatLng(latitude, longitude)).title("You are here!").snippet("Consider yourself located")); } If you are prompted to import the classes then agree by clicking OK: If you are not prompted, you should see some of your code go red like in the following...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  13. MessageBox or AlertDialog in Android Javahttps://www.joellipman.com/articles/else/app-dev/android-os/messagebox-or-alertdialog-in-android-java.html

    I have used an XML as the layout. How? This displays a standard Ok/cancel message popup which you attach to some event import android.app.AlertDialog; import android.content.DialogInterface; new AlertDialog.Builder(this) .setTitle("Some Title")...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  14. Run commands for Windowshttps://www.joellipman.com/component/content/article/run-commands-for-windows.html?catid=80&Itemid=165

    tweakui User Account Management nusrmgr.cpl Utility Manager utilman Windows Address Book wab Windows Address Book Import Utility wabmig Windows Backup Utility (if installed) ntbackup Windows Explorer explorer Windows Firewall firewall.cpl Windows...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  15. 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

    files per sheet. Why? The Excel file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  16. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    or counterclaim in a lawsuit) alleging that any patent claim is infringed by making, using, selling, offering for sale, or importing the Program or any portion of it. 11. Patents. A “contributor” is a copyright holder who authorizes use under this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  17. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/component/content/article/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html?catid=129&Itemid=165

    to be in the rows (ZohoAnalytics may have issues loading a file with only headers) Click on "Create" then "New Table/Import Data" > Select "Files" (the one with the Excel icon) Give the table name "Attachments" > Select your Excel file > Next Get the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Desk
    • Language: *
  18. Zoho People: Get Performance Records over APIhttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-get-performance-records-over-api.html

    one cell. Enter a description in the 2nd row to convince Analytics there is some data in the table we are going to import. You should end up with something like: I'm going to save this file as Zoho_Analytics_Performance_Goals.xlsx Login to Zoho...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  19. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    be repeated across the board. The following example is an isolated Script held in a separate solution which other packages import as a Custom Component Script. (ie. if we use this script in many packages, we can change just this script instead of the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  20. Sync Outlook 2007 Shared Calendar with SharePoint 2007https://www.joellipman.com/component/content/article/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html?catid=77&Itemid=165

    No but far more manageable when using Outlook 2007 instead of the SharePoint 2007 web interface... Other Searches Import Outlook 2007 calendar into Sharepoint 2007 Sync Sharepoint 2007 calendar with shared Outlook 2007 calendar

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
Results 1 - 20 of 22