Search - Joel Lipman .Com

1. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... as these might answer your question to begin with and then we'll do the easy bit on how you set this up in the CRM. I'm using ZohoCRM here despite storing the record in ZohoCreator as the app and data processing ...; Created on 22 April 2024
2. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; What? A quick article on how to get around this error. Why? The use-case here is that I am using the send invoice API and I kept getting this error despite including the customer_id and there ...; Created on 07 March 2024
3. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; What? Another article on something I learned today despite never running into this issue before; but sending a billing/shipping address included in a request to create or update an estimate in ZohoBooks ...; Created on 18 September 2023
4. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... in storing message conversations despite it's purpose being ideal. Instead, let's use a CRM function to store the conversation between ChatGPT and the CRM User. This way, we can also ensure that the data ...; Created on 06 March 2023
5. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... when Status is "Paid" Just once or every time is "Everytime" Actions is a custom function called "fn_invoice_updatepaymentmethod" But this wouldn't work despite being as per the documentation (see ...; Created on 17 August 2022
6. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... each year despite it's expiry in a couple years time. The first time I did it, there were more steps; the second time I just did as per the below. If I ever have to do the long process again, I'l ...; Created on 07 April 2022
7. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... is incorrect, apparently you have to treat the field of type "File Upload" as an attachment despite it not being an attachment (or at least not found in the "Attachments" section of the CRM module). The ...; Created on 02 February 2021
8. A quick run through of setting up an export process in SITS: / Extensible Markup Language /; ... EOT, TOT, TIN, DIN run. Testing: No records are being processed despite relevant ones existing and all monitors run I would get this issue if I cloned an existing process (released an existing one, ...; Created on 21 August 2014
9. Convert to Proper Case in T-SQL: / Transact-SQL /; ... will be applied to names and addresses as well as job titles and departments. Why? We wanted a T-SQL version despite having successfully built a custom script component for SSIS. How? You ...; Created on 04 June 2014
10. Registered Users Cannot Login - Super Users Can: / Joomla /; ... users but only "Super Users" could actually login. "Registered" users would not be able to login, despite their status in the admin panel saying "enabled" and "activated" (not blocked). If I used a test ...; Created on 26 February 2014
11. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; ... "shared data source" to use). You might be able to get this working with a shared data source but in our case the shared data source didn't have the correct database (initial catalog) specified despite ...; Created on 22 November 2013
12. Creating a custom form field type for Joomla XML fieldset: / Joomla /; ... Method #1: Important! It took me two days to realize that underscores are not accepted in the type name (despite copying "custom_field.php" and wanting to call my type "user_projects")!!! My recommendation ...; Created on 25 October 2013
13. Joomla Component: Set default params on installation: / Joomla /; ... haven't been set. I need to go into the Joomla Admin panel, view the Options of the component, and click on "Save"... despite the fact that I don't change anything. How? Add the following line to ...; Created on 24 October 2013
14. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... to solve despite following an innumerable number of sites advising but none of them having my issue of rows after blank ones being out of alignment. TWO DAYS!!! I hope this helps you! If you know ...; Created on 23 April 2013
15. Fix Oracle Tnsping 3511 without Windows Registry: / Oracle PL/SQL /; ... policies: Need to run with elevated permissions which requires UAC prompt (despite being already logged in, this is the same user but re-prompted for credentials) Cannot run System Registry (not even ...; Created on 04 March 2013
16. Search a database with SOUNDEX: / Databases /; Why? Data Consistency. I was tasked with finding variations of our default values. End-users were complaining that some default values get listed twice because their system was case-sensitive despite ...; Created on 11 October 2012
17. T-SQL example of Case-Sensitive Soundex: / Transact-SQL /; ... eg. "Data not yet available". The final system (qlikview) was case-sensitive despite our server collation being case-insensitive. Furthermore, we now have the task of finding all the variations of ...; Created on 10 October 2012
18. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... ), '???') FROM DUAL; The other issue The "other" issue was the problem after all. The first query was erroring despite the stored procedure compiling successfully. An empty dataset is ...; Created on 24 January 2012
19. SSRS Repeat Headers in PDF Report: / SQL Server Reporting Services /; ... When I run the report in BIDS, the whole report (despite spanning 10 pages when printed) is on the same page. The same happens when I run this on the Reporting Server. My Setup - XP Workstation ...; Created on 26 October 2011
20. T-SQL Record Separator: / Transact-SQL /; ... row. My final query This displays all room bookings for today and the next 6 days. Note how I can't use normal dates because the database wasn't designed with timestamps (despite being a timetabling ...; Created on 11 October 2011