Search - Joel Lipman .Com

1. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... setup (when Lockdown due to COVID-19 first happened). The work PC connected to the 3 monitors at the top and the home PC connected to the 2 monitors underneath: How? My upgrade for 2022, is that ...; Created on 12 March 2022
2. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... client who wants to import data via FTP (SFTP - to be precise) and have this available to their Zoho apps. My aim(s) are: Setup recurring FTP connection. Make data readily available to ZohoCRM. ...; Created on 12 January 2022
3. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... details how to setup a connection to use in an invoke URL statement. Specifically for Zoho Books, Subscriptions or Inventory. Why? Setting up a connection avoids the hassle of having to generate ...; Created on 12 August 2020
4. Zoho Deluge - InvokeConnector and useful snippets: / Zoho /; What? So this is an article with some common snippets of code that use the InvokeConnector and do things we can't do in shortcode. List CRM Users (ActiveUsers) Note that this is somewhat superseded ...; Created on 23 January 2020
5. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connec: / MySQL /; ... "Data Export" using MySQL Workbench. This is not regarding the connection issue as I can connect to my database using MySQL Workbench (I have enabled the old authentication protocol). The error ONLY appears ...; Created on 28 July 2014
6. Connect to Joomla database in standalone script: / Joomla /; ... of these need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the credentials (ie. username, password, ...; Created on 17 August 2012
7. Connection Strings for SQL Server: / SQL Server /; Download Connectors from dev.MySQL.com MySQL Connector/Net Type: .NET Framework Class Library Usage: MySql.Data.MySqlClient.MySqlConnection Manufacturer: MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default ...; Created on 05 January 2011
8. Database Error: Unable to connect to the database: Could not connect to MySQL: / MySQL /; I've been looking into this for a friend and going through forums to investigate this error. After you've checked your database connection details, I find what FisherC said below is the most probable cause ...; Created on 25 September 2009
9. Zoho CRM: Updating a CRM record Custom Line Items using API v7: / Zoho /; ... + p_QuoteID; r_QuoteDetails = invokeurl [ url :v_Endpoint type :GET connection:"zcrm" ]; l_RecordData = ifnull(r_QuoteDetails.get("data"),List()); for each m_RecordData in l_RecordData { // // ...; Created on 18 December 2024
10. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... it is Fn - ZohoBooks - Estimates - Accept/Decline It's a standalone function I'll give it the following code (amend the org ID and connection name): // // initialize b_ValidResponse = false; v_EstimateI ...; Created on 04 November 2024
11. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... Getting the team folder information Use the team_folder_ID or if it is a subfolder, then use the team_subfolder_id Ensure the scope for your connection includes WorkDrive.teamfolders.READ and note ...; Created on 11 September 2024
12. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; What? I think I have a similar article on this website but the article below documents the full process to create a button that will map the values/fields from the record into a CRM Mail Merge template ...; Created on 06 August 2024
13. Zoho Projects: Get All Events: / Zoho /; ... get all portals v_EndpointPortals = v_BaseURL + "/restapi/portals/"; r_Portals = invokeUrl [ url: v_EndpointPortals type: GET connection: "my_projects_connection" ]; info r_Portals; // // once ...; Created on 22 July 2024
14. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... + v_ZA_ViewID + "/data"; // // send request r_PurchaseOrders = invokeurl [ url :v_Endpoint type :GET parameters:m_Config headers:m_Header connection:"my_analytics_connection" ]; // // parse ...; Created on 09 July 2024
15. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... "Scheduler" header information such as the name, description, start date/time, frequency, and timezone. While you're here, click on "Connections" at the top of the IDE (where you paste the code) and ensure ...; Created on 02 July 2024
16. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... is sitting right now. The code snippet to get the item record from the price book Note that I'm using a connection called "zbooks" and it has every permission under the sun (the naughty ZohoBooks.fullaccess.all) ...; Created on 23 May 2024
17. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... (3 days overdue) then assign to Dan (set as a separate workflow 4 days after creation of lead? Ensure that when this has been converted to a contact it removes this task.) - Use connection ...; Created on 14 May 2024
18. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... = zoho.creator.createRecord("myOwnerName","myAppName","myFormName",m_CreateRecord,m_Blank,"myCreatorConnection"); // // build the hash based on the payload body v_Data = ifnull(m_Payload.get("body"),""); v_VerifyHash ...; Created on 22 April 2024
19. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... How? So first, this article shows you how to setup an API connection, and then we'll include the code to count the total number of products, and then finallly show the code to loop through all the ...; Created on 15 April 2024
20. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... = invokeurl [ url :v_Endpoint type :POST files: f_CSVFile connection:"zcreator" ]; info r_Upload; Display new file name (optional) // // get updated document file (optional: ...; Created on 25 March 2024