Before and After, Highs and Lowshttps://www.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 report mentioned several times but just in a different week. I want a returned table structured as follows: Report Name Run Last Week Run This Week ------------------ ----------------- ------------------- Report 001 5 2 Report 002 11 47 Report 003 7 61...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 table in turn Configure and Brand your new Joomla site Activate Users Post-Notes: Activating users should be done as the last step of this migration. Rename admin ID in the UPGRADE database We want to make sure that the new user ID doesn't exist in our...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Zoho Creator / Shopify: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-get-all-active-products.html

12 October 2021 + v_ClientID + ":" + v_ClientSecret + "@" + v_ShopID; v_ShopifyApiVersion = "2020-01"; // // loop through 2500 records v_LastID = 0; l_ProductIDs = List(); l_Pages = {1,2,3,4,5,6,7,8,9,10}; for each v_Page in l_Pages { v_Endpoint = v_ShopifyURL +...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 :v_CaptureIntentEndpoint type :POST parameters:m_CaptureParams headers:m_Headers ]; // // get card details (we need to store last 4 digits) v_StripeReference = ""; v_Last4Digits = ""; v_ZB_InvoiceID = 0; m_Charges =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 "_Global". At the same level, create another folder called "Profile Photos". Navigate into the "_Global" folder and note the last hash in the URL (after "/folders/") For this function, I have a connection called "zworkdrive" which has the scopes as...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 the health of the system. Why? The use-case here is to build a system which monitors a Zoho App for when records were last modified and if a synchronization process starts to fail, there should be images or icons warning or advising of failures. How?...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

MySQL day of week ending on Fridayhttps://www.joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 the following Sunday. The solution below is for the opposite, where the week starts on the previous Saturday and ends on the last working day of the week. The Solution Where "givenDate" is the given date you have to calculate the last working day of: --...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Difference between two dates - the midnight hourhttps://www.joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 ---------------- -------------- 04/03/2011 Tweedle Dee 10:00 12:00 2.00 08/03/2011 Tweedle Dum 23:30 00:30 -23.00 Note the last row is obviously incorrect. This is because the script is not changing the date at the stroke of midnight. Take the last row...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Checklist for the local computer repairshttps://www.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 hours, holidays and emergencies, added 20/hour Add 20 for restore disk Questions for customers: What do you need to do? Last time it worked? Emails received since? Programs installed since? Alternative documents/programs to do this? Same errors on...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 the errorlevel, return a message. How? We use a database account with read-only privileges to list all the details. On the last report, the one to execute the stored procedure, we use an account specifically created to run the stored procedure. This...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 array($db->quote('Joe'), $db->quote('jlipman')) )); $db->setQuery($query); $result = $db->query(); -- retrieve last inserted ID $last_inserted_id = $db->insertid(); UPDATE using JDatabaseQuery Note: for Joomla v3.x, use db->execute() instead of...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 ; split into an array StringSplit,ReturnedHTMLTableCols,ReturnedHTMLTableColString,| ; add to last found listview LV_Add("", RowIndex, ReturnedHTMLTableCols1, ReturnedHTMLTableCols2, ReturnedHTMLTableCols3, ReturnedHTMLTableCols4,...

• Type: Article
• Author: Joel Lipman
• Category: Hypertext Markup Language
• Language: en-GB

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 files older than n days/date. /MINAGE:n :: MINimum file AGE - exclude files newer than n days/date. /MAXLAD:n :: MAXimum Last Access Date - exclude files unused since n. /MINLAD:n :: MINimum Last Access Date - exclude files used since n. (If n...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: en-GB

T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 root node SELECT Event_XML.query('/STAFF/EMPLOYEE_NUMBER[position()=1]') FROM [dbo].[XML_EVENTS] -- to get employee node at last position from root node SELECT Event_XML.query('/STAFF/EMPLOYEE_NUMBER[last()]') FROM [dbo].[XML_EVENTS] -- to return...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 apostrophes to double-quotes // split by closing curly brace var myRecords = newSortedArrayObject.split('}'); // removes last row which is undefined (ie. "]") myRecords.pop(); // loop through array for (i=0; i

• Type: Article
• Author: Joel Lipman
• Category: JavaScript
• Language: *

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 = json_decode($response, true); return $output; } 5. Get Minutes Remaining on cached token So usually an access token will last for 60 minutes, in this example, we are going to store the token value so it is reused until it is about to expire. Firstly,...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 v_ContactFname = r_ContactDetails.get("First_Name"); v_ContactSname = r_ContactDetails.get("Last_Name"); v_AddressLine1 = r_ContactDetails.get("Street"); v_AddressCity = r_ContactDetails.get("City"); v_AddressState = r_ContactDetails.get("State");...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Analytics: Determine profits from invoices and purchase ordershttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 = inv."Invoice ID" WHERE inv."Invoice Status" NOT IN ( 'Draft' , 'Void' ) GROUP BY invitm."Item ID", invitm."Quantity" And lastly we can group by invoices in the month and sum up the profits as well as include the customer name and other invoice...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 v_CsvRow = l_CsvFileRow.toString(); l_CsvFileRows.add(v_CsvRow); // // note the cursor so that we resume from the last cursor v_Cursor = r_Node.get("cursor"); // // output to console for debugging purposes info "Page #" + v_Page + "::" + v_CountTotal +...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 m_Create.put("Owner", v_LoggedInUserID); r_Create = zoho.crm.createRecord("GPT_Chats", m_Create); // // add the last question to the messages m_Chat = Map(); m_Chat.put("role", "user"); m_Chat.put("content", v_UserMessage);...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *