Search - Joel Lipman .Com

1. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; What? A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file ...; Created on 01 March 2023
2. Zoho CRM: Template: Empty Space between Header and Line Items: / Zoho /; What? A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this). Why? ...; Created on 03 February 2022
3. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; What? This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a ...; Created on 26 August 2021
4. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; What? This is a quick article documenting how to update custom fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. ...; Created on 17 May 2021
5. PHP - Remove newlines and spaces from StyleSheet: / Personal Home Page /; What? This is a quick note on how to reduce a whole bunch of CSS into a single line without unnecessary spaces and new lines. Why? What I have: #copyright a{ margin: 10px 0 0 85px; box-shadow: ...; Created on 03 January 2020
6. Zoho Deluge - Modify the product line items in an invoice module: / Zoho /; ... product that they didn't stock. How? So editing the product_details field of an invoice record seems straightforward but it isn't. Undocumented, the trick is to remove the existing ID of the line ...; Created on 22 August 2019
7. SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issue: / SQL Server Integration Services /; What? I started getting this error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.2" is not registered for use on this computer Why? We use a combination of MS Visual ...; Created on 09 June 2014
8. List last modified files using FTP Command-line: / File Transfer Protocol /; Why? So let's say my FTP client is not the most expensive (was FREE), nor the most advanced client out there, and I want to know what were the most recent files I modified and uploaded to a site, how ...; Created on 20 November 2012
9. Vertically align an asterisk on a line: / Cascading Stylesheets /; ... size of the asterisk, this often increases the line-height and causes the overall line height to change for other objects in the same row. The problem afterwards was that the asterisk character would ...; Created on 02 September 2012
10. Inline Labels in Form Fields using Javascript: / JavaScript /; ... Explanation type="text" - standard attribute that tells the field this is an input field for single line of text. name="name" - attribute that assigns a variable name to this field so we can reference ...; Created on 21 August 2012
11. Prefix Line Numbers in a Text File: / MS-DOS /; Intro Prefixing lines with their respective line number in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number ...; Created on 18 July 2012
12. Invalid arguments passed in router.php on line 325: / Joomla /; ... in a menu: Warning: implode() [function.implode]: Invalid arguments passed in /home/.../public_html/includes/router.php on line 325 Where "..." is the path on your server. If you're ...; Created on 03 August 2010
13. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... "Role" with the options: "user", "assistant", "system". Add a file upload field called "Big Data" Add a single line field called "Title" (used as a multi-line cannot be used in the listview). Add ...; Created on 06 March 2023
14. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... a split for any multi-line item orders: // // declare variables to store order details in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonOrders = List(); // // loop through orders in ...; Created on 28 February 2023
15. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... Script, add the following: // // CSS overrides v_CssNotes = ""; // // this line hides the delete/cross icon next to each row v_CssNotes = v_CssNotes + ".subformRow .form-group"; // // this line ...; Created on 28 February 2023
16. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; What? An article to resolve my frustration in being able to ONLY retrieve the first 100 products using GraphQL, so page 1 of Shopify products. Why? Our use-case is that we retrieve the 100 most ...; Created on 20 February 2023
17. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Cartoon Polaroid Polka Dot Pop Art Post-Impressionism Psychedelic Punk Rainbow Realism Sketch Steampunk Sticker Surreal Synthwave Unreal Engine Vector Line Watercolor Painting Whimsical ...; Created on 11 February 2023
18. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... which they called "Candidate Ref" and their own reference for the JobOpening called "Vacancy Ref". The below outlines the custom module we created and how we populated with associated candidates: The ...; Created on 08 February 2023
19. ZohoCRM: Import Attachments: / Zoho /; What? An article for myself really as I couldn't find much online to address the errors I encountered below but also to document the import process of a bunch of files into a ZohoCRM system. Why? ...; Created on 16 January 2023
20. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... Using the following line returns all subform rows, even deleted ones, which is why we didn't use this command in the system. But keeping it for future reference. var l_existingSubformRows = ZDK.Apps.CRM.Deployment_Rate_Log.fetch(); ...; Created on 09 December 2022