Search - Joel Lipman .Com

1. Outputting PHP files into different file formats: / Personal Home Page /; I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do ...; Created on 12 February 2010
2. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... going to ZohoCRM > Setup > Customization > Modules and Fields > Contacts > Links and Buttons > Create Button where the function arguments will be p_ContactID = Contacts.Contact_ID v_OutputMessage = ...; Created on 21 October 2021
3. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... p_Position, int p_ProductID) { v_Output = ""; m_Header = Map(); m_Header.put("Content-Type","application/json"); // // your shopify details v_ClientID = ""; v_ClientSecret = ""; v_ShopID ...; Created on 17 October 2021
4. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... */ v_Page = ifnull(p_Page,1); v_PerPage = ifnull(p_PerPage,200); m_Output = Map(); r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; if(r_Api.count() > 0) { v_AccessToken ...; Created on 13 October 2021
5. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... It then outputs a JSON list as a response and the total record count: void API.fn_ShopifyQuery_GetActiveProducts() { m_Header = Map(); m_Header.put("Content-Type","application/json"); // // ...; Created on 12 October 2021
6. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... = invokeUrl [ url :"https://www.zohoapis.eu/crm/v2/coql" type :POST parameters: m_Params.toString() connection: "joels_coql_connection" ]; // // output info r_Coql; But ...; Created on 08 October 2021
7. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... = zoho.books.createRecord("salesorders",v_BooksOrgID,m_BooksCreateSO,"ab_books"); // output response info r_CreateSO; // read response if(!isnull(r_CreateSO.get("salesorder"))) { v_SalesOrderID = r_CreateSO.get("salesorder").get("salesorder_id"); // v_AddressIndex ...; Created on 22 September 2021
8. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... on the function that generates an access token from a refresh token: string API.fn_eBayConnect_AccessToken() { b_SandboxMode = false; v_Output = ""; if(b_SandboxMode) { r_Api = API_Integration[Connection_Name ...; Created on 20 September 2021
9. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... stuff here ... eg getting data fields, generating a title and setting the title: input.Title = "Hello World "; // // output input.Note_Preview = input.Title; // // re-enable auto-update preview input.Update_Preview=true; To ...; Created on 19 September 2021
10. Zoho Creator: Push to eBay Listings: / Zoho /; ... = ""; v_Endpoint = ""; v_ClientID = ""; v_RedirectURI = ""; v_Output = "Error with Grant URL"; l_Params = List(); v_ResponseType = "code"; // // scopes l_Scopes = List(); l_Scopes.add("https://api.ebay.com/oauth/api_scope"); l_Scopes.add("https://api.ebay.com/oauth/api_scope/sell.marketing.readonly"); l_Scopes.add("https://api.ebay.com/oauth/api_scope/sell.marketing"); l_Scopes.add("https://api.ebay.com/oauth/api_scope/sell.inventory.readonly"); l_Scopes.add("https://api.ebay.com/oauth/api_scope/sell.inventory"); l_Scopes.add("https://api.ebay.com/oauth/api_scope/sell.account.readonly"); l_Scopes.add("https://api.ebay.com/oauth/api_scope/sell.account"); l_Scopes.add("https://api.ebay.com/oauth/api_scope/sell.fulfillment.readonly"); l_Scopes.add("https://api.ebay.com/oauth/api_scope/sell.fulfillment"); l_Scopes.add("https://api.ebay.com/oauth/api_scope/sell.analytics.readonly"); l_Scopes.add("https://api.ebay.com/oauth/api_scope/sell.finances"); l_Scopes.add("https://api.ebay.com/oauth/api_scope/sell.payment.dispute"); l_Scopes.add("https://api.ebay.com/oauth/api_scope/commerce.identity.readonly"); l_Scopes.add("https://api.ebay.com/oauth/api_scope/commerce.notification.subscription"); l_Scopes.add("https://api.ebay.com/oauth/api_scope/commerce.notification.subscription.readonly"); v_Scopes ...; Created on 12 September 2021
11. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... the following code which generates a sample CSV and then loops through storing each row as a data record and outputting it to screen: // generate a sample CSV file v_DataCSV = "1,Joel Lipman,Kings ...; Created on 26 August 2021
12. Xero API: Send Multiple Invoices: / Xero /; ... "Date": "2021-08-13", "LineItems": [ { "Description": "My expensive product #1", "Quantity": 1, "UnitAmount": 240, "TaxType": "OUTPUT2", ...; Created on 15 August 2021
13. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... = v_RelatedListXML + "No records found"; v_RelatedListXML = v_RelatedListXML + ""; } // // output return v_RelatedListXML; in Zoho Books // // find all related quotes l_DataRows = List(); v_QuoteRefID ...; Created on 30 July 2021
14. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... no error if not: To return an error (I know we set the function to return "Map" and are using a "Collection" but a Collection is either a list or a map): // return response as error popup v_OutputMessage ...; Created on 10 December 2020
15. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... = "https://books.zoho.eu/api/v3"; // // init v_OutputMessage = ""; v_CrmSoRef = ""; v_CrmSoID = 0; // // get books so name (sales order number) r_BooksSoDetails = zoho.books.getRecordsByID("Salesorders",v_BooksOrgID,v_BooksSoID.toString()); for ...; Created on 15 May 2020
16. MySQL: Count occurrences of words in a column: / MySQL /; What? This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count ...; Created on 12 March 2020
17. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... FileRead, OutputContent, %PreferenceFile% NameStart := InStr(OutputContent, """name"":""")+8 NameEnd := InStr(OutputContent, """", false, NameStart+1) NameLength := NameEnd - NameStart ...; Created on 07 January 2020
18. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; ... v_Center:= v_x1 a_MyArray[1,0] := v_x1 a_MyArray[1,1] := v_y1 a_MyArray[1,2] := v_x2 a_MyArray[1,3] := v_y2 } } ; output ...; Created on 18 July 2019
19. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... Joe Remove block comments: v_MyRegEx = "(\/\*([^*]|(\*+[^*\/]))*\*+\/)"; v_MyString = "String to output: /* this is a comment */"; v_MyFormattedString = v_MyString.replaceAll(v_MyRegEx,""); // ...; Created on 31 May 2019
20. Convert Past Date to Time Ago in PHP: / Personal Home Page /; ... as parameter a SQL date (or date format that strtotime() can convert) and outputs the largest unit (for example "1 year" not "1 year 2 months 3 days, etc..."). function getTimeAgo($p_Date) { ...; Created on 16 May 2019