ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 forcing the billing or shipping address in you should get the following error: Please ensure that the shipping_address has less than 100 characters. How? If you get the above error, the community forums will advise you to get the ID of the Shipping...

• 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 the same request however gives me the following error: { "code": 15, "message": "Please ensure that the billing_address has less than 100 characters." } How? So the quick answer is 2 separate API calls after you have sent the code to either create or...

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

Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 I've decided to put something in here as it took me an age to find out how I could do it. This is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ten chart of your data (eg. movies, music, etc)....

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 256 verification ******************************************************************************* */ // // need to respond in less than 1 second m_Payload = crmAPIRequest.toMap(); m_Blank = Map(); // // you created an app that generated a client ID and a...

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

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 iPhone compatibility and disabled access) Explain balance of scope, quality, time and cost. (focusing on one element means less on another) Search Engine Optimization constraints and standards Domain Registration This is so that you as the client retain...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 of datatype: date v_PerPage = 200; v_CountCriteria = "((Quote_Stage:equals:" + encodeUrl("Draft") + ")AND(Created_Time:less_than:" + encodeUrl("2023-11-01T01:00:00+01:00") + "))"; v_Endpoint =...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 half of these (including Kunena and Agora forums), specifically database intensive plugins and the error happened less... I then went through the menus and installation screen to get rid of anything that was not visibly used on the website. The website...

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

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

30 January 2011 reworked to potentially accommodate). Download my migration script Decide on which script to use: If you have a small site (less than 10'000 articles), then you will use the single script "migrate_j15_to_j25_new_v1_8.sql" For larger sites (~200'000...

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

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 Profile - JoelLipman.Com Plugin" JOELLIPMAN_BOOLEANYES="Yes" JOELLIPMAN_BOOLEANNO="No" JOELLIPMAN_ALLERGYTIMEOPTION0="Less than 6 months" JOELLIPMAN_ALLERGYTIMEOPTION1="Less than a year" JOELLIPMAN_ALLERGYTIMEOPTION2="1 year"...

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

XML Schema Referencehttps://www.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 allowed. Must be equal to or greater than zero maxExclusive Specifies the upper bounds for numeric values (the value must be less than this value) maxInclusive Specifies the upper bounds for numeric values (the value must be less than or equal to this...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 required Stay away from built-up areas Note: There are slightly different regulations for a small unmanned aerial system (less than 20kg) and a small unmanned aerial surveillance system (less than 20kg equipped with a camera). Regulations different to...

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

Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 zero Actually we just want the first two words of those strings: 3 days ago // where event is 3 days ago or just over but less than 4 days ago 1 week ago // where event is just over 1 week ago but less than 2 weeks ago How? I know there are so many...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 A_Index, 9) LV_GetText(v_Col10, A_Index, 10) v_Reason := "Unknown" if(v_Col09...

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 on the decimal field even if that's not the field that is being changed: Decimal places for the Unit Price field should be less than or equal to 6 . How? The workaround for staff is to round this up manually and then save the record. But this can be an...

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

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

31 May 2009 for a month, and for 2 months for the next offense. Permanent ban - At this point, it is obvious that will never learn your lesson, thus, a permanent ban is necessary to be rid of the problems you cause. The following rules are also important: No...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 every day, you would use 86400, or 60 seconds * 60 minutes * 24 hours * 1 day. I wouldn’t recommend setting this to anything less than 4 hours worth, or your computer might get banned by the time servers. Change Your Firewall Settings Third party...

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

Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparisonhttps://www.joellipman.com/articles/cms/joomla/lazy-stats-yootheme-and-gavick-pro.html

08 April 2010 So this is a comparison chart (at least in my opinion) of 3 major joomla template/extension providers. When I'm less caught up in work I'll try adding to this article. But here's some lazy stats: Package Comparison Table Personal Business Developer...

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

Difference between two dates - the midnight hourhttps://www.joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 please)? The Solution Eureka! Or duh! for those that it's obvious to... Compare the two timestamps, if the "To date" is less than the "From date" then add 1 day to the date: $thisDateSQL=date("Y-m-d", strtotime($sub_row['DateSession']));...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

SSRS Zero Paddinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 in the format of -12345. If we want to look them up the error is ORA-12345. Unfortunately Oracle also returns errors of less than 10000 so ORA-00201 would actually be returned as "-201". As I wanted a link so that the user can just click on this link...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 with the charts saying "No Data Available" but I find this better then the alert message "parameter cannot be blank!" and less confusing to the end-user. If this bugs you, you can always include a custom message which displays on top if all 4 parameters...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB