Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 Specify a group which can generate thumbnails and use the service. Login to front-end as a user belonging to the group specified in 3c. Keep refreshing the page until all thumbnails have been generated. Switch "STOP Thumbnail Service" to "YES" Logout...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to a specified user". Why? Sorry Zoho! I tried using the interface to set up a workflow or any other mechanisms within ZohoCRM that allowed...

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

Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 Protocol=socket; "socket" is the default value used if the key isn't specified. Value "tcp" is an equivalent for "socket". Use "pipe" to use a named pipes connection, "unix" for a Unix socket connection and "memory" to use MySQL shared memory....

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 follow the same restrictions as the MS Windows filesystem (so no colons, back/forward slashes, etc). If there is nothing specified, it will name it something like "000065.bmp". Do not include the file extension (and the dot/period) as this is set in the...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 ac abc abbc abbbbc The expression does not match: adc Interval — Exact Count The exact-count interval operator is specified with a single digit enclosed in braces. You use this operator to search for an exact number of occurrences of the preceding...

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

XML Schema Referencehttps://www.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 Specifies the top-level element for schema comments any Enables the author to extend the XML document with elements not specified by the schema anyAttribute Enables the author to extend the XML document with attributes not specified by the schema...

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

Applying a button and centering it in the RocketTheme Affinity templatehttps://www.joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

15 September 2009 Look at the last few lines with the original code (below) For this website template: I've added the module-dark classes. Specified float:none to get rid of float:left Specified width of readon-wrap1 to the width of the button Specified margin:0 auto to...

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

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 criteria, you can use the following 3 methods: getElementById(id) - returns a reference to the first object with the specified ID getElementsByName(name) - Returns a collection of objects with the specified name getElementsByTagName(tagname) - Returns a...

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

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 to the named job file /QUIT :: QUIT after processing command line (to view parameters). /NOSD :: NO Source Directory is specified. /NODD :: NO Destination Directory is specified. /IF :: Include the following Files. Extended Copy Open a command prompt...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 (Royal Marines, Royal Navy Air Service, Royal Air Force, Remote Radar Heads) Some "disused" airfields (former military) Specified nuclear power plants Specified historical buildings Legend: Yellow: Restricted Area: Avoid flying in this area at all. Red:...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 "Enabled the Drive API" via your Google Developers console as well as gotten your OAuth 2.0 access/refresh tokens and specified the appropriate scopes. The scopes I chose were to do with getting a working example rather than the recommended scope,...

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

Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 based on the start date (first field in the subform) match in which case it should re-add the row with an "End Date" specified (blank or not). console.log("Joel Lipman - 20221018 -------------------------"); // get some values from the current record...

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

CSS Background Without Causing Scrollbarshttps://www.joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 with the leftmost tip aligned to the right of a central content section. I separated off the clouds as another div layer, specified the width and height and specified it's left. It caused the horizontal scrollbar which is a bit annoying because you...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 TRUE); END sp_get_studentdetails_from_ad; Permissions on this SP Might need to give permission for your SSRS user (specified credentials in data source) to run this stored procedure. CREATE PUBLIC SYNONYM sp_get_studentdetails_from_ad FOR...

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

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 an interface that either is an official standard defined by a recognized standards body, or, in the case of interfaces specified for a particular programming language, one that is widely used among developers working in that language. The “System...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 the error row disposition on "output column "DC_This_Date" (3833)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure....

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

SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 and the error row disposition on "output column "DC_MyDate" (7349)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure....

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

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 Fri, 4th Nov 2011 1.5.4- Parameter: Custom Order by ID - Parameter: Include Sub-Categories (up to 2 levels deep) of specified category - Fixed Bug: Removed 50% specification - Fixed Bug: Corrected "trigger popup" text translation. - Date Uploaded: Wed,...

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

Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 as a minimum (or CREATE/READ): 2. Code to push Time Log entry to Zoho Projects: Example #1: Pushing a time log with a specified start date/time (requires end time field if using): // // init (from dropdowns you have made applicable to your Zoho Projects...

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

Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM templatehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-send-an-email-with-a-crm-quote-using-a-given-crm-template.html

18 August 2022 a PDF using a customer's template. // // initialize (this is code added to a button so should alert user if no email was specified) v_OutputMessage = ""; v_TemplateID = "123456789012345678"; // // get the quote details given a record ID r_QuoteDetails =...

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