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

  1. Zoho Deluge - Get Refresh/Access Token API v2https://joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

    A sorta quick article to note how I can generate refresh tokens and access tokens using Zoho Deluge code (so within Zoho Creator, CRM or Books) without XML calls. Why? I find myself using this more and more now that API v1 is on the way out and Zoho...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  2. Stop Excel Row Height Self-Adjust on Refreshhttps://joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

    data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30 for example, but everytime we refresh the data in the Excel spreadsheet, all the rows get re-adjusted to fit the data and lose that consistency. A Workaround:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  3. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

    to the Deal record. How? The following is the process from registering the app to call on the full API (grant code > refresh token > access token) and then the code to attach the document to the CRM record. STEP 1: REGISTER A NEW CLIENT First, you need...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

    functions] for this process). So first off, here's a reminder on the function that generates an access token from a refresh token: string API.fn_eBayConnect_AccessToken() { b_SandboxMode = false; v_Output = ""; if(b_SandboxMode) { r_Api =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

    SSRS user) Add a data source to your SSRS report Add an SSRS input parameter Add a dataset Query type: Stored Procedure Refresh fields button Parameter name (oracle input sp variable) and Parameter value (ssrs input parameter) Fields (field name=ssrs...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. Setup a copy of your Joomla websitehttps://joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

    that you've developed. (referred to with the customers as TEST). BACKUP - an exact copy of LIVE (preferably from a daily refresh - and inaccessible to non-administrator users) DEV1 - a copy of LIVE and for developers to play with. DEV2 - a copy of LIVE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

    This is slightly different to my article Zoho Deluge: Get Refresh/Access Token API v2 (Zoho to Zoho service) and different to my Zoho CRM: APIv2 using PHP & cURL (3rd-Party to Zoho), in that this details how to setup a connection to use in an invoke URL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    me thinking I was trying to hack into their servers because of the number of queries Joomla does and the number of times I refresh the page and upload files. Why they think that developers should not be able to send a 1000 queries a minute or why a...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  9. Joes Quicklist Weblinks (JQW)https://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

    that offer FREE thumbnail screenshots are getting stricter with their terms of use. You should only enable thumbnail refreshes at the time of install. Also note, this module will NOT generate thumbnails if you select "Public" as the authorized service...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  10. Excel PivotTable Filter List Orderinghttps://joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

    the field list of the report (so you see the fields panel) Untick the filter that is not in alphabetical order Click on the Refresh button Re-Tick the filter to add it back to the report Move this added field to the Report Filter section (click on it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  11. Include a carriage return in a column headinghttps://joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

    the cells in Excel containing the header under "Alignment" to "Wrap Text". The difference the above does, is that when you refresh the data, it will retain the carriage return in the column headings. Additional: Only appears obvious in SQL Server...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  12. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    ID (Single Line) Redirect URI (Single Line) Scope(s) (Multi Line) Access Token (Multi Line) Access Token Expiry (Date-Time) Refresh Token (Multi Line) Refresh Token Expiry (Date-Time) AuthToken (Multi Line) AuthToken Expiry (Date-Time) You should end up...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

    changes to the program, you'll need to re-run the Help. The Help will tell you what to correct but it doesn't currently refresh its data until you request the Help page again. It only self-analyzes when the Help page loads, it isn't a persistent check....

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  14. MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    Shout in Gordon Ramsey-style: Done! Better than... MS Reporting Services? Yes by far. Fast, quick to setup and a big fat refresh button for the executives. SQL query returns individual items while Excel allows drag and drop grouping/drilldown pivot...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  15. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

    one with all the main details), as well as a job reference (for audit purposes) and click "View Report". The report will refresh with a link to a confirmation report which the user clicks and confirms that this is the student to update. The confirm...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  16. Joes Quicklist Weblinks (JQW) Downloadshttps://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

    alongside, popup, both - Parameter: Display Hit Counter: no, alongside, popup, both - Parameter: Specify Group(s) which can refresh thumbnails - Parameter: Description Length - Parameter: Image Rounded Corners (latest browsers only) - Parameter: Image...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  17. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

    assumes you have already "Enabled the Drive API" via your Google Developers console as well as gotten your OAuth 2.0 access/refresh tokens and specified the appropriate scopes. The scopes I chose were to do with getting a working example rather than the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  18. Google Authentication - OAuth 2.0 using PHP/cURLhttps://joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

    false) { return curl_error($ch); } else { return json_decode($response, true); } curl_close($ch); } // get token (access or refresh) function getAccessToken($credentials) { $expire_date = new DateTime();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  19. Zoho CRM: APIv2 using PHP & cURLhttps://joellipman.com/articles/crm/zoho/zoho-crm-apiv2-using-php-curl.html

    how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet of code below is using the functions to read data from Zoho CRM and to write data back to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  20. Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

    here I am using MS Visual Studio Code for Mac and I get the following: If I change the HTML and save the file, I can refresh the browser page and immediately see the changes: Adding custom CSS and JS files: If using MS Visual Studio Code, I’m adding the...

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

Please publish modules in offcanvas position.