Search - Joel Lipman .Com

1. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... it to a list, then lets you generate an array or list of any size. Why? My use case here is to run a schedule that will populate a list with the upcoming dates for the next week (and for any numbers ...; Created on 21 October 2022
2. Zoho Deluge: Generate List of TimeZones: / Zoho /; What? A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing ...; Created on 19 October 2021
3. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; What? A super quick article to remind me how to generate and send a CSV as an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me ...; Created on 16 June 2021
4. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; What? This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? ...; Created on 09 May 2019
5. Generate a Timesheet in MySQL: / MySQL /; What? This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with ...; Created on 05 December 2013
6. Generate Academic Calendar using MySQL: / MySQL /; ... is to quickly generate a calendar for a full academic year for referencing by staff/students. How? Let us assume that we have a system holding a calendar in the following table (called "joes_weekstructure"): ID ...; Created on 27 November 2012
7. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... the method of "mega-functions", here is the code snippet for one function which will accept as parameter the eBay order reference and generate all the respective records in Zoho Inventory. We're using a ...; Created on 27 April 2023
8. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... now let's generate the page list to have all the available pages v_TotalNumberOfPages = ceil(v_MaximumOrders / v_PerPage); l_AddPages = leftpad(" ",v_TotalNumberOfPages).replaceAll(" ",",").toList(); for ...; Created on 29 March 2023
9. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; What? A quick note here on how to connect to the DHL API and check on a package given a tracking number. Why? In our megafunction to generate a customer, a product/item, a sales order, an invoice, ...; Created on 21 March 2023
10. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... going into how to generate an access token / connection from Zoho to eBay, that is documented in my article: Zoho Creator: Push to eBay Listings The megafunction So I'm going to call this function ...; Created on 01 March 2023
11. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... that were in practice added to the same function and that worked at time of print. Note that this uses the old Trading API as the new API is only available in Sandbox??? I won't go into how to generate ...; Created on 28 February 2023
12. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... = "\"'" + v_InventoryID + "\""; // // generate CSV row for monitoring purposes l_CsvFileRow = List(); l_CsvFileRow.add(v_CountTotal); l_CsvFileRow.add(v_VariantSKU); l_CsvFileRow.add(v_ProductTitle); l_CsvFileRow.add(v_ProductIDStr); l_CsvFileRow.add(v_VariantIDStr); l_CsvFileRow.add(v_InventoryIDStr); l_CsvFileRow.add(v_VariantPrice); l_CsvFileRow.add(v_VariantQty); l_CsvFileRow.add(v_ProductStatus); l_CsvFileRow.add(v_VariantBarcode); l_CsvFileRow.add(v_Shopify_Created); l_CsvFileRow.add(v_Shopify_Updated); l_CsvFileRow.add(v_Shopify_Published); v_CsvRow ...; Created on 20 February 2023
13. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... generator) which the bot can break down into "tokens" and then match with its training data to generate the image. Quick recap on how to first start using the MidJourney Bot Signup to Discord.com ...; Created on 11 February 2023
14. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... and Vacancy reference: /* ******************************************************************************* Function: void fn_AB_GenerateVacanciesCandidatesAssociations() Workflow: - Trigger: ...; Created on 08 February 2023
15. ZohoCRM: Import Attachments: / Zoho /; ... and only unique filenames herein. Perhaps if you were doing this over several imports, you could use the same filenames, I didn't try this, instead my program generates a unique MD5 for each file with ...; Created on 16 January 2023
16. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; What? An article on the reasoning and steps to generate a dataset using Zoho's ANSI-SQL queries to generate the margins of each invoice in ZohoBooks. Why? We need to create a profits/losses dashboard ...; Created on 03 November 2022
17. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... you will be provided with Client ID and Client Secret. Do not share the Client ID and Client Secret with anyone. STEP 2: GENERATE A GRANT CODE On the above screen (Zoho API Console - Applications ...; Created on 17 October 2022
18. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... set the data type r_DownloadedPhoto.setParamName("image"); // // build up request to Zoho m_Params = Map(); m_Params.put("image",r_DownloadedPhoto); // // generate endpoint v_Url = "https://books.zoho.eu/api/v3/items/" ...; Created on 21 June 2022
19. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... on the "Generate, view, upload, or delete SSL certificates" link in the right sidebar Scroll down and click on "Choose File" button under the "Upload a new certificate" section > Then select the certificate ...; Created on 07 April 2022
20. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... Zoho Creator to accept this ID, download the file, and upload it to a "File Upload" field Get Zoho Creator to generate a published / public URL of the file Get Zoho CRM to scan Creator for the public ...; Created on 31 March 2022