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

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

    created in the upgrade site. This is the ID -- used when installing Joomla CMS. It is important that the script below -- accounts for the fact that you may have a user with the same ID in your -- previous Joomla CMS and we would want to maintain any...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  2. SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

    if Google's logo still appears. Test browsing to your images when you are not using one of your Intranet computers or user accounts (eg. try Local Admin Account on Computername as domain). The first two of the above worked for us, which indicated an...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  3. Migrate Joomla Users to WordPresshttps://joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

    what the commercial applications are doing. The script to transfer users This is a free solution to at least get your user accounts all migrated. How you deal with the passwords can then be up to you. To use the following script, you need to change the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  4. Basic Oracle Function Structurehttps://joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

    (ad_username IN varchar2) RETURN number IS student_no number; cursor c1 is select student_reference from student_accounts_table where student_ad_account = trim(lower(ad_username)); BEGIN open c1; fetch c1 into student_no; if c1%notfound then student_no...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  5. Basic Oracle Stored Procedure Structurehttps://joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

    ( c_test out sys_refcursor, p_STUDENT_ADNAME in varchar2 ) IS BEGIN OPEN c_test FOR SELECT * FROM student_accounts WHERE student_username = p_STUDENT_ADNAME; END; View the results? Oracle PL/SQL is a bit of a bugger as you need to do a few other things...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  6. Data Randomization Function in Oracle PL/SQLhttps://joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

    'DATE','01/01/1000','31/12/1002') random_daterange -- testing date range FROM UFN_STUDENT_ACCOUNTS WHERE ROWNUM

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  7. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

    adding a "setup wizard" project. This results in a setup.exe and msi file which can be installed on Windows Servers run by accounts which do not have access or which do not have the full Windows SDK (ie. access to the global assembly cache). The process...

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

    scopes as needed // generic $GAPIS = 'https://www.googleapis.com/'; $GAPIS_AUTH = $GAPIS . 'auth/'; $GOAUTH = 'https://accounts.google.com/o/oauth2/'; $REDIRECT_URI = 'http' . ($_SERVER['SERVER_PORT'] == 80 ? '' : 's') . '://' . $_SERVER['SERVER_NAME']...

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

    making it as generic as I can in order to apply it to any client. How? Firstly, you will need to browse to https://accounts.zoho.eu/developerconsole and register your new app (or the one you will have completed once copying the below scripts). Let's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  10. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

    absolute path to your private key, this should be the JSON file that you generated at Google's developer console - service accounts section. It also contains the public key under the guise of a URL (x509 certificate) but we don't need it for this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  11. Zoho CRM/Creator - Common Errors & Gotchashttps://joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

    This is a quick issue to resolve as it may be incorrect scopes specified but in my case is more than often the wrong accounts server: v_DataEndpoint = "https://books.zoho.com/api/v3/contacts?organization_id=123456789"; r_Response = invokeurl [ url...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Zoho Deluge: Search Records with Special Characters (COQL)https://joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

    value v_SearchName = v_SearchName.replaceAll("&","\u0026",true); // // build up COQL query v_CoqlQuery = "select id from Accounts where Account_Name='" + v_SearchName + "'"; // // build up parameters m_Params = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Zoho CRM & Zoho Books: Get Books Currency and Tax IDshttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-books-currency-and-tax-ids.html

    info m_Currencies; // // get Books ID for a currency from an CRM account record r_AccountDetails = zoho.crm.getRecordByID("Accounts", 9012345678901234567); v_BooksCurrencyID = m_Currencies.get(ifnull(r_AccountDetails.get("Currency"),"GBP")); info...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho Analytics: Determine profits from invoices and purchase ordershttps://joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

    ID", if_null(so."Sales Person ID", if_null(e."Sales Person ID", '-')))) AS "Sales Person ID" FROM "Customers" c LEFT JOIN "Accounts" a ON a."Account ID" = c."Customer ID" LEFT JOIN "Users" u ON u."User ID" = if_null(c."Account Owner", c."Created By")...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

    { v_OutputResponse = "FAILED: " + r_UpdateBooksInvoice.get("message"); } It's a cop-out I know, but it beats the accounts staff having to enter the adjustment each time. The create invoice process would be treated the same. The below are all the various...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 21 - 35 of 35

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.