Search - Joel Lipman .Com

1. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; What? A quick article on how to setup an automation that checks if a datasource synchronization between Zoho People and Zoho Analytics failed. This can be adapted to any data source for Zoho Analytics. ...; Created on 02 July 2024
2. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... Type FTP in the filter field in the top right and there should be a single FTP option displayed to you: Step 1 of 2: Give the datasource the table name it will have in Zoho Analytics, a description ...; Created on 12 January 2022
3. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... the data for my widgets), I have to write it as such: SELECT 'CRM Accounts' AS "DataSource", date(t1."ModifiedTime") AS "Date", t1."RecordID" AS "Record ID", t1."RecordName" AS "Record Name", ...; Created on 25 July 2024
4. 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
5. 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
6. 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
7. 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
8. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; ... to other systems holding the images), then please refer to my article on SSRS External Images don't display. The answer to this error is your report needs to use a datasource with the credentials stored, ...; Created on 22 November 2013
9. Problem creating SSRS report subscriptions: / SQL Server Reporting Services /; ... There are various types of data sources used in SSRS so I'm going to try and cover the ones I have used previously and what we needed to get them working. Custom DataSource Upload the report ...; Created on 11 November 2013
10. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... people on the net, I've been given a datasource with names and addresses all in UPPERCASE. Initially, no one seemed bothered but now the request came through asking if this could be restored to a normal ...; Created on 04 October 2013
11. 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
12. SSIS Convert a string into a date: / SQL Server Integration Services /; ... failure. -- often when processing a datasource, the function is being applied to a NULL date timestamp. Dealing with Date NULLs: Fix: Put conditional statements to account for NULLs. -- Standard TRIM(This_Date) ...; Created on 14 March 2013
13. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... the second query which is the one that will return my columns. Two output fields are expected to be returned: "p_STUDENT_DETAILS" and "p_STUDENT_REF". 2. Add a datasource Nothing different to ...; Created on 19 January 2012
14. Performance Report - Background colors based on dataset values: / SQL Server Reporting Services /; ... want to use these datasets, parameter options should be that the Name is the "Label" and ItemID is the "Value", just in case you didn't pick up on this. If no type is specified (type=2) then datasources ...; Created on 02 December 2011
15. SSRS Parameters in Oracle Stored Procedure: / SQL Server Reporting Services /; ... and then browse the dropdown for the name of your stored procedure (should be listed if datasource is correct): Before you close this box, click on "Parameters" in the right and specify your parameters ...; Created on 02 September 2011
16. Accessing a MySQL Database with Business Intelligence Development Studio: / MySQL /; ... Explorer > select "Add New Data Source" Give the DataSource1 a more memorable name Click on the "Edit..." button Click on the "Change..." button Select "ODBC" and click on "OK" Select the system data ...; Created on 05 January 2011