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

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

    The slightly longer answer to describe this might be better explained if you consider the following snippet of code: // sample data v_Test = "00011,Joel Lipman,\"Flat 8, House Corner\",Brummieland"; // regex to replace a comma found between 2...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-sort-a-map-by-a-specific-field.html

    How? So to give you a gist of what the following snippet of code is doing, let me give an overview: Build up a map with sample data (you won't need to this, use your own data, this one is for this demonstration only) Initialize a list to hold the keys...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    CMS Go through the Joomla Web-based Installation GUI until the process deletes the Installation folder. Avoid installing Sample Data if possible (there will be some but this script has been reworked to potentially accommodate). Download my migration...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    1 if you only want to generate the SQL statements without seraching the database. By default it is 0 and it will search. Samples : 1. To search data in a table EXEC SearchTables @Tablenames = 'T1' ,@SearchStr = '%TEST%' The above sample searches in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  5. AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/component/content/article/autohotkey-get-media-information-and-display.html?catid=48&Itemid=165

    Continue } } fex.SetCapacity(-1) Return fex } Usage v_MyMediaFile := "C:\Users\Public\Music\Sample Music\Maid with the Flaxen Hair.mp3" a_MediaObject := Filexpro( v_MyMediaFile,, "System.Media.Duration" , "System.Audio.ChannelCount" ,...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  6. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    to use even for REST API v2.0 would have been something like the following: // // init l_CrmLineItems = List(); // // some sample values v_CrmProductID = "123456789012345678"; // // build up product details JSON to send m_LineItemProduct = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-process-all-records-of-a-module.html

    as it's a field to update In your code, sort a list by "Modified_Time", loop through and update each iterated record. (see sample code below). Go to the list view in CRM and filter by "Processed" is "Selected", check after each run of the function that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-inventory-upload-image-to-item-record.html

    = x_MainNode.executeXPath("//Item/PictureDetails/PictureURL/text()").toXmlList(); // yields // https://i.ebayimg.com/00/s/SAMPLE/z/ELPMAS/$_57.JPG?set_id=1234567890,https://i.ebayimg.com/00/s/SAMPLE/z/ELPMAS/$_57.JPG?set_id=1234567891 Note that for the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

    solid #ccc; width:300px; float:left; } Basic Mootools Form in Joomla 2.5 Basic Mootools Form in Joomla 2.5 Name: E-Mail: Sample CheckBox: Sample SelectList: yes no Ajax Response Ready, Willing and Able Big Note: UPDATE 2012 It is important to refer to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  10. Copy a Wordpress Site for Developmenthttps://www.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

    in the `wp_options` database table (note: include `wp_postmeta` and `wp_posts` if you want images and attachments) Done Sample Configuration PHP Note that the following are sample values and just for myself to quickly modify a Wordpress configuration...

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

    SQL Server\100\DTS) Right-click on the Application folder and add the sub-folder you need to put your sample in (ie. Tasks, PipelineComponents, Connections) Right-click on the new folder, and add "Project Output" to the folder to place binaries from...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  12. Connection Strings for SQL Serverhttps://www.joellipman.com/component/content/article/connection-strings-for-sql-server.html?catid=78&Itemid=165

    Usage: System.Data.OleDb.OleDbConnection Manufacturer: Microsoft Bridging to MySQL OLEDB This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  13. MySQL day of week ending on Fridayhttps://www.joellipman.com/articles/else/database/mysql/mysql-day-of-week-ending-on-friday.html

    working day of the week. The Solution Where "givenDate" is the given date you have to calculate the last working day of: -- SAMPLE DATES ARE: -- -- 2012-04-27 10:00:00 -- is a Friday -- 2012-04-28 11:00:00 -- is a Saturday -- 2012-04-29 12:00:00 -- is a...

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

    I have to go through a few hundred files manually checking that I have the converted version and deleting the original. SAMPLE USAGE: If you have a portable media player that needs to convert media files before they can be transferred to the device,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  15. Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-update-creator-from-crm.html

    For example: https://creator.zoho.eu/api/myAdminAccount/json/myApp/form/myForm/record/update The code to update a form (sample data for demonstration purposes). Note that the payload here is submitted through URL parameters: v_AccessToken =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  16. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

    know, when you queried CRM for that field, you received a JSON response somewhat similar to the following: // this is sample JSON with replaced IDs "My_CRM_File": [ { "extn": "pdf", "is_Preview_Available": true, "download_Url":...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  17. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

    = zoho.crm.searchRecords("Vendors_X_Users",v_SearchCriteria); Code to Add a value to a multi-lookup (on Create Record): // sample code when creating a record in a module that contains a lookup m_Create = Map(); m_Create.put("Name","Joels Amazing Test");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  18. Zoho Projects: Deluge to Submit Custom Fieldshttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-deluge-to-submit-custom-fields.html

    API would only show responses rather than requests. Sure it lists fields that are required in the request but not a sample request packaged to be sent. How? Let's assume that my custom fields have as identifiers UDF_CHAR8 (which is a Zoho ID) and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  19. Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-schedule-a-call-with-deluge.html

    date time start in US format v_CustomerAppointmentDateTimeStart = v_CustomerCallTime.toString("MM/dd/yy h:mma z"); // // sample lead owner ID and lead ID record v_LeadOwnerID = 5432109876543210987; v_LeadID = 4321098765432109876; v_CustomerName = "Test...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  20. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/component/content/article/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html?catid=138&Itemid=165

    zoho.com or zoho.eu v_TLD = "com"; // // enter client ID, secret and refresh token as noted from above steps (the below are sample ones and will not work) v_ClientID = "1000.ABCDEFGHIJKLMNOPQRSTUVWXYZ1234"; v_ClientSecret =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Sign
    • Language: *
Results 1 - 20 of 31