Search - Joel Lipman .Com

21. AutoHotkey Format Date and Format Seconds: / AutoHotkey /; ... straightforward form FormatTime( TimeString, Format ) { FormatTime, FormattedTime , TimeString, %Format% return Formattedtime } The following function is to convert a given SQ ...; Created on 20 September 2011
22. Format Numbers in AutoHotkey with Commas: / AutoHotkey /; Just a quick note as I use this function in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop ...; Created on 20 September 2011
23. Unix Date Format Specifiers: / Linux /; I could just remember to search wikipedia for "Date (Unix)" or search my site for "Unix". This was easier. Source: Wikipedia: Date (Unix) Format specifiers (format string starts with +) ...; Created on 05 July 2011
24. Formatting a date in an MDX query: / Transact-SQL /; Thought I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown as: =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) The ...; Created on 11 January 2011
25. Transact-SQL Date Format Conversions: / Transact-SQL /; Source: http://www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql-convert-function.aspx; Created on 19 November 2010
26. 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 ...; Created on 12 February 2010
27. Does Google Chrome Frame really improve performance: / Google /; The jury's still out on this one. I have noticed a slight improvement in my page loads but will have to carry out proper tests on the weekend. Instructions to a hard-coder The Google Chrome Frame ...; Created on 23 September 2009
28. Converting SQL date in PHP to European date format and vice-versa: / Personal Home Page /; The Issue If you've ever made PHP scripts to process data within a LAMP environment (Linux, Apache, MySQL, PHP) then this happens a lot. In the following example, our HTML form will allow the user to ...; Created on 17 September 2009
29. Using a HTML form and PHP to upload a file: / Personal Home Page /; The Issue Basically you have a HTML form with an input field type of 'FILE' (ie. ) and want a PHP file to process this. This example applies to a Linux Apache MySQL PHP (LAMP) environment. The ...; Created on 17 September 2009
30. How to make a HTML form post its variables to itself: / Hypertext Markup Language /; The Issue You have a PHP page which generates a HTML form. When the user submits the form, you want the same PHP page to process the data. Solution I've seen a lot of people write CGI requests but ...; Created on 17 September 2009
31. Zoho Creator: Sendmail a list of attachments: / Zoho /; ... void fn_Joel_Test() { /*** - tried with getUrl() but this doesn't work. - has to be an invokeUrl - set param name required - if file comes from a Creator form, no InvokeURL needed c_Form ...; Created on 20 July 2023
32. Zoho Deluge: Proper Case for Names: / Zoho /; ... " :|JOEL|: ", true).proper(); v_FirstName = v_FirstName.replaceAll(" :|joel|: ", "-", true); // // Names starting with Mc, O', D', I' l_ExceptionPrefixes = ; // // deal with double barrelled surnames l_FormattedLastName ...; Created on 13 July 2023
33. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... I had this formula which seemed to do the same thing but unnecessarily moved the pointer to the start of the week. It could also error eventually if Zoho made it possible to change the start of the week ...; Created on 06 July 2023
34. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... key here to enable inventory tracking m_CreateBooksItem.put("item_type","inventory"); // // other less important values to include re purchase information m_CreateBooksItem.put("product_type","goods"); m_CreateBooksItem.put("reorder_level",0); m_CreateBooksItem.put("available_stock",v_QuantityAvailable.toLong()); m_CreateBooksItem.put("initial_stock",v_Quantity.toLong()); m_CreateBooksItem.put("initial_stock_rate",v_ItemPrice.toDecimal()); m_CreateBooksItem.put("inventory_account_id",m_Accounts.get("Inventor ...; Created on 04 May 2023
35. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... API for the eBay store /* Function: fn_eBay_GetOrderInfoCreateUpdateZohoSO(string p_eBayOrderRef) Purpose: Queries eBay for information about an order and then creates item/contact/sales ...; Created on 27 April 2023
36. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... each index v_Increment in l_AddPages { l_Pages.add(v_Increment + 1); } v_TotalNumberOfPages = l_Pages.size(); // // declare variables to store order details in a JSON or ZohoDeluge Map format m_Response ...; Created on 29 March 2023
37. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... "id": "123456789000000123456789", "type": "custom" } } Tidied Up Want that in a practical format for use in ZohoCreator? Preferably not in the Zoho order, but that of the normal wee ...; Created on 28 March 2023
38. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... and then I'll include the code to query the shipment status based on a tracking number. Becoming a DHL Developer Browse to https://developer.dhl.com/user/register to Signup Complete the form with ...; Created on 21 March 2023
39. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... https://platform.openai.com/docs/api-reference/chat/create m_Params.put("temperature",0.8); m_Params.put("n",1); m_Params.put("max_tokens",256); m_Params.put("presence_penalty",0); m_Params.put("frequency_penalty",0); // ...; Created on 06 March 2023
40. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonProducts = List(); // // start preparing CSV file to email for export v_ReportCSV = "ItemID,ItemName,Price,CurrencyCode,QuantityAvailable,SKU,DateCreated"; l_CsvFileRows ...; Created on 01 March 2023