Search - Joel Lipman .Com

1. Transact-SQL: / Category /; Created on 05 March 2020
2. Zoho Creator: eBay: Get Item Transaction: / Zoho /; What? This is the function to get the line item order/transaction from eBay if you give it the eBay Item ID as a parameter. Why? Mostly for debugging but here's the code that will quickly get the ...; Created on 22 January 2022
3. MySQL Transactions in PHP: / MySQL /; ... changes to the data. This where transactions are useful. We can run the queries, then check if some conditions are met before committing the changes in the data: $mysqli->begin_transaction(); $mysqli->query ...; Created on 14 December 2016
4. 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
5. Zoho CRM: Updating a CRM record Custom Line Items using API v7: / Zoho /; ... my designers keep including custom fields in their transactional modules line items (quotes, sales orders, invoices, purchase orders). The only way to update these are by using the API and deluge function ...; Created on 18 December 2024
6. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/getmyebayselling.html - GetOrderTransactions Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/GetOrderTransactions.html - ...; Created on 27 April 2023
7. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
8. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how 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 ...; Created on 28 February 2023
9. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; ... I'm going to show you the code first of how to parse the eBay Transaction data and then the code to create a Shopify Order: Parse an eBay Transaction Notification (XML) x_ResponseBody = input.Payload.getJSON("body"); v_MainNodeName ...; Created on 21 January 2022
10. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... API... Why? A follow on from my article Zoho Creator: Push to eBay Listings. I have a Creator app that needs to receive the orders from an eBay account as soon as the order or transaction is made ...; Created on 20 September 2021
11. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; ... have this selectable for users in their transactional modules (quotes, sales orders, invoices, purchase orders), you need to modify each product record (can be done with "Mass Update") to give them the ...; Created on 02 September 2021
12. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; What? This is a quick article documenting how to update custom fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. ...; Created on 17 May 2021
13. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... data. And yes, the part that took me about 8 hours and the key point above is to replace the ampersand with its unicode equivalent. I consider myself familiar with Transact-SQL, Oracle PL/SQL and ...; Created on 28 August 2020
14. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... ms-settings:nfctransactions Proxy ms-settings:network-proxy Status ms-settings:network-status ms-settings:network VPN ms-settings:network-vpn Wi-Fi ms-settings:network-wifi Wi-Fi Calling ms-settings:network-wificalling ...; Created on 30 July 2020
15. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... This works in the scenario where you have disabled the transaction modules in CRM (so Sales Orders, Invoices, Purchase Orders) and integrated your Zoho CRM with your Zoho Books. Why? Because then Zoho ...; Created on 15 May 2020
16. TravelPort Universal API - Ping Request with PHP-cURL: / API Miscellaneous /; Applies to: TravelPort Universal API PHP 4 or 5 cURL What? An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using ...; Created on 27 April 2015
17. Android OS: Add GoogleMap as fragment: / AndroidOS /; ... private void addMapFragment() { FragmentManager manager = getSupportFragmentManager(); FragmentTransaction transaction = manager.beginTransaction(); MapFragment fragment ...; Created on 25 November 2014
18. Compare two databases using T-SQL: / Transact-SQL /; Applies to: MS SQL Server Management Studio 2008 Two Transact-SQL databases What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without ...; Created on 24 September 2013
19. Split a row into multiple rows based on a column value: / Transact-SQL /; Applies to Transact-SQL (T-SQL) What? This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that ...; Created on 23 August 2013
20. Modifying columns in a table: / Databases /; What? This is an article to remind me how to modify a column in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools). ...; Created on 24 July 2013