Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html

31 May 2009 and that you have broken a rule. I will determine whether you knew what you were doing was wrong or whether a warning is necessary to explain it to you. If I do not give a warning, I will skip ahead to the next step in the penalty list. Muting - This is...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 setup: A working website in Joomla CMS v1.5.14 Applied RocketTheme's Affinity template to our website We have all the necessary files: RokBB3 administration module (rokbb3.zip) Affinity phpBB3 template (rt_affinity_phpbb3.zip) [ the template we're using...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 – testing and confirmation that both systems are operational, data needs to be entered in both systems. (this is only necessary if this is an upgrade or replacement of an existing system). Warranty checks will be run for 1 month (unless agreed...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Zoho Analytics: Setup DataSource via FTP Connectionhttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

12 January 2022 as per your configuration, then click on "Next": Step 2 of 2: specify whether first row are headers/column/field names. If necessary, specify the format of the data per column (in this example, I highlight the Date column, it then prompted me what...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 ones we have found in ZohoBooks and other Zoho Apps. Prerequisites: Setup a connection called "joel_books" that has the necessary scopes to view taxes and chart of accounts Setup a connection called "joel_inventory" that has the necessary scopes to do...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 anyway. Note(s) The following code accesses APIs on the EU datacenter. I have a connection called "zbooks" which has the necessary scope(s) to create and update an estimate as well as read settings and contacts. I have a connection called "zcrm" which...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 // output response of task creation from CRM info r_NewResp; Step 2: Setup workflow to escalate after 4 days: No code here necessary, this screenshot shows the settings I put in as a separate workflow: Step 3: Delete transferred tasks on converted...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 at http://www.joellipman.com/features/downloads.html?func=fileinfo&id=12. Install IE7 from Microsoft's website. Reboot if necessary Navigate to http://browsers.evolt.org Scroll down to "Internet Explorer - Microsoft" Select Win32 > standalone >...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Joes Word Cloud (JWC)https://www.joellipman.com/component/content/article/module-joes-word-cloud-jwc.html?catid=40

13 October 2010 Manager View the module on your front-end to see if it does what you want it to do. Modify the module parameters as necessary. Setup First of all, you need to make it visible. These 3 steps will have your module ready: The further steps below are how to...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 > OK Select the data source from the dropdown (the one you just created earlier should be listed) Enter credentials if necessary and click on "Test Connection" Expand the data connection you just made and expand "Tables" just to see if the connection is...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

List all cron jobs for all usershttps://www.joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 directory. Change these for your system. CRONTAB='/etc/crontab' CRONDIR='/etc/cron.d' # Single tab character. Annoyingly necessary. tab=$(echo -en "\t") # Given a stream of crontab lines, exclude non-cron job lines, replace # whitespace characters with...

• Type: Article
• Author: Joel Lipman
• Category: Linux
• Language: *

Unix Date Format Specifiershttps://www.joellipman.com/articles/linux/unix-date-format-specifiers.html

05 July 2011 %M MM minutes 20 Seconds %s seconds since 00:00:00 1970-01-01 UTC (Unix epoch) 1309785651 %S SS second 00–60 (The 60 is necessary to accommodate a leap second) %N nanoseconds 000000000–999999999 Time %r hours, minutes, seconds (12-hour clock) 01:20:51...

• Type: Article
• Author: Joel Lipman
• Category: Linux
• Language: *

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 circumstances is permitted solely under the conditions stated below. Sublicensing is not allowed; section 10 makes it unnecessary. 3. Protecting Users' Legal Rights From Anti-Circumvention Law. No covered work shall be deemed part of an effective...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 + CAST(@TimeVal AS varchar(16)); ELSE SET @NewVal = ''; -- REDUCE THIS STRING TO THE SAME LENGTH AS SUBMITTED VALUE // not necessary for update -- SET @NewVal = SUBSTRING(LTRIM(RTRIM(CAST(@NewVal AS VARCHAR(30)))), 1, LEN(@OrigVal)); END ELSE BEGIN IF...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 !!!) Copy database from LIVE to TEST (Operations > Copy to... > untick "Create Database") Done! and you have all the necessary backups for a restore point. Additional Notes Don't forget the .htaccess file for Search-Engine Friendly (SEF) website...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Country Lookup by IP address CSVhttps://www.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 How to use: Download from my site: «Download» Run the SQL script against a test database, Modify the table name to use if necessary. Uncomment the drop statement if running for the second time. Modify the PHP file to use database login credentials,...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Add attribute xsl:nil=true on empty elements using XSLThttps://www.joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 so we had to find a place to introduce it. On strings this has little worth, but on dates which could be NULL, this was necessary (unless we interpreted dates as strings which we don't want to do): -- SITS Output: Option 1 -- SITS Output: Option 2 --...

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 This is an article which lists the functions necessary to process Google Authentication using OAuth2.0. These functions allow a script to simply be loaded and to either create a token file, or use the existing one as long as it hasn't expired. Update...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

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

17 July 2019 invokeurl [ url :v_EndPoint type :POST parameters:m_Payload ]; info r_AuthToken; Once you have a refresh token, it is not necessary to generate another refresh token as it does not expire. You would only generate a new one if you were changing scope....

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 keyboard or on a Qwerty UK/US keyboard layout. Why? Being able to type international characters from other alphabets is necessary when dealing with languages other than English. Preserving files in unicode or utf-8 encoding will help but there will be...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *