Search - Joel Lipman .Com

1. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; What? A quick article on how to setup an automation that checks if a datasource synchronization between Zoho People and Zoho Analytics failed. This can be adapted to any data source for Zoho Analytics. ...; Created on 02 July 2024
2. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; What? So this is going to be an article with a bunch of pictures showing step-by-step of how I setup a recurring data source in Zoho Analytics via FTP. Why? The use-case here is that I have a ...; Created on 12 January 2022
3. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; ... connection manager but this is inefficient and not versatile enough to accommodate files that get added later. Why? I am creating an extract SSIS package intended to take a text file as its source ...; Created on 13 June 2014
4. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; What? This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation ...; Created on 23 April 2013
5. SSIS Skip Rows in Excel Source file: / SQL Server Integration Services /; What? A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then ...; Created on 04 April 2013
6. Zoho Creator: Input Color Picker: / Zoho /; ... = v_HeximalRef; input.RGB_Value = thisapp.ColorPicker.fn_HexToRGB(v_HeximalRef); } Source(s): Joel Lipman - Zoho Creator: Radio group into Calendar Carousel Joel Lipman - Zoho Deluge: Convert ...; Created on 14 October 2024
7. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... = Map(); m_Params.put("resource_id",v_WorkdriveFolderID); m_Params.put("shared_type","workspace"); m_Params.put("email_id",l_RecipientsEmails); // role id 34 is view only on the file (see below ...; Created on 11 September 2024
8. What can MAGA’s do to stop Biden from cheating again?: / Jokes /; A guy goes to a bar and is served by a robot bartender. The robot says, "What'll you have?" and the guy says, "A martini." He then gets the best martini he's ever tasted. The robot says, "What's your IQ?" ...; Created on 28 August 2024
9. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... ct = Map(); if(v_FullName.contains(" ")) { v_Forenames = v_FullName.subString(0,v_FullName.lastIndexOf(" ")); v_LastName = v_FullName.subString(v_FullName.lastIndexOf(" ")); m_CreateContact.put("First_Name",v_Forenames); m_CreateContact.put("Last_Name",v_LastName); } else { m_CreateContact.put("First_Name",v_FullName); } m_CreateContact.put("Email",m_Notification.get("beneficiary_email")); m_CreateContact.put("Account_Name",v_ZCRM_DocRecordAccountID); m_CreateContact.put("Contact_Status","Active"); m_CreateContact.put("Lead_Source_Detail","Cre ...; Created on 06 August 2024
10. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... the data for my widgets), I have to write it as such: SELECT 'CRM Accounts' AS "DataSource", date(t1."ModifiedTime") AS "Date", t1."RecordID" AS "Record ID", t1."RecordName" AS "Record Name", ...; Created on 25 July 2024
11. Zoho Projects: Get All Events: / Zoho /; ... v_ProjectID + "/events/" + v_EventID + "/"; r_ThisEvent = invokeurl [ url :v_EndpointEvent type :GET connection:"my_projects_connection" ]; info r_ThisEvent; Source(s): Zoho Projects - ...; Created on 22 July 2024
12. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... to Zoho Analytics, and choose a workspace with the relevant data (in this case Zoho Books Analytics workspace) In the left sidebar, select "Data Sources" then click on the "Add Data Sources" button Select ...; Created on 09 July 2024
13. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; What? A quick article on how to get the pricebook entry using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine ...; Created on 23 May 2024
14. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... user, and authorized as the system account (a separate Zoho user we have named SYSTEM ADMIN); this reduces the amount of blame on the system manager believed to be assigning these manually. Source(s): Zoho ...; Created on 14 May 2024
15. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... could be the same under price total. Where a price is applied, values should be retained in decimal format with currency symbol prefixed if value is greater than zero. Source(s): To convert Page ...; Created on 07 May 2024
16. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... + zoho.currenttime.toString("yyyy-MM-dd HH:mm","Europe/London")); m_WebhookLog.put("Body",m_Payload.get("body")); m_WebhookLog.put("Event_Type","Inventory Update"); m_WebhookLog.put("Source","Shopify"); m_WebhookLog.put("Data_Format","JSON"); r_WebhookL ...; Created on 22 April 2024
17. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... product count as products can belong to multiple categories. Consider just using the WooCommerce interface to check the total number of products (wp-admin > Products > All Products). Source(s): WooCommerce ...; Created on 15 April 2024
18. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... an external server. Create your own web app on another server and setup a server to server API connection to your Zoho Creator instance. Source(s): Zoho Creator: Create your first widget Zoh ...; Created on 14 March 2024
19. Zoho CRM: Client Script Confirmation Box and Popup Mailer: / Zoho /; ... it, just show it in the logs) console.log(e); //ZDK.Client.showMessage("Client Script error"); } Output Source(s): Zoho CRM Community - Kaizen #71 - Client Script ZDK ...; Created on 06 February 2024
20. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... Data Sources in the left sidebar Add Data Sources > Select Zoho Desk Do "Next" and select the Zoho Desk Portal Ensure that "Tickets" is selected (I'd tick most of the fields this contains) Create ...; Created on 05 December 2023