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

  1. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttp://mail.joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

    to tell MySQL WorkBench 6.0 to "use the old authentication protocol": • For versions before 6.0.7 • For versions after 6.0.7 Method #3 (Recommended): Do not use MySQL WorkBench!!! Seriously, your pride will slow you down or get you sacked!...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  2. A quick run through of setting up an export process in SITShttp://mail.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    up to running the monitors and populating an OUTPUT table in the SITS database. Note that this does not include steps thereafter in the Staging or Target destination which will be specific to your business requirements. Why? If you're developing in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  3. DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttp://mail.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

    decided to repair the hull integrity of my DJI Phantom FC40 after a crash and sorta had the day off so... There are so many pictures because I wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
  4. Quadcopter App with Flight Restrictions (JQA)http://mail.joellipman.com/component/content/article/quadcopter-app.html?catid=40

    you chose when registering for username reminders, password resets, or e-mail changes. The key stored on the device expires after 30 days and requires you to login again if you have not used this app in that time. ChangeLog v1.8.x [25 Nov 2014] -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  5. Excel: convert degrees minutes seconds to decimalhttp://mail.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

    (for importing to a database where DECIMAL(10,7) ). Merging the lot If B1 contains the coordinates and there is a space after the first letter (N or S): // for latitude =IF(MID(B1,FIND("″",B1)+1, 1)="N", (MID(B1, 1, FIND("°", B1)-1) +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  6. Joes Word Cloud (JWC) Downloadhttp://mail.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

    is not already in list. - Date Uploaded: Wed, 20th Jul 2011 1.6.5- Bug Fix: Keyword Exclusion List removes spaces before and after all words. - Date Uploaded: Mon, 18th Jul 2011 1.6.4- Added Joomla! Admin Option: Module Content Caching - Added Joomla!...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  7. Foreign Characters create symbols in PHP and MySQLhttp://mail.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    'ISO-8859-15', true), ENT_COMPAT, 'UTF-8'); My other fix (for Croatian characters and Western languages): // insert after database connection and prior to database query (where $db_conn is your mysqli connection) mysqli_set_charset($db_conn,"utf8"); //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  8. Accessing Apimo WebService APIhttp://mail.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

    a Non-SSL-Enabled host. How? Previously, I would have used cURL but for some reason, I couldn't get the configuration right. After several days... I tried the example as per the Apimo documentation and it worked! There were a few adjustments to make...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  9. Zoho Deluge - Update Creator from CRMhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

    documentation provided, and the responses returned as successful, but the target fields did not update. This was as a result after changing the owner of the Creator app to another person and adding our previous Super Admin account as a "Developer". How?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  10. Zoho Deluge - Modify the product line items in an invoice modulehttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-modify-the-product-line-items-in-an-invoice-module.html

    null, "Currency": "USD", "name": "Test Product", "id": "1642130000000104087" }, "quantity": 1, "Discount": 0, "total_after_discount": 0, "net_total": 0, "book": null, "Tax": 0, "list_price": 0, "unit_price": 0, "quantity_in_stock": 0, "total": 0, "id":...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

    Bing, I never get around to searching that). This took several hours but it is possible, I was just about to give up even after having spoken to Zoho Support... And then I started updating multiple fields at the same time. How? Through sweat and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Zoho Creator: Create a Widget which uses JavaScripthttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

    Zoho services and programming in Zoho Deluge for a few years now, even I thought of Zoho Widgets as a daunting task. But after doing some, I realize this is actually very quick to do and much easier than first thought. The article below documents how to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Zoho Creator: info/alert/modal/popup notification for any userhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    */ .popupClose{position:relative !important;z-index:1000;top:28px;right:46px !important;} .fa.fa-close::before,.fa.fa-close::after{background:#999 !important;} 2. Trigger the notification There are several ways to display this as a popup, the first use...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho Creator: Set Up Custom Domain for Customer Portalhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

    level and equal number of steps as verifying by CNAME; or by uploading a HTML verify file which I tend to forget to delete afterwards and involves just as many steps to instruct the client. I use CNAME as I find it easier and it is a step we need for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho Creator: Button on Report for Merging Multiple Selected Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

    v_TotalVat = v_TotalVat + v_LineItemTotalVat; v_Total = v_Total + v_LineItemTotal; } // // other actions you want to do after all quotes looped through // } Save your function and click on "Done" to ensure it's all saved in the system. Create the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

    redirecting the user. A HTML element to the page won't help either as you need to redirect the user to the specified report after submitting the form. How? Well as always, I'm going to cheat. My solution here was to simply repurpose a decision box field...

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

    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 the number has incremented. Once all records are done, return to the Module Layout and delete...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Zoho CRM & Zoho Books: Get SalesPersonshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-salespersons.html

    is that I want to create a Sales Order in ZohoBooks based on one in ZohoCRM and wanted to assign the sales person. How? So after an hour or so trying to get the Zoho.books.getRecords() function to filter the sales persons, I gave up and used a for each...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

    + v_ListingPublishKey; v_ImageSrc = v_ImageSrc + "?filepath=/" + v_Filename; l_ShopifyPictures.add(v_ImageSrc); } // after I've pushed the product to Shopify and it returned to me a Product ID: if(v_ShopifyProductID != 0) { // do photos...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

    which opens Writer, then has to click on various settings and run the Mail Merge; then has to click on "execute function after merge" and select the function to run (this would initially attach the file to the CRM record). This wasn't working really as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 81 - 100 of 128

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.