Autohotkey Count Number of Files/Folders in a Directoryhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 Method #5: MS-DOS Command Prompt dir c:\*.* /os /s -- bear with me as i try to create a for loop one to omit all the header info

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

SSIS Multiple Lookups in onehttps://www.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 lookup task that executes a SQL query which returns all the joined tables and displays the decode name. Let's pretend the info we want is rather simple: SELECT [sequenceID], [student_reference], [student_title_code], [student_name],...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Copy a Wordpress Site for Developmenthttps://www.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

08 March 2015 sample values and just for myself to quickly modify a Wordpress configuration file. // ** MySQL settings - You can get this info from your web host ** // /** The name of the database for WordPress */ define('DB_NAME', 'my_database_name'); /** MySQL...

• Type: Article
• Author: Joel Lipman
• Category: Wordpress
• Language: en-GB

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 text/xml')); // specify content type of what we're sending curl_setopt($ch, CURLOPT_HEADER, 0); // hide header info !!SECURITY WARNING!! curl_setopt($ch, CURLOPT_POST, TRUE); // TRUE to do a regular HTTP POST. curl_setopt($ch, CURLOPT_POSTFIELDS,...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 JSON Key This key doesn't just contain the private key we need. It is a JSON file with links to the public key, as well as info as to the project ID, the client ID, the client Email... Stuff that this script will use so: // Get JSON file (generated by...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 r_Update = zoho.books.updateRecord("Invoices",v_BooksOrgID,v_InvoiceID,m_UpdateInvoice); info r_Update; Update 2023 If the above doesn't work, consider making an API call to the following endpoint: m_Params = Map(); m_Params.put("invoice_ids", );...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 FileExist( sFile:=A_LoopFileLongPath ) { Return } SplitPath, sFile, _FileExt, _Dir, _Ext, _File, _Drv If ( p[p.length()] = "xInfo" ) ; Last parameter is xInfo { p.Pop() ; Delete parameter fex.SetCapacity(11) ; Make room for Extra info fex["_Attrib"] :=...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 = v_ThisFrom || v_CompareDateFrom = v_ThisTill) { v_TotalClashes = v_TotalClashes + 1; v_ClashOrNot = "Clashes with "; } info v_ClashOrNot + r_TimeOff.get("Employee_ID") + ":" + v_ThisFrom + "-" + v_ThisTill; } } } Note: Play around with the Status,...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Convert Map to HTML Table without a FOR loophttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-html-table-without-a-for-loop.html

11 January 2021 m_Data.put("Last_Name","Person"); m_Data.put("id","2"); l_Data.add(m_Data); v_Data = l_Data.toString(); info v_Data; // yields // {"First_Name":"Joel","Last_Name":"Lipman","id":"1"},{"First_Name":"Another","Last_Name":"Person","id":"2"} Some formatting...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

29 January 2021 = l_SortingKeys.sort(false); for each v_SortKey in l_SortedKeysDesc { m_ThisRecord = m_UnsortedRecords.get(v_SortKey); info m_ThisRecord; } Recap The original sample data l_MyListUnsorted looks something like this in a JSON parser: [ { "name": "Joel",...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 { $v_PostedSecret = $_POST['auth']['secret']; } if($v_PostedKey == $v_Key && $v_PostedSecret == $v_Secret) { mail("info@joellipman.com","Post to AscentCloud","Successful Auth"); } } // yields: Successful Auth Caveat Unfortunately, I've titled this...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 :"https://www.zohoapis.eu/crm/v2.1/Invoices/" + p_InvoiceID type :GET parameters: m_Params connection:"joels_connector" ]; info r_InvoiceDetails; Common Error(s): {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"data"},"message":"required field not...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Deluge: Map a custom field from user profilehttps://www.joellipman.com/articles/crm/zoho/zohocrm-deluge-map-a-custom-field-from-user-profile.html

01 September 2021 = Map(); m_UpdateDeal.put("Division",v_DivisionID); r_UpdateDeal = zoho.crm.updateRecord("Deals",v_DealID,m_UpdateDeal); info r_UpdateDeal; } } break; } }

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Standard Setup for Tax Rateshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

02 September 2021 a CRM product record (you can do mass edit on a listview of products but for demo purposes, we'll do just one) Under Price Information, edit the field "Tax" (multi-select) and select both tax rates Now go to a transactional module that has line items...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 v_PositionIndex, v_ShopifyImageSrc); } v_PositionIndex = v_PositionIndex + 1; } info "Re-uploaded Photos to Shopify"; } } Correction / Additional The above solution means that for every photo uploaded, an API call is used up. If you have low limits,...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-adding-10-minutes-to-a-crm-date-time-field.html

11 November 2021 m_UpdateLead.put("Check_Date_Time", v_LeadTimeDelay); r_UpdateLead = zoho.crm.updateRecord("Leads", p_LeadID, m_UpdateLead); info r_UpdateLead;

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

16 December 2021 m_Data = Map(); m_Data.put("Body",v_Message); m_Data.put("From",v_OurTwilioNumber); m_Data.put("To",v_CustomerNumber); info m_Data; // // JSON request r_TwilioResponse = invokeurl [ url :v_Endpoint type :POST parameters:m_Data ]; } Error(s) Encountered...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

10 February 2022 an ID on this record to avoid looping through error messages if(!isNull(r_Result.get("id"))) { // do stuff to each record... info r_Result.get("id"); } } // // stop looping if less than 200 records on this page if(l_SearchResults.size()...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Generate a loop or list of any sizehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-a-list-of-any-size.html

21 October 2022 { if(v_Index>0) { l_CheckDates.add(zoho.currentdate.addDay(v_Index).toString("yyyy-MM-dd")); } } // // output info l_CheckDates; // // outputs: 2022-10-22,2022-10-23,2022-10-24,2022-10-25,2022-10-26,2022-10-27,2022-10-28

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://www.joellipman.com/articles/crm/zoho/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

28 February 2023 I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this function too often either for debugging/monitoring purposes but it's easier to use...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *