Search - Joel Lipman .Com

1. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; What? This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate ...; Created on 13 June 2014
2. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... now I can go back to my query and expand on it a little to include the other datasources (CRM Tables): SELECT 'CRM Accounts' AS "DataSource", date(t1."ModifiedTime") AS "Date", t1."RecordID" ...; Created on 25 July 2024
3. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... to Zoho Analytics, and choose a workspace with the relevant data (in this case Zoho Books Analytics workspace) In the left sidebar, select "Data Sources" then click on the "Add Data Sources" button Select ...; Created on 09 July 2024
4. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... void Check_DataSources_Sync_to_ZohoAnalytics () Label: Check DataSources Sync to ZohoAnalytics Trigger: Scheduled daily at 1am starting from tomorrow (3-Jul-2024) Purpose: To ...; Created on 02 July 2024
5. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... Data Sources in the left sidebar Add Data Sources > Select Zoho Desk Do "Next" and select the Zoho Desk Portal Ensure that "Tickets" is selected (I'd tick most of the fields this contains) Create ...; Created on 05 December 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 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
8. 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
9. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... This is a formula which returns pretty realistic images and references as demo'd in Maximize's Youtube video (see sources below): Type of photography, lens, distance, subject, direction, type of film, ...; Created on 11 February 2023
10. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... sources below). Here's the code for our function; note it is within ZohoBooks and not ZohoInventory (moved) and the connection "zbooks" has a fullaccess scope: // // initialize v_PaymentMode = ...; Created on 17 August 2022
11. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... How? Well, let's setup the FTP connection first in Zoho Analytics: Login to Zoho Analytics Click on "Data Sources" in the left sidebar then click on "Add Data Sources" in the top right: ...; Created on 12 January 2022
12. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... have a maximum of 15 digits. Source(s): Twilio Docs - HTTP Methods - Creating or Updating Resources with the POST Method Twilio Docs - Error 21211 Twilio Docs - E.164 (Telephone numbering plan) ...; Created on 16 December 2021
13. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving time by country Wikipedia: List of tz database time ...; Created on 07 December 2021
14. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... Source(s): Joel Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving time by country Wikipedia: ...; Created on 07 December 2021
15. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... Source(s): Zoho Deluge: Supported Time Zones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving time by country Wikipedia: List of tz database time ...; Created on 19 October 2021
16. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... articles on handling images in Zoho Creator (see "Sources" below), the most relevant one being my article Zoho Deluge: Get Image Uploaded in Creator Form which has one method of getting a public link. ...; Created on 17 October 2021
17. Sort an associative array by values in Javascript: / JavaScript /; What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. ...; Created on 29 September 2015
18. Android Java: Remove first two entries from Google News feed in SimpleRssReader: / AndroidOS /; ... { return date; } public String getDesc() { return desc; } } My rss_item.xml (reduced down): Sources: Android ...; Created on 24 October 2014
19. Convert to Proper Case in T-SQL: / Transact-SQL /; What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...; Created on 04 June 2014
20. MS-DOS: Copy folders without overwriting files: / MS-DOS /; What? A quick note on how to copy files and folders over without overwriting existing files. It's easy to say "Yes" and replace all files. What I need is something that synchronizes files on an internal ...; Created on 23 February 2014