Search - Joel Lipman .Com

1. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; What? So this is going to be an article with a bunch of pictures showing step-by-step of how I setup a recurring data source in Zoho Analytics via FTP. Why? The use-case here is that I have a ...; Created on 12 January 2022
2. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; ... connection manager but this is inefficient and not versatile enough to accommodate files that get added later. Why? I am creating an extract SSIS package intended to take a text file as its source ...; Created on 13 June 2014
3. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; What? This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation ...; Created on 23 April 2013
4. SSIS Skip Rows in Excel Source file: / SQL Server Integration Services /; What? A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then ...; Created on 04 April 2013
5. ZohoBooks: Code 15 Ensure Billing Address has less than 100 characters: / Zoho /; ... :PUT parameters:m_BooksShippingAddress.toString() connection:"zbooks" ]; info "ZohoBooks Estimate Shipping Address RESPONSE: "; info r_EstimateShippingAddress; } } } Source(s): Zoho ...; Created on 18 September 2023
6. Zoho Creator: Sendmail a list of attachments: / Zoho /; ... = Form[ID == 1234]; r_Download1 = c_Form.myFieldWithFile; ***/ l_Downloads = List(); r_Download1 = invokeUrl [ url: "https://www.w3.org/WAI/ER/tests/xhtml/testfiles/resources/pdf/dummy.pdf" ...; Created on 20 July 2023
7. Zoho Deluge: Proper Case for Names: / Zoho /; ... "Maci", "Macala", "Mack", "Macoy", "Macey", "Macedonia"... Source(s): Wikipedia: Category: Compound surnames Diana, Goddess of the Hunt - Every-Name Index to Family Group Sheets: Mac / Mc Wikipedia ...; Created on 13 July 2023
8. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; What? There are other sources on the web which show you how to deduplicate a contact but usually involve entering a customer name or other key to check if there are already records in the system with ...; Created on 12 July 2023
9. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; What? A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday. Why? I think it's the US system which generally says that a week starts on a ...; Created on 06 July 2023
10. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; What? A quick article on getting the payment terms in Zoho Books along with their IDs. Why? I often need to send through an automatic payment term on the creation of an invoice but lots of my ...; Created on 06 July 2023
11. Zoho Inventory: Enable Tracking using the API: / Zoho /; What? One of these articles because I spent so long trying different snippets of code to enable tracking when using Deluge code to create an item in Zoho Inventory: Why? Who uses ZohoInventory ...; Created on 04 May 2023
12. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... cases, a working example can return within the hour as authenticated. Use the following link to continue monitoring for when this has taken effect: https://zohomail.tools/#runChecks Source(s): ZohoCRM: ...; Created on 04 May 2023
13. 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
14. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... string is a no go. Set it to an atom time or nice SQL date/time (eg. "yyyy-MM-dd HH:mm:ss") and then apply the function .toTime() Source(s) Zoho CRM v3 Organization API Zoho Community Forums ...; Created on 28 March 2023
15. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... "Message: " + r_ZohoShipmentUpdate.get("message"); } } } } } } } } Caveat(s): Limited to 250 requests per day (can be upgraded at a cost) Source(s): DH ...; Created on 21 March 2023
16. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... on each row and then the campaigns as columns. What we want: Contact Name Lead Source Campaign 1 Campaign 2 Campaign 3 ---------------- --------------- -------------- -------------- ...; Created on 20 March 2023
17. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... Planning Need to ensure data fed into a session is not shared or available to external sources once entered into OpenAI. If I train OpenAI on a dataset, can that data be accessed by external sources? No, ...; Created on 06 March 2023
18. ZohoCRM: Get All eBay Active Listings: / Zoho /; What? Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory ...; Created on 01 March 2023
19. 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
20. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... recently modified products at the end of each day and run some Deluge code against it to ensure that the data in Shopify is the same as in Zoho. In this case, Shopify is considered the source of truth ...; Created on 20 February 2023