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 40 results were found.

  1. Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    you should run the respective commands to update the Installer ID in these as well. Copy over users (but with disabled accounts): CHANGE the value of @v25_admin_id to the number (in my example "42") to the admin ID of your installer ID. --...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  2. MySQL last year week month day trend periodshttps://joellipman.com/articles/else/database/mysql/mysql-last-year-week-month-day-trend.html

    I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  3. Project Plan for Freelance Websitehttps://joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    server space - expected size of website including all uploaded files. Add domain folder to the server. Setup FTP Accounts (just one username/password). Setup automated backup system. Create test space with same access details. Database Setup For...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  4. GDPR Privacy Policyhttps://joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  5. Zoho CRM: APIv2 using PHP & cURLhttps://joellipman.com/articles/crm/zoho/zoho-crm/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 CRM
    • Language: en-GB
  6. Zoho CRM/Creator - Common Errors & Gotchashttps://joellipman.com/articles/crm/zoho/zoho-crm/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 CRM
    • Language: *
  7. Zoho Deluge: Search Records with Special Characters (COQL)https://joellipman.com/articles/crm/zoho/zoho-deluge/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 Deluge
    • Language: *
  8. Zoho CRM & Zoho Books: Get Books Currency and Tax IDshttps://joellipman.com/articles/crm/zoho/zoho-books/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 Books
    • Language: *
  9. Zoho Analytics: Determine profits from invoices and purchase ordershttps://joellipman.com/articles/crm/zoho/zoho-analytics/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 Analytics
    • Language: *
  10. ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://joellipman.com/articles/crm/zoho/zoho-books/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 Books
    • Language: *
  11. Zoho Survey: Zoho CRM Webhookhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

    m_CreateAccount.put("Turnover", m_SurveyBody.get("Last_Years_Turnover")); r_CreateAccount = zoho.crm.createRecord("Accounts", m_CreateAccount); info "Creating CRM Account: " + r_CreateAccount; if(!isNull(r_CreateAccount.get("id"))) { v_CrmAccountID =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. 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: *
  13. 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
  14. Google Authentication - OAuth 2.0 using PHP/cURLhttps://joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    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
  15. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    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
  16. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    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
  17. SSRS External Images don't displayhttps://joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

    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: *
  18. Basic Oracle Function Structurehttps://joellipman.com/articles/else/database/oracle-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
  19. Basic Oracle Stored Procedure Structurehttps://joellipman.com/articles/else/database/oracle-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
  20. Data Randomization Function in Oracle PL/SQLhttps://joellipman.com/articles/else/database/oracle-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
Results 21 - 40 of 40