Search - Joel Lipman .Com

1. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... is incorrect in Zoho Analytics, and payroll gets run with these discrepancies, then they will have a fair few disgruntled employees who may have been paid incorrectly. As such this system has to be reliable ...; Created on 02 July 2024
2. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... Initial release - Correctly rounds any decimal fields to their maximum decimal place. Date Modified: ??? - ??? ******************************************************************************* ...; Created on 13 December 2023
3. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... Marked Items as inclusive of VAT so VAT reports in Books will be accurate (eg. £499.95 is correctly £416.62) Date Modified: 2023-02-23 (Joel Lipman) - Check if ebay Order ID already exists on ...; Created on 27 April 2023
4. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; What? This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit. Why? We're creating a custom module ...; Created on 08 February 2023
5. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
6. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... has not been tested extensively. Do not use if you are unsure it is calculating correctly. I use these to store the values in a table that can be double-checked at a later date. Source(s): Joel ...; Created on 07 December 2021
7. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... / listings / channels m_Product.put("published_scope","global"); m_Product.put("published",true); // set to true when comfortable with it publishing correctly m_Product.put("status",ifnull(input.Publish_Status.toLowerCase(),"draft")); // ...; Created on 17 October 2021
8. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... you should see notifications come in via your email (now comment this out in your CRM before it drives you insane) but also, and if setup correctly, sent through to your Creator app, all without having ...; Created on 20 September 2021
9. Zoho CRM: Permission Denied for Quote Conversion Mapping: / Zoho /; What? A really quick article for anyone experiencing the same issue: As a super admin in CRM, I am denied permission to access the Quote Conversion Mapping page... Why? I wanted to map a billing ...; Created on 02 September 2021
10. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; ... If we are getting a date from a CSV or other external source as "dd/MM/yyyy", how do we guarantee that the system will understand the date correctly? How? It may be that when obtaining a date string ...; Created on 01 September 2021
11. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name): / Zoho /; What? A quick article to explain why the full name might appear in the last name field in Zoho CRM. Why? We had a customer report the issue that sometimes the full name of a contact was appearing ...; Created on 01 September 2021
12. MS Excel - Open CSV with Long Numbers: / Excel /; What? This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ...; Created on 23 July 2019
13. CSS Ordered List 1, 1.1...1.10 Formatting and Alignment: / Cascading Stylesheets /; What? A quick article to remind me on how create an multi-level ordered list that indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to ...; Created on 10 July 2019
14. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... insert the new comments, correctly associated to -- their respective articles and users. Most of the users as per -- previous steps will match up, anonymous users (non-registered members) -- will ...; Created on 12 September 2015
15. 404: Page Not Found: / Static Items /; Sorry, but the content you requested could not be found. It is possible that you have followed an out-of-date link or incorrectly typed an address. We have revamped this website as of September 2015 ...; Created on 11 February 2015
16. Basic Android App using Google Maps and Current Location: / AndroidOS /; ... Just in case: AndroidManifest.xml The example above should have populated this correctly but if you are still getting problems, I have the following fields that I also use related to Google Maps v2: ...; Created on 10 October 2014
17. T-SQL Record Separator: / Transact-SQL /; I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on ...; Created on 11 October 2011
18. Joes Bug Tracker (JBT): / Product Documentation /; ... template which could be quite tiring. Following the crash, database performance was at an all time low and analysis revealed it be incorrectly designed. Interestingly enough there is a Bug Tracker fo ...; Created on 07 July 2011
19. Could not instantiate mail function: / Joomla /; ... email from that server ERROR: Message not sent. Server replied: Connection refused 111 Can't open SMTP stream. One common problem people have is an incorrectly setup mail system. Here is a ...; Created on 09 May 2011
20. Frontpage Item Ordering: / Joomla /; ... answer is that it is within the menu manager > main menu > menu item section of your Joomla! Admin Panel. Certain Advanced Parameters in your Menu Item called "Home" must be set correctly for the article ...; Created on 16 September 2010