Accessing Apimo WebService APIhttp://mail.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 } Advanced Example Here's a complete PHP script of a more complex example of 1) getting the agencies belonging to a company then 2) getting the properties for each agency: Other Methods Here's the cURL I couldn't get working. Instead I used Apimo's...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !http://mail.joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 in /home/public_html/my_folder/my_xml_processing_script.php on line 160 Why? I'm downloading an XML feed to our servers, and then loading the downloaded file into memory with simplexml_load_string(). I get the above error when it is attempting to load...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)http://mail.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 "'.$desc.'", "copyRequiresWriterPermission": true, "writersCanShare": false } Reminder: if you are adding the description, then pass this as a parameter to the above function. Source(s): Google Drive API v3 Google OAuth 2.0 Playground Google Developers...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttp://mail.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 Templates - Font size is inexplicably tinyhttp://mail.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 with a separate program that you want to use in the template and try to set them to the size that they will print out in. Then re-upload them noting the SRC of the image so that you can position it as per your requirements. That should do it.... The...

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

CSS Printing - Page Break Inside with Headers and Footershttp://mail.joellipman.com/articles/web-development/css/css-printing-page-break-inside-with-headers-and-footers.html

22 February 2019 @page { size: A4; margin: 3cm 1cm 2cm 1cm; } @page :first { size: A4; margin: 0cm 0cm 0cm 0cm; } If this works for you then brilliant because it didn't work for me... I guess I'm special, this is what I had to do: @page { size: A4; margin: 0cm 0cm 0cm...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

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

16 May 2019 } Usage $v_Str = getTimeAgo('2019-05-16 19:30:00'); // If (at time of print) this date is 17 minutes and 5 seconds ago // then $v_Str = "17 minutes ago" Or how about $v_Str = getTimeAgo('-1 week 2 days 4 hours 2 seconds'); // yields "1 week ago" $v_Str...

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

CSS Add Text to Breadcrumb Link with a Transitionhttp://mail.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 transition as the width transition is not a smooth one. If anyone has a tried and working solution to the width transition then feel free to comment/message me (please test before sending it to me as I'm aware of width transitions for div layers). DEMO:...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Zoho Deluge - Get distance between two coordinateshttp://mail.joellipman.com/articles/crm/zoho/get-distance-between-two-points-in-zoho.html

11 June 2019 function in Zoho which is acos or inverse cosine. Just lifted from the JavaScript library figuring if it supports cos() then try this standard function. Note this has only been tested in Zoho Creator rather than Zoho CRM. How? This function returns the...

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

Zoho Deluge - Counting in a Map dataTypehttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-counting-in-a-map.html

02 September 2019 account, and specifying the quantity for each. How? So depending on the number of levels, the count will be with a series if then else statements. See the results/yield section to determine which best fits your scenario: Counting total products: // //...

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

CSS Center an iFrame Horizontally and Verticallyhttp://mail.joellipman.com/articles/web-development/css/css-center-an-iframe-horizontally-and-vertically.html

23 September 2019 -50%); } DEMO: See my JSFiddle demo: https://jsfiddle.net/Jlipman/u5sew3ob/21 and modify the height of the iframe then click on 'Run'. The iframe is always centered even if the top is off screen.

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

Zoho Creator: Retrieve record with case-insensitive queryhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 myproduct3 TEST03 I'm trying to insert a record for a new product if it doesn't exist in the table but if it does exist then to simply skip adding the product. v_Name = "Myproduct1"; // note the lowercase P l_ProductDetails = Product[Product_Name ==...

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

Zoho Deluge - Compare time and currenttime with timezonehttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-compare-time-and-currenttime-with-timezone.html

13 January 2020 v_ExpiryTime.toTime(); // yields // 25-Mar-2020 20:41:07 // 25-Mar-2020 00:00:00 Example of splitting date-time value and then comparing: v_CustomTime = "2020-03-25 20:41:07".toTime().toString("yyyy-MM-dd HH:mm:ss"); v_ExpiryTime =...

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 This took several hours but it is possible, I was just about to give up even after having spoken to Zoho Support... And then I started updating multiple fields at the same time. How? Through sweat and perseverance. The trick is to update both the sales...

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

Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creatorhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-push-multi-select-picklist-containing-commas-from-crm-to-creator.html

20 April 2020 option in Creator (Options 2 is split from 3) Solution: In the Creator picklist/dropdown options, change any comma to , then in your CRM code to create the record in Creator: l_MyMultiPicklist = List(); for each r_PicklistOption in...

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

Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

04 May 2020 Xero stores its dates in Unix Timestamps. How? We're going to filter out the unix seconds from the date provided by Xero then apply a toTime() function to it. v_XeroTime="/Date(1586995200000+0000)/"; v_StartIndex = v_XeroTime.indexOf("(")+1; v_EndIndex...

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

AutoHotkey: Get Media Information and Displayhttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 this is also applicable to media files in general. How? So first I'm going to list a function I use called "Filexpro()", then list some examples of usage. And in the second-to-last section, I'll quickly convert a 100 nanoseconds unit to display Hours :...

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

Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

22 October 2020 attributes (such as position and float) will be removed automatically. The code has to be pasted directly in the Page and then the CSS attributes will remain. Preview the Code The code below can be changed to suit your own styling. It has been intended...

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

Zoho Creator: info/alert/modal/popup notification for any userhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 the styled modal. I'm going to call it "Notify". Add the 2 parameters p_NotifyTitle and p_NotifyContent to the page: Then drag a HTML snippet onto the page with the following: /* optional: hide some of the wrapper div boxes: leaves a modal with rounded...

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

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 Life"); m_DataRecord.put("item_price","priceless"); m_Data.put("data", m_DataRecord); How? So this is more of an annoyance then an impossible task... because it is possible, the technique above is simply wrong. The trick and solution is a lot simpler...

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