Search - Joel Lipman .Com

1. MS-DOS: Copy folders without overwriting files: / MS-DOS /; What? A quick note on how to copy files and folders over without overwriting existing files. It's easy to say "Yes" and replace all files. What I need is something that synchronizes files on an internal ...; Created on 23 February 2014
2. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... by creating a table in ZohoAnalytics rather than simply writing a query and using the 'asynchronous' method to extract the query result. To create an analytics table from a query, we do the following: Login ...; Created on 09 July 2024
3. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... > Schedules > Create New Schedule I'm calling my schedule "Shopify - Check Webhooks" and I'm going to execute a writing function. It has a function name of "fn_Schedule_ShopifyWebhooks" and a display name ...; Created on 22 April 2024
4. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... = Document[ID == v_ZC_DocumentRecordID]; info c_ExistingDocument.Document_File; Upload the generated file to the record Note that this is overwriting the existing record and associated file. ...; Created on 25 March 2024
5. ZohoCRM: Import Attachments: / Zoho /; ... A_Index, 8) LV_GetText(v_Col02, A_Index, 2) ; overwriting created time with modified time LV_GetText(v_Col03, A_Index, 2) LV_GetText(v_Col04, A_Index, 9) LV_GetText(v_Col05, A_Index, ...; Created on 16 January 2023
6. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... writing this article as it had gone through several partners before us and even Zoho themselves without a solution. This took my team the best part of two months to find a solution. How? Disclaimer ...; Created on 03 November 2022
7. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; What? Just a quick article if you get the above error and what to look for. Why? I was writing a function with perhaps too many for each loops within a for loop. How? The following is 1 ...; Created on 17 November 2021
8. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; What? A quick article to remind me on how to upload a photo using CRM API v2. Yes it's documented and yes it still confuses me now and again. So I'm writing this to remind me and to keep reminding me ...; Created on 27 September 2021
9. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; What? So this is a super quick note that I'll probably remember anyway but just in case, I'm writing this article so I don't spend time researching it later. Why? I'm synchronizing Xero Invoices with ...; Created on 04 May 2020
10. Joomla: Remove IDs from URLs for out-of-the-box SEF: / Joomla /; ... With URL rewriting enabled www.joellipman.com/index.php/4-category-alias/123-article-alias.html // What I want www.joellipman.com/category-alias/article-alias.html How? You could buy an SEF ...; Created on 14 March 2020
11. Zoho Deluge - Pad with leading Zeros: / Zoho /; ... to do this so often that it deserves an article. Though writing a whole page for this is probably unwarranted so I may rename this article later to common things I need to do in Zoho Deluge. How? ...; Created on 07 February 2020
12. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... Some XML bits: v_MyRegEx = ""; v_MyString = ""; v_FormattedString = v_MyString.replaceAll(v_MyRegEx,"$1",false); // yields my_real_textual_data Additional Since writing this article ...; Created on 31 May 2019
13. GDPR Privacy Policy: / Static Items /; ... and other communications that we provide to you electronically satisfy any legal requirement that such communications be in writing. COPYRIGHT All content included on this site, such as text, graphics, ...; Created on 14 February 2019
14. Zoho Deluge - MD5 function: / Zoho /; ... writing a Creator function but found a shortcut playing with the base64encode function: v_Etag = zoho.encryption.base64encode(v_Combined_Fields); // returns error Error on Execution Execution ...; Created on 19 November 2018
15. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... from (eg. `myuser_joellipmancom_mysitedb`.`lkdjf_content`) `v34_db`.`v34_tablename` -- with the database name and table prefix of database you are WRITING to (eg. `myuser_joellipmancom_mysitedb`.`ejf1r_content`) ...; Created on 12 September 2015
16. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; ... The data still hasn't been properly decoded from UTF-16 and encoded to UTF-8 Test writing to a file, re-encoding the file then reading from it. Helpful Links XML parsing in PHP convert xml ...; Created on 28 March 2015
17. Basic Android App using Google Maps and Current Location: / AndroidOS /; Applies to: Android Studio (Beta) 0.8.6 Google Android Maps API What? I am writing an app for a tablet running Android and wanted to include a Google Map. The following exercise focuses solely ...; Created on 10 October 2014
18. Creating a custom form field type for Joomla XML fieldset: / Joomla /; What? I'm writing a Joomla 2.5.x component for logging time and projects and need a dropdown to have selectable options restricted to the logged-in user. This is specified in the XML file of the custom ...; Created on 25 October 2013
19. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... case, a mixture of mostly lowercase and some UPPERCASE. Why? I'm writing this article because other solutions on the net were either incomplete, did not work for me or simply did not match the requirements ...; Created on 04 October 2013
20. DBMS Random Reference: / Oracle PL/SQL /; What? How to use the randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing ...; Created on 21 August 2012