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. ZohoCRM & ZohoWriter: Generate Rich Email Signatures in CRM: / Zoho /; ... to be unable to handle a lot of code or long URLs such as a base64 source URL for an image. The Plan Get company phone and website from Organization Details in ZohoCRM. Upload and get publicly-accessible ...; Created on 05 December 2023
6. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; What? An example of code using the new API call "Module Record Count" with some criteria. Why? At time of print, I couldn't find an example of how to use this API call with search filters or criteria. ...; Created on 14 November 2023
7. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; ... zoho.appname, "Quote", m_QuoteRecord, m_Blank, "my_creator_connection"); // // SUCCEEDS: with r_Create = ,"message":"Data Added Successfully"} Source(s): Zoho Creator / API Status Codes Zoho Community ...; Created on 04 October 2023
8. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... is attached to the last record of the source data File identifying number is returned from being attached File is opened in a new tab/window to trigger downloading. File is deleted from attachments ...; Created on 02 October 2023
9. ZohoBooks: Error 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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