Search - Joel Lipman .Com

1. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !: / Personal Home Page /; ... in PHP with the function simplexml_load_string(). The error I get is something similar to: PHP Warning: simplexml_load_string(): Entity: line #: parser error : Input is not proper UTF-8, indicate encoding ...; Created on 02 August 2016
2. T-SQL: Parse an XML value: / Transact-SQL /; What? This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings ...; Created on 27 March 2014
3. AwStats Data Parser (ADP): / Product Documentation /; ... there isn't the menu on the left) Run "Generate_AwStatsParsedData.exe" Select the file you saved in step 1 Click on "Go". What data does it return? Any table/grid in the Awstats report uniquely ...; Created on 03 April 2013
4. Parse a HTML Table into a ListView: / Hypertext Markup Language /; ... Method #1 This method replicates the table in a listview format: ; tell the script which content to parse Haystack := CodeContainingMyHTMLTable ; determine markers (character ...; Created on 30 March 2013
5. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; What? I think I have a similar article on this website but the article below documents the full process to create a button that will map the values/fields from the record into a CRM Mail Merge template ...; Created on 06 August 2024
6. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... + v_ZA_ViewID + "/data"; // // send request r_PurchaseOrders = invokeurl [ url :v_Endpoint type :GET parameters:m_Config headers:m_Header connection:"my_analytics_connection" ]; // // parse ...; Created on 09 July 2024
7. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... :v_Endpoint type :GET headers:m_Header connection:"my_connection" ]; //info r_Analytics; // // parse response if(r_Analytics.get("status") == "success") { m_ResponseData = ifnull(r_Analytics.get("data"),Map()); l_DataSources ...; Created on 02 July 2024
8. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... information to your Zoho instance via API. No need for the Zoho Widget SDK. Why? At time of print, I felt the documentation was a little sparse on how to connect a JS widget to the data held in Zoho ...; Created on 14 March 2024
9. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... else use the current value var v_ProductWeightFormatted = fn_CountDecimals(v_ProductWeight) > 2 ? parseFloat(v_ProductWeight).toFixed(2) : v_ProductWeight; // set the field value to the formatted ...; Created on 13 December 2023
10. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
11. 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
12. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... m_Header detailed: true ]; // // parse response if(r_ShipmentDetails.get("responseCode")==200) { l_Shipments = r_ShipmentDetails.get("responseText").get("shipments"); for each r_Shipment in l_Shipments ...; Created on 21 March 2023
13. 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
14. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... :POST parameters:m_GraphQl.toString() headers:m_Header ]; //info r_GetProductVariants; // // parse the response if(r_GetProductVariants.get("data") != null) { if(r_GetProductVariants.get("data").get("productVariants") ...; Created on 20 February 2023
15. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... json_Row = l_NewSubformRows; // put the arguments into a single row (json array) json_Row.push(json_Arg); // need to stringify AND parse otherwise this won't work var json_Parsed ...; Created on 09 December 2022
16. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... you can parse the multi-line into a nice HTML table. But on a mobile device, it's somewhat better to use the built-in interfaces provided by Zoho Creator. What I really needed was a way to display ...; Created on 18 August 2022
17. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... there's more documentation on the API for Zoho Books, we're going to apply this solution to Zoho Books. How? We're not going to go into detail on how to parse an eBay response here (see my other articles ...; Created on 21 June 2022
18. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... one way, in other words, listings on eBay get downloaded to Zoho Inventory but not vice-versa. Then there's an added delay of 4 hours. Then item specifics in eBay's listings don't get parsed into custom ...; Created on 31 March 2022
19. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... parse the response if(!isnull(r_GetProduct.get("data"))) { if(!isnull(r_GetProduct.get("data").get("productVariants"))) { if(!isnull(r_GetProduct.get("data").get("productVariants").get("edges"))) ...; Created on 14 February 2022
20. 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 ...; Created on 22 January 2022